4 Replies Latest reply on Aug 10, 2007 5:23 PM by dingo001

Exception when deploying a process definition to Mysql

sujeewanie Jul 25, 2007 8:29 AM

I have jbpm 3.2.1 and mysql 5.0.27
I am trying to run the Db example in the chapter 3 of the tutorial.
I changed my jbpm-jpdl-3.2.1\config\hibernate.cfg.xml as follows

<?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>


org.hibernate.dialect.MySQLInnoDBDialect


com.mysql.jdbc.Driver
jdbc:mysql://localhost/jbpm
root
root


org.hibernate.cache.HashtableCacheProvider





































































</session-factory>
</hibernate-configuration>

when I run the test I get the following exception
17:43:44,123 [main] INFO JbpmConfiguration : using jbpm configuration resource 'jbpm.cfg.xml'
17:43:44,139 [main] DEBUG JbpmConfiguration : loading defaults in jbpm configuration
17:43:44,217 [main] DEBUG ObjectFactoryImpl : adding object info 'default.jbpm.context'
17:43:44,217 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.hibernate.cfg.xml'
17:43:44,217 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.business.calendar'
17:43:44,217 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.default.modules'
17:43:44,217 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.converter'
17:43:44,217 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.action.types'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.node.types'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.parsers'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.varmapping'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'resource.mail.templates'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.byte.block.size'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.mail.smtp.host'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.task.instance.factory'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.variable.resolver'
17:43:44,232 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.mail.address.resolver'
17:43:44,248 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpm.job.executor'
17:43:44,248 [main] DEBUG JbpmConfiguration : loading specific configuration...
17:43:44,248 [main] DEBUG ObjectFactoryImpl : adding object info 'jbpmConfiguration'
17:43:44,372 [main] WARN JpdlParser : couldn't set xml parser property 'http://java.sun.com/xml/jaxp/properties/schemaLanguage' to 'http://www.w3.org/2001/XMLSchema'
org.xml.sax.SAXNotRecognizedException: Property: http://java.sun.com/xml/jaxp/properties/schemaLanguage
at org.apache.crimson.parser.XMLReaderImpl.setProperty(XMLReaderImpl.java:272)
at org.apache.crimson.jaxp.SAXParserImpl.setProperty(SAXParserImpl.java:190)
at org.jbpm.jpdl.xml.JpdlParser.createXmlReader(JpdlParser.java:75)
at org.jbpm.jpdl.xml.JpdlParser.createSaxReader(JpdlParser.java:63)
at org.jbpm.jpdl.xml.JpdlParser.parse(JpdlParser.java:57)
at org.jbpm.jpdl.xml.JpdlXmlReader.readProcessDefinition(JpdlXmlReader.java:141)
at org.jbpm.graph.def.ProcessDefinition.parseXmlInputStream(ProcessDefinition.java:180)
at org.jbpm.graph.def.ProcessDefinition.parseXmlResource(ProcessDefinition.java:161)
at com.sample.SimpleProcessTest.testSimpleProcess(SimpleProcessTest.java:16)
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:324)
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)
17:43:44,403 [main] WARN JpdlParser : couldn't set xml parser property 'http://apache.org/xml/properties/schema/external-schemaLocation'
org.xml.sax.SAXNotRecognizedException: Property: http://apache.org/xml/properties/schema/external-schemaLocation
at org.apache.crimson.parser.XMLReaderImpl.setProperty(XMLReaderImpl.java:272)
at org.apache.crimson.jaxp.SAXParserImpl.setProperty(SAXParserImpl.java:190)
at org.jbpm.jpdl.xml.JpdlParser.createXmlReader(JpdlParser.java:81)
at org.jbpm.jpdl.xml.JpdlParser.createSaxReader(JpdlParser.java:63)
at org.jbpm.jpdl.xml.JpdlParser.parse(JpdlParser.java:57)
at org.jbpm.jpdl.xml.JpdlXmlReader.readProcessDefinition(JpdlXmlReader.java:141)
at org.jbpm.graph.def.ProcessDefinition.parseXmlInputStream(ProcessDefinition.java:180)
at org.jbpm.graph.def.ProcessDefinition.parseXmlResource(ProcessDefinition.java:161)
at com.sample.SimpleProcessTest.testSimpleProcess(SimpleProcessTest.java:16)
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:324)
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)
17:43:44,403 [main] WARN JpdlParser : couldn't set xml parser feature 'http://apache.org/xml/features/validation/dynamic'
org.xml.sax.SAXNotRecognizedException: Feature: http://apache.org/xml/features/validation/dynamic
at org.apache.crimson.parser.XMLReaderImpl.setFeature(XMLReaderImpl.java:219)
at org.jbpm.jpdl.xml.JpdlParser.createXmlReader(JpdlParser.java:92)
at org.jbpm.jpdl.xml.JpdlParser.createSaxReader(JpdlParser.java:63)
at org.jbpm.jpdl.xml.JpdlParser.parse(JpdlParser.java:57)
at org.jbpm.jpdl.xml.JpdlXmlReader.readProcessDefinition(JpdlXmlReader.java:141)
at org.jbpm.graph.def.ProcessDefinition.parseXmlInputStream(ProcessDefinition.java:180)
at org.jbpm.graph.def.ProcessDefinition.parseXmlResource(ProcessDefinition.java:161)
at com.sample.SimpleProcessTest.testSimpleProcess(SimpleProcessTest.java:16)
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:324)
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)
17:43:44,606 [main] DEBUG NodeTypes : node 'page' will not be available. class 'org.jboss.seam.pageflow.Page' couldn't be loaded
17:43:44,606 [main] DEBUG NodeTypes : node 'start-page' will not be available. class 'org.jboss.seam.pageflow.Page' couldn't be loaded
17:43:44,684 [main] DEBUG GraphElement : event 'process-start' on 'ProcessDefinition(simple)' for 'Token(/)'
17:43:44,699 [main] DEBUG JbpmContextInfo : creating jbpm context with service factories '[tx, message, scheduler, logging, persistence, authentication]'
17:43:44,699 [main] DEBUG JbpmContext : creating org.jbpm.JbpmContext@cbf30e
17:43:44,699 [main] DEBUG DbPersistenceServiceFactory : creating persistence service
17:43:44,715 [main] DEBUG DbPersistenceServiceFactory : building hibernate session factory
17:43:44,777 [main] INFO Environment : Hibernate 3.2.3
17:43:44,792 [main] INFO Environment : hibernate.properties not found
17:43:44,792 [main] INFO Environment : Bytecode provider name : cglib
17:43:44,824 [main] INFO Environment : using JDK 1.4 java.sql.Timestamp handling
17:43:44,948 [main] DEBUG HibernateHelper : creating hibernate configuration resource 'hibernate.cfg.xml'
17:43:44,948 [main] INFO Configuration : configuring from resource: hibernate.cfg.xml
17:43:44,948 [main] INFO Configuration : Configuration resource: hibernate.cfg.xml
17:43:44,995 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/action/Script.hbm.xml
17:43:45,150 [main] INFO Configuration : Reading mappings from resource : org/jbpm/identity/User.hbm.xml
17:43:45,228 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.User -> JBPM_ID_USER
17:43:45,337 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.User.permissions -> JBPM_ID_PERMISSIONS
17:43:45,337 [main] INFO Configuration : Reading mappings from resource : org/jbpm/identity/Group.hbm.xml
17:43:45,368 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.Group -> JBPM_ID_GROUP
17:43:45,493 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.permissions -> JBPM_ID_PERMISSIONS
17:43:45,493 [main] INFO Configuration : Reading mappings from resource : org/jbpm/identity/Membership.hbm.xml
17:43:45,524 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.Membership -> JBPM_ID_MEMBERSHIP
17:43:45,524 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Membership.permissions -> JBPM_ID_PERMISSIONS
17:43:45,524 [main] INFO Configuration : Reading mappings from resource : org/jbpm/db/hibernate.queries.hbm.xml
17:43:45,571 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/action/MailAction.hbm.xml
17:43:45,586 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/ProcessDefinition.hbm.xml
17:43:45,602 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.ProcessDefinition -> JBPM_PROCESSDEFINITION
17:43:45,633 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Node.hbm.xml
17:43:45,649 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Node -> JBPM_NODE
17:43:45,664 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Transition.hbm.xml
17:43:45,695 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Transition -> JBPM_TRANSITION
17:43:45,695 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Event.hbm.xml
17:43:45,742 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Event -> JBPM_EVENT
17:43:45,742 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/Action.hbm.xml
17:43:45,773 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Action -> JBPM_ACTION
17:43:45,773 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/SuperState.hbm.xml
17:43:45,898 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.def.SuperState -> JBPM_NODE
17:43:45,898 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/def/ExceptionHandler.hbm.xml
17:43:45,929 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.ExceptionHandler -> JBPM_EXCEPTIONHANDLER
17:43:45,929 [main] INFO Configuration : Reading mappings from resource : org/jbpm/instantiation/Delegation.hbm.xml
17:43:45,944 [main] INFO HbmBinder : Mapping class: org.jbpm.instantiation.Delegation -> JBPM_DELEGATION
17:43:45,960 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/StartState.hbm.xml
17:43:45,975 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.StartState -> JBPM_NODE
17:43:45,975 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/EndState.hbm.xml
17:43:45,991 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.EndState -> JBPM_NODE
17:43:45,991 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/ProcessState.hbm.xml
17:43:46,007 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.ProcessState -> JBPM_NODE
17:43:46,007 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/Decision.hbm.xml
17:43:46,022 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Decision -> JBPM_NODE
17:43:46,022 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.Decision.decisionConditions -> JBPM_DECISIONCONDITIONS
17:43:46,038 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/Fork.hbm.xml
17:43:46,038 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Fork -> JBPM_NODE
17:43:46,053 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/Join.hbm.xml
17:43:46,069 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Join -> JBPM_NODE
17:43:46,069 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/MailNode.hbm.xml
17:43:46,147 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.MailNode -> JBPM_NODE
17:43:46,147 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/State.hbm.xml
17:43:46,162 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.State -> JBPM_NODE
17:43:46,162 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/node/TaskNode.hbm.xml
17:43:46,193 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.TaskNode -> JBPM_NODE
17:43:46,193 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/def/ContextDefinition.hbm.xml
17:43:46,209 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/def/VariableAccess.hbm.xml
17:43:46,224 [main] INFO HbmBinder : Mapping class: org.jbpm.context.def.VariableAccess -> JBPM_VARIABLEACCESS
17:43:46,240 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml
17:43:46,256 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/Swimlane.hbm.xml
17:43:46,271 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Swimlane -> JBPM_SWIMLANE
17:43:46,271 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/Task.hbm.xml
17:43:46,302 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Task -> JBPM_TASK
17:43:46,318 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/def/TaskController.hbm.xml
17:43:46,318 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.TaskController -> JBPM_TASKCONTROLLER
17:43:46,333 [main] INFO Configuration : Reading mappings from resource : org/jbpm/module/def/ModuleDefinition.hbm.xml
17:43:46,349 [main] INFO HbmBinder : Mapping class: org.jbpm.module.def.ModuleDefinition -> JBPM_MODULEDEFINITION
17:43:46,349 [main] INFO Configuration : Reading mappings from resource : org/jbpm/bytes/ByteArray.hbm.xml
17:43:46,427 [main] INFO HbmBinder : Mapping class: org.jbpm.bytes.ByteArray -> JBPM_BYTEARRAY
17:43:46,427 [main] INFO HbmBinder : Mapping collection: org.jbpm.bytes.ByteArray.byteBlocks -> JBPM_BYTEBLOCK
17:43:46,427 [main] INFO Configuration : Reading mappings from resource : org/jbpm/file/def/FileDefinition.hbm.xml
17:43:46,442 [main] INFO HbmBinder : Mapping subclass: org.jbpm.file.def.FileDefinition -> JBPM_MODULEDEFINITION
17:43:46,442 [main] INFO Configuration : Reading mappings from resource : org/jbpm/scheduler/def/CreateTimerAction.hbm.xml
17:43:46,458 [main] INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CreateTimerAction -> JBPM_ACTION
17:43:46,458 [main] INFO Configuration : Reading mappings from resource : org/jbpm/scheduler/def/CancelTimerAction.hbm.xml
17:43:46,473 [main] INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CancelTimerAction -> JBPM_ACTION
17:43:46,473 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/Comment.hbm.xml
17:43:46,489 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Comment -> JBPM_COMMENT
17:43:46,505 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/ProcessInstance.hbm.xml
17:43:46,520 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.ProcessInstance -> JBPM_PROCESSINSTANCE
17:43:46,520 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/Token.hbm.xml
17:43:46,551 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Token -> JBPM_TOKEN
17:43:46,551 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/exe/RuntimeAction.hbm.xml
17:43:46,582 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.RuntimeAction -> JBPM_RUNTIMEACTION
17:43:46,582 [main] INFO Configuration : Reading mappings from resource : org/jbpm/module/exe/ModuleInstance.hbm.xml
17:43:46,598 [main] INFO HbmBinder : Mapping class: org.jbpm.module.exe.ModuleInstance -> JBPM_MODULEINSTANCE
17:43:46,598 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/ContextInstance.hbm.xml
17:43:46,614 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.ContextInstance -> JBPM_MODULEINSTANCE
17:43:46,614 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/TokenVariableMap.hbm.xml
17:43:46,629 [main] INFO HbmBinder : Mapping class: org.jbpm.context.exe.TokenVariableMap -> JBPM_TOKENVARIABLEMAP
17:43:46,629 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/VariableInstance.hbm.xml
17:43:46,645 [main] INFO HbmBinder : Mapping class: org.jbpm.context.exe.VariableInstance -> JBPM_VARIABLEINSTANCE
17:43:46,676 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml
17:43:46,800 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.ByteArrayInstance -> JBPM_VARIABLEINSTANCE
17:43:46,800 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml
17:43:46,816 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DateInstance -> JBPM_VARIABLEINSTANCE
17:43:46,816 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml
17:43:46,831 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DoubleInstance -> JBPM_VARIABLEINSTANCE
17:43:46,831 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml
17:43:46,847 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateLongInstance -> JBPM_VARIABLEINSTANCE
17:43:46,863 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
17:43:46,863 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateStringInstance -> JBPM_VARIABLEINSTANCE
17:43:46,894 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml
17:43:46,909 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.LongInstance -> JBPM_VARIABLEINSTANCE
17:43:46,909 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml
17:43:46,925 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.NullInstance -> JBPM_VARIABLEINSTANCE
17:43:46,925 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
17:43:46,940 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.StringInstance -> JBPM_VARIABLEINSTANCE
17:43:46,940 [main] INFO Configuration : Reading mappings from resource : org/jbpm/job/Job.hbm.xml
17:43:46,972 [main] INFO HbmBinder : Mapping class: org.jbpm.job.Job -> JBPM_JOB
17:43:46,972 [main] INFO Configuration : Reading mappings from resource : org/jbpm/job/Timer.hbm.xml
17:43:46,987 [main] INFO HbmBinder : Mapping subclass: org.jbpm.job.Timer -> JBPM_JOB
17:43:46,987 [main] INFO Configuration : Reading mappings from resource : org/jbpm/job/ExecuteNodeJob.hbm.xml
17:43:47,003 [main] INFO HbmBinder : Mapping subclass: org.jbpm.job.ExecuteNodeJob -> JBPM_JOB
17:43:47,003 [main] INFO Configuration : Reading mappings from resource : org/jbpm/job/ExecuteActionJob.hbm.xml
17:43:47,018 [main] INFO HbmBinder : Mapping subclass: org.jbpm.job.ExecuteActionJob -> JBPM_JOB
17:43:47,034 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml
17:43:47,049 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.exe.TaskMgmtInstance -> JBPM_MODULEINSTANCE
17:43:47,065 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml
17:43:47,158 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.TaskInstance -> JBPM_TASKINSTANCE
17:43:47,189 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.pooledActors -> JBPM_TASKACTORPOOL
17:43:47,189 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/exe/PooledActor.hbm.xml
17:43:47,205 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.PooledActor -> JBPM_POOLEDACTOR
17:43:47,205 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.PooledActor.taskInstances -> JBPM_TASKACTORPOOL
17:43:47,205 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml
17:43:47,221 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.SwimlaneInstance -> JBPM_SWIMLANEINSTANCE
17:43:47,221 [main] INFO Configuration : Reading mappings from resource : org/jbpm/logging/log/ProcessLog.hbm.xml
17:43:47,252 [main] INFO HbmBinder : Mapping class: org.jbpm.logging.log.ProcessLog -> JBPM_LOG
17:43:47,252 [main] INFO Configuration : Reading mappings from resource : org/jbpm/logging/log/MessageLog.hbm.xml
17:43:47,267 [main] INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.MessageLog -> JBPM_LOG
17:43:47,267 [main] INFO Configuration : Reading mappings from resource : org/jbpm/logging/log/CompositeLog.hbm.xml
17:43:47,267 [main] INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.CompositeLog -> JBPM_LOG
17:43:47,283 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/ActionLog.hbm.xml
17:43:47,283 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ActionLog -> JBPM_LOG
17:43:47,298 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/NodeLog.hbm.xml
17:43:47,314 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.NodeLog -> JBPM_LOG
17:43:47,314 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml
17:43:47,330 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceCreateLog -> JBPM_LOG
17:43:47,330 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml
17:43:47,345 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceEndLog -> JBPM_LOG
17:43:47,345 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/ProcessStateLog.hbm.xml
17:43:47,361 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessStateLog -> JBPM_LOG
17:43:47,361 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/SignalLog.hbm.xml
17:43:47,376 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.SignalLog -> JBPM_LOG
17:43:47,376 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/TokenCreateLog.hbm.xml
17:43:47,392 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenCreateLog -> JBPM_LOG
17:43:47,392 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/TokenEndLog.hbm.xml
17:43:47,470 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenEndLog -> JBPM_LOG
17:43:47,470 [main] INFO Configuration : Reading mappings from resource : org/jbpm/graph/log/TransitionLog.hbm.xml
17:43:47,485 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TransitionLog -> JBPM_LOG
17:43:47,485 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/VariableLog.hbm.xml
17:43:47,501 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableLog -> JBPM_LOG
17:43:47,501 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/VariableCreateLog.hbm.xml
17:43:47,516 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableCreateLog -> JBPM_LOG
17:43:47,516 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/VariableDeleteLog.hbm.xml
17:43:47,532 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableDeleteLog -> JBPM_LOG
17:43:47,532 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/VariableUpdateLog.hbm.xml
17:43:47,547 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableUpdateLog -> JBPM_LOG
17:43:47,547 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml
17:43:47,563 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.ByteArrayUpdateLog -> JBPM_LOG
17:43:47,579 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml
17:43:47,579 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DateUpdateLog -> JBPM_LOG
17:43:47,579 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml
17:43:47,594 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DoubleUpdateLog -> JBPM_LOG
17:43:47,594 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml
17:43:47,610 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateLongUpdateLog -> JBPM_LOG
17:43:47,610 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml
17:43:47,625 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateStringUpdateLog -> JBPM_LOG
17:43:47,625 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml
17:43:47,641 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.LongUpdateLog -> JBPM_LOG
17:43:47,641 [main] INFO Configuration : Reading mappings from resource : org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml
17:43:47,656 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.StringUpdateLog -> JBPM_LOG
17:43:47,672 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/TaskLog.hbm.xml
17:43:47,672 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskLog -> JBPM_LOG
17:43:47,672 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml
17:43:47,688 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskCreateLog -> JBPM_LOG
17:43:47,688 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml
17:43:47,703 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskAssignLog -> JBPM_LOG
17:43:47,703 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml
17:43:47,796 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskEndLog -> JBPM_LOG
17:43:47,796 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml
17:43:47,812 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneLog -> JBPM_LOG
17:43:47,812 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml
17:43:47,828 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneCreateLog -> JBPM_LOG
17:43:47,828 [main] INFO Configuration : Reading mappings from resource : org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml
17:43:47,843 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneAssignLog -> JBPM_LOG
17:43:47,843 [main] INFO Configuration : Configured SessionFactory: null
17:43:47,843 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.def.TaskMgmtDefinition -> JBPM_MODULEDEFINITION
17:43:47,843 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.action.MailAction -> JBPM_ACTION
17:43:47,843 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.def.ContextDefinition -> JBPM_MODULEDEFINITION
17:43:47,843 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.action.Script -> JBPM_ACTION
17:43:47,843 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.User.memberships -> JBPM_ID_MEMBERSHIP
17:43:47,859 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.children -> JBPM_ID_GROUP
17:43:47,859 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.memberships -> JBPM_ID_MEMBERSHIP
17:43:47,859 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.events -> JBPM_EVENT
17:43:47,859 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
17:43:47,859 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.nodes -> JBPM_NODE
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.actions -> JBPM_ACTION
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.definitions -> JBPM_MODULEDEFINITION
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.events -> JBPM_EVENT
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.leavingTransitions -> JBPM_TRANSITION
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.arrivingTransitions -> JBPM_TRANSITION
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Transition.events -> JBPM_EVENT
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Transition.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
17:43:47,874 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Event.actions -> JBPM_ACTION
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.SuperState.nodes -> JBPM_NODE
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ExceptionHandler.actions -> JBPM_ACTION
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.ProcessState.variableAccesses -> JBPM_VARIABLEACCESS
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.TaskNode.tasks -> JBPM_TASK
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Swimlane.tasks -> JBPM_TASK
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Task.events -> JBPM_EVENT
17:43:47,890 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Task.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskController.variableAccesses -> JBPM_VARIABLEACCESS
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.file.def.FileDefinition.processFiles -> JBPM_BYTEARRAY
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.ProcessInstance.runtimeActions -> JBPM_RUNTIMEACTION
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.ProcessInstance.instances -> JBPM_MODULEINSTANCE
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.Token.children -> JBPM_TOKEN
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.Token.comments -> JBPM_COMMENT
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.context.exe.ContextInstance.tokenVariableMaps -> JBPM_TOKENVARIABLEMAP
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.context.exe.TokenVariableMap.variableInstances -> JBPM_VARIABLEINSTANCE
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskMgmtInstance.swimlaneInstances -> JBPM_SWIMLANEINSTANCE
17:43:47,905 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances -> JBPM_TASKINSTANCE
17:43:47,937 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.variableInstances -> JBPM_VARIABLEINSTANCE
17:43:47,937 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.comments -> JBPM_COMMENT
17:43:47,952 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.SwimlaneInstance.pooledActors -> JBPM_POOLEDACTOR
17:43:47,952 [main] INFO HbmBinder : Mapping collection: org.jbpm.logging.log.CompositeLog.children -> JBPM_LOG
17:43:47,952 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes -> JBPM_SWIMLANE
17:43:47,952 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks -> JBPM_TASK
17:43:47,952 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.action.Script.variableAccesses -> JBPM_VARIABLEACCESS
17:43:48,077 [main] INFO DriverManagerConnectionProvider : Using Hibernate built-in connection pool (not for production use!)
17:43:48,077 [main] INFO DriverManagerConnectionProvider : Hibernate connection pool size: 20
17:43:48,077 [main] INFO DriverManagerConnectionProvider : autocommit mode: false
17:43:48,092 [main] INFO DriverManagerConnectionProvider : using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/jbpm
17:43:48,092 [main] INFO DriverManagerConnectionProvider : connection properties: {user=root, password=****}
17:43:48,559 [main] INFO SettingsFactory : RDBMS: MySQL, version: 5.0.27-community-nt
17:43:48,559 [main] INFO SettingsFactory : JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.3 ( $Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $, $Revision: 5553 $ )
17:43:48,606 [main] INFO Dialect : Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
17:43:48,606 [main] INFO TransactionFactoryFactory : Using default transaction strategy (direct JDBC transactions)
17:43:48,621 [main] INFO TransactionManagerLookupFactory : No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:43:48,621 [main] INFO SettingsFactory : Automatic flush during beforeCompletion(): disabled
17:43:48,621 [main] INFO SettingsFactory : Automatic session close at end of transaction: disabled
17:43:48,621 [main] INFO SettingsFactory : JDBC batch size: 15
17:43:48,621 [main] INFO SettingsFactory : JDBC batch updates for versioned data: disabled
17:43:48,621 [main] INFO SettingsFactory : Scrollable result sets: enabled
17:43:48,621 [main] INFO SettingsFactory : JDBC3 getGeneratedKeys(): enabled
17:43:48,621 [main] INFO SettingsFactory : Connection release mode: auto
17:43:48,621 [main] INFO SettingsFactory : Maximum outer join fetch depth: 2
17:43:48,637 [main] INFO SettingsFactory : Default batch fetch size: 1
17:43:48,637 [main] INFO SettingsFactory : Generate SQL with comments: disabled
17:43:48,637 [main] INFO SettingsFactory : Order SQL updates by primary key: disabled
17:43:48,637 [main] INFO SettingsFactory : Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:43:48,637 [main] INFO ASTQueryTranslatorFactory : Using ASTQueryTranslatorFactory
17:43:48,637 [main] INFO SettingsFactory : Query language substitutions: {}
17:43:48,637 [main] INFO SettingsFactory : JPA-QL strict compliance: disabled
17:43:48,637 [main] INFO SettingsFactory : Second-level cache: enabled
17:43:48,637 [main] INFO SettingsFactory : Query cache: disabled
17:43:48,637 [main] INFO SettingsFactory : Cache provider: org.hibernate.cache.HashtableCacheProvider
17:43:48,653 [main] INFO SettingsFactory : Optimize cache for minimal puts: disabled
17:43:48,653 [main] INFO SettingsFactory : Structured second-level cache entries: disabled
17:43:48,668 [main] INFO SettingsFactory : Statistics: disabled
17:43:48,668 [main] INFO SettingsFactory : Deleted entity synthetic identifier rollback: disabled
17:43:48,668 [main] INFO SettingsFactory : Default entity-mode: pojo
17:43:48,668 [main] INFO SettingsFactory : Named query checking : enabled
17:43:48,746 [main] INFO SessionFactoryImpl : building session factory
17:43:51,703 [main] INFO SessionFactoryObjectFactory : Not binding factory to JNDI, no JNDI name configured
17:43:52,637 [main] DEBUG DbPersistenceService : creating hibernate session
17:43:52,715 [main] DEBUG DbPersistenceService : beginning hibernate transaction
17:43:52,715 [main] DEBUG DbPersistenceService : begun hibernate transaction org.hibernate.transaction.JDBCTransaction@77eb97
17:43:53,135 [main] WARN JDBCExceptionReporter : SQL Error: 1146, SQLState: 42S02
17:43:53,135 [main] ERROR JDBCExceptionReporter : Table 'jbpm.jbpm_transition' doesn't exist
17:43:53,135 [main] DEBUG JbpmContext : closing JbpmContext
17:43:53,151 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@ed5d9d
17:43:53,151 [main] DEBUG DbPersistenceService : committing hibernate transaction org.hibernate.transaction.JDBCTransaction@77eb97
17:43:53,166 [main] WARN JDBCExceptionReporter : SQL Error: 1146, SQLState: 42S02
17:43:53,166 [main] ERROR JDBCExceptionReporter : Table 'jbpm.jbpm_transition' doesn't exist
17:43:53,166 [main] ERROR DbPersistenceService : hibernate commit failed
org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.graph.def.Transition]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131)
at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:255)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:213)
at org.jbpm.svc.Services.close(Services.java:222)
at org.jbpm.JbpmContext.close(JbpmContext.java:139)
at com.sample.SimpleProcessTest.testSimpleProcess(SimpleProcessTest.java:41)
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:324)
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)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jbpm.jbpm_transition' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 71 more
17:43:53,182 [main] DEBUG DbPersistenceService : rolling back hibernate transaction
17:43:53,260 [main] DEBUG DbPersistenceService : closing hibernate session
17:43:53,260 [main] ERROR Services : problem closing service 'persistence'
org.jbpm.persistence.JbpmPersistenceException: hibernate commit failed
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:218)
at org.jbpm.svc.Services.close(Services.java:222)
at org.jbpm.JbpmContext.close(JbpmContext.java:139)
at com.sample.SimpleProcessTest.testSimpleProcess(SimpleProcessTest.java:41)
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:324)
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)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.graph.def.Transition]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131)
at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:255)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:213)
... 21 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jbpm.jbpm_transition' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUp

