topic Re: Alfresco Error: JDBC rollback failed in Alfresco Archive

Alfresco Error: JDBC rollback failed

paramesh — Wed, 08 Aug 2012 09:56:02 GMT

Hi All,I am getting some errors after i start the alfresco service….due to which my website loading slowly…please tell me how to resolve this///14:48:41,082 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failedjava.sql.SQLNonTransientConnectionException: No current connection.

Re: Alfresco Error: JDBC rollback failed

jpotts — Wed, 08 Aug 2012 20:23:01 GMT

Are you intentionally using Derby as your database? Most people find that may work okay for local development, but if you are running a web site in front of Alfresco you should be using MySQL or PostgreSQL or some other database.

Jeff

Re: Alfresco Error: JDBC rollback failed

paramesh — Thu, 09 Aug 2012 06:53:38 GMT

Are you intentionally using Derby as your database? Most people find that may work okay for local development, but if you are running a web site in front of Alfresco you should be using MySQL or PostgreSQL or some other database.

Jeff

Hell sir,
we already implemented in derby database and it is running…could you please tell me what is the procedure to use mysql now.

Re: Alfresco Error: JDBC rollback failed

bisana — Thu, 09 Aug 2012 07:03:59 GMT

You need to download MySQL Java driver in 'lib' directory
and you need to do the changes in "tomcat/shared/classes/alfresco-global.properties" for MySQL databases