Re: How to get Tomcat to pick up Oracle database connections after database shutdown?

[Felix Schumacher <fe...@internetallee.de>]

On Thu, April 3, 2008 9:45 pm, steve kerver wrote:
> ...
> (If I shutdown the Oracle database and then don't do a
> Tomcat restart when the database comes back up, we get
> HTTP 500 errors).
> ...
>  Also- FYI, we are using Hibernate.
You are not telling us, which tomcat version, java version or OS you are
using. And we can only guess, if your hibernate app uses it's own database
connection pool or one supplied by the tomcat container.

If you are using a database connection pool supplied by tomcat v6.0 than you
should look at it's documentation at

http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html

and follow the link to the commons-dbcp documentation at

http://commons.apache.org/dbcp/configuration.html

The Parameters
 - validationQuery
 - testOnBorrow
will be of particular interest to you.

HTH
 Felix
>
>  Any help would be greatly appreciated.
>
>   Thanks!
>    -Steve.



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org