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

satish polasi [http://community.jboss.org/people/satishpolasi] created the discussion "Problem configuring hibernate.cfg.xml to point to datasource located under jbpm-gwt-console-server.war>WEB-INF>classes" To view the discussion, visit: http://community.jboss.org/message/620485#620485 -------------------------------------------------------------- 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 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. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/620485#620485] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]