users@glassfish.java.net

Re: How to make Toplink Essentials robust to lost DB connections?

From: <glassfish_at_javadesktop.org>
Date: Tue, 08 Apr 2008 12:47:40 PDT

I would say you need to configure JDBC connection pool to test availability of connections.

For example in glassfish you can use is-connection-validation-required="true" connection-validation-method="table" validation-table-name="dual". You need to find out how to configure it in Tomcat.

Then when your application acquires new connection from pool, server should test it before giving it to you.

When connection error occurs during some processing, just treat it as error.
[Message sent by forum member 'jarol1' (jarol1)]

http://forums.java.net/jive/thread.jspa?messageID=268240