1. Re: Exception when deploying a process definition to Mysql

sujeewanie Jul 26, 2007 12:11 AM (in response to sujeewanie)

Actually I am trying to run the Db example in the chapter 3 of the tutorial. When the code to deploy the process runs I get the below exception.
In the stack trace it complains that able 'jbpm.jbpm_transition' doesn't exist.
Actually the scripts in the db\jbpm.jpdl.mssql.sql does not create such a table.
Appreciate if some one can throw some light on this.
Actions
2. Re: Exception when deploying a process definition to Mysql

sujeewanie Jul 27, 2007 1:18 AM (in response to sujeewanie)

Ok.I figured it out. The jbpm.jpdl.mysql.sql not only does not have a ; at each sql statement, there is no commit at the end. So even though i ran the script there are no tables in the DB :(
But even after that I still keep getting the exception

org.jbpm.JbpmException: no jbpm tx service configured
at org.jbpm.persistence.db.DbPersistenceService.isRollbackOnly(DbPersistenceService.java:390)
at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:212)
at org.jbpm.svc.Services.close(Services.java:222)
at org.jbpm.JbpmContext.close(JbpmContext.java:139)
at org.jbpm.examples.action.HelloWorldDbTest.deployProcessDefinition(HelloWorldDbTest.java:116)
at org.jbpm.examples.action.HelloWorldDbTest.testSimplePersistence(HelloWorldDbTest.java:78)
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:324)
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)
Actions
3. Re: Exception when deploying a process definition to Mysql

