[jboss-user] [JBoss jBPM] - Re: MYSQL + JBOSS JBPM 3.2 --> do NOT work together .. hel

[vperez]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4079260#4079260

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4079260