8 Replies Latest reply on Jun 27, 2008 10:28 AM by btl_ayd

    calling process from the database of JBPM

      Hi
      I want o call websale process that deploying on he server of jpm database.
      I found some code about it on this forums.But when execute this code the error has been occured.
      here is code for starting process:

      public static void startProcessDefinition() {
       String processDefinitionName = new String("websale");
       JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance();
       JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
       try {
       GraphSession graphSession = jbpmContext.getGraphSession();
       ProcessDefinition definition = graphSession.findLatestProcessDefinition(processDefinitionName);
       ProcessInstance instance = definition.createProcessInstance();
       instance.signal();
       jbpmContext.save(instance);
       } finally {
       jbpmContext.close();
       }
       }
      


      error has beeb occured
      org.hibernate.exception.SQLGrammarException: could not execute query
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.Loader.doList(Loader.java:2223)
       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
       at org.hibernate.loader.Loader.list(Loader.java:2099)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
       at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
       at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
       at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
       at uzak.startProcessDefinition(uzak.java:24)
       at uzak.main(uzak.java:34)
      Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ 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.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
       at org.hibernate.loader.Loader.doQuery(Loader.java:673)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
       at org.hibernate.loader.Loader.doList(Loader.java:2220)
       ... 11 more
      09:58:31,439 [main] ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not execute query
      09:58:31,439 [main] DEBUG JbpmContext : closing JbpmContext
      09:58:31,439 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@98bbf6
      09:58:31,439 [main] DEBUG DbPersistenceService : committing hibernate transaction org.hibernate.transaction.JDBCTransaction@1c6a99d
      09:58:31,439 [main] DEBUG DbPersistenceService : closing hibernate session
      09:58:31,439 [main] DEBUG Services : closing service 'tx': org.jbpm.tx.TxService@1aa0e3b
      Exception in thread "main" org.jbpm.JbpmException: couldn't find process definition 'websale'
       at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:170)
       at uzak.startProcessDefinition(uzak.java:24)
       at uzak.main(uzak.java:34)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.Loader.doList(Loader.java:2223)
       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
       at org.hibernate.loader.Loader.list(Loader.java:2099)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
       at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
       at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
       at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
       ... 2 more
      Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ 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.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
       at org.hibernate.loader.Loader.doQuery(Loader.java:673)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
       at org.hibernate.loader.Loader.doList(Loader.java:2220)
       ... 11 more
      

      the websale process is in the jbpm database server.What is the problem can anyboyd help me?

        • 1. Re: calling process from the database of JBPM
          soumya_in

          Stop your server and Start running it.
          If it works I will tell you the reason later.

          • 2. Re: calling process from the database of JBPM
            soumya_in

            Make sure that before running the process should be deployed.

            • 3. Re: calling process from the database of JBPM

              Hi I treid it but it didnt work.I want to start this process in java class.
              I changed "JbpmConfiguration jbpmConfiguration =JbpmConfiguration.getInstance(); " as a "JbpmConfiguration jbpmConfiguration =JbpmConfiguration.parseResource("jbpm.cfg.xml");"
              and here is my all code that calling process:


              public static void startProcessDefinition() {
               String processDefinitionName = new String("websale");
               JbpmConfiguration jbpmConfiguration =JbpmConfiguration.parseResource("jbpm.cfg.xml");
              
               JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
               try {
               GraphSession graphSession = jbpmContext.getGraphSession();
               ProcessDefinition definition = graphSession.findLatestProcessDefinition(processDefinitionName);
               System.out.println(graphSession.getProcessDefinition(2));
               ProcessInstance instance = definition.createProcessInstance();
               instance.signal();
              
               jbpmContext.save(instance);
               } finally {
               jbpmContext.close();
               }
               }
               public static void main(String[] args) {
              
               uzak.startProcessDefinition();
               }
              


              here is error has been occured

              15:37:12,229 [main] ERROR JDBCExceptionReporter : Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ 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:67)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.loader.Loader.doList(Loader.java:2223)
               at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
               at org.hibernate.loader.Loader.list(Loader.java:2099)
               at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
               at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
               at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
               at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
               at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
               at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
               at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
               at uzak.startProcessDefinition(uzak.java:28)
               at uzak.main(uzak.java:40)
              Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ 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.<init>(Unknown Source)
               at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
               at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
               at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
               at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
               at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
               at org.hibernate.loader.Loader.doQuery(Loader.java:673)
               at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
               at org.hibernate.loader.Loader.doList(Loader.java:2220)
               ... 11 more
              Exception in thread "main" org.jbpm.JbpmException: couldn't find process definition 'websale'
               at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:170)
               at uzak.startProcessDefinition(uzak.java:28)
               at uzak.main(uzak.java:40)
              Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.loader.Loader.doList(Loader.java:2223)15:37:12,430 [main] ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not execute query
              15:37:12,430 [main] DEBUG JbpmContext : closing JbpmContext
              15:37:12,430 [main] DEBUG Services : closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@98bbf6
              15:37:12,430 [main] DEBUG DbPersistenceService : committing hibernate transaction org.hibernate.transaction.JDBCTransaction@1c6a99d
              15:37:12,430 [main] DEBUG DbPersistenceService : closing hibernate session
              15:37:12,430 [main] DEBUG Services : closing service 'tx': org.jbpm.tx.TxService@1aa0e3b
              
               at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
               at org.hibernate.loader.Loader.list(Loader.java:2099)
               at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
               at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
               at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
               at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
               at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
               at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
               at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
               ... 2 more
              Caused by: java.sql.SQLException: Table not found in statement [select top ? processdef0_.ID_ as ID1_0_, processdef0_.NAME_ as NAME3_0_, processdef0_.DESCRIPTION_ as DESCRIPT4_0_, processdef0_.VERSION_ as VERSION5_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_0_, processdef0_.STARTSTATE_ as STARTSTATE7_0_ 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.<init>(Unknown Source)
               at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
               at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
               at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
               at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
               at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
               at org.hibernate.loader.Loader.doQuery(Loader.java:673)
               at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
               at org.hibernate.loader.Loader.doList(Loader.java:2220)
               ... 11 more
              

              here is my jbpm.cfg.xml:

              <jbpm-configuration>
              
               <!--
               This configuration is used when there is no jbpm.cfg.xml file found in the
               root of the classpath. It is a very basic configuration without persistence
               and message services. Only the authorization service installed.
               You can parse and create processes, but when you try to use one of the
               unavailable services, you'll get an exception.
               -->
              
               <jbpm-context>
               <service name="persistence" factory="org.jbpm.persistence.db.DbPersistenceServiceFactory" />
               <service name="tx" factory="org.jbpm.tx.TxServiceFactory" />
               <service name="message" factory="org.jbpm.msg.db.DbMessageServiceFactory" />
               <service name="scheduler" factory="org.jbpm.scheduler.db.DbSchedulerServiceFactory" />
               <service name="logging" factory="org.jbpm.logging.db.DbLoggingServiceFactory" />
               <service name="authentication" factory="org.jbpm.security.authentication.DefaultAuthenticationServiceFactory" />
               </jbpm-context>
              
               <!-- configuration property used by persistence service impl org.jbpm.persistence.db.DbPersistenceServiceFactory -->
               <string name="resource.hibernate.cfg.xml" value="hibernate.cfg.xml" />
              
               <!-- configuration resource files pointing to default configuration files in jbpm-{version}.jar -->
               <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.parsers" value="org/jbpm/jpdl/par/jbpm.parsers.xml" />
               <string name="resource.varmapping" value="org/jbpm/context/exe/jbpm.varmapping.xml" />
               <string name="resource.mail.templates" value="jbpm.mail.templates.xml" />
              
               <int name="jbpm.byte.block.size" value="1024" singleton="true" />
               <string name="jbpm.mail.smtp.host" value="localhost" />
               <bean name="jbpm.task.instance.factory" class="org.jbpm.taskmgmt.impl.DefaultTaskInstanceFactoryImpl" singleton="true" />
               <!-- bean name="jbpm.task.instance.factory" class="org.jbpm.taskinstance.CustomTaskInstanceFactoryImpl" singleton="true" /-->
               <bean name="jbpm.variable.resolver" class="org.jbpm.jpdl.el.impl.JbpmVariableResolver" singleton="true" />
               <bean name="jbpm.mail.address.resolver" class="org.jbpm.identity.mail.IdentityAddressResolver" singleton="true" />
              
               <bean name="jbpm.job.executor" class="org.jbpm.job.executor.JobExecutor">
               <field name="jbpmConfiguration"><ref bean="jbpmConfiguration" /></field>
               <field name="name"><string value="JbpmJobExector" /></field>
               <field name="nbrOfThreads"><int value="1" /></field>
               <field name="idleInterval"><int value="2500" /></field>
               <field name="maxIdleInterval"><int value="3600000" /></field>
               <field name="historyMaxSize"><int value="20" /></field>
               </bean>
              
              </jbpm-configuration>
              

              What is wrong can you help me?
              Thx.

              • 4. Re: calling process from the database of JBPM
                soumya_in

                give me your hibernate.cfg.xml file conf

                • 5. Re: calling process from the database of JBPM
                  soumya_in

                  Also the JBPM version ur using...

                  • 6. Re: calling process from the database of JBPM

                    I use JBPM 3.2.1
                    and here is my hibernate.cfg.xml:

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


                    • 7. Re: calling process from the database of JBPM
                      soumya_in

                      Everything looks fine.
                      Do one thing.
                      1)Replace your existing deployed websale process from console.
                      2)Redeploy the process freshly once again
                      3)Stop your JBoss server
                      4)Use default.jbpm.cfg.xml instead of jbpm.cfg.xml
                      4)Start your application(client application)


                      • 8. Re: calling process from the database of JBPM

                        I tried everything you wrote but it doesnt work :(