Hi Isomorphic,
after a network change (before: DB and application server on the same system, now different systems very close by, but not behind same firewall) this exception happens out of the blue from time to time (current 6.1p).
I'm not sure it has any negative consequences, but wanted to double check with you.
Does your pool invalidate connections when this happens and use others instead?
Best regards
Blama
after a network change (before: DB and application server on the same system, now different systems very close by, but not behind same firewall) this exception happens out of the blue from time to time (current 6.1p).
I'm not sure it has any negative consequences, but wanted to double check with you.
Does your pool invalidate connections when this happens and use others instead?
Code:
=== 2018-10-18 04:30:17,727 [c-13] WARN PoolableSQLConnectionFactory - [builtinApplication.fetchFirstRow] Exception running pingTest: IO Error: Connection timed out (Read failed)
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:5416)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1585)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1570)
at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:94)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at com.isomorphic.sql.PoolableSQLConnectionFactory.validateObject(PoolableSQLConnectionFactory.java:221)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1205)
at com.isomorphic.pool.ISCObjectPool.borrowObject(ISCObjectPool.java:112)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:102)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:76)
at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:177)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:950)
at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1391)
at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:585)
at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:579)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1768)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:439)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:384)
at com.lmscompany.lms.server.LMSSQLDataSource.executeFetch(LMSSQLDataSource.java:148)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:2274)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:638)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:548)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2815)
at com.lmscompany.lms.server.SendMail.writeActionMails(SendMail.java:161)
at com.lmscompany.lms.server.SendMail.doGet(SendMail.java:41)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:247)
at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:479)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Blama
Comment