I'm not sure how this is related to
1) "Io exception: Connection reset"
2) "Io exception: The Network Adapter could not establish the connection"
issues.
However, this type of "hang" will be due to open transactions.
eg:
conn1 has updated row1 in table1, but did not commit.
conn2 is trying to read/update row1 which will have to wait till conn1's job is complete (commit/rollback).
a) How about switching off pooling ? (I guess, this will help to overcome the "hang" but the actual problem may be with the application code that need to be fixed)
: To switch off pooling, set
i)steady-pool-size=0
ii) pool-resize-quantity=1
iii) max-connection-usage-count=1
b) Try using "resource-type" as javax.sql.ConnectionPoolDataSource with appropriate CPDS class in Oracle.
Thanks,
-Jagadish
[Message sent by forum member 'jr158900' (jr158900)]
http://forums.java.net/jive/thread.jspa?messageID=227691