1 Reply Latest reply on Sep 13, 2013 9:51 AM by ashpcs

    JBPM standalone DB script requirements

    ayusman_dikshit
    ayusman_dikshit Sep 11, 2013 9:50 AM

      From my understanding of the JBPM 5.4 user guide, I see the following:

       

      3.7.3 Quick start: (From Chapter 3. Installer) states

       

      The following 4 files define the persistence settings for the jbpm-installer demo:
      1. db/persistence.xml
      2. task-service/resources/META-INF/persistence.xml
      3. db/jBPM-ds.xml If you're using the JBoss AS 5 server
      4. standalone.xml If you're using the JBoss AS 7 server

       

       

      Since I am trying to use a local standalone installation; I should need only the first 2 files:

       

      db/persistence.xml

      and

      task-service/resources/META-INF/persistence.xml

       

      Let's say my JBPM full installer unzipped location is <JBPM_FULL>(D:\Test\jbpm-5.4.0.Final-installer-full).

       

      D:\Test\jbpm-5.4.0.Final-installer-full\db has files:
      driver
      jBPM-ds.xml
      jbpm-persistence-JPA1.xml
      jbpm-persistence-JPA2.xml
      mysql_module.xml
      ProcessInstanceInfo.hbm.xml
      ProcessInstanceInfoMapping.xml
      task-persistence-JPA1.xml
      task-persistence-JPA2.xml
      Taskorm-JPA2.xml

       

      And the location: D:\Test\jbpm-5.4.0.Final-installer-full\task-service\resources\META-INF has files:

       

      persistence.xml

       

      Questions:

       

      1. I don't see this "db/persistence.xml"; which one should I use instead?

      2. Is there a clear detail on how to create a database schema, tables and all related DB structures for a JBPM 5.4 application?

      3. How do I use these persistence files in a standalone application? Should I just add these to my class path and JBPM will automatically create the tables necessary. Of course I would have changed the persistence files with the correct DB details.


      Any help will be appreciated.

      Thanks,

      Ayusman