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

2008-04-04 Thread Felix Schumacher
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

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

2008-04-04 Thread Christopher Schultz
-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

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

2008-04-03 Thread steve kerver
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).

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

2008-04-03 Thread David Fisher
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