11 Replies Latest reply on Dec 3, 2012 6:24 AM by thomas.setiabudi

    Missing db\persistence.xml

    lauradp

      Hello everybody,

      I was trying to replace the H2 db with a mysql one, but I cannot find the any "persistence.xml"file in thr jbpm-installer folder. I'm following the tutorial at

      http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e597

       

      Can anyone help me?

        • 1. Re: Missing db\persistence.xml
          salaboy21

          Did you do a filesystem search? that's probably the simple way. In linux:

          find . |grep persistence.xml

          • 2. Re: Missing db\persistence.xml
            thomas.setiabudi

            Hi Laura Delli Paoli,

             

            I see you put your question in JBPM5.4 category, does it mean you use jbpm5.4 final full installer?

             

            if you are using JBPM5.4 full installer, there is no more db/persistence.xml file, it has been replaced and unfortunately the guide for jbpm5.4 is not updated yet

            http://docs.jboss.org/jbpm/v5.4/userguide/ch.installer.html#d0e609

            it still shows db/persistence.xml while actually that file does not exist in jbpm5.4 final full installer.

             

             

            I know you are trying to use MySQL Database, but maybe my explanation on setting SQL Server 2008 Database here https://community.jboss.org/wiki/SetUpJBPM54FinalInstallerToUseMSSQLServer2008UsingJTDS

             

            can be useful just for you to know which files needs to be updated as of JBPM5.4

             

             

            Regards,

            Thomas Setiabudi

            • 3. Re: Missing db\persistence.xml
              lauradp

              Thanks,

              I'll use your instruction

              • 4. Re: Missing db\persistence.xml
                lauradp

                Hi Thomas,

                I followed your tutorial and when I start my service I get this error:

                 

                JBAS014775:    New missing/unsatisfied dependencies:

                      service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/jbpmDS]

                 

                How can I fix it?

                 

                Laura

                • 5. Re: Missing db\persistence.xml
                  thomas.setiabudi

                  Have you copied the jdbc jar?

                   

                  What is your standalone.xml looks like? especially in <datasources> and <drivers>

                   

                   

                  Regards,

                  Thomas Setiabudi

                  • 6. Re: Missing db\persistence.xml
                    lauradp

                    Thanks for your answer.

                     

                    I copied both jdbc.jar and module.xml in jboss-as-7.1.1.Final\modules\MySQL\jdbc\main folder.

                     

                    This is my datasources configuration:

                     

                    <subsystem xmlns="urn:jboss:domain:datasources:1.0">

                                <datasources>

                                    <datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" use-java-context="true">

                                        <connection-url>jdbc:mysql://10.21.101.175:3306/jbpm5</connection-url>

                                        <driver>mysql</driver>

                                        <security>

                                            <user-name>jbpm5</user-name>

                                            <password>jbpm5</password>

                                        </security>

                                    </datasource>

                                    <drivers>

                                        <driver name="mysql" module="MySQL.jdbc">

                                            <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

                                        </driver>

                     

                                    </drivers>

                                </datasources>

                            </subsystem>

                    • 7. Re: Missing db\persistence.xml
                      thomas.setiabudi

                      I never used mysql before, but by looking at this guide here

                      http://docs.jboss.org/jbpm/v5.4/userguide/ch.installer.html#d0e609

                       

                      Isn't the <drivers> part should be like this:

                       

                      <drivers>
                                          <driver name="mysql" module="com.mysql">
                                              <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
                                          </driver>
                                      </drivers>

                       

                      Regards,

                      Thomas Setiabudi

                      • 8. Re: Missing db\persistence.xml
                        lauradp

                        I  thought

                        module="MySQL.jdbc">

                        should represent the modulees subfolder

                        • 9. Re: Missing db\persistence.xml
                          thomas.setiabudi

                          hmm..

                           

                          then how about your jbpm-installer\db\mysql_module.xml file?

                          is it like this?

                          <module xmlns="urn:jboss:module:1.0" name="com.mysql">
                             <resources>
                               <resource-root path="mysql-connector-java.jar"/>
                             </resources>

                             <dependencies>
                                <module name="javax.api"/>
                                <module name="javax.transaction.api"/>
                              </dependencies>
                          </module>

                           

                          or is it

                           

                          <module xmlns="urn:jboss:module:1.0" name="MySQL.jdbc">
                             <resources>
                               <resource-root path="mysql-connector-java.jar"/>
                             </resources>

                             <dependencies>
                                <module name="javax.api"/>
                                <module name="javax.transaction.api"/>
                              </dependencies>
                          </module>

                           

                           

                           

                          you are using mysql-connector-java.jar right?

                          • 10. Re: Missing db\persistence.xml
                            lauradp

                            mmmm I think there's a problem:

                            My jbpm-installer\db\mysql_module.xml looks like this: <module xmlns="urn:jboss:module:1.0" name="MySQL.jdbc">.....

                            but the installer places my connector under com/...

                             

                            I'll try to run again the installation using module xmlns="urn:jboss:module:1.0" name="com.mysql">

                            • 11. Re: Missing db\persistence.xml
                              thomas.setiabudi

                              I think the problem is in the

                               

                              jbpm-installer\build.properties

                               

                              look at this property (default value)

                               

                              db.driver.module.prefix=com/mysql

                               

                               

                              this value determine the folder that will be created on the JBOSS AS module.