detecting oracle connection failures

2009-09-07 Thread Roberto Benedetti
hi everyone, I'm having problems trying to combine Oracle and Tomcat: if I define a DB connection to a MySQL or Postgres resource, everything works fine and DB failures are properly detected. conversely, if I define an Oracle DataSource, apparently RDBMS or network problems are not detected

Re: detecting oracle connection failures

2009-09-07 Thread David Smith
I think you've misunderstood what maxWait does. It tells the pool how long to have your webapp code wait for a connection when all the connections in the pool are busy servicing other requests (the pool is exhausted). Sounds to me like you've successfully received a connection, are attempting a

RE: detecting oracle connection failures

2009-09-07 Thread Caldarale, Charles R
From: Roberto Benedetti [mailto:r.benede...@cineca.it] Subject: detecting oracle connection failures if I define an Oracle DataSource, apparently RDBMS or network problems are not detected and my application keeps waiting ad libitum, ignoring the maxWait parameter. You might want to try