Socket Timeout

[Ben Narendren]

Hi,

I am trying to put in a Socket time out on a Oracle JDBC connection. I googled it and didn't find much. I use DriverManager.getConnection(connectionString); to create connections. Anybody has any ideas how to do this? Any help is greatly appreciated.

Thanks
Ben

[William P O'Sullivan]

A Socket timeout? for a DB Connection?

Don't you mean a statement or transaction timeout?

WP

[Ben Narendren]

I mean a connection level socket timeout which will be invoked if the physical connection is lost and the thread is hanging.

[Martin Vajsar]

Have you found this? The Oracle connection apparently recognizes the oracle.jdbc.ReadTimeout property. I don't have any experiences with the more exotic connection properties though, and this area is quite muddy for me.

[Ben Narendren]

Thanks Martin. I think this is what I was looking for.

[Martin Vajsar]

You're welcome.