sujeewanie Jul 27, 2007 1:40 AM (in response to sujeewanie)

Ok.Got it again.
In the jbpm-configuration created by the example, no services are created.
I commented that code and obtained a context throgh the default settings like

JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();

Fanally it works now
Actions

4. Re: Exception when deploying a process definition to Mysql

dingo001 Aug 10, 2007 5:23 PM (in response to sujeewanie)

"sujeewanie" wrote:
Ok.Got it again.
In the jbpm-configuration created by the example, no services are created.
I commented that code and obtained a context throgh the default settings like

JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();

Fanally it works now

Change to this

jbpmConfiguration = JbpmConfiguration
 .parseXmlString("<jbpm-configuration>"
 +

 // A jbpm-context mechanism separates the jbpm core
 // engine from the services that jbpm uses from
 // the environment.

 " <jbpm-context>"
 + " <service name='persistence' "
 + " factory='org.jbpm.persistence.db.DbPersistenceServiceFactory' />"
 + " <service name='tx' factory='org.jbpm.tx.TxServiceFactory' />"
 + " </jbpm-context>"
 +

 // Also all the resource files that are used by jbpm are
 // referenced from the jbpm.cfg.xml

 " <string name='resource.hibernate.cfg.xml' "
 + " value='hibernate.cfg.xml' />"
 + " <string name='resource.business.calendar' "
 + " value='org/jbpm/calendar/jbpm.business.calendar.properties' />"
 + " <string name='resource.default.modules' "
 + " value='org/jbpm/graph/def/jbpm.default.modules.properties' />"
 + " <string name='resource.converter' "
 + " value='org/jbpm/db/hibernate/jbpm.converter.properties' />"
 + " <string name='resource.action.types' "
 + " value='org/jbpm/graph/action/action.types.xml' />"
 + " <string name='resource.node.types' "
 + " value='org/jbpm/graph/node/node.types.xml' />"
 + " <string name='resource.varmapping' "
 + " value='org/jbpm/context/exe/jbpm.varmapping.xml' />"
 + "</jbpm-configuration>");

Go to original post