Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Socket Timeout

 
Ben Narendren
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 859
Chrome IBM DB2 Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A Socket timeout? for a DB Connection?

Don't you mean a statement or transaction timeout?

WP
 
Ben Narendren
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I mean a connection level socket timeout which will be invoked if the physical connection is lost and the thread is hanging.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Martin. I think this is what I was looking for.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're welcome.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic