topic oracle connection closed error from share in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284004#M237134 <HTML><HEAD></HEAD><BODY><SPAN>Dear Forum Members,</SPAN><BR /><BR /><SPAN>Getting the below connection closed error from share. Using jboss 6.2 Enterprise, oracle 11g, alfresco 4.2.3.3 on windows server 2008 64 bit.</SPAN><BR /><SPAN>Share works for a day or so and then started throwing error. once we restart server or flush pool from jboss admin console it starts working again.</SPAN><BR /><BR /><SPAN>Please share your thoughts on this.</SPAN><BR /><BR /><SPAN>–Error message–</SPAN><BR /><BR /><BR /><SPAN>org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC commit failed</SPAN><BR /><SPAN>caused by:</SPAN><BR /><SPAN>org.hibernate.TransactionException: JDBC commit failed</SPAN><BR /><SPAN>caused by:</SPAN><BR /><SPAN>java.sql.SQLRecoverableException: Closed Connection</SPAN><BR /><BR /><SPAN>Hide Details</SPAN><BR /><BR /><SPAN>org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC commit failed </SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:660) </SPAN><BR /><SPAN>at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) </SPAN><BR /><SPAN>at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) </SPAN><BR /><SPAN>at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) </SPAN><BR /><SPAN>at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) </SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) </SPAN><BR /><SPAN>at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) </SPAN><BR /><SPAN>at com.sun.proxy.$Proxy72.validate(Unknown Source) </SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationHelper.getUser(AuthenticationHelper.java:580) </SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:177) </SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:156) </SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:100) </SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) </SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) </SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) </SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:606) </SPAN><BR /><SPAN>at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:125) </SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) </SPAN><BR /><SPAN>at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) </SPAN><BR /><SPAN>at com.sun.proxy.$Proxy330.doFilter(Unknown Source) </SPAN><BR /><SPAN>at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:82) </SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) </SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) </SPAN><BR /><SPAN>at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:68) </SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) </SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) </SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) </SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:606) </SPAN><BR /><SPAN>at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:125) </SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) </SPAN><BR /><SPAN>at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) </SPAN><BR /><SPAN>at com.sun.proxy.$Proxy330.doFilter(Unknown Source) </SPAN><BR /><SPAN>at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:82) </SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) </SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) </SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61) </SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) </SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) </SPAN><BR /><SPAN>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) </SPAN><BR /><SPAN>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) </SPAN><BR /><SPAN>at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407) </SPAN><BR /><SPAN>at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) </SPAN><BR /><SPAN>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) </SPAN><BR /><SPAN>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) </SPAN><BR /><SPAN>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) </SPAN><BR /><SPAN>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) </SPAN><BR /><SPAN>at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) </SPAN><BR /><SPAN>at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) </SPAN><BR /><SPAN>at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) </SPAN><BR /><SPAN>at java.lang.Thread.run(Thread.java:724) </SPAN><BR /><SPAN>Caused by: org.hibernate.TransactionException: JDBC commit failed </SPAN><BR /><SPAN>at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:130) </SPAN><BR /><SPAN>at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656) </SPAN><BR /><SPAN>… 49 more </SPAN><BR /><SPAN>Caused by: java.sql.SQLRecoverableException: Closed Connection </SPAN><BR /><SPAN>at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3867) </SPAN><BR /><SPAN>at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3907) </SPAN><BR /><SPAN>at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:1063) </SPAN><BR /><SPAN>at org.jboss.jca.adapters.jdbc.WrappedConnection.commit(WrappedConnection.java:758) </SPAN><BR /><SPAN>at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139) </SPAN><BR /><SPAN>at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115) </SPAN><BR /><SPAN>… 50 more </SPAN><BR /><SPAN>Return to application</SPAN><BR /><SPAN>My Content</SPAN><BR /><SPAN>Logout</SPAN><BR /><BR /><BR /><SPAN>—-</SPAN><BR /></BODY></HTML> Tue, 06 Jan 2015 17:20:36 GMT rajeshdk 2015-01-06T17:20:36Z oracle connection closed error from share https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284004#M237134 Dear Forum Members,Getting the below connection closed error from share. Using jboss 6.2 Enterprise, oracle 11g, alfresco 4.2.3.3 on windows server 2008 64 bit.Share works for a day or so and then started throwing error. once we restart server or flush pool from jboss admin console it starts working Tue, 06 Jan 2015 17:20:36 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284004#M237134 rajeshdk 2015-01-06T17:20:36Z Re: oracle connection closed error from share https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284005#M237135 <HTML><HEAD></HEAD><BODY><SPAN>In the jboss console use the flush option to resolve this issue. Hope this helps</SPAN></BODY></HTML> Sun, 20 Sep 2015 20:16:27 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284005#M237135 rajeshdk 2015-09-20T20:16:27Z Re: oracle connection closed error from share https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284006#M237136 <HTML><HEAD></HEAD><BODY><SPAN>Can You please explain how to resolve this in detail please </SPAN></BODY></HTML> Wed, 07 Oct 2015 09:42:35 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-connection-closed-error-from-share/m-p/284006#M237136 dsr471 2015-10-07T09:42:35Z