5 Replies Latest reply on Aug 9, 2006 3:00 AM by Claus Wittmann

    jBPM BPEL change DB - HowTo?

    Claus Wittmann Newbie

      Hi there!

      I have installed the jBPM BPEL beta1 (and also downloaded the CVS - but so it is clearer which version I'm running)

      I'm using
      * Eclipse 3.1.2F
      * JBOSS 4.0.4GA
      * jBPM 3.1.1 (included)
      * jBPM BPEL beta 1
      * MySQL 5.0

      I want to change the standard Database connection from Hybersonic-in-Jboss-Database (which I cannot verify and handle from outside) to a MySQL Database.
      I tried different settings and found also some posts (like this: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=74798)
      but It won't work.

      Can someone give me a HowTo configure my Database connection to MySQL?

      If someone could help me - this would be great!
      Thanks in advance!



        • 1. Re: jBPM BPEL change DB - HowTo?
          Claus Wittmann Newbie

          P.S. Also MSSQL would be possible... Everything is available :-)

          • 2. Re: jBPM BPEL change DB - HowTo?
            Roy Forever Newbie

            Hi Claus,

            Thanks for trying my previous post. May be my previous post is not well organized. However, I make a updated version for MySQL. In facts, I haven't been used MSSQL.

            My Configure:
            - jbpm-bpel-1.1-beta1
            - jboss-4.0.4.GA
            - mysql-5.0.21
            - mysql-connector-java-5.0.0-beta

            1. Edit JBPM_HOME\build.properties


            2. Edit JBPM_HOME\src\resources\jbpm-bpel.sar\hibernate.properties
            hibernate.query.substitutions=true 1, false 0

            - Datasource name is case sentience
            - doankhoavy talk about use "create" rather than "update"

            3. Edit JBPM_HOME\src\resources\jbpm-bpel.sar\jbpm-bpel-ds.xml
            <?xml version="1.0" encoding="UTF-8"?>
             <track-statements />

            4. Execute command
            CD JBPM_HOME
            ANT build.service.404

            5. Copy JBPM_HOME\build\jbpm-bpel.sar to JBOSS\service\default\deploy
            - Place into your server instead of default server

            6. Copy MySQL Driver into JBOSS\service\default\lib
            - Place into your server instead of default server

            7. Before start JBoss:
            - Please confirm that your MySQL is running
            - The database is existing in your MySQL
            - The user is able to access the database

            8. Start your JBoss

            Wish it is helpful for you and I am welcome for point out my mistake.


            • 3. Re: jBPM BPEL change DB - HowTo?
              Alejandro Guizar Master

              Excellent guide! I can only add that, if you don't want automatic database schema creation (as is most often the case in a production environment) you should remove this line from your hibernate.properties:


              Instead, execute the following commands after you deploy jbpm-bpel.sar:
              cd JBPM_HOME/doc/examples
              ant create-schema


              • 5. Re: jBPM BPEL change DB - HowTo?
                Claus Wittmann Newbie

                More by accident I found this docu here.
                I think it has anything we need to change DBs.
                The first link contains the needed links to other DBs.
                Have fun!


                This seems to be the original docu: