aspose file tools*
The moose likes JDBC and the fly likes java.sql.BatchUpdateException: IO Error: Socket read timed out error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.BatchUpdateException: IO Error: Socket read timed out error " Watch "java.sql.BatchUpdateException: IO Error: Socket read timed out error " New topic
Author

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

monika se
Greenhorn

Joined: Mar 23, 2011
Posts: 22
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

Joined: Oct 21, 2008
Posts: 1107

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

Joined: Aug 22, 2010
Posts: 3610
    
  60

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.BatchUpdateException: IO Error: Socket read timed out error