Re: Queries Colliding in JDBC. Table Locking.
Posted by: T Schumann
Date: February 02, 2005 04:28PM

I coded a temporary work-around. The connection was being opened as a static object, and therefore all requests were going through the same connection. OK as long as the database calls were atomic. But when several successive calls needed to be made without interruption, then problems occured. For now, I've coded an explicit (non-static) connection to be opened in the above code and then closed after the query. This seems to keep other queries "out". I know this is inefficient and I will need to use connection pooling at some point. But that 's a different hurdle...

Options: ReplyQuote

Written By
Re: Queries Colliding in JDBC. Table Locking.
February 02, 2005 04:28PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.