Java. SQL. SQLRecoverableException: IO error: Socketclosed
Today, weblogic's alllog reports many socket closed errors.
### Cause: org. hibernate. exception. JDBCConnectionException: IO error: Socket closed
At com. gg. corm. exceptions. ExceptionFactory. wrapException (ExceptionFactory. java: 23 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com. gg. corm. session. defaults. DefaultSqlSession. selectList (DefaultSqlSession. java: 104 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com. gg. corm. session. defaults. DefaultSqlSession. selectList (DefaultSqlSession. java: 95 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com. gg. corm. session. defaults. DefaultSqlSession. selectOne (DefaultSqlSession. java: 59 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com.gg.sproc.core.base.dao.mybatisdao=6.exe cute (MyBatisDAO. java: 241 )~ [Sproc-core-1.3.1-20141225.jar: 1.3.1-20141225]
At org.hibernate.jdbc.WorkExecutor.exe cuteWork (WorkExecutor. java: 54 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. internal. SessionImpl $2. accept (SessionImpl. java: 1936 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. internal. SessionImpl $2. accept (SessionImpl. java: 1933 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. engine. jdbc. internal. JdbcCoordinatorImpl. coordinateWork (JdbcCoordinatorImpl. java: 211 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. internal. SessionImpl. doWork (SessionImpl. java: 1954 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. internal. SessionImpl. doWork (SessionImpl. java: 1940 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At com. gg. sproc. core. base. dao. MyBatisDAO. getObject (MyBatisDAO. java: 236 )~ [Sproc-core-1.3.1-20141225.jar: 1.3.1-20141225]
... 75 common frames omitted
Caused by: org. hibernate. exception. JDBCConnectionException: IO error: Socket closed
At org. hibernate. exception. internal. SQLStateConversionDelegate. convert (SQLStateConversionDelegate. java: 131 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. exception. internal. StandardSQLExceptionConverter. convert (StandardSQLExceptionConverter. java: 49 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. engine. jdbc. spi. SqlExceptionHelper. convert (SqlExceptionHelper. java: 125 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. engine. jdbc. spi. SqlExceptionHelper. convert (SqlExceptionHelper. java: 110 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. engine. jdbc. internal. proxy. AbstractStatementProxyHandler. continueInvocation (AbstractStatementProxyHandler. java: 129 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At org. hibernate. engine. jdbc. internal. proxy. AbstractProxyHandler. invoke (AbstractProxyHandler. java: 81 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
At com.sun.proxy.w.proxy250.exe cute (Unknown Source )~ [Na: na]
At com.gg.corm.exe cutor. statement. PreparedStatementHandler. query (PreparedStatementHandler. java: 56 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com.gg.corm.exe cutor. statement. RoutingStatementHandler. query (RoutingStatementHandler. java: 70 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At sun. reflect. GeneratedMethodAccessor197.invoke (Unknown Source )~ [Na: na]
At sun. reflect. DelegatingMethodAccessorImpl. invoke (DelegatingMethodAccessorImpl. java: 43 )~ [Na: 1.7.0 _ 40]
At java. lang. reflect. Method. invoke (Method. java: 606 )~ [Na: 1.7.0 _ 40]
At com. gg. corm. plugin. Plugin. invoke (Plugin. java: 59 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com. sun. proxy. $ Proxy234.query (Unknown Source )~ [Na: na]
At com.gg.corm.exe cutor. SimpleExecutor. doQuery (SimpleExecutor. java: 69 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com.gg.corm.exe cutor. BaseExecutor. queryFromDatabase (BaseExecutor. java: 267 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com.gg.corm.exe cutor. BaseExecutor. query (BaseExecutor. java: 141 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com.gg.corm.exe cutor. CachingExecutor. query (CachingExecutor. java: 105 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com.gg.corm.exe cutor. CachingExecutor. query (CachingExecutor. java: 81 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
At com. gg. corm. session. defaults. DefaultSqlSession. selectList (DefaultSqlSession. java: 101 )~ [Gg-top-corm-3.1.2-20141209.jar: na]
... 85 common frames omitted
Caused by: java. SQL. SQLRecoverableException: IO error: Socket closed
At oracle.jdbc.driver.T4CPreparedStatement.exe cuteForDescribe (T4CPreparedStatement. java: 897 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.jdbc.driver.OracleStatement.exe cuteMaybeDescribe (OracleStatement. java: 1167 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. OracleStatement. doExecuteWithTimeout (OracleStatement. java: 1289 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.jdbc.driver.OraclePreparedStatement.exe cuteInternal (OraclePreparedStatement. java: 3594 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.jdbc.driver.OraclePreparedStatement.exe cute (OraclePreparedStatement. java: 3695 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.jdbc.driver.OraclePreparedStatementWrapper.exe cute (OraclePreparedStatementWrapper. java: 1378 )~ [Ojdbc6.jar: 11.2.0.3.0]
At weblogic.jdbc.wrapper.PreparedStatement.exe cute (PreparedStatement. java: 101 )~ [Weblogic. server. merged. jar: 12.1.2.0.0]
At sun. reflect. GeneratedMethodAccessor695.invoke (Unknown Source )~ [Na: na]
At sun. reflect. DelegatingMethodAccessorImpl. invoke (DelegatingMethodAccessorImpl. java: 43 )~ [Na: 1.7.0 _ 40]
At java. lang. reflect. Method. invoke (Method. java: 606 )~ [Na: 1.7.0 _ 40]
At org. hibernate. engine. jdbc. internal. proxy. AbstractStatementProxyHandler. continueInvocation (AbstractStatementProxyHandler. java: 122 )~ [Com. gg. top. thirdparty-hibernate-core-4.1.9.Final.jar: 4.1.9.Final]
... 100 common frames omitted
Caused by: java.net. SocketException: Socket closed
At java.net. SocketInputStream. socketRead0 (Native Method )~ [Na: 1.7.0 _ 40]
At java.net. SocketInputStream. read (SocketInputStream. java: 152 )~ [Na: 1.7.0 _ 40]
At java.net. SocketInputStream. read (SocketInputStream. java: 122 )~ [Na: 1.7.0 _ 40]
At oracle.net. ns. Packet. receive (Packet. java: 300 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.net. ns. DataPacket. receive (DataPacket. java: 106 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.net. ns. NetInputStream. getNextPacket (NetInputStream. java: 315 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.net. ns. NetInputStream. read (NetInputStream. java: 260 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.net. ns. NetInputStream. read (NetInputStream. java: 185 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.net. ns. NetInputStream. read (NetInputStream. java: 102 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4CSocketInputStreamWrapper. readNextPacket (T4CSocketInputStreamWrapper. java: 124 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4CSocketInputStreamWrapper. read (T4CSocketInputStreamWrapper. java: 80 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4CMAREngine. unmarshalUB1 (T4CMAREngine. java: 1137 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4CTTIfun. receive (T4CTTIfun. java: 290 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4CTTIfun. doRPC (T4CTTIfun. java: 192 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4C8Oall. doOALL (T4C8Oall. java: 531 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle. jdbc. driver. T4CPreparedStatement. doOall8 (T4CPreparedStatement. java: 207 )~ [Ojdbc6.jar: 11.2.0.3.0]
At oracle.jdbc.driver.T4CPreparedStatement.exe cuteForDescribe (T4CPreparedStatement. java: 884 )~ [Ojdbc6.jar: 11.2.0.3.0]
... 110 common frames omitted
Check the server log and find the time period when the socket closed error is reported in alllog:
#### <11:37:22 A.M. CST> <Info> <JDBC> <scgg15140> <appServer> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic. kernel. default (self-tuning) '> <WLS Kernel> <1420429042060> <BEA-001128> <Connection for pool "ggDataSource" has been closed.>
#### <11:38:32 A.M. CST> <Info> <JDBC> <scgg15140> <appServer> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic. kernel. default (self-tuning) '> <WLS Kernel> <1420429112057> <BEA-001128> <Connection for pool "ggDataSource" has been closed.>
#### <11:38:52 A.M. CST> <Info> <JDBC> <scgg15140> <appServer> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic. kernel. default (self-tuning) '> <WLS Kernel> <1420429132057> <BEA-001128> <Connection for pool "ggDataSource" has been closed.>
#### <11:51:32 A.M. CST> <Info> <JDBC> <scgg15140> <appServer> <[ACTIVE] ExecuteThread: '13' for queue: 'weblogic. kernel. default (self-tuning) '> <WLS Kernel> <1420429892057> <BEA-001128> <Connection for pool "ggDataSource" has been closed.>
The connection pool is closed. There are two possible reasons: Database problems, and network problems that cause the database to be unable to connect.
Check alert. log of the database again. If no exception is found, it indicates a network problem.
