6 Replies Latest reply on Oct 11, 2005 4:56 AM by Alejandro Guizar

    Hibernate connection problem

    Rajesh Patel Newbie

      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)

        • 1. Re: Hibernate connection problem
          amir kamal Newbie

          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

          • 2. Re: Hibernate connection problem
            Ronald van Kuijk Master

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

            • 3. Re: Hibernate connection problem
              wang xb Newbie

               

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

              mybe the user is not exist!

              • 4. Re: Hibernate connection problem
                Rajesh Patel Newbie

                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

                • 5. Re: Hibernate connection problem
                  Rajesh Patel Newbie

                  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

                  • 6. Re: Hibernate connection problem
                    Alejandro Guizar Master

                    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.