Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.BatchUpdateException: IO Error: Socket read timed out error

 
monika se
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please help me as what could be going wrong. My full stackTrace is:



I am a new to this kind of exception but I know its getting timed out. Sometimes same action works fine. any help would be appreciated. Thanks in adv.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This usually means there is a lock on the database somewhere.
The first thing to do is make sure everything is closed. I don't know how to do this in hibernate.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure about the "forgotten lock". In my experience, a session can wait for many hours for a lock in Oracle. However, I have only tried with SQL*plus, not with JDBC, so I may be wrong.

I'd suggest to check the database logs for possible errors.

This OTN thread mentions the culprit might be an invalid connection handed out by the connection pool; setting the pool to validate the connections could solve the issue.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic