cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC rollback failed after a license file update

joe_l3
Confirmed Champ
Confirmed Champ
Hi,
I updated a "ENTERPRISE MODE" license file in alfresco_home/tomcat/shared/classes/alfresco/license/
Alfresco correctly works but now I've a verbose log of the following error


ERROR [hibernate.transaction.JDBCTransaction] [AlfrescoJbpmJobExecutor:192.168.71.66:1] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
   at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:822)
   at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:839)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)


Here my environment:
SO Redaht 6.1
Alfresco 4.0.2.9 enterprise
Postgresql Server 8.1.23 - jdbc postgresql-9.0-802.jdbc4.jar
JDK 1.6.0_31 64-bit

2 REPLIES 2

afaust
Legendary Innovator
Legendary Innovator
Hello,

do you have anymore log output? This just shows the rollback - some information before and after might be needed to identify a potential why.
Also, your PostgreSQL server is not on the list of officially / fully supported DBs for Alfresco Enterprise 4.x as listed on <a href="http://www.alfresco.com/services/subscription/supported-platforms">the Alfresco homepage</a> and doesn't match the driver JAR you are using.

Regards
Axel

joe_l3
Confirmed Champ
Confirmed Champ
You're right Axel.
I performed a setup of license key  in a Test environment where there was installed a unsupported postgresql version (8.2)!!!
Luckily in the Production environment, the postgresql is in the true supported version 9.0.4.
Thanks!