WAS常见操作与故障解决：[2]DSRA9110E解决

1、1、问题现象

应用查询报连接失败，不能查询出结果。后台报错：

[8/20/12 15:10:14:902 GMT+08:00] 00000038 ConnectionEve W   J2CA0206W: A

connection error occurred.  To help determine the problem, enable the

Diagnose Connection Usage option on the Connection Factory or Data Source.

[8/20/12 15:10:14:904 GMT+08:00] 00000038 ConnectionEve A   J2CA0056I: The

Connection Manager received a fatal connection error from the Resource

Adapter for resource jdbc/ccms. The exception is: com.ibm.db2.jcc.am.zn:

[jcc][t4][2030][11211][3.57.110] A communication error occurred during

operations on the connection's underlying socket, socket input stream,

or socket output stream.  Error location: T4Agent.sendRequest().  Message:

[jcc][t4][20121][11651]{1} is NULL.. ERRORCODE=-4499,

SQLSTATE=08001:java.io.IOException: [jcc][t4][20121][11651]{1} is NULL.

[8/20/12 15:10:14:913 GMT+08:00] 00000038 FfdcProvider  W

com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident

emitted on

/was/log/ffdc/WASCCPB2_17201720_12.08.20_15.10.14.9093773932699622569110.txt

com.ibm.ws.rsadapter.jdbc.WSJccSQLJConnection.commit 587

[8/20/12 15:10:14:922 GMT+08:00] 00000038 SystemOut     O [2012-08-20

15:10:14]ERROR org.hibernate.transaction.JDBCTransaction(line:232) -Could

not toggle autocommit

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is

closed.

2、2、问题分析

经搜索该报错，查询可能原因，怀疑是数据库驱动版本或数据库重启原因导致。查询驱动程序没有问题后。咨询DB2工程师，数据库做过重启，确实WAS连接池中失效连接未被清除

3、3、问题解决

增加JDBC 驱动程序验证无效连接机制。参考图中设置，设置完成后，需要重启WAS