Hibernate connection problem

[dharraj]

Hello all,

Following are messages printed when I try using the jBPM. Please let me know how to fix it.

Thanks
Raj
16:11:23,039 DEBUG JbpmConfiguration : jbpm.hibernate.properties=hibernate.properties
16:11:23,135 INFO Environment : Hibernate 3.0.5
16:11:23,145 INFO Environment : loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.c3p0.max_size=3, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.c3p0.min_size=1, hibernate.connection.username=sa, hibernate.connection.url=jdbc:hsqldb:hsql://localhost:1701, hibernate.show_sql=true, hibernate.connection.password=****}
16:11:23,151 INFO Environment : using CGLIB reflection optimizer
16:11:23,155 INFO Environment : using JDK 1.4 java.sql.Timestamp handling
16:11:23,329 DEBUG JbpmSessionFactory : using the default hibernate configuration file: hibernate.cfg.xml
16:11:23,331 INFO Configuration : configuring from resource: /hibernate.cfg.xml
16:11:23,337 INFO Configuration : Configuration resource: /hibernate.cfg.xml
16:11:24,099 INFO Configuration : Mapping resource: org/jbpm/identity/User.hbm.xml
16:11:24,388 INFO HbmBinder : Mapping class: org.jbpm.identity.User -> JBPM_ID_USER
16:11:24,477 INFO HbmBinder : Mapping collection: org.jbpm.identity.User.permissions -> JBPM_ID_PERMISSIONS
16:11:24,479 INFO Configuration : Mapping resource: org/jbpm/identity/Group.hbm.xml
16:11:24,563 INFO HbmBinder : Mapping class: org.jbpm.identity.Group -> JBPM_ID_GROUP
16:11:24,580 INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.permissions -> JBPM_ID_PERMISSIONS
16:11:24,582 INFO Configuration : Mapping resource: org/jbpm/identity/Membership.hbm.xml
16:11:24,658 INFO HbmBinder : Mapping class: org.jbpm.identity.Membership -> JBPM_ID_MEMBERSHIP
16:11:24,795 INFO HbmBinder : Mapping collection: org.jbpm.identity.Membership.permissions -> JBPM_ID_PERMISSIONS
16:11:24,797 INFO Configuration : Mapping resource: org/jbpm/graph/def/ProcessDefinition.hbm.xml
16:11:24,876 INFO HbmBinder : Mapping class: org.jbpm.graph.def.ProcessDefinition -> JBPM_PROCESSDEFINITION
16:11:24,926 INFO Configuration : Mapping resource: org/jbpm/graph/def/Node.hbm.xml
16:11:24,994 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Node -> JBPM_NODE
16:11:25,020 INFO Configuration : Mapping resource: org/jbpm/graph/def/Transition.hbm.xml
16:11:25,052 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Transition -> JBPM_TRANSITION
16:11:25,059 INFO Configuration : Mapping resource: org/jbpm/graph/def/Event.hbm.xml
16:11:25,110 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Event -> JBPM_EVENT
16:11:25,116 INFO Configuration : Mapping resource: org/jbpm/graph/def/Action.hbm.xml
16:11:25,283 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Action -> JBPM_ACTION
16:11:25,291 INFO Configuration : Mapping resource: org/jbpm/graph/def/SuperState.hbm.xml
16:11:25,416 INFO HbmBinder : Mapping subclass: org.jbpm.graph.def.SuperState -> JBPM_NODE
16:11:25,419 INFO Configuration : Mapping resource: org/jbpm/graph/def/ExceptionHandler.hbm.xml
16:11:25,454 INFO HbmBinder : Mapping class: org.jbpm.graph.def.ExceptionHandler -> JBPM_EXCEPTIONHANDLER
16:11:25,457 INFO Configuration : Mapping resource: org/jbpm/instantiation/Delegation.hbm.xml
16:11:25,497 INFO HbmBinder : Mapping class: org.jbpm.instantiation.Delegation -> JBPM_DELEGATION
16:11:25,502 INFO Configuration : Mapping resource: org/jbpm/graph/node/StartState.hbm.xml
16:11:25,522 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.StartState -> JBPM_NODE
16:11:25,523 INFO Configuration : Mapping resource: org/jbpm/graph/node/EndState.hbm.xml
16:11:25,543 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.EndState -> JBPM_NODE
16:11:25,544 INFO Configuration : Mapping resource: org/jbpm/graph/node/ProcessState.hbm.xml
16:11:25,562 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.ProcessState -> JBPM_NODE
16:11:25,570 INFO Configuration : Mapping resource: org/jbpm/graph/node/Decision.hbm.xml
16:11:25,600 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Decision -> JBPM_NODE
16:11:25,601 INFO HbmBinder : Mapping collection: org.jbpm.graph.node.Decision.decisionConditions -> JBPM_DECISIONCONDITIONS
16:11:25,603 INFO Configuration : Mapping resource: org/jbpm/graph/node/Fork.hbm.xml
16:11:25,627 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Fork -> JBPM_NODE
16:11:25,628 INFO Configuration : Mapping resource: org/jbpm/graph/node/Join.hbm.xml
16:11:25,651 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Join -> JBPM_NODE
16:11:25,652 INFO Configuration : Mapping resource: org/jbpm/graph/node/State.hbm.xml
16:11:25,701 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.State -> JBPM_NODE
16:11:25,702 INFO Configuration : Mapping resource: org/jbpm/graph/node/TaskNode.hbm.xml
16:11:25,827 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.TaskNode -> JBPM_NODE
16:11:25,844 INFO Configuration : Mapping resource: org/jbpm/graph/action/Script.hbm.xml
16:11:25,894 INFO HbmBinder : Mapping subclass: org.jbpm.graph.action.Script -> JBPM_ACTION
16:11:25,910 INFO Configuration : Mapping resource: org/jbpm/context/def/ContextDefinition.hbm.xml
16:11:25,927 INFO Configuration : Mapping resource: org/jbpm/context/def/VariableAccess.hbm.xml
16:11:25,950 INFO HbmBinder : Mapping class: org.jbpm.context.def.VariableAccess -> JBPM_VARIABLEACCESS
16:11:25,954 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml
16:11:25,982 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/Swimlane.hbm.xml
16:11:26,012 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Swimlane -> JBPM_SWIMLANE
16:11:26,023 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/Task.hbm.xml
16:11:26,057 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Task -> JBPM_TASK
16:11:26,070 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/TaskController.hbm.xml
16:11:26,094 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.TaskController -> JBPM_TASKCONTROLLER
16:11:26,121 INFO Configuration : Mapping resource: org/jbpm/module/def/ModuleDefinition.hbm.xml
16:11:26,147 INFO HbmBinder : Mapping class: org.jbpm.module.def.ModuleDefinition -> JBPM_MODULEDEFINITION
16:11:26,150 INFO Configuration : Mapping resource: org/jbpm/bytes/ByteArray.hbm.xml
16:11:26,177 INFO HbmBinder : Mapping class: org.jbpm.bytes.ByteArray -> JBPM_BYTEARRAY
16:11:26,278 INFO HbmBinder : Mapping collection: org.jbpm.bytes.ByteArray.byteBlocks -> JBPM_BYTEBLOCK
16:11:26,279 INFO Configuration : Mapping resource: org/jbpm/file/def/FileDefinition.hbm.xml
16:11:26,299 INFO HbmBinder : Mapping subclass: org.jbpm.file.def.FileDefinition -> JBPM_MODULEDEFINITION
16:11:26,300 INFO Configuration : Mapping resource: org/jbpm/scheduler/def/CreateTimerAction.hbm.xml
16:11:26,322 INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CreateTimerAction -> JBPM_ACTION
16:11:26,327 INFO Configuration : Mapping resource: org/jbpm/scheduler/def/CancelTimerAction.hbm.xml
16:11:26,345 INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CancelTimerAction -> JBPM_ACTION
16:11:26,348 INFO Configuration : Mapping resource: org/jbpm/graph/exe/Comment.hbm.xml
16:11:26,365 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Comment -> JBPM_COMMENT
16:11:26,369 INFO Configuration : Mapping resource: org/jbpm/graph/exe/ProcessInstance.hbm.xml
16:11:26,395 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.ProcessInstance -> JBPM_PROCESSINSTANCE
16:11:26,413 INFO Configuration : Mapping resource: org/jbpm/graph/exe/Token.hbm.xml
16:11:26,440 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Token -> JBPM_TOKEN
16:11:26,458 INFO Configuration : Mapping resource: org/jbpm/graph/exe/RuntimeAction.hbm.xml
16:11:26,484 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.RuntimeAction -> JBPM_RUNTIMEACTION
16:11:26,487 INFO Configuration : Mapping resource: org/jbpm/module/exe/ModuleInstance.hbm.xml
16:11:26,510 INFO HbmBinder : Mapping class: org.jbpm.module.exe.ModuleInstance -> JBPM_MODULEINSTANCE
16:11:26,512 INFO Configuration : Mapping resource: org/jbpm/context/exe/ContextInstance.hbm.xml
16:11:26,530 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.ContextInstance -> JBPM_MODULEINSTANCE
16:11:26,533 INFO Configuration : Mapping resource: org/jbpm/context/exe/TokenVariableMap.hbm.xml
16:11:26,571 INFO HbmBinder : Mapping class: org.jbpm.context.exe.TokenVariableMap -> JBPM_TOKENVARIABLEMAP
16:11:26,581 INFO Configuration : Mapping resource: org/jbpm/context/exe/VariableInstance.hbm.xml
16:11:26,752 INFO HbmBinder : Mapping class: org.jbpm.context.exe.VariableInstance -> JBPM_VARIABLEINSTANCE
16:11:26,759 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml
16:11:26,792 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.ByteArrayInstance -> JBPM_VARIABLEINSTANCE
16:11:26,793 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml
16:11:26,814 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DateInstance -> JBPM_VARIABLEINSTANCE
16:11:26,815 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml
16:11:26,847 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DoubleInstance -> JBPM_VARIABLEINSTANCE
16:11:26,850 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml
16:11:26,866 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateLongInstance -> JBPM_VARIABLEINSTANCE
16:11:26,870 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
16:11:26,885 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateStringInstance -> JBPM_VARIABLEINSTANCE
16:11:26,886 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml
16:11:26,905 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.LongInstance -> JBPM_VARIABLEINSTANCE
16:11:26,906 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
16:11:26,922 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.StringInstance -> JBPM_VARIABLEINSTANCE
16:11:26,923 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml
16:11:26,946 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.exe.TaskMgmtInstance -> JBPM_MODULEINSTANCE
16:11:26,953 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml
16:11:26,976 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.TaskInstance -> JBPM_TASKINSTANCE
16:11:26,992 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.pooledActors -> JBPM_TASKACTORPOOL
16:11:26,993 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/PooledActor.hbm.xml
16:11:27,017 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.PooledActor -> JBPM_POOLEDACTOR
16:11:27,025 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.PooledActor.taskInstances -> JBPM_TASKACTORPOOL
16:11:27,027 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml
16:11:27,148 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.SwimlaneInstance -> JBPM_SWIMLANEINSTANCE
16:11:27,153 INFO Configuration : Mapping resource: org/jbpm/scheduler/exe/Timer.hbm.xml
16:11:27,174 INFO HbmBinder : Mapping class: org.jbpm.scheduler.exe.Timer -> JBPM_TIMER
16:11:27,182 INFO Configuration : Mapping resource: org/jbpm/logging/log/ProcessLog.hbm.xml
16:11:27,202 INFO HbmBinder : Mapping class: org.jbpm.logging.log.ProcessLog -> JBPM_LOG
16:11:27,209 INFO Configuration : Mapping resource: org/jbpm/logging/log/MessageLog.hbm.xml
16:11:27,226 INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.MessageLog -> JBPM_LOG
16:11:27,230 INFO Configuration : Mapping resource: org/jbpm/logging/log/CompositeLog.hbm.xml
16:11:27,248 INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.CompositeLog -> JBPM_LOG
16:11:27,250 INFO Configuration : Mapping resource: org/jbpm/graph/log/ActionLog.hbm.xml
16:11:27,264 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ActionLog -> JBPM_LOG
16:11:27,267 INFO Configuration : Mapping resource: org/jbpm/graph/log/NodeLog.hbm.xml
16:11:27,285 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.NodeLog -> JBPM_LOG
16:11:27,288 INFO Configuration : Mapping resource: org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml
16:11:27,305 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceCreateLog -> JBPM_LOG
16:11:27,307 INFO Configuration : Mapping resource: org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml
16:11:27,321 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceEndLog -> JBPM_LOG
16:11:27,323 INFO Configuration : Mapping resource: org/jbpm/graph/log/SignalLog.hbm.xml
16:11:27,343 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.SignalLog -> JBPM_LOG
16:11:27,344 INFO Configuration : Mapping resource: org/jbpm/graph/log/TokenCreateLog.hbm.xml
16:11:27,466 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenCreateLog -> JBPM_LOG
16:11:27,468 INFO Configuration : Mapping resource: org/jbpm/graph/log/TokenEndLog.hbm.xml
16:11:27,484 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenEndLog -> JBPM_LOG
16:11:27,487 INFO Configuration : Mapping resource: org/jbpm/graph/log/TransitionLog.hbm.xml
16:11:27,510 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TransitionLog -> JBPM_LOG
16:11:27,512 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableLog.hbm.xml
16:11:27,526 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableLog -> JBPM_LOG
16:11:27,530 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableCreateLog.hbm.xml
16:11:27,547 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableCreateLog -> JBPM_LOG
16:11:27,548 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableDeleteLog.hbm.xml
16:11:27,568 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableDeleteLog -> JBPM_LOG
16:11:27,569 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableUpdateLog.hbm.xml
16:11:27,585 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableUpdateLog -> JBPM_LOG
16:11:27,586 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml
16:11:27,605 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.ByteArrayUpdateLog -> JBPM_LOG
16:11:27,607 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml
16:11:27,625 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DateUpdateLog -> JBPM_LOG
16:11:27,626 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml
16:11:27,644 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DoubleUpdateLog -> JBPM_LOG
16:11:27,646 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml
16:11:27,665 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateLongUpdateLog -> JBPM_LOG
16:11:27,667 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml
16:11:27,685 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateStringUpdateLog -> JBPM_LOG
16:11:27,687 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml
16:11:27,702 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.LongUpdateLog -> JBPM_LOG
16:11:27,703 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml
16:11:27,727 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.StringUpdateLog -> JBPM_LOG
16:11:27,728 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskLog.hbm.xml
16:11:27,744 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskLog -> JBPM_LOG
16:11:27,747 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml
16:11:27,768 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskCreateLog -> JBPM_LOG
16:11:27,771 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml
16:11:27,789 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskAssignLog -> JBPM_LOG
16:11:27,791 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml
16:11:27,806 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskEndLog -> JBPM_LOG
16:11:27,807 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml
16:11:27,927 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneLog -> JBPM_LOG
16:11:27,929 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml
16:11:27,947 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneCreateLog -> JBPM_LOG
16:11:27,952 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml
16:11:27,966 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneAssignLog -> JBPM_LOG
16:11:27,969 INFO Configuration : Configured SessionFactory: null
16:11:27,976 DEBUG JbpmSessionFactory : overriding hibernate properties with {hibernate.connection.username=sa, hibernate.connection.password=, hibernate.c3p0.min_size=1, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.c3p0.max_size=3, hibernate.show_sql=true, hibernate.connection.url=jdbc:hsqldb:hsql://localhost:1701, hibernate.connection.driver_class=org.hsqldb.jdbcDriver}
16:11:27,977 DEBUG JbpmSessionFactory : building hibernate session factory
16:11:27,978 INFO Configuration : processing extends queue
16:11:27,979 INFO HbmBinder : Mapping subclass: org.jbpm.context.def.ContextDefinition -> JBPM_MODULEDEFINITION
16:11:27,980 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.def.TaskMgmtDefinition -> JBPM_MODULEDEFINITION
16:11:27,982 INFO Configuration : processing collection mappings
16:11:27,983 INFO HbmBinder : Mapping collection: org.jbpm.identity.User.memberships -> JBPM_ID_MEMBERSHIP
16:11:27,985 INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.memberships -> JBPM_ID_MEMBERSHIP
16:11:27,986 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.events -> JBPM_EVENT
16:11:27,987 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
16:11:27,988 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.nodes -> JBPM_NODE
16:11:27,989 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.actions -> JBPM_ACTION
16:11:27,993 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.definitions -> JBPM_MODULEDEFINITION
16:11:27,994 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.events -> JBPM_EVENT
16:11:27,995 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
16:11:27,998 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.leavingTransitions -> JBPM_TRANSITION
16:11:27,999 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.arrivingTransitions -> JBPM_TRANSITION
16:11:28,000 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Transition.events -> JBPM_EVENT
16:11:28,001 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Transition.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
16:11:28,002 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Event.actions -> JBPM_ACTION
16:11:28,003 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.SuperState.nodes -> JBPM_NODE
16:11:28,004 INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ExceptionHandler.actions -> JBPM_ACTION
16:11:28,004 INFO HbmBinder : Mapping collection: org.jbpm.graph.node.ProcessState.variableAccesses -> JBPM_VARIABLEACCESS
16:11:28,010 INFO HbmBinder : Mapping collection: org.jbpm.graph.node.TaskNode.tasks -> JBPM_TASK
16:11:28,013 INFO HbmBinder : Mapping collection: org.jbpm.graph.action.Script.variableAccesses -> JBPM_VARIABLEACCESS
16:11:28,014 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Swimlane.tasks -> JBPM_TASK
16:11:28,014 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Task.events -> JBPM_EVENT
16:11:28,015 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Task.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
16:11:28,016 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskController.variableAccesses -> JBPM_VARIABLEACCESS
16:11:28,017 INFO HbmBinder : Mapping collection: org.jbpm.file.def.FileDefinition.processFiles -> JBPM_BYTEARRAY
16:11:28,018 INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.ProcessInstance.runtimeActions -> JBPM_RUNTIMEACTION
16:11:28,019 INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.ProcessInstance.instances -> JBPM_MODULEINSTANCE
16:11:28,020 INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.Token.children -> JBPM_TOKEN
16:11:28,021 INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.Token.comments -> JBPM_COMMENT
16:11:28,023 INFO HbmBinder : Mapping collection: org.jbpm.context.exe.ContextInstance.tokenVariableMaps -> JBPM_TOKENVARIABLEMAP
16:11:28,024 INFO HbmBinder : Mapping collection: org.jbpm.context.exe.TokenVariableMap.variableInstances -> JBPM_VARIABLEINSTANCE
16:11:28,025 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskMgmtInstance.swimlaneInstances -> JBPM_SWIMLANEINSTANCE
16:11:28,027 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances -> JBPM_TASKINSTANCE
16:11:28,030 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.comments -> JBPM_COMMENT
16:11:28,031 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.SwimlaneInstance.pooledActors -> JBPM_POOLEDACTOR
16:11:28,031 INFO HbmBinder : Mapping collection: org.jbpm.logging.log.CompositeLog.children -> JBPM_LOG
16:11:28,033 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes -> JBPM_SWIMLANE
16:11:28,033 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks -> JBPM_TASK
16:11:28,034 INFO Configuration : processing association property references
16:11:28,035 INFO Configuration : processing foreign key constraints
16:11:28,183 INFO C3P0ConnectionProvider : C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:1701
16:11:28,184 INFO C3P0ConnectionProvider : Connection properties: {user=sa, password=****}
16:11:28,189 INFO C3P0ConnectionProvider : autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@737371 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@14db0e3 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 3, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@1cb52ae [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:hsql://localhost:1701, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 737371 ]
java.sql.SQLException: socket creation error
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
java.sql.SQLException: socket creation error
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)

[sak]

hi
can you please specify your environment detail as to which database you are trying to connect ?
which server is any you are using..etc
Is your trying just to deploy or run the sample PAR?
This appears to be a driver class exception where jar has not been ptu into the proper path..
thanks

[kukeltje]

looks like hsqldb is not running. Did you start it? (either stand-alone or via jboss)

[kylin_bo]

"kukeltje" wrote:
looks like hsqldb is not running. Did you start it? (either stand-alone or via jboss)

mybe the user is not exist!

[dharraj]

I started hibernate on port 7070 and than specified hibernate.cfg.xml in classpath, however, when I create jbpm session, it is states that it is uisng port 1701. How can I fix this.

I did started hibernate on port 1701 and ran my test case. Here is what I got.

.............
...............
15:58:14,882 WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
15:58:15,156 WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
15:58:15,161 WARN EhCacheProvider : Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
15:58:15,985 WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
15:58:16,077 WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
15:58:16,217 WARN EhCacheProvider : Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
15:58:16,341 WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
15:58:16,715 WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
15:58:18,617 INFO SessionFactoryObjectFactory : Not binding factory to JNDI, no JNDI name configured
15:58:18,619 INFO SessionFactoryImpl : Checking 0 named queries
com.sample.action.RuntimeActionHandler Action =null created using default constructor
Hibernate: insert into JBPM_TOKEN (NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, NODE_, PROCESSINSTANCE_, PARENT_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null)
15:58:20,214 WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
15:58:20,217 ERROR JDBCExceptionReporter : Table not found: JBPM_TOKEN in statement [insert into JBPM_TOKEN (NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, NODE_, PROCESSINSTANCE_, PARENT_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null)]
15:58:20,224 WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
15:58:20,226 ERROR JDBCExceptionReporter : Table not found: JBPM_TOKEN in statement [insert into JBPM_TOKEN (NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, NODE_, PROCESSINSTANCE_, PARENT_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null)]
MainDriverComplete::Main() Got exception=could not insert: [org.jbpm.graph.exe.Token]
org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.graph.exe.Token]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1777)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:96)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:468)
at org.hibernate.engine.Cascades$5.cascade(Cascades.java:154)
at org.hibernate.engine.Cascades.cascadeAssociation(Cascades.java:771)
at org.hibernate.engine.Cascades.cascade(Cascades.java:720)
at org.hibernate.engine.Cascades.cascade(Cascades.java:847)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:332)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:214)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
at org.jbpm.graph.exe.ProcessInstance.(ProcessInstance.java:91)
at com.sample.action.MainDriverComplete.main(Unknown Source)
Caused by: java.sql.SQLException: Table not found: JBPM_TOKEN in statement [insert into JBPM_TOKEN (NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, NODE_, PROCESSINSTANCE_, PARENT_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null)]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:189)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:76)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1739)
... 28 more

Thanks for you time and help.
Raj

[dharraj]

Sorry I forgot to ask one more thing.

I see what looks like hibernate configuration files (*hibernate.*) in several directories. Which one is really used by the JbpmConfiguration class. Is it the one specified through the jbpm.properties file located in org/jbpm? If so, do I need to put the hibernate config filein the org/jbpm directory or to $JBPM_HOME?

I am really tired and will appreciate any help.

Thanks

Raj

[aguizar]

You need to create the jBPM schema in the Hypersonic database you started. Go to the database compatibility package included in the starters kit (directory jbpm-db) and follow the instructions in readme.html for creating and running the SQL DDL scripts. Alternatively, you can download the package here.

The jBPM user guide, section 5.2 answers your second question.