I'm not changing the autocommit at this point. Basically I cannot count on connections
returns from the connection pool to be coordinated in any way my container managed
transactions. So the detail bean will never see the insert that the master bean has
just inserted, even thought both of them are in the same container transaction.
-----Original Message-----
From: Ole Husgaard [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 5:31 PM
To: jBoss
Subject: Re: [jBoss-User] JBOSS and Oracle
Hi,
> "Bolt, Dave" wrote:
>
> The big problem is that the XA driver from Oracle keeps timing out whenever
> I have two beans which write to tables that have a master/detail FK relationship.
> The detail bean times out, because the master record (which was just inserted prior
> to the detail beans insert) is not visible yet. Search the archives on "JBoss and
> Oracle" for more sordid details.
I would (again) recommend that you do not touch
the autoCommit property of your connections.
Nobody else does this.
Depending on how the Oracle XA driver works
internally, this may cause exactly the problem
you are describing.
Best Regards,
Ole Husgaard.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
