Hi,
"Table based validation detected invalid connection. Querying the table dual failed." is due to connection validation. This is an informatory message that an invalid connection is detected.
whereas,
1) "Io exception: Connection reset"
2) "Io exception: The Network Adapter could not establish the connection"
are from the jdbc driver.
1) Do you have any firewall configured ?
Firewall may reset the connections. Or there are intermittent network failures. Hence, bad connections in the pool were detected during connection validation and in-use connections have failed.
2) Could you post the pool configuration ?
3) When the appserver is hung, could you get a thread dump (jstack) of appserver process.
[Message sent by forum member 'jr158900' (jr158900)]
http://forums.java.net/jive/thread.jspa?messageID=227240