Hi, After the insert transaction is committed, I try to read the same record.
Actually it's like this: In for loop <TRANSACTION1 BEGIN> I check to see if there is Record for a particular combination (let's say record for name="A"). < TRANSACTION 2 BEGIN> If the record does not exist I insert the record (with name="A"). < TRANSACTION 2 END> When the I come across same combination and check if r record exists (with name="A"), A null record is returned. < TRANSACTION 1 END> Regards, Vagula -----Original Message----- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:43 PM To: OJB Users List Subject: Re: Problem in retrieving data Hi Vagula, > I insert a record (if the record does not exists for a particular > combination) into a table in a (broker) transaction and try to access > the same record in a different (broker) transaction. Could you give us more details. OJB version? Did the second broker instance try to read the record before the first broker commits? regards, Armin Vagula wrote: > Hi, > > > > > > > > I'm facing a problem. > > > > > > The problem description is as follows: > > > > > I insert a record (if the record does not exists for a particular > combination) into a table in a (broker) transaction and try to access > the same record in a different (broker) transaction. > > > > > Though the record gets inserted in > the physical database, OJB is not retrieving the record. > > > > > > When I stop the server and run the > application again the data is retrieved. > > > > > > The sequence: > > > > > INSERT > RETREIVE data > is not working. > > > > > RETREIVE data is working > > > > > > > > > > > Please Help!!! > > > > > > > > > > TIA, > > Vagula > > > > > > > > > > > **************** 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]