RE: detect connection problems

  • From: "Eric Buddelmeijer" <Eric.Buddelmeijer@xxxxxxxxxx>
  • To: <valpis@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 23 May 2006 17:30:03 +0200

Hi Johan,
 
We have had similar problems with Hibernate. One of our java developers
found out that the connection pool itself is able to detect if the
connections are dead and can be reconnected when necessary. It is an option
built into the connection pool java object or something (not a Java
developer myself). If the developer here can find that option, your
developer must be able to find that as well. Google is his/her friend ;-)
Maybe it is even a good aspect of java?
 
Regards,
Eric.


  _____  

Van: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Namens Johan Eriksson
Verzonden: dinsdag 23 mei 2006 16:17
Aan: oracle-l@xxxxxxxxxxxxx
Onderwerp: detect connection problems


Hi all

A developer asked me a question I couldn't give any answer to.
Our application connect through a connection pool (hibernate) to the
database and the application should shut down if it can't create a
connection to db or if the connection is lost, all other failures should not
shut down but just give the error.

How could you catch only these messages? To figure out all possible ora
errors and have logic for these doesn't seem like a good idea. Anyone that
has done something similiar?

/Johan


Other related posts: