Re: Queries Colliding in JDBC. Table Locking.

[T Schumann]

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...
Trent