topic Re: Stuck at SpringTransactionInterceptor execute ! in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187677#M140807 <HTML><HEAD></HEAD><BODY><SPAN>Like Joram mentioned it seems to be a problem with the database connections. Are you using the default Explorer and REST app settings for this? It's using DBCP by default. You might want to try something like C3P0 to see if it solves your issue.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 20 Jun 2014 07:10:14 GMT trademak 2014-06-20T07:10:14Z Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187674#M140804 This is a bit of long story so please bear with me for a minute:We are using mysql database as the backend.We are using the out of the box activiti-explorer.war and activiti-rest.warWe put them in an apache tomcat instance and we modified db.property and pointed them to the mysql database.For the ex Thu, 12 Jun 2014 07:57:58 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187674#M140804 ssun 2014-06-12T07:57:58Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187675#M140805 <HTML><HEAD></HEAD><BODY><SPAN>very strange issue you encountered ….</SPAN><BR /><BR /><SPAN>are the database set up the same? Connection settings / amount of connections. Whats your connection pool settings? I would look into that direction (however … pretty much a shot in the dark)</SPAN></BODY></HTML> Tue, 17 Jun 2014 10:29:34 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187675#M140805 jbarrez 2014-06-17T10:29:34Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187676#M140806 <HTML><HEAD></HEAD><BODY><SPAN>Yes. The databases are the same, with same settings. I simply import a working database dump and a non-working database dump.</SPAN><BR /><SPAN>The working dump is when I put everything up in production. The non-working dump is after a couple of days it accumulated some process and tasks.</SPAN></BODY></HTML> Thu, 19 Jun 2014 23:16:20 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187676#M140806 ssun 2014-06-19T23:16:20Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187677#M140807 <HTML><HEAD></HEAD><BODY><SPAN>Like Joram mentioned it seems to be a problem with the database connections. Are you using the default Explorer and REST app settings for this? It's using DBCP by default. You might want to try something like C3P0 to see if it solves your issue.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 20 Jun 2014 07:10:14 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187677#M140807 trademak 2014-06-20T07:10:14Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187678#M140808 <HTML><HEAD></HEAD><BODY><SPAN>Yes. I am using the default Explorer and REST. The REST has no problem at all including successfully connect to database of course. Only the Explorer stuck. We are using mysql, I dropped the same mysql-connector jar to the lib folder of both REST and Explorer.</SPAN><BR /><SPAN>What is C3P0?</SPAN></BODY></HTML> Fri, 20 Jun 2014 18:44:49 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187678#M140808 ssun 2014-06-20T18:44:49Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187679#M140809 <HTML><HEAD></HEAD><BODY><SPAN>C3P0 is a connection pool (like dbcp, BoneCP, …). Once you go in production it's quite mandatory for performance reasons.</SPAN></BODY></HTML> Fri, 27 Jun 2014 14:10:12 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187679#M140809 jbarrez 2014-06-27T14:10:12Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187680#M140810 <HTML><HEAD></HEAD><BODY><SPAN>Anything specific to C3P0 that makes the explorer need it but rest-api is still lightening fast?</SPAN></BODY></HTML> Fri, 27 Jun 2014 21:19:12 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187680#M140810 ssun 2014-06-27T21:19:12Z Re: Stuck at SpringTransactionInterceptor execute ! https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187681#M140811 <HTML><HEAD></HEAD><BODY><SPAN>No, no specific differences. Just a way to assure that it's not caused by a database connection issue.</SPAN><BR /></BODY></HTML> Mon, 30 Jun 2014 15:22:17 GMT https://connect.hyland.com/t5/alfresco-archive/stuck-at-springtransactioninterceptor-execute/m-p/187681#M140811 trademak 2014-06-30T15:22:17Z