2 Replies Latest reply on Aug 29, 2007 12:19 PM by Victoria Perez

    MYSQL + JBOSS  JBPM 3.2 --> do NOT work together .. help pl

    Victoria Perez Newbie

      Hello

      my trainng to change jbpm.3.2 suite to mysql. But it doesnt work!
      in the manual (http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html) say things than i cant do in this version.

      please help!, what i should do??

      sorry my english is terrible.
      thanks Victoria

        • 1. Re:  MYSQL + JBOSS  JBPM 3.2 --> do NOT work together .. hel
          Ronald van Kuijk Master

          first be specific which errors you get. A 'it does not work' is not detailed enough for us to help you. I'm sure you can understand that. Then read the wiki a little... and search the forum (e.g. with google) for the same errors.

          If it does not help, please post what you DID find and why it was not related or did not help. Post detailed errors and then we might be able to help

          • 2. Re:  MYSQL + JBOSS  JBPM 3.2 --> do NOT work together .. hel
            Victoria Perez Newbie

            i am using this version -> jbpm-jpdl-suite-3.2.1.zip
            first i used this -> http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html
            but some of these files don´t exist in this version (3.2.1).

            so i was searching in the wiki and de forum, and i found this articuls:
            ---> http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource
            ---> http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS
            ---> http://www.jboss.com/index.html?module=bb&op=viewtopic&t=116029

            i tried doing this :

            1. Install the MySQL JDBC driver (mysql-connector-java-3.1.14-bin.jar) in the $JBOSS_HOME/server/default/lib directory.

            2. Delete $JBOSS_HOME/server/default/deploy/hsqldb-ds.xml.

            3. Copy $JBOSS_HOME/docs/examples/jca/mysql-ds.xml to $JBOSS_HOME/server/default/deploy. Modify the <local-tx-datasource> element with your MySQL connection settings:
            <connection-url>jdbc:mysql://your-hostname:your-port/your-database-name</connection-url>
            <driver-class>com.mysql.jdbc.Driver</driver-class>
            <user-name>your-user</user-name>
            your-pass

            4. In $JBOSS_HOME/server/default/conf/standardjaws.xml change the <type-mapping> element:
            <type-mapping>mySQL</type-mapping>

            5. In standardjbosscmp-jdbc.xml change the following, not necessarily contiguous, elements:
            java:/DefaultDS
            <datasource-mapping>mySQL</datasource-mapping>
            <fk-constraint>true</fk-constraint>

            6. Add the following within the element of login-config.xml:
            <application-policy name = "MySqlDbRealm?">

            <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule?" flag = "required">
            <module-option name = "principal">your-user</module-option>
            <module-option name = "userName">your-user</module-option>
            <module-option name ="password">your-pass</module-option>
            <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM?,name=DefaultDS</module-option>
            </login-module>

            </application-policy>

            7. Replace file $JBOSS_HOME/server/default/deploy/jms/hsql-jdbc2-service.xml by file $JBOSS_HOME/docs/examples/jms/mysql-jdbc2-service.xml

            8. Change MySqlDS? to DefaultDS in $JBOSS_HOME/server/default/deploy/jms/mysql-jdbc2-service.xml:

            <depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS
            ...

            9. Rename hsqldb-jdbc-state-service.xml to mysql-jdbc-state-service.xml.


            i was following these steps below. But its still no working, i cannot login in the console (localhost:8080/jbpm-console) and i was trying to deploy a process without success

            which definition database i should use???
            I would apreciate if you could help me with these issue
            regards, Victoria