-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Steve,

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).

Are you getting exceptions in Tomcat's logs? If so, what are they?

I'm guessing that your JDBC connections are poorly set-up.

Do you get to configure the connection pool at all through Hibernate?
You need to have your connection pool test connections before attempting
to use them.

Tomcat uses Commons DBCP which allows for a "validation query" that gets
executed as a test before any "real" query goes through. Any connections
that are dead (because of an Oracle bounce, for instance) will be cycled
out of the pool and replaced with good ones. No need to restart Tomcat
after a db bounce.

I have to imagine that Hibernate is able to do this as well.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkf2QEcACgkQ9CaO5/Lv0PBFugCgl+GrCPSfSbutHP2k/cm007ro
b6kAn1TmoVPC/DHu753GtN7BLs9aCNXO
=FflQ
-----END PGP SIGNATURE-----

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

Reply via email to