Oracle9i/OJB - No return after commit transaction

Thread view:

Stefan Gerlach - 21 Oct 2003 22:40 GMT

Hello,

we use the Apache-OJB-framework (PersistenceBroker) in different java
programs and Oracle9i. These programs import data from other systems into
our database. Often I have the problem that a program stops after a
transaction commit was called. No exception was thrown. The stops were
independent from imported data (I repeated the tests) and I'm sure (80%)
that I have no deadlocks (the programs use different tables).
Could You help me to find out the cause?

Thanks
Stefan

Reply to this Message

Joseph Weinstein - 21 Oct 2003 22:52 GMT

> Hello,
>
[quoted text clipped - 8 lines]
> Thanks
> Stefan

Get a full thread dupm of the application to find out what it thinks it's doing
after the commit. Then get DBMS information on what the DBMS thinks is
happening. Are allthe connections idle, or are they blocked? etc.
Joe Weinstein at BEA

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...