1 Reply Latest reply on Jun 24, 2009 8:42 AM by Michael Wohlfart

    How to configure jBPM on seam-gen application, using mysql db

    Chris Lambert Newbie

      Hi


      I'm deploying my first seam application created by seam-gen with mysql. I'm trying to use jbpm module, actually everything looks works fine for me, with one exception - when Application Server going to shutdown, all the previously created jbpm processes are lost.
      I want to do this way, that jbpm-data stored in database can be loaded again automatically after AS restarts.


      Is there any option to achieve this functionality?


      regards
      Chris


      Jboss AS 4.2.3 , seam 2.1.2. mysql 5.0.37, mysqlconnector 1.5.7




      <hibernate-configuration>
        <session-factory>
      
         <!-- hibernate dialect -->
          <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
      
          <!-- JDBC connection properties (begin) -->
          <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
          <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/baza</property>
          <property name="hibernate.connection.username">root</property>
          <property name="hibernate.connection.password"></property>
          <property name="hibernate.query.substitutions">true 1, false 0</property>
          
          
           <property name="show_sql">true</property>
      <!--     <property name="connection.datasource">bazaDatasource</property>-->
          <property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
          <property name="transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
          <property name="cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
          <property name="hbm2ddl.auto">create</property>
          
          
          <!-- JDBC connection properties (end) -->
          <!--property name="transaction.flush_before_completion">true</property-->
          
          <!-- ############################################ -->
          <!-- # 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.action mapping files -->
          <mapping resource="org/jbpm/graph/action/MailAction.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/MailNode.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"/>
          
        </session-factory>
      </hibernate-configuration>




      <jbpm-configuration>
      
        <jbpm-context>
          <service name="persistence">
             <factory>
                <bean class="org.jbpm.persistence.db.DbPersistenceServiceFactory">
                   <field name="isTransactionEnabled"><false/></field>
                </bean>
             </factory>
          </service>
          <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>
      
      </jbpm-configuration>