1、问题现象

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

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.

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:

A communication error occurred during

operations on the connections underlying socket, socket input stream,

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

{1} is NULL.. ERRORCODE=-4499,

SQLSTATE=08001:java.io.IOException: {1} is NULL.

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

00000038 SystemOut O ERROR org.hibernate.transaction.JDBCTransaction(line:232) -Could

not toggle autocommit

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

closed.

2、问题分析

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

3、问题解决

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