0 Replies Latest reply on Aug 10, 2011 8:03 PM by satish polasi

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

    satish polasi Newbie

      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.