i'm not exactly sure that this is the correct place to ask this, but the system uses hibernate (3.2.0.x) for all database transactions and I'm trying to get an error or exception to be thrown.

I'm trying to fix a server recovery issue where we lose the database connection. To reproduce my problem, I have a large table that I query and sort (in a remote oracle box), then in the middle of the transaction, I pull the plug to internet connection.

My problem is that Linux (ubutu 6.10 edgy-eft all updates installed to date) will not recognize that the connection has been lost in teh middle of the transaction and the Application Hangs.

Once I plug the box back in, my interceptors will catch the timeout, and throw the appropriate errors, but I need the system to catch the lost connection either immediately or quickly adn then throw the errors.


has anyone else ran into this problem and if so how did you fix it?

We also sometimes have the same problems, but didn't have times to find out a solution. We were thinking about configuring the connection pool timeout, if possible, did you try it?

my system is set up on linux kernel 2.6.17 (ubuntu 6.10), and Depending on your datasource and operating system, connection pool timeouts won't always work. in linux the problem is at the driver level. If you're using an oracle database, use the oracle.jdbc.pool.OracleDataSource or whatever extention of that suits you best. set the loginTimeout, then include the property oracle.jdbc.ReadTimeout in the connectionProperties that it passes to your jdbc driver. ** note: i've only tested this out with oracle thin driver

Try configuring your connection pool to issue a special query every n minutes, something like "select 1 from dual" is fine on Oracle. This way your connection system will detect connection problem if this query becomes unavailable.