Hi community,
My requirement is not to have password as clear text in hibernate.cfg.xml and persistence.xml file located in jbpm-human-task.jar so I modified the hibernate.cfg.xml to point to datasource. Can anyone please help how to over come this problem.
My hibernate.cfg.xml is
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.datasource">java:workflow-Datasource</property> // This is my datasource i am using to connect to oracle database
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<property name="show_sql">false</property>
<mapping resource="AuditLog.hbm.xml"/>
</session-factory>
</hibernate-configuration>
I am able to login to jbpm-console but on task creation i am getting the following exception
16:41:45,747 ERROR [JDBCTransaction] JDBC commit failed
java.sql.SQLException: You cannot commit during a managed transaction!
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:660)
at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:487)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:170)
16:41:45,751 INFO [STDOUT] 16:41:45,749 ERROR [SingleSessionCommandService] Could not commit session
org.hibernate.TransactionException: JDBC commit failed
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:161)
at org.jbpm.process.audit.WorkingMemoryDbLogger.addProcessLog(WorkingMemoryDbLogger.java:68)
at org.jbpm.process.audit.WorkingMemoryDbLogger.logEventCreated(WorkingMemoryDbLogger.java:44)
Caused by: java.sql.SQLException: You cannot commit during a managed transaction!
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:660)
at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:487)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:170)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:146)
I have attached the complete server log.
Thanks,
Satish.