3 Replies Latest reply on Apr 21, 2006 8:41 AM by Ronald van Kuijk

    Error in Process Definition Deployment.

    pganesh81 Newbie

      -------------------------------------------------------------------------------

      Hi,

      I tried executing the code deploying process definition and creating an instance of it, given in this forum, but i received a different error showing SQLException error.
      Do we have to make specific change in database configuration.
      Could anyone help me in sorting out the problem
      Below is the code which i tried.

      Thanks in advance.

      package MyPack;

      import org.jbpm.graph.def.ProcessDefinition;
      import org.jbpm.graph.exe.ProcessInstance;
      import org.jbpm.JbpmConfiguration;
      import org.jbpm.db.GraphSession;
      import org.jbpm.graph.exe.Token;
      import org.jbpm.JbpmContext;

      public class StartProcess
      {

      /** Init */
      public void init()
      {
      // Lookup the pojo persistence context-builder that is configured above
      JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance();
      JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();

      try
      {
      GraphSession graphSession = jbpmContext.getGraphSession();
      ProcessDefinition processDefinition = graphSession.findLatestProcessDefinition("Initiator");

      // With the processDefinition that we retrieved from the database,
      // we can create an execution of the process definition just like
      // in the hello world example (which was without persistence).
      ProcessInstance processInstance = new ProcessInstance(processDefinition);
      Token token = processInstance.getRootToken();
      //assertEquals("start new process", token.getNode().getName());

      // Let's start the process execution
      // processInstance.signal();
      token.signal();

      // Now the process is in the state 'state1'.
      // assertEquals("state1", token.getNode().getName());

      // Now the processInstance is saved in the database. So the
      // current state of the execution of the process is stored in the
      // database.
      jbpmContext.save(processInstance);
      }
      finally
      {
      // Tear down the pojo persistence context.
      jbpmContext.close();
      }
      }


      /** */
      public static void main(String[] args)
      {
      try
      {
      StartProcess sp = new StartProcess();
      sp.init();
      }
      catch(Exception exc)
      {
      System.err.println(exc.getMessage());
      exc.printStackTrace();
      }
      }
      }

      --------------------------------------------------------------------------------

      This is the output in the output showing error




      14:18:23,407 [main] INFO JbpmConfiguration : using jbpm configuration resource 'jbpm.cfg.xml'
      14:18:23,610 [main] DEBUG JbpmConfiguration : creating jbpm configuration from input stream
      14:18:23,688 [main] DEBUG JbpmContextInfo : creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      14:18:23,688 [main] DEBUG JbpmContext : creating JbpmContext
      14:18:23,688 [main] DEBUG DbPersistenceServiceFactory : creating persistence service
      14:18:23,719 [main] DEBUG DbPersistenceServiceFactory : building hibernate session factory
      14:18:23,829 [main] INFO Environment : Hibernate 3.1
      14:18:23,829 [main] INFO Environment : hibernate.properties not found
      14:18:23,844 [main] INFO Environment : using CGLIB reflection optimizer
      14:18:23,860 [main] INFO Environment : using JDK 1.4 java.sql.Timestamp handling
      14:18:24,016 [main] DEBUG HibernateHelper : creating hibernate configuration resource 'hibernate.cfg.xml'
      14:18:24,016 [main] INFO Configuration : configuring from resource: hibernate.cfg.xml
      14:18:24,016 [main] INFO Configuration : Configuration resource: hibernate.cfg.xml
      14:18:24,204 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/action/Script.hbm.xml
      14:18:24,392 [main] INFO Configuration : Reading mappings from resource: org/jbpm/identity/User.hbm.xml
      14:18:24,454 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.User -> JBPM_ID_USER
      14:18:24,532 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.User.permissions -> JBPM_ID_PERMISSIONS
      14:18:24,548 [main] INFO Configuration : Reading mappings from resource: org/jbpm/identity/Group.hbm.xml
      14:18:24,579 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.Group -> JBPM_ID_GROUP
      14:18:24,751 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.permissions -> JBPM_ID_PERMISSIONS
      14:18:24,751 [main] INFO Configuration : Reading mappings from resource: org/jbpm/identity/Membership.hbm.xml
      14:18:24,782 [main] INFO HbmBinder : Mapping class: org.jbpm.identity.Membership -> JBPM_ID_MEMBERSHIP
      14:18:24,782 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Membership.permissions -> JBPM_ID_PERMISSIONS
      14:18:24,782 [main] INFO Configuration : Reading mappings from resource: org/jbpm/db/hibernate.queries.hbm.xml
      14:18:24,829 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/ProcessDefinition.hbm.xml
      14:18:24,860 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.ProcessDefinition -> JBPM_PROCESSDEFINITION
      14:18:24,907 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/Node.hbm.xml
      14:18:24,939 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Node -> JBPM_NODE
      14:18:24,954 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/Transition.hbm.xml
      14:18:24,986 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Transition -> JBPM_TRANSITION
      14:18:25,001 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/Event.hbm.xml
      14:18:25,017 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Event -> JBPM_EVENT
      14:18:25,017 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/Action.hbm.xml
      14:18:25,064 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.Action -> JBPM_ACTION
      14:18:25,064 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/SuperState.hbm.xml
      14:18:25,189 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.def.SuperState -> JBPM_NODE
      14:18:25,204 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/def/ExceptionHandler.hbm.xml
      14:18:25,220 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.def.ExceptionHandler -> JBPM_EXCEPTIONHANDLER
      14:18:25,220 [main] INFO Configuration : Reading mappings from resource: org/jbpm/instantiation/Delegation.hbm.xml
      14:18:25,236 [main] INFO HbmBinder : Mapping class: org.jbpm.instantiation.Delegation -> JBPM_DELEGATION
      14:18:25,251 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/StartState.hbm.xml
      14:18:25,267 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.StartState -> JBPM_NODE
      14:18:25,267 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/EndState.hbm.xml
      14:18:25,283 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.EndState -> JBPM_NODE
      14:18:25,283 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/ProcessState.hbm.xml
      14:18:25,298 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.ProcessState -> JBPM_NODE
      14:18:25,298 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/Decision.hbm.xml
      14:18:25,329 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Decision -> JBPM_NODE
      14:18:25,345 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.Decision.decisionConditions -> JBPM_DECISIONCONDITIONS
      14:18:25,345 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/Fork.hbm.xml
      14:18:25,361 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Fork -> JBPM_NODE
      14:18:25,361 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/Join.hbm.xml
      14:18:25,408 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Join -> JBPM_NODE
      14:18:25,408 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/State.hbm.xml
      14:18:25,423 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.State -> JBPM_NODE
      14:18:25,423 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/node/TaskNode.hbm.xml
      14:18:25,454 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.TaskNode -> JBPM_NODE
      14:18:25,470 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/def/ContextDefinition.hbm.xml
      14:18:25,486 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/def/VariableAccess.hbm.xml
      14:18:25,533 [main] INFO HbmBinder : Mapping class: org.jbpm.context.def.VariableAccess -> JBPM_VARIABLEACCESS
      14:18:25,533 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml
      14:18:25,564 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/def/Swimlane.hbm.xml
      14:18:25,580 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Swimlane -> JBPM_SWIMLANE
      14:18:25,580 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/def/Task.hbm.xml
      14:18:25,595 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Task -> JBPM_TASK
      14:18:25,611 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/def/TaskController.hbm.xml
      14:18:25,689 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.TaskController -> JBPM_TASKCONTROLLER
      14:18:25,689 [main] INFO Configuration : Reading mappings from resource: org/jbpm/module/def/ModuleDefinition.hbm.xml
      14:18:25,736 [main] INFO HbmBinder : Mapping class: org.jbpm.module.def.ModuleDefinition -> JBPM_MODULEDEFINITION
      14:18:25,736 [main] INFO Configuration : Reading mappings from resource: org/jbpm/bytes/ByteArray.hbm.xml
      14:18:25,767 [main] INFO HbmBinder : Mapping class: org.jbpm.bytes.ByteArray -> JBPM_BYTEARRAY
      14:18:25,783 [main] INFO HbmBinder : Mapping collection: org.jbpm.bytes.ByteArray.byteBlocks -> JBPM_BYTEBLOCK
      14:18:25,783 [main] INFO Configuration : Reading mappings from resource: org/jbpm/file/def/FileDefinition.hbm.xml
      14:18:25,798 [main] INFO HbmBinder : Mapping subclass: org.jbpm.file.def.FileDefinition -> JBPM_MODULEDEFINITION
      14:18:25,798 [main] INFO Configuration : Reading mappings from resource: org/jbpm/scheduler/def/CreateTimerAction.hbm.xml
      14:18:25,830 [main] INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CreateTimerAction -> JBPM_ACTION
      14:18:25,845 [main] INFO Configuration : Reading mappings from resource: org/jbpm/scheduler/def/CancelTimerAction.hbm.xml
      14:18:25,861 [main] INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CancelTimerAction -> JBPM_ACTION
      14:18:25,861 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/exe/Comment.hbm.xml
      14:18:25,877 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Comment -> JBPM_COMMENT
      14:18:25,892 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/exe/ProcessInstance.hbm.xml
      14:18:25,923 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.ProcessInstance -> JBPM_PROCESSINSTANCE
      14:18:25,939 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/exe/Token.hbm.xml
      14:18:25,970 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Token -> JBPM_TOKEN
      14:18:25,986 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/exe/RuntimeAction.hbm.xml
      14:18:26,002 [main] INFO HbmBinder : Mapping class: org.jbpm.graph.exe.RuntimeAction -> JBPM_RUNTIMEACTION
      14:18:26,002 [main] INFO Configuration : Reading mappings from resource: org/jbpm/module/exe/ModuleInstance.hbm.xml
      14:18:26,080 [main] INFO HbmBinder : Mapping class: org.jbpm.module.exe.ModuleInstance -> JBPM_MODULEINSTANCE
      14:18:26,080 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/ContextInstance.hbm.xml
      14:18:26,111 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.ContextInstance -> JBPM_MODULEINSTANCE
      14:18:26,111 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/TokenVariableMap.hbm.xml
      14:18:26,127 [main] INFO HbmBinder : Mapping class: org.jbpm.context.exe.TokenVariableMap -> JBPM_TOKENVARIABLEMAP
      14:18:26,142 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/VariableInstance.hbm.xml
      14:18:26,158 [main] INFO HbmBinder : Mapping class: org.jbpm.context.exe.VariableInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,158 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml
      14:18:26,174 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.ByteArrayInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,174 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml
      14:18:26,205 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DateInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,205 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml
      14:18:26,220 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DoubleInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,220 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml
      14:18:26,236 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateLongInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,236 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
      14:18:26,252 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateStringInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,252 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml
      14:18:26,330 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.LongInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,330 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml
      14:18:26,345 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.NullInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,345 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
      14:18:26,361 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.StringInstance -> JBPM_VARIABLEINSTANCE
      14:18:26,361 [main] INFO Configuration : Reading mappings from resource: org/jbpm/msg/Message.hbm.xml
      14:18:26,392 [main] INFO HbmBinder : Mapping class: org.jbpm.msg.Message -> JBPM_MESSAGE
      14:18:26,392 [main] INFO Configuration : Reading mappings from resource: org/jbpm/msg/db/TextMessage.hbm.xml
      14:18:26,408 [main] INFO HbmBinder : Mapping subclass: org.jbpm.msg.db.TextMessage -> JBPM_MESSAGE
      14:18:26,424 [main] INFO Configuration : Reading mappings from resource: org/jbpm/command/ExecuteActionCommand.hbm.xml
      14:18:26,439 [main] INFO HbmBinder : Mapping subclass: org.jbpm.command.ExecuteActionCommand -> JBPM_MESSAGE
      14:18:26,439 [main] INFO Configuration : Reading mappings from resource: org/jbpm/command/ExecuteNodeCommand.hbm.xml
      14:18:26,455 [main] INFO HbmBinder : Mapping subclass: org.jbpm.command.ExecuteNodeCommand -> JBPM_MESSAGE
      14:18:26,455 [main] INFO Configuration : Reading mappings from resource: org/jbpm/command/SignalCommand.hbm.xml
      14:18:26,471 [main] INFO HbmBinder : Mapping subclass: org.jbpm.command.SignalCommand -> JBPM_MESSAGE
      14:18:26,486 [main] INFO Configuration : Reading mappings from resource: org/jbpm/command/TaskInstanceEndCommand.hbm.xml
      14:18:26,517 [main] INFO HbmBinder : Mapping subclass: org.jbpm.command.TaskInstanceEndCommand -> JBPM_MESSAGE
      14:18:26,517 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml
      14:18:26,549 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.exe.TaskMgmtInstance -> JBPM_MODULEINSTANCE
      14:18:26,564 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml
      14:18:26,580 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.TaskInstance -> JBPM_TASKINSTANCE
      14:18:26,596 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.pooledActors -> JBPM_TASKACTORPOOL
      14:18:26,596 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/exe/PooledActor.hbm.xml
      14:18:26,627 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.PooledActor -> JBPM_POOLEDACTOR
      14:18:26,627 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.PooledActor.taskInstances -> JBPM_TASKACTORPOOL
      14:18:26,627 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml
      14:18:26,689 [main] INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.SwimlaneInstance -> JBPM_SWIMLANEINSTANCE
      14:18:26,689 [main] INFO Configuration : Reading mappings from resource: org/jbpm/scheduler/exe/Timer.hbm.xml
      14:18:26,721 [main] INFO HbmBinder : Mapping class: org.jbpm.scheduler.exe.Timer -> JBPM_TIMER
      14:18:26,721 [main] INFO Configuration : Reading mappings from resource: org/jbpm/logging/log/ProcessLog.hbm.xml
      14:18:26,752 [main] INFO HbmBinder : Mapping class: org.jbpm.logging.log.ProcessLog -> JBPM_LOG
      14:18:26,752 [main] INFO Configuration : Reading mappings from resource: org/jbpm/logging/log/MessageLog.hbm.xml
      14:18:26,768 [main] INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.MessageLog -> JBPM_LOG
      14:18:26,768 [main] INFO Configuration : Reading mappings from resource: org/jbpm/logging/log/CompositeLog.hbm.xml
      14:18:26,783 [main] INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.CompositeLog -> JBPM_LOG
      14:18:26,783 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/ActionLog.hbm.xml
      14:18:26,814 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ActionLog -> JBPM_LOG
      14:18:26,814 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/NodeLog.hbm.xml
      14:18:26,846 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.NodeLog -> JBPM_LOG
      14:18:26,846 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml
      14:18:26,861 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceCreateLog -> JBPM_LOG
      14:18:26,877 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml
      14:18:26,893 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceEndLog -> JBPM_LOG
      14:18:26,893 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/SignalLog.hbm.xml
      14:18:26,908 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.SignalLog -> JBPM_LOG
      14:18:26,908 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/TokenCreateLog.hbm.xml
      14:18:26,924 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenCreateLog -> JBPM_LOG
      14:18:26,939 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/TokenEndLog.hbm.xml
      14:18:26,955 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenEndLog -> JBPM_LOG
      14:18:26,955 [main] INFO Configuration : Reading mappings from resource: org/jbpm/graph/log/TransitionLog.hbm.xml
      14:18:26,971 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TransitionLog -> JBPM_LOG
      14:18:26,971 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/VariableLog.hbm.xml
      14:18:26,986 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableLog -> JBPM_LOG
      14:18:26,986 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/VariableCreateLog.hbm.xml
      14:18:27,065 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableCreateLog -> JBPM_LOG
      14:18:27,065 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/VariableDeleteLog.hbm.xml
      14:18:27,080 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableDeleteLog -> JBPM_LOG
      14:18:27,080 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/VariableUpdateLog.hbm.xml
      14:18:27,096 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableUpdateLog -> JBPM_LOG
      14:18:27,096 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml
      14:18:27,111 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.ByteArrayUpdateLog -> JBPM_LOG
      14:18:27,127 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml
      14:18:27,143 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DateUpdateLog -> JBPM_LOG
      14:18:27,143 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml
      14:18:27,158 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DoubleUpdateLog -> JBPM_LOG
      14:18:27,158 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml
      14:18:27,174 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateLongUpdateLog -> JBPM_LOG
      14:18:27,174 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml
      14:18:27,190 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateStringUpdateLog -> JBPM_LOG
      14:18:27,190 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml
      14:18:27,221 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.LongUpdateLog -> JBPM_LOG
      14:18:27,221 [main] INFO Configuration : Reading mappings from resource: org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml
      14:18:27,236 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.StringUpdateLog -> JBPM_LOG
      14:18:27,236 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/TaskLog.hbm.xml
      14:18:27,252 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskLog -> JBPM_LOG
      14:18:27,268 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml
      14:18:27,299 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskCreateLog -> JBPM_LOG
      14:18:27,299 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml
      14:18:27,393 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskAssignLog -> JBPM_LOG
      14:18:27,393 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml
      14:18:27,408 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskEndLog -> JBPM_LOG
      14:18:27,408 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml
      14:18:27,424 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneLog -> JBPM_LOG
      14:18:27,424 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml
      14:18:27,455 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneCreateLog -> JBPM_LOG
      14:18:27,455 [main] INFO Configuration : Reading mappings from resource: org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml
      14:18:27,471 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneAssignLog -> JBPM_LOG
      14:18:27,487 [main] INFO Configuration : Configured SessionFactory: null
      14:18:27,487 [main] INFO Configuration : processing extends queue
      14:18:27,487 [main] INFO HbmBinder : Mapping subclass: org.jbpm.context.def.ContextDefinition -> JBPM_MODULEDEFINITION
      14:18:27,487 [main] INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.def.TaskMgmtDefinition -> JBPM_MODULEDEFINITION
      14:18:27,487 [main] INFO HbmBinder : Mapping subclass: org.jbpm.graph.action.Script -> JBPM_ACTION
      14:18:27,502 [main] INFO Configuration : processing collection mappings
      14:18:27,502 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.User.memberships -> JBPM_ID_MEMBERSHIP
      14:18:27,502 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.children -> JBPM_ID_GROUP
      14:18:27,502 [main] INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.memberships -> JBPM_ID_MEMBERSHIP
      14:18:27,502 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.events -> JBPM_EVENT
      14:18:27,502 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
      14:18:27,502 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.nodes -> JBPM_NODE
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.actions -> JBPM_ACTION
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ProcessDefinition.definitions -> JBPM_MODULEDEFINITION
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.events -> JBPM_EVENT
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.leavingTransitions -> JBPM_TRANSITION
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Node.arrivingTransitions -> JBPM_TRANSITION
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Transition.events -> JBPM_EVENT
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Transition.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.Event.actions -> JBPM_ACTION
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.SuperState.nodes -> JBPM_NODE
      14:18:27,518 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.def.ExceptionHandler.actions -> JBPM_ACTION
      14:18:27,533 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.ProcessState.variableAccesses -> JBPM_VARIABLEACCESS
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.node.TaskNode.tasks -> JBPM_TASK
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Swimlane.tasks -> JBPM_TASK
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Task.events -> JBPM_EVENT
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.Task.exceptionHandlers -> JBPM_EXCEPTIONHANDLER
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskController.variableAccesses -> JBPM_VARIABLEACCESS
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.file.def.FileDefinition.processFiles -> JBPM_BYTEARRAY
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.ProcessInstance.runtimeActions -> JBPM_RUNTIMEACTION
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.ProcessInstance.instances -> JBPM_MODULEINSTANCE
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.Token.children -> JBPM_TOKEN
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.exe.Token.comments -> JBPM_COMMENT
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.context.exe.ContextInstance.tokenVariableMaps -> JBPM_TOKENVARIABLEMAP
      14:18:27,549 [main] INFO HbmBinder : Mapping collection: org.jbpm.context.exe.TokenVariableMap.variableInstances -> JBPM_VARIABLEINSTANCE
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskMgmtInstance.swimlaneInstances -> JBPM_SWIMLANEINSTANCE
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances -> JBPM_TASKINSTANCE
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.variableInstances -> JBPM_VARIABLEINSTANCE
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.comments -> JBPM_COMMENT
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.SwimlaneInstance.pooledActors -> JBPM_POOLEDACTOR
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.logging.log.CompositeLog.children -> JBPM_LOG
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes -> JBPM_SWIMLANE
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks -> JBPM_TASK
      14:18:27,565 [main] INFO HbmBinder : Mapping collection: org.jbpm.graph.action.Script.variableAccesses -> JBPM_VARIABLEACCESS
      14:18:27,565 [main] INFO Configuration : processing association property references
      14:18:27,565 [main] INFO Configuration : processing foreign key constraints
      14:18:27,768 [main] INFO DriverManagerConnectionProvider : Using Hibernate built-in connection pool (not for production use!)
      14:18:27,768 [main] INFO DriverManagerConnectionProvider : Hibernate connection pool size: 20
      14:18:27,768 [main] INFO DriverManagerConnectionProvider : autocommit mode: false
      14:18:27,768 [main] INFO DriverManagerConnectionProvider : using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:mem:.;sql.enforce_strict_size=true
      14:18:27,768 [main] INFO DriverManagerConnectionProvider : connection properties: {user=sa, password=****}
      14:18:28,221 [main] INFO SettingsFactory : RDBMS: HSQL Database Engine, version: 1.8.0
      14:18:28,221 [main] INFO SettingsFactory : JDBC driver: HSQL Database Engine Driver, version: 1.8.0
      14:18:28,268 [main] INFO Dialect : Using dialect: org.hibernate.dialect.HSQLDialect
      14:18:28,284 [main] INFO TransactionFactoryFactory : Using default transaction strategy (direct JDBC transactions)
      14:18:28,284 [main] INFO TransactionManagerLookupFactory : No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
      14:18:28,284 [main] INFO SettingsFactory : Automatic flush during beforeCompletion(): disabled
      14:18:28,299 [main] INFO SettingsFactory : Automatic session close at end of transaction: disabled
      14:18:28,299 [main] INFO SettingsFactory : JDBC batch size: 15
      14:18:28,299 [main] INFO SettingsFactory : JDBC batch updates for versioned data: disabled
      14:18:28,299 [main] INFO SettingsFactory : Scrollable result sets: enabled
      14:18:28,299 [main] INFO SettingsFactory : JDBC3 getGeneratedKeys(): disabled
      14:18:28,299 [main] INFO SettingsFactory : Connection release mode: auto
      14:18:28,299 [main] INFO SettingsFactory : Default batch fetch size: 1
      14:18:28,299 [main] INFO SettingsFactory : Generate SQL with comments: disabled
      14:18:28,299 [main] INFO SettingsFactory : Order SQL updates by primary key: disabled
      14:18:28,299 [main] INFO SettingsFactory : Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      14:18:28,315 [main] INFO ASTQueryTranslatorFactory : Using ASTQueryTranslatorFactory
      14:18:28,315 [main] INFO SettingsFactory : Query language substitutions: {}
      14:18:28,315 [main] INFO SettingsFactory : Second-level cache: enabled
      14:18:28,315 [main] INFO SettingsFactory : Query cache: disabled
      14:18:28,315 [main] INFO SettingsFactory : Cache provider: org.hibernate.cache.EhCacheProvider
      14:18:28,331 [main] INFO SettingsFactory : Optimize cache for minimal puts: disabled
      14:18:28,331 [main] INFO SettingsFactory : Structured second-level cache entries: disabled
      14:18:28,346 [main] INFO SettingsFactory : Statistics: disabled
      14:18:28,346 [main] INFO SettingsFactory : Deleted entity synthetic identifier rollback: disabled
      14:18:28,346 [main] INFO SettingsFactory : Default entity-mode: pojo
      14:18:28,550 [main] INFO SessionFactoryImpl : building session factory
      14:18:29,003 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
      14:18:29,159 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
      14:18:29,394 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
      14:18:29,628 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
      14:18:29,722 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
      14:18:29,738 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
      14:18:30,128 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
      14:18:30,238 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
      14:18:30,457 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
      14:18:30,629 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
      14:18:30,894 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
      14:18:30,926 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
      14:18:30,926 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
      14:18:30,941 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
      14:18:30,957 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Event.actions]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.Task.events]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Node.events]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.SuperState.nodes]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
      14:18:30,972 [main] WARN EhCacheProvider : Could not find configuration [org.jbpm.graph.def.Transition.events]; using defaults.
      14:18:31,441 [main] INFO SessionFactoryObjectFactory : Not binding factory to JNDI, no JNDI name configured
      14:18:31,441 [main] INFO SessionFactoryImpl : Checking 25 named HQL queries
      14:18:31,973 [main] INFO SessionFactoryImpl : Checking 0 named SQL queries
      14:18:31,973 [main] DEBUG DbPersistenceService : creating hibernate session
      14:18:32,051 [main] DEBUG DbPersistenceService : beginning hibernate transaction
      14:18:32,114 [main] WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
      14:18:32,114 [main] ERROR JDBCExceptionReporter : Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
      org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2153)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
      at org.hibernate.loader.Loader.list(Loader.java:2024)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:745)
      at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:138)
      at MyPack.StartProcess.init(StartProcess.java:26)
      at MyPack.StartProcess.main(StartProcess.java:61)
      Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
      at org.hsqldb.jdbc.Util.throwError(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
      at org.hibernate.loader.Loader.doQuery(Loader.java:661)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2150)
      ... 11 more
      14:18:32,317 [main] ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not execute query
      14:18:32,317 [main] DEBUG JbpmContext : closing JbpmContext
      14:18:32,317 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@134eb84
      14:18:32,317 [main] DEBUG DbPersistenceService : committing hibernate transaction
      couldn't find process definition 'Initiator'
      org.jbpm.JbpmException: couldn't find process definition 'Initiator'
      at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:155)
      at MyPack.StartProcess.init(StartProcess.java:26)
      at MyPack.StartProcess.main(StartProcess.java:61)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2153)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
      at org.hibernate.loader.Loader.list(Loader.java:2024)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:745)
      at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:138)
      ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
      at org.hsqldb.jdbc.Util.throwError(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
      at org.hibernate.loader.Loader.doQuery(Loader.java:661)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2150)
      ... 11 more
      14:18:32,332 [main] DEBUG DbPersistenceService : closing hibernate session

        • 1. Re: Error in Process Definition Deployment.
          tansdale tan Newbie

          14:18:32,114 [main] ERROR JDBCExceptionReporter : Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
          org.hibernate.exception.SQLGrammarException: could not execute query

          i am no sure the reason of this error.
          But,the exception above show that, the jbpm couldn't find out the process definition called "Initiator".Be sure the process definition named "Initiator" had been deployed before.

          • 2. Re: Error in Process Definition Deployment.
            pganesh81 Newbie

            Ok. Fine. I tried the code below, where i defined the process in the code itself and tried to deploy it. But the error remains the same.
            Help me out in solving this problem.

            --------------------------------------------------------------------------------------

            package org.jbpm.tutorial.db;

            import java.util.List;

            import junit.framework.TestCase;

            import org.jbpm.JbpmConfiguration;
            import org.jbpm.JbpmContext;
            import org.jbpm.db.GraphSession;
            import org.jbpm.graph.def.ProcessDefinition;
            import org.jbpm.graph.exe.ProcessInstance;
            import org.jbpm.graph.exe.Token;

            public class CopyOfHelloWorldDbTest extends TestCase {

            static JbpmConfiguration jbpmConfiguration = null;

            static {

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


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


            " <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>"
            );
            }

            public void setUp() {
            jbpmConfiguration.createSchema();
            }

            public void tearDown() {
            jbpmConfiguration.dropSchema();
            }

            public void testSimplePersistence() {
            deployProcessDefinition();
            processInstanceIsCreatedWhenUserSubmitsWebappForm();
            theProcessInstanceContinuesWhenAnAsyncMessageIsReceived();
            }

            public void deployProcessDefinition() {
            ProcessDefinition processDefinition = ProcessDefinition.parseXmlString(
            "<process-definition name='MyProcess'>" +
            " <start-state name='start'>" +
            " " +
            " </start-state>" +
            " " +
            " " +
            " " +
            " <end-state name='end' />" +
            "</process-definition>"
            );

            JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
            try {
            System.out.println("Before Deploy------------------");
            jbpmContext.deployProcessDefinition(processDefinition);

            } finally {
            jbpmContext.close();
            }
            }

            public void processInstanceIsCreatedWhenUserSubmitsWebappForm() {
            JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
            try {

            GraphSession graphSession = jbpmContext.getGraphSession();

            ProcessDefinition processDefinition =
            graphSession.findLatestProcessDefinition("MyProcess");
            ProcessInstance processInstance =
            new ProcessInstance(processDefinition);

            Token token = processInstance.getRootToken();
            assertEquals("start", token.getNode().getName());
            token.signal();
            assertEquals("s", token.getNode().getName());

            jbpmContext.save(processInstance);

            } finally {
            jbpmContext.close();
            }
            }

            public void theProcessInstanceContinuesWhenAnAsyncMessageIsReceived() {

            JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
            try {

            GraphSession graphSession = jbpmContext.getGraphSession();
            ProcessDefinition processDefinition =
            graphSession.findLatestProcessDefinition("MyProcess");

            List processInstances =
            graphSession.findProcessInstances(processDefinition.getId());

            ProcessInstance processInstance =
            (ProcessInstance) processInstances.get(0);
            processInstance.signal();

            assertTrue(processInstance.hasEnded());

            jbpmContext.save(processInstance);

            } finally {
            jbpmContext.close();
            }
            }
            public static void main(String args[]){
            new CopyOfHelloWorldDbTest().testSimplePersistence();
            }
            }


            --------------------------------------------------------------------------------------
            The output in conole window shows the same error

            15:24:42,613 [main] INFO SessionFactoryObjectFactory : Not binding factory to JNDI, no JNDI name configured
            15:24:42,613 [main] INFO SessionFactoryImpl : Checking 25 named HQL queries
            15:24:43,238 [main] INFO SessionFactoryImpl : Checking 0 named SQL queries
            15:24:43,238 [main] DEBUG DbPersistenceService : creating hibernate session
            15:24:43,332 [main] DEBUG DbPersistenceService : beginning hibernate transaction
            15:24:43,848 [main] WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002
            15:24:43,863 [main] ERROR JDBCExceptionReporter : Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
            org.hibernate.exception.SQLGrammarException: could not execute query
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.doList(Loader.java:2153)
            at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
            at org.hibernate.loader.Loader.list(Loader.java:2024)
            at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
            at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300)
            at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146)
            at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093)
            at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
            at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:745)
            at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:138)
            at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:67)
            at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:166)
            at org.jbpm.tutorial.db.CopyOfHelloWorldDbTest.deployProcessDefinition(CopyOfHelloWorldDbTest.java:133)
            at org.jbpm.tutorial.db.CopyOfHelloWorldDbTest.testSimplePersistence(CopyOfHelloWorldDbTest.java:100)
            at org.jbpm.tutorial.db.CopyOfHelloWorldDbTest.main(CopyOfHelloWorldDbTest.java:228)
            Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
            at org.hsqldb.jdbc.Util.throwError(Unknown Source)
            at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
            at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
            at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
            at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
            at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
            at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
            at org.hibernate.loader.Loader.doQuery(Loader.java:661)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
            at org.hibernate.loader.Loader.doList(Loader.java:2150)
            ... 14 more
            15:24:44,066 [main] ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not execute query
            15:24:44,066 [main] DEBUG JbpmContext : closing JbpmContext
            15:24:44,066 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@3a0ab1
            15:24:44,066 [main] DEBUG DbPersistenceService : committing hibernate transaction
            15:24:44,066 [main] DEBUG DbPersistenceService : closing hibernate session
            org.jbpm.JbpmException: couldn't find process definition 'MyProcess'
            at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:155)
            at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:67)
            at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:166)
            at org.jbpm.tutorial.db.CopyOfHelloWorldDbTest.deployProcessDefinition(CopyOfHelloWorldDbTest.java:133)
            at org.jbpm.tutorial.db.CopyOfHelloWorldDbTest.testSimplePersistence(CopyOfHelloWorldDbTest.java:100)
            at org.jbpm.tutorial.db.CopyOfHelloWorldDbTest.main(CopyOfHelloWorldDbTest.java:228)
            Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.doList(Loader.java:2153)
            at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
            at org.hibernate.loader.Loader.list(Loader.java:2024)
            at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
            at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:300)
            at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:146)
            at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1093)
            at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
            at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:745)
            at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:138)
            ... 5 more
            Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_4_, processdef0_.NAME_ as NAME2_4_, processdef0_.VERSION_ as VERSION3_4_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_, processdef0_.STARTSTATE_ as STARTSTATE5_4_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
            at org.hsqldb.jdbc.Util.throwError(Unknown Source)
            at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
            at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
            at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
            at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
            at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
            at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
            at org.hibernate.loader.Loader.doQuery(Loader.java:661)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
            at org.hibernate.loader.Loader.doList(Loader.java:2150)
            ... 14 more

            • 3. Re: Error in Process Definition Deployment.
              Ronald van Kuijk Master

              Look at my post to your same question in another topic:

              http://www.jboss.com/index.html?module=bb&op=viewtopic&t=81449

              Please respond first before asking the same question again.