I think you are correct. We manage our Oracle connections ourselves
using classes12 and a ConnectionPool. I have no need to restart tomcat
after an Oracle "bounce". I do restart my Tomcats much more often than
Oracle - every day. It has been almost a year since we restarted Oracle.
It could be that Hibernate is your issue. I know that Tomcat can
manage connections perhaps there is something in that configuration
that will help.
Good luck.
Dave
On Apr 3, 2008, at 2:45 PM, steve kerver wrote:
Hi- I'm an Oracle DBA, but since I work in a small
company, I've been tasked with restarting our Tomcat
servers everytime I have to shut down or restart our
database.
(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).
To me, this seems silly though- Tomcat should be able
to be aware that no database connection is available,
but when one *does* become available, it should just
pick it up, instead of requiring a restart.
Does anyone here know how to configure this?
Also- FYI, we are using Hibernate.
Any help would be greatly appreciated.
Thanks!
-Steve.
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of
Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]