Hi, I'm hoping someone can help me here!

We are using Hibernate with SQL Server, and one of our clients is experiencing situations where every once in a while the connection cannot be opened (we get a SQLException for "Exception:Cannot open connection"). It looks like this is an issue with their network, and they can't seem to resolve it. We are deploying within JBoss and using a pool of connections.

Is there a way to configure or code within Hibernate to be able to, in the event that it fails trying to get a connection, that it tries to get another one? Or kill the bad connection and then retry? Or verify the connection prior to doing the query? We can try to do a lot of workaround coding, but I was wondering if this was something that we could build using Hibernate itself.

Thanks in advance!

Hi!

There is a tag <check-valid-connection-sql> you can use in datasource files.

See

http://www.jboss.org/community/wiki/ConfigDataSources

kind regards

foster