在开发项目的过程中,出现了以下的问题:
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [sqlstring]; SQL state [null]; error code [-4499]; A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: 断开的管道. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS ; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: 断开的管道. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: 断开的管道. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
查询出错的地方,只是一个简单的查询sql,放到数据库中进行查询很正常.但是怎么会造成管道断开??
仔细想想后,发现可能是因为在使用的过程中,有人重新启动了数据库,而没有重新启动server.造成server中的数据库连接池中的连接都已经断开.
故,重新实现自己认为的错误过程,重新启动了db2,但是不重新启动server,确实造成了connection中断.出现以上问题.
我想原因大概如此吧.
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [sqlstring]; SQL state [null]; error code [-4499]; A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: 断开的管道. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS ; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: 断开的管道. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: 断开的管道. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
查询出错的地方,只是一个简单的查询sql,放到数据库中进行查询很正常.但是怎么会造成管道断开??
仔细想想后,发现可能是因为在使用的过程中,有人重新启动了数据库,而没有重新启动server.造成server中的数据库连接池中的连接都已经断开.
故,重新实现自己认为的错误过程,重新启动了db2,但是不重新启动server,确实造成了connection中断.出现以上问题.
我想原因大概如此吧.