[jboss-user] [jBPM] - Re: Changing from H2 database to MSQL database

[tmmaluleke]

tmmaluleke [https://community.jboss.org/people/tmmaluleke] created the discussion

"Re: Changing from H2 database to MSQL database"

To view the discussion, visit: https://community.jboss.org/message/766226#766226

--------------------------------------------------------------
Hello gvino,

This is what I did: I downloaded mysql-connector( mysql-connector-java-5.1.18) then copied the jar file to the jbpm-installer\db\driver\mysql-connector-java-5.1.18-bin.jar,
then after installing the ant.install.db there will be mysql folder in C:\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main then you edit the module.xml

<module xmlns="urn:jboss:module:1.0" name="com.mysql">
  <resources>
    <resource-root path="mysql-connector-java-5.1.18-bin.jar"/>
        <!-- Insert resources here -->
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>

After you run your database and ant start.demo it won't start the H2 coz you have edited all the xml files to mysqlDialect and the drivers. Please update me after doing this what happen.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/766226#766226]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20121017/ce9ed3c5/attachment.html