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

satish polasi do-not-reply at jboss.com
Wed Aug 10 22:29:47 EDT 2011


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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110810/4ff6fbae/attachment.html 


More information about the jboss-user mailing list