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

1、问题现象应用查询报连接失败，不能查询出结果。后台报错：[8/20/12 15:10:14:902 GMT+08:00] 00000038 ConnectionEve W J2CA0206W: Aconnection error occurred. To help determine the problem, enable theDiagnose Connection Usage option on the Connection Factory or Data Source.[8/20/12 15:10:14:904 GMT+08:00] 00000038 ConnectionEve A J2CA0056I: TheConnection Manager received a fatal connection error from the ResourceAdapter for resource jdbc/ccms. The exception is: com.ibm.db2.jcc.am.zn:[jcc][t4][2030][11211][3.57.110] A communication error occurred duringoperations 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 Wcom.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incidentemitted on/was/log/ffdc/WASCCPB2_17201720_12.08.20_15.10.14.9093773932699622569110.txtcom.ibm.ws.rsadapter.jdbc.WSJccSQLJConnection.commit 587[8/20/12 15:10:14:922 GMT+08:00] 00000038 SystemOut O [2012-08-2015:10:14]ERROR org.hibernate.transaction.JDBCTransaction(line:232) -Couldnot toggle autocommitcom.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection isclosed.

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

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