<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>there could be probably some C3P0 parameter dealing with this,
but the first question I would ask is:</p>
<p>Why is Oracle DB closing the connections?<br>
</p>
<pre class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
<div class="moz-cite-prefix">On 26.10.2017 17:18, IDM wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFdx=BBXgT=q92GE8cBsjnTRO6BbQTYAHx=ZPNzVd1bzfaZqPA@mail.gmail.com">
<div dir="ltr">Hello.
<div><br>
</div>
<div>We have midpoint in 2 Tomcat instances over Oracle DB.
We are getting errors with the DB. The DB is closing he
sockets without notifing Midpoint so at the next operation,
Midpoint fails using this socket due to this. </div>
<div><br>
</div>
<div>There is some configuration, or parameter in the
config.xml we can use to solve it ?</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><b>1.The error is :</b></div>
<div><br>
</div>
<div><font size="1" face="monospace, monospace">2017-10-18
14:34:26,108 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
WARN (com.mchange.v2.c3p0.impl.NewP<wbr>ooledConnection):
[c3p0] A PooledConnection that has already signalled a
Connection error is still in use!<br>
2017-10-18 14:34:26,109 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
WARN (com.mchange.v2.c3p0.impl.NewP<wbr>ooledConnection):
[c3p0] Another error has occurred [
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection ]
which will not be reported to listeners!<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.getAutoCommit(Physical<wbr>Connection.java:4337)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.rollback(PhysicalConne<wbr>ction.java:4507)
~[na:12.1.0.1.0]<br>
at com.mchange.v2.c3p0.impl.NewPr<wbr>oxyConnection.rollback(NewProx<wbr>yConnection.java:860)
~[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at sun.reflect.NativeMethodAccess<wbr>orImpl.invoke0(Native
Method) ~[na:1.8.0_101]<br>
at sun.reflect.NativeMethodAccess<wbr>orImpl.invoke(NativeMethodAcce<wbr>ssorImpl.java:62)
~[na:1.8.0_101]<br>
at sun.reflect.DelegatingMethodAc<wbr>cessorImpl.invoke(DelegatingMe<wbr>thodAccessorImpl.java:43)
~[na:1.8.0_101]<br>
at java.lang.reflect.Method.invok<wbr>e(Method.java:498)
~[na:1.8.0_101]<br>
at org.quartz.impl.jdbcjobstore.A<wbr>ttributeRestoringConnectionInv<wbr>ocationHandler.invoke(Attribut<wbr>eRestoringConnectionInvocation<wbr>Handler.java:73)
[quartz-2.2.3.jar:na]<br>
at com.sun.proxy.$Proxy106.rollba<wbr>ck(Unknown
Source) [na:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.rollbackConnect<wbr>ion(JobStoreSupport.java:3666)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.executeInNonMan<wbr>agedTXLock(JobStoreSupport.<wbr>java:3825)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>gers(JobStoreSupport.java:<wbr>2756)
[quartz-2.2.3.jar:na]<br>
at org.quartz.core.QuartzSchedule<wbr>rThread.run(QuartzSchedulerThr<wbr>ead.java:272)
[quartz-2.2.3.jar:na]<br>
2017-10-18 14:34:26,109 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
ERROR (org.quartz.impl.jdbcjobstore.<wbr>JobStoreTX):
Couldn't rollback jdbc connection. Closed Connection<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.getAutoCommit(Physical<wbr>Connection.java:4337)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.rollback(PhysicalConne<wbr>ction.java:4507)
~[na:12.1.0.1.0]<br>
at com.mchange.v2.c3p0.impl.NewPr<wbr>oxyConnection.rollback(NewProx<wbr>yConnection.java:860)
~[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at sun.reflect.NativeMethodAccess<wbr>orImpl.invoke0(Native
Method) ~[na:1.8.0_101]<br>
at sun.reflect.NativeMethodAccess<wbr>orImpl.invoke(NativeMethodAcce<wbr>ssorImpl.java:62)
~[na:1.8.0_101]<br>
at sun.reflect.DelegatingMethodAc<wbr>cessorImpl.invoke(DelegatingMe<wbr>thodAccessorImpl.java:43)
~[na:1.8.0_101]<br>
at java.lang.reflect.Method.invok<wbr>e(Method.java:498)
~[na:1.8.0_101]<br>
at org.quartz.impl.jdbcjobstore.A<wbr>ttributeRestoringConnectionInv<wbr>ocationHandler.invoke(Attribut<wbr>eRestoringConnectionInvocation<wbr>Handler.java:73)
~[quartz-2.2.3.jar:na]<br>
at com.sun.proxy.$Proxy106.rollba<wbr>ck(Unknown
Source) ~[na:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.rollbackConnect<wbr>ion(JobStoreSupport.java:3666)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.executeInNonMan<wbr>agedTXLock(JobStoreSupport.<wbr>java:3825)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>gers(JobStoreSupport.java:<wbr>2756)
[quartz-2.2.3.jar:na]<br>
at org.quartz.core.QuartzSchedule<wbr>rThread.run(QuartzSchedulerThr<wbr>ead.java:272)
[quartz-2.2.3.jar:na]<br>
2017-10-18 14:34:26,111 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
WARN (com.mchange.v2.c3p0.impl.NewP<wbr>ooledConnection):
[c3p0] A PooledConnection that has already signalled a
Connection error is still in use!<br>
2017-10-18 14:34:26,111 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
WARN (com.mchange.v2.c3p0.impl.NewP<wbr>ooledConnection):
[c3p0] Another error has occurred [
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection ]
which will not be reported to listeners!<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.setAutoCommit(Physical<wbr>Connection.java:4315)
~[na:12.1.0.1.0]<br>
at com.mchange.v2.c3p0.impl.NewPr<wbr>oxyConnection.setAutoCommit(Ne<wbr>wProxyConnection.java:912)
~[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at org.quartz.impl.jdbcjobstore.A<wbr>ttributeRestoringConnectionInv<wbr>ocationHandler.restoreOriginal<wbr>Atributes(AttributeRestoringCo<wbr>nnectionInvocationHandler.<wbr>java:141)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.cleanupConnecti<wbr>on(JobStoreSupport.java:3616)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.executeInNonMan<wbr>agedTXLock(JobStoreSupport.<wbr>java:3835)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>gers(JobStoreSupport.java:<wbr>2756)
[quartz-2.2.3.jar:na]<br>
at org.quartz.core.QuartzSchedule<wbr>rThread.run(QuartzSchedulerThr<wbr>ead.java:272)
[quartz-2.2.3.jar:na]<br>
2017-10-18 14:34:26,111 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
WARN (org.quartz.impl.jdbcjobstore.<wbr>AttributeRestoringConnectionIn<wbr>vocationHandler):
Failed restore connection's original auto commit setting.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.setAutoCommit(Physical<wbr>Connection.java:4315)
~[na:12.1.0.1.0]<br>
at com.mchange.v2.c3p0.impl.NewPr<wbr>oxyConnection.setAutoCommit(Ne<wbr>wProxyConnection.java:912)
~[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at org.quartz.impl.jdbcjobstore.A<wbr>ttributeRestoringConnectionInv<wbr>ocationHandler.restoreOriginal<wbr>Atributes(AttributeRestoringCo<wbr>nnectionInvocationHandler.<wbr>java:141)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.cleanupConnecti<wbr>on(JobStoreSupport.java:3616)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.executeInNonMan<wbr>agedTXLock(JobStoreSupport.<wbr>java:3835)
[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>gers(JobStoreSupport.java:<wbr>2756)
[quartz-2.2.3.jar:na]<br>
at org.quartz.core.QuartzSchedule<wbr>rThread.run(QuartzSchedulerThr<wbr>ead.java:272)
[quartz-2.2.3.jar:na]<br>
2017-10-18 14:34:26,115 [] [C3P0PooledConnectionPoolManag<wbr>er[identityToken->1bqrhnx9rd69<wbr>7zdr1tks2|7417a2b7]-<wbr>HelperThread-#2]
WARN (com.mchange.v1.db.sql.Stateme<wbr>ntUtils): Statement
close FAILED.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.needLine(PhysicalConne<wbr>ction.java:6295)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.closeOrCache(OracleStatem<wbr>ent.java:1364)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.close(OracleStatement.<wbr>java:1343)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>mentWrapper.close(OracleStatem<wbr>entWrapper.java:100)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.close(Orac<wbr>lePreparedStatementWrapper.<wbr>java:82)
~[na:12.1.0.1.0]<br>
at com.mchange.v1.db.sql.Statemen<wbr>tUtils.attemptClose(StatementU<wbr>tils.java:53)
~[mchange-commons-java-0.2.3.4<wbr>.jar:na]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache$StatementDestr<wbr>uctionManager.synchronousDestr<wbr>oyStatement(GooGooStatementCac<wbr>he.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache.closeAll(GooGo<wbr>oStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeAllCachedS<wbr>tatements(NewPooledConnection.<wbr>java:768)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.close(NewPooled<wbr>Connection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeMaybeCheck<wbr>edOut(NewPooledConnection.<wbr>java:259)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.C3P0P<wbr>ooledConnectionPool$1PooledCon<wbr>nectionResourcePoolManager.<wbr>destroyResource(C3P0PooledConn<wbr>ectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at <a href="http://com.mchange.v2.resourcepool.Ba"
moz-do-not-send="true">com.mchange.v2.resourcepool.Ba</a><wbr>sicResourcePool$1DestroyResour<wbr>ceTask.run(BasicResourcePool.<wbr>java:1024)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.async.ThreadPoo<wbr>lAsynchronousRunner$PoolThread<wbr>.run(ThreadPoolAsynchronousRun<wbr>ner.java:648)
[mchange-commons-java-0.2.3.4.<wbr>jar:na]<br>
2017-10-18 14:34:26,116 [] [C3P0PooledConnectionPoolManag<wbr>er[identityToken->1bqrhnx9rd69<wbr>7zdr1tks2|7417a2b7]-<wbr>HelperThread-#2]
WARN (com.mchange.v1.db.sql.Stateme<wbr>ntUtils): Statement
close FAILED.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.needLine(PhysicalConne<wbr>ction.java:6295)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.closeOrCache(OracleStatem<wbr>ent.java:1364)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.close(OracleStatement.<wbr>java:1343)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>mentWrapper.close(OracleStatem<wbr>entWrapper.java:100)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.close(Orac<wbr>lePreparedStatementWrapper.<wbr>java:82)
~[na:12.1.0.1.0]<br>
at com.mchange.v1.db.sql.Statemen<wbr>tUtils.attemptClose(StatementU<wbr>tils.java:53)
~[mchange-commons-java-0.2.3.4<wbr>.jar:na]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache$StatementDestr<wbr>uctionManager.synchronousDestr<wbr>oyStatement(GooGooStatementCac<wbr>he.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache.closeAll(GooGo<wbr>oStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeAllCachedS<wbr>tatements(NewPooledConnection.<wbr>java:768)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.close(NewPooled<wbr>Connection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeMaybeCheck<wbr>edOut(NewPooledConnection.<wbr>java:259)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.C3P0P<wbr>ooledConnectionPool$1PooledCon<wbr>nectionResourcePoolManager.<wbr>destroyResource(C3P0PooledConn<wbr>ectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at <a href="http://com.mchange.v2.resourcepool.Ba"
moz-do-not-send="true">com.mchange.v2.resourcepool.Ba</a><wbr>sicResourcePool$1DestroyResour<wbr>ceTask.run(BasicResourcePool.<wbr>java:1024)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.async.ThreadPoo<wbr>lAsynchronousRunner$PoolThread<wbr>.run(ThreadPoolAsynchronousRun<wbr>ner.java:648)
[mchange-commons-java-0.2.3.4.<wbr>jar:na]<br>
2017-10-18 14:34:26,116 [] [C3P0PooledConnectionPoolManag<wbr>er[identityToken->1bqrhnx9rd69<wbr>7zdr1tks2|7417a2b7]-<wbr>HelperThread-#2]
WARN (com.mchange.v1.db.sql.Stateme<wbr>ntUtils): Statement
close FAILED.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.needLine(PhysicalConne<wbr>ction.java:6295)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.closeOrCache(OracleStatem<wbr>ent.java:1364)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.close(OracleStatement.<wbr>java:1343)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>mentWrapper.close(OracleStatem<wbr>entWrapper.java:100)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.close(Orac<wbr>lePreparedStatementWrapper.<wbr>java:82)
~[na:12.1.0.1.0]<br>
at com.mchange.v1.db.sql.Statemen<wbr>tUtils.attemptClose(StatementU<wbr>tils.java:53)
~[mchange-commons-java-0.2.3.4<wbr>.jar:na]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache$StatementDestr<wbr>uctionManager.synchronousDestr<wbr>oyStatement(GooGooStatementCac<wbr>he.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache.closeAll(GooGo<wbr>oStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeAllCachedS<wbr>tatements(NewPooledConnection.<wbr>java:768)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.close(NewPooled<wbr>Connection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeMaybeCheck<wbr>edOut(NewPooledConnection.<wbr>java:259)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.C3P0P<wbr>ooledConnectionPool$1PooledCon<wbr>nectionResourcePoolManager.<wbr>destroyResource(C3P0PooledConn<wbr>ectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at <a href="http://com.mchange.v2.resourcepool.Ba"
moz-do-not-send="true">com.mchange.v2.resourcepool.Ba</a><wbr>sicResourcePool$1DestroyResour<wbr>ceTask.run(BasicResourcePool.<wbr>java:1024)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.async.ThreadPoo<wbr>lAsynchronousRunner$PoolThread<wbr>.run(ThreadPoolAsynchronousRun<wbr>ner.java:648)
[mchange-commons-java-0.2.3.4.<wbr>jar:na]<br>
2017-10-18 14:34:26,116 [] [midPointScheduler_QuartzSched<wbr>ulerThread]
ERROR (org.quartz.core.ErrorLogger): An error occurred while
scanning for the next triggers to fire.<br>
org.quartz.JobPersistenceExcep<wbr>tion: Couldn't acquire
next trigger: IO Error: Connection timed out<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>ger(JobStoreSupport.java:2864)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport$40.execute(JobS<wbr>toreSupport.java:2759)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport$40.execute(JobS<wbr>toreSupport.java:2757)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.executeInNonMan<wbr>agedTXLock(JobStoreSupport.<wbr>java:3803)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>gers(JobStoreSupport.java:<wbr>2756)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.core.QuartzSchedule<wbr>rThread.run(QuartzSchedulerThr<wbr>ead.java:272)
~[quartz-2.2.3.jar:na]<br>
Caused by: java.sql.SQLRecoverableExcepti<wbr>on: IO Error:
Connection timed out<br>
at oracle.jdbc.driver.T4CPrepared<wbr>Statement.executeForRows(T4CPr<wbr>eparedStatement.java:967)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.executeMaybeDescribe(Orac<wbr>leStatement.java:929)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.doExecuteWithTimeout(Orac<wbr>leStatement.java:1034)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatement.executeInternal(O<wbr>raclePreparedStatement.java:38<wbr>20)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatement.executeQuery(Orac<wbr>lePreparedStatement.java:3867)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.<wbr>executeQuery(OraclePreparedSta<wbr>tementWrapper.java:1502)
~[na:12.1.0.1.0]<br>
at com.mchange.v2.c3p0.impl.NewPr<wbr>oxyPreparedStatement.executeQu<wbr>ery(NewProxyPreparedStatement.<wbr>java:116)
~[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at org.quartz.impl.jdbcjobstore.S<wbr>tdJDBCDelegate.selectTriggerTo<wbr>Acquire(StdJDBCDelegate.java:<wbr>2613)
~[quartz-2.2.3.jar:na]<br>
at org.quartz.impl.jdbcjobstore.J<wbr>obStoreSupport.acquireNextTrig<wbr>ger(JobStoreSupport.java:2798)
~[quartz-2.2.3.jar:na]<br>
... 5 common frames omitted<br>
Caused by: java.net.SocketException: Connection timed out<br>
at java.net.SocketInputStream.soc<wbr>ketRead0(Native
Method) ~[na:1.8.0_101]<br>
at java.net.SocketInputStream.soc<wbr>ketRead(SocketInputStream.java<wbr>:116)
~[na:1.8.0_101]<br>
at java.net.SocketInputStream.rea<wbr>d(SocketInputStream.java:170)
~[na:1.8.0_101]<br>
at java.net.SocketInputStream.rea<wbr>d(SocketInputStream.java:141)
~[na:1.8.0_101]<br>
at oracle.net.ns.Packet.receive(P<wbr>acket.java:311)
~[na:12.1.0.1.0]<br>
at oracle.net.ns.DataPacket.recei<wbr>ve(DataPacket.java:105)
~[na:12.1.0.1.0]<br>
at oracle.net.ns.NetInputStream.g<wbr>etNextPacket(NetInputStream.ja<wbr>va:305)
~[na:12.1.0.1.0]<br>
at oracle.net.ns.NetInputStream.r<wbr>ead(NetInputStream.java:249)
~[na:12.1.0.1.0]<br>
at oracle.net.ns.NetInputStream.r<wbr>ead(NetInputStream.java:171)
~[na:12.1.0.1.0]<br>
at oracle.net.ns.NetInputStream.r<wbr>ead(NetInputStream.java:89)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CSocketIn<wbr>putStreamWrapper.readNextPacke<wbr>t(T4CSocketInputStreamWrapper.<wbr>java:123)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CSocketIn<wbr>putStreamWrapper.read(T4CSocke<wbr>tInputStreamWrapper.java:79)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CMAREngin<wbr>eStream.unmarshalUB1(T4CMAREng<wbr>ineStream.java:426)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CTTIfun.r<wbr>eceive(T4CTTIfun.java:390)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CTTIfun.d<wbr>oRPC(T4CTTIfun.java:249)
~[na:12.1.0.1.0]<br>
at <a href="http://oracle.jdbc.driver.T4C8Oall.do"
moz-do-not-send="true">oracle.jdbc.driver.T4C8Oall.do</a><wbr>OALL(T4C8Oall.java:566)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CPrepared<wbr>Statement.doOall8(T4CPreparedS<wbr>tatement.java:215)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CPrepared<wbr>Statement.doOall8(T4CPreparedS<wbr>tatement.java:58)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.T4CPrepared<wbr>Statement.executeForRows(T4CPr<wbr>eparedStatement.java:943)
~[na:12.1.0.1.0]<br>
... 13 common frames omitted<br>
2017-10-18 14:34:26,117 [] [C3P0PooledConnectionPoolManag<wbr>er[identityToken->1bqrhnx9rd69<wbr>7zdr1tks2|7417a2b7]-<wbr>HelperThread-#2]
WARN (com.mchange.v1.db.sql.Stateme<wbr>ntUtils): Statement
close FAILED.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.needLine(PhysicalConne<wbr>ction.java:6295)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.closeOrCache(OracleStatem<wbr>ent.java:1364)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.close(OracleStatement.<wbr>java:1343)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>mentWrapper.close(OracleStatem<wbr>entWrapper.java:100)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.close(Orac<wbr>lePreparedStatementWrapper.<wbr>java:82)
~[na:12.1.0.1.0]<br>
at com.mchange.v1.db.sql.Statemen<wbr>tUtils.attemptClose(StatementU<wbr>tils.java:53)
~[mchange-commons-java-0.2.3.4<wbr>.jar:na]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache$StatementDestr<wbr>uctionManager.synchronousDestr<wbr>oyStatement(GooGooStatementCac<wbr>he.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache.closeAll(GooGo<wbr>oStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeAllCachedS<wbr>tatements(NewPooledConnection.<wbr>java:768)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.close(NewPooled<wbr>Connection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeMaybeCheck<wbr>edOut(NewPooledConnection.<wbr>java:259)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.C3P0P<wbr>ooledConnectionPool$1PooledCon<wbr>nectionResourcePoolManager.<wbr>destroyResource(C3P0PooledConn<wbr>ectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at <a href="http://com.mchange.v2.resourcepool.Ba"
moz-do-not-send="true">com.mchange.v2.resourcepool.Ba</a><wbr>sicResourcePool$1DestroyResour<wbr>ceTask.run(BasicResourcePool.<wbr>java:1024)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.async.ThreadPoo<wbr>lAsynchronousRunner$PoolThread<wbr>.run(ThreadPoolAsynchronousRun<wbr>ner.java:648)
[mchange-commons-java-0.2.3.4.<wbr>jar:na]<br>
2017-10-18 14:34:26,117 [] [C3P0PooledConnectionPoolManag<wbr>er[identityToken->1bqrhnx9rd69<wbr>7zdr1tks2|7417a2b7]-<wbr>HelperThread-#2]
WARN (com.mchange.v1.db.sql.Stateme<wbr>ntUtils): Statement
close FAILED.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.needLine(PhysicalConne<wbr>ction.java:6295)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.closeOrCache(OracleStatem<wbr>ent.java:1364)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.close(OracleStatement.<wbr>java:1343)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>mentWrapper.close(OracleStatem<wbr>entWrapper.java:100)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.close(Orac<wbr>lePreparedStatementWrapper.<wbr>java:82)
~[na:12.1.0.1.0]<br>
at com.mchange.v1.db.sql.Statemen<wbr>tUtils.attemptClose(StatementU<wbr>tils.java:53)
~[mchange-commons-java-0.2.3.4<wbr>.jar:na]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache$StatementDestr<wbr>uctionManager.synchronousDestr<wbr>oyStatement(GooGooStatementCac<wbr>he.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache.closeAll(GooGo<wbr>oStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeAllCachedS<wbr>tatements(NewPooledConnection.<wbr>java:768)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.close(NewPooled<wbr>Connection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeMaybeCheck<wbr>edOut(NewPooledConnection.<wbr>java:259)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.C3P0P<wbr>ooledConnectionPool$1PooledCon<wbr>nectionResourcePoolManager.<wbr>destroyResource(C3P0PooledConn<wbr>ectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at <a href="http://com.mchange.v2.resourcepool.Ba"
moz-do-not-send="true">com.mchange.v2.resourcepool.Ba</a><wbr>sicResourcePool$1DestroyResour<wbr>ceTask.run(BasicResourcePool.<wbr>java:1024)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.async.ThreadPoo<wbr>lAsynchronousRunner$PoolThread<wbr>.run(ThreadPoolAsynchronousRun<wbr>ner.java:648)
[mchange-commons-java-0.2.3.4.<wbr>jar:na]<br>
2017-10-18 14:34:26,117 [] [C3P0PooledConnectionPoolManag<wbr>er[identityToken->1bqrhnx9rd69<wbr>7zdr1tks2|7417a2b7]-<wbr>HelperThread-#2]
WARN (com.mchange.v1.db.sql.Stateme<wbr>ntUtils): Statement
close FAILED.<br>
java.sql.SQLRecoverableExcepti<wbr>on: Closed Connection<br>
at oracle.jdbc.driver.PhysicalCon<wbr>nection.needLine(PhysicalConne<wbr>ction.java:6295)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.closeOrCache(OracleStatem<wbr>ent.java:1364)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>ment.close(OracleStatement.<wbr>java:1343)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OracleState<wbr>mentWrapper.close(OracleStatem<wbr>entWrapper.java:100)
~[na:12.1.0.1.0]<br>
at oracle.jdbc.driver.OraclePrepa<wbr>redStatementWrapper.close(Orac<wbr>lePreparedStatementWrapper.<wbr>java:82)
~[na:12.1.0.1.0]<br>
at com.mchange.v1.db.sql.Statemen<wbr>tUtils.attemptClose(StatementU<wbr>tils.java:53)
~[mchange-commons-java-0.2.3.4<wbr>.jar:na]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache$StatementDestr<wbr>uctionManager.synchronousDestr<wbr>oyStatement(GooGooStatementCac<wbr>he.java:947)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.stmt.GooGo<wbr>oStatementCache.closeAll(GooGo<wbr>oStatementCache.java:387)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeAllCachedS<wbr>tatements(NewPooledConnection.<wbr>java:768)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.close(NewPooled<wbr>Connection.java:609)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.NewPo<wbr>oledConnection.closeMaybeCheck<wbr>edOut(NewPooledConnection.<wbr>java:259)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.c3p0.impl.C3P0P<wbr>ooledConnectionPool$1PooledCon<wbr>nectionResourcePoolManager.<wbr>destroyResource(C3P0PooledConn<wbr>ectionPool.java:619)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at <a href="http://com.mchange.v2.resourcepool.Ba"
moz-do-not-send="true">com.mchange.v2.resourcepool.Ba</a><wbr>sicResourcePool$1DestroyResour<wbr>ceTask.run(BasicResourcePool.<wbr>java:1024)
[c3p0-0.9.2.1.jar:0.9.2.1]<br>
at com.mchange.v2.async.ThreadPoo<wbr>lAsynchronousRunner$PoolThread<wbr>.run(ThreadPoolAsynchronousRun<wbr>ner.java:648)
[mchange-commons-java-0.2.3.4.<wbr>jar:na]</font><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><b>2. OurOur config.xml is: </b></div>
<div><br>
</div>
<div><font size="1" face="monospace, monospace">[...]</font></div>
<div>
<div><font size="1" face="monospace, monospace"><midpoint></font></div>
<div><font size="1" face="monospace, monospace">
<webApplication></font></div>
<div><font size="1" face="monospace, monospace">
<importFolder>${midpoint.home}<wbr>/import</importFolder></font></div>
<div><font size="1" face="monospace, monospace">
</webApplication></font></div>
<div><font size="1" face="monospace, monospace">
<repository></font></div>
<div><font size="1" face="monospace, monospace"> <<wbr>repositoryServiceFactoryClass><wbr>com.evolveum.midpoint.repo.<wbr>sql.SqlRepositoryFactory</<wbr>repositoryServiceFactoryClass></font></div>
<div><font size="1" face="monospace, monospace">
<database>oracle</database></font></div>
<div><font size="1" face="monospace, monospace">
<jdbcUsername>MP_USER</<wbr>jdbcUsername></font></div>
<div><font size="1" face="monospace, monospace">
<jdbcPassword>MP_USERPASS</<wbr>jdbcPassword></font></div>
<div><font size="1" face="monospace, monospace">
<jdbcUrl>jdbc:oracle:thin:@<wbr>hostDB1:1521/path1</jdbcUrl></font></div>
<div><font size="1" face="monospace, monospace">
</repository></font></div>
<div><font size="1" face="monospace, monospace">
<taskManager></font></div>
<div><font size="1" face="monospace, monospace">
<threads>15</threads></font></div>
<div><font size="1" face="monospace, monospace">
<clustered>true</clustered></font></div>
<div><font size="1" face="monospace, monospace">
<jdbcUser>MP_USER</jdbcUser></font></div>
<div><font size="1" face="monospace, monospace">
<jdbcPassword>MP_USERPASS</<wbr>jdbcPassword></font></div>
<div><font size="1" face="monospace, monospace">
<jdbcUrl>jdbc:oracle:thin:@<wbr>hostDB1:1521/path1</jdbcUrl></font></div>
<div><font size="1" face="monospace, monospace">
<jmxUsername>user</<wbr>jmxUsername></font></div>
<div><font size="1" face="monospace, monospace">
<jmxPassword>password</<wbr>jmxPassword></font></div>
<div><font size="1" face="monospace, monospace"><br>
</font></div>
<div><font size="1" face="monospace, monospace">
<jdbcJobStore>true</<wbr>jdbcJobStore></font></div>
<div><font size="1" face="monospace, monospace">
<useThreadInterrupt><wbr>whenNecessary</<wbr>useThreadInterrupt></font></div>
<div><font size="1" face="monospace, monospace"><br>
</font></div>
<div><font size="1" face="monospace, monospace">
<jmxConnectTimeout>5</<wbr>jmxConnectTimeout></font></div>
<div><font size="1" face="monospace, monospace">
<nodeTimeout>30</nodeTimeout></font></div>
<div><font size="1" face="monospace, monospace"> <<wbr>quartzNodeRegistrationInterval<wbr>>10</<wbr>quartzNodeRegistrationInterval<wbr>></font></div>
<div><font size="1" face="monospace, monospace">
<nodeRegistrationInterval>10</<wbr>nodeRegistrationInterval></font></div>
<div><font size="1" face="monospace, monospace">
<stalledTasksCheckInterval><wbr>600</<wbr>stalledTasksCheckInterval></font></div>
<div><font size="1" face="monospace, monospace">
<stalledTasksThreshold>600</<wbr>stalledTasksThreshold></font></div>
<div><font size="1" face="monospace, monospace"> <<wbr>stalledTasksRepeatedNotificati<wbr>onInterval>3600</<wbr>stalledTasksRepeatedNotificati<wbr>onInterval></font></div>
<div><font size="1" face="monospace, monospace">
<runNowKeepsOriginalSchedule><wbr>false</<wbr>runNowKeepsOriginalSchedule></font></div>
<div><font size="1" face="monospace, monospace"><br>
</font></div>
<div><font size="1" face="monospace, monospace">
</taskManager></font></div>
</div>
<div><font size="1" face="monospace, monospace">[...]</font><br>
</div>
</div>
<br>
<p><span>Segun el Articulo 5 de la L.O.P.D, le informamos que sus
datos constan en un fichero titularidad de CORE NETWORKS,
S.L., cuya finalidad es la gestion administrativa. Podra
ejercer su derecho de acceso, rectificacion, cancelacion y
oposicion mediante correo postal a C/ Serrano Galvache, 56,
Edificio Olmo, 1 Planta - C.P. 28033 (MADRID), o enviando un
correo electrónico a <a href="mailto:info@corenetworks.es"
target="_blank" moz-do-not-send="true"><span>info@corenetworks.es</span></a>.</span></p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
</body>
</html>