Problem configuring hibernate.cfg.xml to point to datasource located under jbpm-gwt-console-server.war>WEB-INF>classes

[satishpolasi]

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.