users@glassfish.java.net

Re: Connection validation on JDBC pool resource does not work

From: <glassfish_at_javadesktop.org>
Date: Thu, 15 Mar 2007 02:42:55 PST

I do not see validation related message /stack trace in the previous log. Is validation (table-based) set ?
you may see
"RAR5074 : Table based validation detected invalid connection. Querying the table TABLE-NAME failed. Set resource-adapter log-level to FINE for exception stack trace."
when you restart db & access your app.


[Also, validation will ensure that any new connection received by the application will be valid. In-flight /In-use connections being used by the application during db-restart will anyway fail]
[Message sent by forum member 'jr158900' (jr158900)]

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