Vagula wrote:
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>
Assume there is something wrong in your code. I locally setup a similar
test which run without problems.
Did you use a non-default database lock isolation level? e.g. REPEATABLE
READ.
regards,
Armin
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
