topic Can't recover from connection interruption to Oracle in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9310#M3281 <HTML><HEAD></HEAD><BODY><SPAN>Hello Activiti friends,</SPAN><BR /><BR /><SPAN>Activiti 5.1, Oracle 10G 10.2 database, JDK 1.6.0_16, Tomcat 6.0</SPAN><BR /><BR /><SPAN>Our Oracle database performs a warm backup each night.&nbsp; I'm not aware of any other scheduled tasks/processes that might interrupt a connection. </SPAN><BR /><BR /><SPAN>The next morning Activiti can't connect and throws the attached exception.&nbsp; I've tried ojdbc5.jar and ojdbc6.jar version 11.2.&nbsp; Restarting the applications resolves the issue.</SPAN><BR /><BR /><SPAN>I'll play with it a bit but was hoping someone'd seen this already.&nbsp; Not sure if it is an Oracle driver or iBatis configuration issue.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><SPAN>Erik</SPAN><BR /><BR /><SPAN>### Error querying database.&nbsp; </SPAN><SPAN style="color:#FF0000;">Cause: java.sql.SQLRecoverableException: No more data to read from socket</SPAN><BR /><SPAN>### The error may involve org.activiti.persistence.selectUserById-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: java.sql.SQLRecoverableException: No more data to read from socket</SPAN><BR /><SPAN>org.springframework.extensions.webscripts.WebScriptException: 01030000 Wrapped Exception (with status template): </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: java.sql.SQLRecoverableException: No more data to read from socket</SPAN><BR /><SPAN>### The error may involve org.activiti.persistence.selectUserById-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: java.sql.SQLRecoverableException: No more data to read from socket</SPAN><BR /><SPAN>….</SPAN><BR /><SPAN>Caused by: org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: java.sql.SQLRecoverableException: No more data to read from socket</SPAN><BR /><SPAN>### The error may involve org.activiti.persistence.selectUserById-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: java.sql.SQLRecoverableException: No more data to read from socket</SPAN></BODY></HTML> Thu, 03 Feb 2011 22:13:06 GMT hawkeyeerik 2011-02-03T22:13:06Z Can't recover from connection interruption to Oracle https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9310#M3281 Hello Activiti friends,Activiti 5.1, Oracle 10G 10.2 database, JDK 1.6.0_16, Tomcat 6.0Our Oracle database performs a warm backup each night.&nbsp; I'm not aware of any other scheduled tasks/processes that might interrupt a connection. The next morning Activiti can't connect and throws the attached excep Thu, 03 Feb 2011 22:13:06 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9310#M3281 hawkeyeerik 2011-02-03T22:13:06Z Re: Can't recover from connection interruption to Oracle https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9311#M3282 <HTML><HEAD></HEAD><BODY><SPAN>Hi, we are exactly facing the same problem. If you have found a solution, can you please share it here.</SPAN><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Prashanth</SPAN></BODY></HTML> Wed, 03 Jul 2013 17:26:51 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9311#M3282 azhilprashanth8 2013-07-03T17:26:51Z Re: Can't recover from connection interruption to Oracle https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9312#M3283 <HTML><HEAD></HEAD><BODY><SPAN>Not really Activti related … did you check eg </SPAN><A href="http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error</A><SPAN> ?</SPAN></BODY></HTML> Fri, 05 Jul 2013 11:26:53 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-recover-from-connection-interruption-to-oracle/m-p/9312#M3283 jbarrez 2013-07-05T11:26:53Z