topic Transaction problem within spring config / hibernate in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/transaction-problem-within-spring-config-hibernate/m-p/138571#M97126 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I'm facing a problem with my spring configuration. My processEngine bean can't be created. </SPAN><BR /><SPAN>Instead, following exception is throwed :</SPAN><BR /><BR /><SPAN>Caused by: org.hibernate.TransactionException: commit failed</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: org.h2.jdbc.JdbcSQLException: The object is already closed [90007-167]</SPAN><BR /><BR /><SPAN>My config is :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;beans xmlns="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:aop="<A href="http://www.springframework.org/schema/aop" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/aop</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:tx="<A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>" xmlns:context="<A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A>"<BR />&nbsp;&nbsp;&nbsp;xmlns:util="<A href="http://www.springframework.org/schema/util" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/util</A>"<BR /><BR />&nbsp;&nbsp;&nbsp;xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A> <A href="http://www.springframework.org/schema/beans/spring-beans-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans-3.0.xsd</A><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A> <A href="http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx/spring-tx-3.0.xsd</A><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/aop" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/aop</A> <A href="http://www.springframework.org/schema/aop/spring-aop-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/aop/spring-aop-3.0.xsd</A><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A> <A href="http://www.springframework.org/schema/context/spring-context-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context/spring-context-3.0.xsd</A><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/util" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/util</A> <A href="http://www.springframework.org/schema/util/spring-util-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/util/spring-util-3.0.xsd</A>"&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;!– config –&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;context:annotation-config /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;!– &lt;import resource="classpath:spring-dcontract-core-context.xml" /&gt;–&gt;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&lt;bean<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id="properties"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="locations"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;classpath:properties/database.properties&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="ignoreUnresolvablePlaceholders" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&lt;bean<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="coreJpaAdapter"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="showSql" value="${jpa.showSql}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databasePlatform" value="${jpa.dialect}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="generateDdl" value="${jpa.generateDdl}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="dContractDataSource"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClass" value="${dcontract.database.driverClass}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="${dcontract.database.url}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="${dcontract.database.username}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="${dcontract.database.password}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="dContractEntityManagerFactory"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dContractDataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jpaVendorAdapter" ref="coreJpaAdapter" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="persistenceUnitName" value="digital-contract-unit" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="packagesToScan" value="net.domain.entity" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="dContractTransactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="entityManagerFactory" ref="dContractEntityManagerFactory" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;tx:annotation-driven transaction-manager="dContractTransactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;<BR /><BR />&lt;!– activiti –&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&lt;!– &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseType" value="h2" /&gt; –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dContractDataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="dContractTransactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="deploymentResources" value="classpath*:diagrams/TestProcess.bpmn" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="history" value="audit" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!– ajout pour utiliser JPA / hibernate avec activiti –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jpaEntityManagerFactory" ref="dContractEntityManagerFactory" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jpaHandleTransaction" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jpaCloseEntityManager" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="repositoryService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getRepositoryService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="runtimeService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getRuntimeService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="taskService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getTaskService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="identityService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getIdentityService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="historyService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getHistoryService" /&gt;<BR /><BR />&lt;/beans&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>and my properties file is :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />#### H2 ######<BR /><BR />dcontract.database.driverClass=org.h2.Driver<BR />dcontract.database.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000<BR />dcontract.database.username=sa<BR />dcontract.database.password=<BR /><BR /># Depends on the underlying database system<BR />jpa.dialect=org.hibernate.dialect.H2Dialect<BR /><BR /># If true, create/update all relevant tables at startup.<BR /># Only for local and dev environnements, do not activate in production.<BR />jpa.generateDdl=true<BR />jpa.addCustomFK=false<BR />jpa.showSql=true<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>any help is welcome…</SPAN></BODY></HTML> Fri, 07 Jun 2013 09:16:23 GMT cthurier 2013-06-07T09:16:23Z Transaction problem within spring config / hibernate https://connect.hyland.com/t5/alfresco-archive/transaction-problem-within-spring-config-hibernate/m-p/138571#M97126 Hello,I'm facing a problem with my spring configuration. My processEngine bean can't be created. Instead, following exception is throwed :Caused by: org.hibernate.TransactionException: commit failed…Caused by: org.h2.jdbc.JdbcSQLException: The object is already closed [90007-167]My config is :&lt;?x Fri, 07 Jun 2013 09:16:23 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-problem-within-spring-config-hibernate/m-p/138571#M97126 cthurier 2013-06-07T09:16:23Z Re: Transaction problem within spring config / hibernate https://connect.hyland.com/t5/alfresco-archive/transaction-problem-within-spring-config-hibernate/m-p/138572#M97127 <HTML><HEAD></HEAD><BODY><SPAN>And when do you get this error message? Can you add a stacktrace?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Mon, 10 Jun 2013 14:47:33 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-problem-within-spring-config-hibernate/m-p/138572#M97127 trademak 2013-06-10T14:47:33Z