Re: JDBC Connection & Listener

Dustin

Yes this is interesting terrirtory. I've been playing around with it a little today, and I discovered that the Connection object is actually set to null when you come to close it if your original connection request has been rejected by the database. The close method appears to execute, but instead of generating an SQLException it just hangs, and never executes anything past the close(). I've not noticed this before because in my application you get a new thread of execution for every connection, so it's inconsequential to the application if that thread is hung.

I've now changed it to test the connection for null before attempting to close it. The application correctly closes down the thread now, but still the multiple connection requests go across to the listener!

Just a thought, but do you think I should be using an OracleConnection object rather than the standard Connection object?

Tarik Received on Mon Nov 26 2001 - 09:37:44 CST