Re: Concurrent Users
Vagula escribió: Hi, Yes I need info about concurrent connections. What are the settings to be in OJB.properties? Look in [1] for persistence broker pool properties. Inside the file each property is described. Best Regards, Antonio Gallardo [1] http://db.apache.org/ojb/OJB.properties.txt - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users-Please Help!
Hi, In my opinion in your case there is no support from OJB. because it is a problem of normalization of the db table. You have two possibilities if now one sends you a other response ;) 1. normalize the table remove Col1 and declare Col2 and Col3 as primary key. In this case ojb will update the second object. 2. Declare the constraints in the db and catch the exception in the Db layer of your application and try to update if the exception occurs. Remarks: that is only a problem by creation. After creation you can work with optimistic locking, have a look at the documentation of ojb. Regards Matthias -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 5. September 2006 09:48 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! Hi, Let's say there is a Table A with columns Col1 (Id primary key), Col2, Col3, and Col4. Say the data for the combination of col2 and col3 should be unique. Both user1 and user2 are trying to insert (create) the same data Col1- (id self generated) Col2-A Col3-1 Col4-abc In my case two rows are inserted. What are the settings that I can make for adding a single row and updating the same? Regards, Vagula - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users-Please Help!
Hi, Let's say there is a Table A with columns Col1 (Id primary key), Col2, Col3, and Col4. Say the data for the combination of col2 and col3 should be unique. Both user1 and user2 are trying to insert (create) the same data Col1- (id self generated) Col2-A Col3-1 Col4-abc In my case two rows are inserted. What are the settings that I can make for adding a single row and updating the same? Regards, Vagula -Original Message- From: Matthias Roth [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 11:50 AM To: ojb-user@db.apache.org Subject: RE: Concurrent Users-Please Help! Hi With the default settings from ojb it works. But every thread must have it's one borker! Matthias Roth -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 5. September 2006 06:31 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! I get the broker from the PB pool. I close the transaction in a finally block, Please let me know 1. What are the settings that are to be made for handling concurrent transaction using PB API? Regards, Vagula - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users-Please Help!
Hi With the default settings from ojb it works. But every thread must have it's one borker! Matthias Roth -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 5. September 2006 06:31 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! I get the broker from the PB pool. I close the transaction in a finally block, Please let me know 1. What are the settings that are to be made for handling concurrent transaction using PB API? Regards, Vagula - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users-Please Help!
I get the broker from the PB pool. I close the transaction in a finally block, Please let me know 1. What are the settings that are to be made for handling concurrent transactionusing PB API? Regards, Vagula -Original Message- From: Matthias Roth [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 2:24 AM To: ojb-user@db.apache.org Subject: AW: Concurrent Users-Please Help! Hi How do you get the broker? In your code snip the statement broker=PersistenceBrokerFactory.defaultPersistenceBroker(); and broker.close is missing. Where do you do this calls? is missing. where do you do this calls? Matthias Roth -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Montag, 4. September 2006 14:52 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! Hi All, I'm using: 1. OJB version 1.0 2. The block looks like: broker.beginTransaction(); broker.store(Object); broker.commitTransaction(); Regards, Vagula - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: Concurrent Users-Please Help!
Hi How do you get the broker? In your code snip the statement broker=PersistenceBrokerFactory.defaultPersistenceBroker(); and broker.close is missing. Where do you do this calls? is missing. where do you do this calls? Matthias Roth -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Montag, 4. September 2006 14:52 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! Hi All, I'm using: 1. OJB version 1.0 2. The block looks like: broker.beginTransaction(); broker.store(Object); broker.commitTransaction(); Regards, Vagula - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users-Please Help!
Hi All, I'm using: 1. OJB version 1.0 2. The block looks like: broker.beginTransaction(); broker.store(Object); broker.commitTransaction(); Regards, Vagula -Original Message- From: Matthias Roth [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 5:49 PM To: 'OJB Users List' Subject: AW: Concurrent Users-Please Help! Hi Vagula It is difficult to answer if there is not code sequence and properties. Your problem can be in some OJB settings but it is also possible That you have a kind of anti pattern. For example same reference to The data object in both threads. We work with over 1000 concurrent threads on the same data object and have no problem. Hear some example: 1. We work with ojb version 1.04 2. we work not with a cash (the cash in version rc1 was corrupt), but perhaps it works now. 2. each call looks like: Try{ broker = PersistenceBrokerFactory.defaultPersistenceBroker(); // in J2EE do not handle transctions broker.store(yourObject); }finaly{ if (broker != null && ! broker.isClosed()) broker.close(); } Matthias Roth -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Montag, 4. September 2006 11:00 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! Hi All, I'm using PB API. When concurrent threads are running on a particular object, the data gets corrupted. Let say Thread1 sends data 1,2,3,4 Thread2 sends data 5,6,7,8 In the DB data stored is 1,2,5,6. How can I solve this issue? Please Help!! Urgently need solution!! Thanks in Advance! Regards, Vagula -Original Message- From: Vagula [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 11:55 AM To: OJB Users List Subject: RE: Concurrent Users Hi, Yes I need info about concurrent connections. What are the settings to be in OJB.properties? Thanks! Regards, Vagula -Original Message- From: Antonio Gallardo [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 8:25 PM To: OJB Users List Subject: Re: Concurrent Users Hi Vagula, Would you explain more your idea? If you are talking about concurrent connections to the database, OJB has database connection pool, which can be configured in the OJB.properties. Best Regards, Antonio Gallardo. Vagula escribió: > Hi All, > > > > How can I handle concurrent users using OJB? > > > > TIA. > > > > Regards, > > Vagula > > > > It may be more worthwhile, to find out what is right than-who is right. > > > > > > > > CAUTION - Disclaimer * > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. > ***INFOSYS End of Disclaimer INFOSYS*** > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: Concurrent Users-Please Help!
Hi Vagula It is difficult to answer if there is not code sequence and properties. Your problem can be in some OJB settings but it is also possible That you have a kind of anti pattern. For example same reference to The data object in both threads. We work with over 1000 concurrent threads on the same data object and have no problem. Hear some example: 1. We work with ojb version 1.04 2. we work not with a cash (the cash in version rc1 was corrupt), but perhaps it works now. 2. each call looks like: Try{ broker = PersistenceBrokerFactory.defaultPersistenceBroker(); // in J2EE do not handle transctions broker.store(yourObject); }finaly{ if (broker != null && ! broker.isClosed()) broker.close(); } Matthias Roth -Ursprüngliche Nachricht- Von: Vagula [mailto:[EMAIL PROTECTED] Gesendet: Montag, 4. September 2006 11:00 An: OJB Users List Betreff: RE: Concurrent Users-Please Help! Hi All, I'm using PB API. When concurrent threads are running on a particular object, the data gets corrupted. Let say Thread1 sends data 1,2,3,4 Thread2 sends data 5,6,7,8 In the DB data stored is 1,2,5,6. How can I solve this issue? Please Help!! Urgently need solution!! Thanks in Advance! Regards, Vagula -Original Message- From: Vagula [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 11:55 AM To: OJB Users List Subject: RE: Concurrent Users Hi, Yes I need info about concurrent connections. What are the settings to be in OJB.properties? Thanks! Regards, Vagula -Original Message- From: Antonio Gallardo [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 8:25 PM To: OJB Users List Subject: Re: Concurrent Users Hi Vagula, Would you explain more your idea? If you are talking about concurrent connections to the database, OJB has database connection pool, which can be configured in the OJB.properties. Best Regards, Antonio Gallardo. Vagula escribió: > Hi All, > > > > How can I handle concurrent users using OJB? > > > > TIA. > > > > Regards, > > Vagula > > > > It may be more worthwhile, to find out what is right than-who is right. > > > > > > > > CAUTION - Disclaimer * > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. > ***INFOSYS End of Disclaimer INFOSYS*** > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users-Please Help!
Hi All, I'm using PB API. When concurrent threads are running on a particular object, the data gets corrupted. Let say Thread1 sends data 1,2,3,4 Thread2 sends data 5,6,7,8 In the DB data stored is 1,2,5,6. How can I solve this issue? Please Help!! Urgently need solution!! Thanks in Advance! Regards, Vagula -Original Message- From: Vagula [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 11:55 AM To: OJB Users List Subject: RE: Concurrent Users Hi, Yes I need info about concurrent connections. What are the settings to be in OJB.properties? Thanks! Regards, Vagula -Original Message- From: Antonio Gallardo [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 8:25 PM To: OJB Users List Subject: Re: Concurrent Users Hi Vagula, Would you explain more your idea? If you are talking about concurrent connections to the database, OJB has database connection pool, which can be configured in the OJB.properties. Best Regards, Antonio Gallardo. Vagula escribió: > Hi All, > > > > How can I handle concurrent users using OJB? > > > > TIA. > > > > Regards, > > Vagula > > > > It may be more worthwhile, to find out what is right than-who is right. > > > > > > > > CAUTION - Disclaimer * > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, > please notify the sender by e-mail and delete the original message. Further, > you are not to copy, disclose, or distribute this e-mail or its contents to > any other person and any such actions are unlawful. This e-mail may contain > viruses. Infosys has taken every reasonable precaution to minimize this risk, > but is not liable for any damage you may sustain as a result of any virus in > this e-mail. You should carry out your own virus checks before opening the > e-mail or attachment. Infosys reserves the right to monitor and review the > content of all messages sent to or from this e-mail address. Messages sent to > or from this e-mail address may be stored on the Infosys e-mail system. > ***INFOSYS End of Disclaimer INFOSYS*** > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Concurrent Users
Hi, Yes I need info about concurrent connections. What are the settings to be in OJB.properties? Thanks! Regards, Vagula -Original Message- From: Antonio Gallardo [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 8:25 PM To: OJB Users List Subject: Re: Concurrent Users Hi Vagula, Would you explain more your idea? If you are talking about concurrent connections to the database, OJB has database connection pool, which can be configured in the OJB.properties. Best Regards, Antonio Gallardo. Vagula escribió: > Hi All, > > > > How can I handle concurrent users using OJB? > > > > TIA. > > > > Regards, > > Vagula > > > > It may be more worthwhile, to find out what is right than-who is right. > > > > > > > > CAUTION - Disclaimer * > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, > please notify the sender by e-mail and delete the original message. Further, > you are not to copy, disclose, or distribute this e-mail or its contents to > any other person and any such actions are unlawful. This e-mail may contain > viruses. Infosys has taken every reasonable precaution to minimize this risk, > but is not liable for any damage you may sustain as a result of any virus in > this e-mail. You should carry out your own virus checks before opening the > e-mail or attachment. Infosys reserves the right to monitor and review the > content of all messages sent to or from this e-mail address. Messages sent to > or from this e-mail address may be stored on the Infosys e-mail system. > ***INFOSYS End of Disclaimer INFOSYS*** > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Concurrent Users
Hi Vagula, Would you explain more your idea? If you are talking about concurrent connections to the database, OJB has database connection pool, which can be configured in the OJB.properties. Best Regards, Antonio Gallardo. Vagula escribió: Hi All, How can I handle concurrent users using OJB? TIA. Regards, Vagula It may be more worthwhile, to find out what is right than-who is right. CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Concurrent Users
Hi All, How can I handle concurrent users using OJB? TIA. Regards, Vagula It may be more worthwhile, to find out what is right than-who is right. CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS***