8 Replies Latest reply on Jul 31, 2007 7:53 AM by dleerob

    Cannot get JBPM + MSSQL to run together!

    pjodev

      Hello everyone,

      I am fairly new to JBPM, but I have read as much documentation and forums as I can without posting a question, but I am still stuck. Here is my config:

      Tomcat 6.0
      JBPM 3.2
      MS SQL 2000

      Using the jtds-1.2.jar for MSSQL access.

      Here is my hibernate.cfg.xml file

      <?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>
      
       <!-- hibernate dialect -->
       <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
      
       <!-- JDBC connection properties (begin) ===
       <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:jtds:sqlserver://192.168.0.2</property>
       <property name="hibernate.connection.username">jbpmsa</property>
       <property name="hibernate.connection.password">testjbpm</property>
       <property name="c3p0.min_size">5</property>
       <property name="c3p0.max_size">20</property>
       <property name="c3p0.timeout">300</property>
       <property name="c3p0.max_statements">50</property>
       <property name="c3p0.idle_test_period">3000</property>
       ==== JDBC connection properties (end) -->
      
       <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
      
       <!-- DataSource properties (begin) ==
       <property name="hibernate.connection.datasource">java:/JbpmDS</property>
       == DataSource properties (end) -->
       <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
      
      
       <!-- CMT transaction properties (begin) ===
       <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
       <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
       ==== CMT transaction properties (end) -->
      
       <!-- logging properties (begin) -->
       <property name="hibernate.show_sql">true</property>
       <property name="hibernate.format_sql">true</property>
       <property name="hibernate.use_sql_comments">true</property>
       <!-- logging properties (end) -->
      
       <!-- ############################################ -->
       <!-- # mapping files with external dependencies # -->
       <!-- ############################################ -->
      
       <!-- following mapping file has a dependendy on -->
       <!-- 'bsh-{version}.jar'. -->
       <!-- uncomment this if you don't have bsh on your -->
       <!-- classpath. you won't be able to use the -->
       <!-- script element in process definition files -->
       <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>
      
       <!-- following mapping files have a dependendy on -->
       <!-- 'jbpm-identity.jar', mapping files -->
       <!-- of the pluggable jbpm identity component. -->
       <!-- Uncomment the following 3 lines if you -->
       <!-- want to use the jBPM identity mgmgt -->
       <!-- component. -->
       <!-- identity mappings (begin) -->
       <mapping resource="org/jbpm/identity/User.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
       <!-- identity mappings (end) -->
      
       <!-- following mapping files have a dependendy on -->
       <!-- the JCR API -->
       <!-- jcr mappings (begin) ===
       <mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/>
       ==== jcr mappings (end) -->
      
      
       <!-- ###################### -->
       <!-- # jbpm mapping files # -->
       <!-- ###################### -->
      
       <!-- hql queries and type defs -->
       <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" />
      
       <!-- graph.def mapping files -->
       <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
       <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>
      
       <!-- graph.node mapping files -->
       <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>
      
       <!-- context.def mapping files -->
       <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>
      
       <!-- taskmgmt.def mapping files -->
       <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>
      
       <!-- module.def mapping files -->
       <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>
      
       <!-- bytes mapping files -->
       <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>
      
       <!-- file.def mapping files -->
       <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>
      
       <!-- scheduler.def mapping files -->
       <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
       <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>
      
       <!-- graph.exe mapping files -->
       <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>
      
       <!-- module.exe mapping files -->
       <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
      
       <!-- context.exe mapping files -->
       <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>
      
       <!-- job mapping files -->
       <mapping resource="org/jbpm/job/Job.hbm.xml"/>
       <mapping resource="org/jbpm/job/Timer.hbm.xml"/>
       <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/>
       <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/>
      
       <!-- taskmgmt.exe mapping files -->
       <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>
      
       <!-- logging mapping files -->
       <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
       <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
       <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>
      
       </session-factory>
      </hibernate-configuration>
      


      Everytime I try to load the jbpm-console, I get this error:

      INFO: Statistics: disabled
      Apr 12, 2007 10:36:04 PM org.hibernate.cfg.SettingsFactory buildSettings
      INFO: Deleted entity synthetic identifier rollback: disabled
      Apr 12, 2007 10:36:04 PM org.hibernate.cfg.SettingsFactory buildSettings
      INFO: Default entity-mode: pojo
      Apr 12, 2007 10:36:04 PM org.hibernate.impl.SessionFactoryImpl <init>
      INFO: building session factory
      Apr 12, 2007 10:36:08 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
      INFO: Not binding factory to JNDI, no JNDI name configured
      Apr 12, 2007 10:36:09 PM org.jbpm.job.executor.JobExecutorThread run
      SEVERE: exception in job executor thread. waiting 5000 milliseconds
      java.lang.UnsupportedOperationException: The user must supply a JDBC connection
       at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:30)
       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
       at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
       at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
       at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
       at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
       at org.jbpm.persistence.db.DbPersistenceService.beginTransaction(DbPersistenceService.java:130)
       at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:122)
       at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:352)
       at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
       at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
       at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)


      I know I must be missing something here, but I really do not know ;/ Any help?

      Thanks!

        • 1. Re: Cannot get JBPM + MSSQL to run together!
          mputz

          look at this wiki for a detailed description

          http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnTomcat

          (it's for MySQL but it's almost the same for MSSQL)

          what's wrong with your configuration is that you don't have any jdbc connection properties defined. These lines

          <!-- JDBC connection properties (begin) -->
           <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
           <property name="hibernate.connection.url">jdbc:jtds:sqlserver://192.168.0.2</property>
           <property name="hibernate.connection.username">jbpmsa</property>
           <property name="hibernate.connection.password">testjbpm</property>
           <!-- JDBC connection properties (end) -->


          should not be commented out (assumed that they contain the proper settings for your db).

          Regards, Martin

          • 2. Re: Cannot get JBPM + MSSQL to run together!
            pjodev

            ....thank you! I knew I just needed another set of eyes

            • 3. Re: Cannot get JBPM + MSSQL to run together!
              pjodev

              I managed to get the process to deploy, now when I try testing the process, I get this error in the JUnit log...


              07:29:41,078 [main] INFO JbpmConfiguration : using jbpm configuration resource 'jbpm.cfg.xml'
              07:29:41,078 [main] DEBUG JbpmConfiguration : loading defaults in jbpm configuration
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'default.jbpm.context'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.hibernate.cfg.xml'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.business.calendar'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.default.modules'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.converter'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.action.types'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.node.types'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.parsers'
              07:29:41,203 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.varmapping'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.mail.templates'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.byte.block.size'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.mail.smtp.host'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.task.instance.factory'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.variable.resolver'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.mail.address.resolver'
              07:29:41,218 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.job.executor'
              07:29:41,234 [main] DEBUG JbpmConfiguration : loading specific configuration...
              07:29:41,234 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpmConfiguration'
              07:29:41,265 [main] DEBUG JbpmContextInfo : creating jbpm context with service factories '[message, tx, scheduler, authentication, persistence, logging]'
              07:29:41,265 [main] DEBUG JbpmContext : creating org.jbpm.JbpmContext@15fadcf
              07:29:41,281 [main] DEBUG DbPersistenceServiceFactory : creating persistence service
              07:29:41,281 [main] DEBUG DbPersistenceServiceFactory : building hibernate session factory
              07:29:41,343 [main] INFO Environment : Hibernate 3.2.1
              07:29:41,359 [main] INFO Environment : hibernate.properties not found
              07:29:41,359 [main] INFO Environment : Bytecode provider name : cglib
              07:29:41,375 [main] INFO Environment : using JDK 1.4 java.sql.Timestamp handling
              07:29:41,453 [main] DEBUG HibernateHelper : creating hibernate configuration resource 'hibernate.cfg.xml'
              07:29:41,453 [main] INFO Configuration : configuring from resource: hibernate.cfg.xml
              07:29:41,453 [main] INFO Configuration : Configuration resource: hibernate.cfg.xml
              07:29:41,562 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/action/Script.hbm.xml
              07:29:41,687 [main] INFO Configuration : Reading mappings from resource : org/jbpm/identity/User.hbm.xml
              07:29:41,765 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.User -> JBPM_ID_USER
              07:29:41,796 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.User.permissions -> JBPM_ID_PERMISSIONS
              07:29:41,796 [main] INFO Configuration : Reading mappings from resource : org/jbpm/identity/Group.hbm.xml
              07:29:41,843 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.Group -> JBPM_ID_GROUP
              07:29:41,953 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.permissions -> JBPM_ID_PERMISSIONS
              07:29:41,953 [main] INFO Configuration : Reading mappings from resource : org/jbpm/identity/Membership.hbm.xml
              07:29:41,968 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.Membership -> JBPM_ID_MEMBERSHIP
              07:29:41,984 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Membership.permissions -> JBPM_ID_PERMISSIONS
              07:29:41,984 [main] INFO Configuration : Reading mappings from resource : org/jbpm/db/hibernate.queries.hbm.xml
              07:29:42,015 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/ProcessDefinition.hbm.xml
              07:29:42,031 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.ProcessDefinition -> JBPM_PROCESSDEFINITION
              07:29:42,062 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Node.hbm.xml
              07:29:42,093 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Node -> JBPM_NODE
              07:29:42,109 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Transition.hbm.xml
              07:29:42,140 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Transition -> JBPM_TRANSITION
              07:29:42,140 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Event.hbm.xml
              07:29:42,156 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Event -> JBPM_EVENT
              07:29:42,171 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Action.hbm.xml
              07:29:42,187 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Action -> JBPM_ACTION
              07:29:42,187 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/SuperState.hbm.xml
              07:29:42,250 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.def.SuperState -> JBPM_NODE
              07:29:42,250 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/ExceptionHandler.hbm.xml
              07:29:42,265 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.ExceptionHandler -> JBPM_EXCEPTIONHANDLER
              07:29:42,281 [main] INFO Configuration : Reading mappings from resource : org/jbpm/instantiation/Delegation.hbm.xml
              07:29:42,296 [main] INFO HbmBinder : Mapping class: org.jbpm.instantiation.Delegation -> JBPM_DELEGATION
              07:29:42,296 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/StartState.hbm.xml
              07:29:42,312 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.StartState -> JBPM_NODE
              07:29:42,312 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/EndState.hbm.xml
              07:29:42,328 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.EndState -> JBPM_NODE
              07:29:42,328 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/ProcessState.hbm.xml
              07:29:42,343 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.ProcessState -> JBPM_NODE
              07:29:42,343 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/Decision.hbm.xml
              07:29:42,359 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Decision -> JBPM_NODE
              07:29:42,359 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.Decision.decisionConditions -> JBPM_DECISIONCONDITIONS
              07:29:42,359 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/Fork.hbm.xml
              07:29:42,390 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Fork -> JBPM_NODE
              07:29:42,406 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/Join.hbm.xml
              07:29:42,406 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Join -> JBPM_NODE
              07:29:42,406 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/State.hbm.xml
              07:29:42,421 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.State -> JBPM_NODE
              07:29:42,421 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/TaskNode.hbm.xml
              07:29:42,437 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.TaskNode -> JBPM_NODE
              07:29:42,453 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/def/ContextDefinition.hbm.xml
              07:29:42,453 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/def/VariableAccess.hbm.xml
              07:29:42,468 [main] INFO HbmBinder : Mapping class: org.jbpm.context.def.VariableAccess -> JBPM_VARIABLEACCESS
              07:29:42,468 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml
              07:29:42,484 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/Swimlane.hbm.xml
              07:29:42,562 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Swimlane -> JBPM_SWIMLANE
              07:29:42,562 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/Task.hbm.xml
              07:29:42,578 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Task -> JBPM_TASK
              07:29:42,593 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/TaskController.hbm.xml
              07:29:42,609 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.TaskController -> JBPM_TASKCONTROLLER
              07:29:42,609 [main] INFO Configuration : Reading mappings from resource : org/jbpm/module/def/ModuleDefinition.hbm.xml
              07:29:42,625 [main] INFO HbmBinder : Mapping class: org.jbpm.module.def.ModuleDefinition -> JBPM_MODULEDEFINITION
              07:29:42,625 [main] INFO Configuration : Reading mappings from resource : org/jbpm/bytes/ByteArray.hbm.xml
              07:29:42,625 [main] INFO HbmBinder : Mapping class: org.jbpm.bytes.ByteArray -> JBPM_BYTEARRAY
              07:29:42,625 [main] INFO HbmBinder : Mapping collection: org.jbpm.bytes.ByteArray.byteBlocks -> JBPM_BYTEBLOCK
              07:29:42,625 [main] INFO Configuration : Reading mappings from resource : org/jbpm/file/def/FileDefinition.hbm.xml
              07:29:42,640 [main] INFO HbmBinder : Mapping subclass: org.jbpm.file.def.FileDefinition -> JBPM_MODULEDEFINITION
              07:29:42,640 [main] INFO Configuration : Reading mappings from resource : org/jbpm/scheduler/def/CreateTimerAction.hbm.xml
              07:29:42,656 [main] INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CreateTimerAction -> JBPM_ACTION
              07:29:42,656 [main] INFO Configuration : Reading mappings from resource : org/jbpm/scheduler/def/CancelTimerAction.hbm.xml
              07:29:42,671 [main] INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CancelTimerAction -> JBPM_ACTION
              07:29:42,671 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/Comment.hbm.xml
              07:29:42,687 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Comment -> JBPM_COMMENT
              07:29:42,687 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/ProcessInstance.hbm.xml
              07:29:42,703 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.ProcessInstance -> JBPM_PROCESSINSTANCE
              07:29:42,718 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/Token.hbm.xml
              07:29:42,734 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Token -> JBPM_TOKEN
              07:29:42,750 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/RuntimeAction.hbm.xml
              07:29:42,750 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.RuntimeAction -> JBPM_RUNTIMEACTION
              07:29:42,765 [main] INFO Configuration : Reading mappings from resource : org/jbpm/module/exe/ModuleInstance.hbm.xml
              07:29:42,781 [main] INFO HbmBinder : Mapping class: org.jbpm.module.exe.ModuleInstance -> JBPM_MODULEINSTANCE
              07:29:42,781 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/ContextInstance.hbm.xml
              07:29:42,796 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.ContextInstance -> JBPM_MODULEINSTANCE
              07:29:42,796 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/TokenVariableMap.hbm.xml
              07:29:42,812 [main] INFO HbmBinder : Mapping class: org.jbpm.context.exe.TokenVariableMap -> JBPM_TOKENVARIABLEMAP
              07:29:42,812 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/VariableInstance.hbm.xml
              07:29:42,812 [main] INFO HbmBinder : Mapping class: org.jbpm.context.exe.VariableInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,828 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml
              07:29:42,843 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.ByteArrayInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,843 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml
              org.hibernate.MappingNotFoundException: resource: org/jbpm/msg/Message.hbm.xml not found
               at org.hibernate.cfg.Configuration.addResource(Configuration.java:563)
               at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1584)
               at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1552)
               at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1531)
               at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1505)
               at org.hibernate.cfg.Configuration.configure(Configuration.java:1425)
               at org.jbpm.db.hibernate.HibernateHelper.createConfiguration(HibernateHelper.java:91)
               at org.jbpm.persistence.db.DbPersistenceServiceFactory.getConfiguration(DbPersistenceServiceFactory.java:69)
               at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
               at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
               at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
               at org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:334)
               at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:571)
               at com.rco.bpm.util.JBPMAccessor.startEfileDestructionProcess(JBPMAccessor.java:37)
               at com.rco.TestJBPMEfileProcess.testSimpleProcess(TestJBPMEfileProcess.java:19)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:597)
               at junit.framework.TestCase.runTest(TestCase.java:154)
               at junit.framework.TestCase.runBare(TestCase.java:127)
               at junit.framework.TestResult$1.protect(TestResult.java:106)
               at junit.framework.TestResult.runProtected(TestResult.java:124)
               at junit.framework.TestResult.run(TestResult.java:109)
               at junit.framework.TestCase.run(TestCase.java:118)
               at junit.framework.TestSuite.runTest(TestSuite.java:208)
               at junit.framework.TestSuite.run(TestSuite.java:203)
               at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
               at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
              07:29:42,859 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DateInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,859 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml
              07:29:42,859 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DoubleInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,875 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml
              07:29:42,875 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateLongInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,875 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
              07:29:42,890 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateStringInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,890 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml
              07:29:42,906 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.LongInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,906 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml
              07:29:42,921 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.NullInstance -> JBPM_VARIABLEINSTANCE
              07:29:42,921 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
              07:29:43,000 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.StringInstance -> JBPM_VARIABLEINSTANCE
              07:29:43,000 [main] INFO Configuration : Reading mappings from resource : org/jbpm/msg/Message.hbm.xml
              07:29:43,000 [main] DEBUG JbpmContext : closing JbpmContext
              07:29:43,000 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@8a548b
              


              It seems like something is missing? I am using all of the default jars..

              • 4. Re: Cannot get JBPM + MSSQL to run together!
                mputz

                It seems you are running tests with some 3.1 code and/or configuration files, as the Message class and corresponding mapping file no longer exists in 3.2.

                Regards, Martin

                • 5. Re: Cannot get JBPM + MSSQL to run together!
                  dleerob

                  I also have the error: "java.lang.UnsupportedOperationException: The user must supply a JDBC connection".

                  I do have the JDBC connection properties set. I am using JBPM 3.2.1 and Tomcat 5.0.28. Any ideas why I get this error?

                  • 6. Re: Cannot get JBPM + MSSQL to run together!
                    kukeltje

                    post the whole stacktrace, not just the exception

                    • 7. Re: Cannot get JBPM + MSSQL to run together!
                      dleerob

                      Hi, sorry, here is some more info...

                      Stacktrace:

                      Exception in thread "main" java.lang.UnsupportedOperationException: The user must supply a JDBC connection
                       at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:30)
                       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
                       at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
                       at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
                       at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
                       at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
                       at org.jbpm.persistence.db.DbPersistenceService.beginTransaction(DbPersistenceService.java:131)
                       at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:123)
                       at org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:336)
                       at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:571)
                       at za.co.itdynamics.jbpm.practice.Tests.execute(Tests.java:24)
                       at za.co.itdynamics.jbpm.practice.Tests.main(Tests.java:16)
                      


                      This is my hibernate.cfg.xml file:
                      <?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>
                      
                       <!-- hibernate dialect -->
                       <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
                      
                       <!-- JDBC connection properties (begin) ===
                       <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
                       <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpmdb</property>
                       <property name="hibernate.connection.username">jbpmdb</property>
                       <property name="hibernate.connection.password">itd_mysql_jbpmdb_dev</property>
                       ==== JDBC connection properties (end) -->
                      
                       <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
                      
                       <!-- DataSource properties (begin) -->
                       <!-- <property name="hibernate.connection.datasource">java:/JbpmDS</property> -->
                       <!-- DataSource properties (end) -->
                      
                       <!-- JTA transaction properties (begin) ===
                       <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
                       <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
                       ==== JTA transaction properties (end) -->
                      
                       <!-- CMT transaction properties (begin) ===
                       <property name="hibernate.transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
                       <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
                       ==== CMT transaction properties (end) -->
                      
                       <!-- logging properties (begin) ===
                       <property name="hibernate.show_sql">true</property>
                       <property name="hibernate.format_sql">true</property>
                       <property name="hibernate.use_sql_comments">true</property>
                       ==== logging properties (end) -->
                      
                       <!-- ############################################ -->
                       <!-- # mapping files with external dependencies # -->
                       <!-- ############################################ -->
                      
                       <!-- following mapping file has a dependendy on -->
                       <!-- 'bsh-{version}.jar'. -->
                       <!-- uncomment this if you don't have bsh on your -->
                       <!-- classpath. you won't be able to use the -->
                       <!-- script element in process definition files -->
                       <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>
                      
                       <!-- following mapping files have a dependendy on -->
                       <!-- 'jbpm-identity.jar', mapping files -->
                       <!-- of the pluggable jbpm identity component. -->
                       <!-- Uncomment the following 3 lines if you -->
                       <!-- want to use the jBPM identity mgmgt -->
                       <!-- component. -->
                       <!-- identity mappings (begin) -->
                       <mapping resource="org/jbpm/identity/User.hbm.xml"/>
                       <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
                       <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
                       <!-- identity mappings (end) -->
                      
                       <!-- following mapping files have a dependendy on -->
                       <!-- the JCR API -->
                       <!-- jcr mappings (begin) ===
                       <mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/>
                       ==== jcr mappings (end) -->
                      
                      
                       <!-- ###################### -->
                       <!-- # jbpm mapping files # -->
                       <!-- ###################### -->
                      
                       <!-- hql queries and type defs -->
                       <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" />
                      
                       <!-- graph.action mapping files -->
                       <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/>
                      
                       <!-- graph.def mapping files -->
                       <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
                       <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>
                      
                       <!-- graph.node mapping files -->
                       <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>
                      
                       <!-- context.def mapping files -->
                       <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
                       <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>
                      
                       <!-- taskmgmt.def mapping files -->
                       <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>
                      
                       <!-- module.def mapping files -->
                       <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>
                      
                       <!-- bytes mapping files -->
                       <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>
                      
                       <!-- file.def mapping files -->
                       <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>
                      
                       <!-- scheduler.def mapping files -->
                       <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
                       <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>
                      
                       <!-- graph.exe mapping files -->
                       <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>
                      
                       <!-- module.exe mapping files -->
                       <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
                      
                       <!-- context.exe mapping files -->
                       <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>
                      
                       <!-- job mapping files -->
                       <mapping resource="org/jbpm/job/Job.hbm.xml"/>
                       <mapping resource="org/jbpm/job/Timer.hbm.xml"/>
                       <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/>
                       <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/>
                      
                       <!-- taskmgmt.exe mapping files -->
                       <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>
                      
                       <!-- logging mapping files -->
                       <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
                       <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
                       <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
                       <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
                       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>
                      
                       </session-factory>
                      </hibernate-configuration>
                      


                      Thanks.

                      • 8. Re: Cannot get JBPM + MSSQL to run together!
                        dleerob

                        Wait, sorry, forget about my post, I was being silly. I was using the wrong hibernate file, and as you can see above, the JDBC connection properties are still commented out.