<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">

<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>

                                <td>

                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>

                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px;  -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
    Re: Changing from H2 database to MSQL database
</h3>
<span style="margin-bottom: 10px;">
    created by <a href="https://community.jboss.org/people/tmmaluleke">tmmaluleke</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/766226#766226">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">

<div class="jive-rendered-content"><p>Hello gvino,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>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,</p><p>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</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>&lt;module xmlns="urn:jboss:module:1.0" name="com.mysql"&gt;</p><p>&#160; &lt;resources&gt;</p><p>&#160;&#160;&#160; &lt;resource-root path="mysql-connector-java-5.1.18-bin.jar"/&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;!-- Insert resources here --&gt;</p><p>&#160; &lt;/resources&gt;</p><p>&#160; &lt;dependencies&gt;</p><p>&#160;&#160;&#160; &lt;module name="javax.api"/&gt;</p><p>&#160;&#160;&#160; &lt;module name="javax.transaction.api"/&gt;</p><p>&#160; &lt;/dependencies&gt;</p><p>&lt;/module&gt;</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>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. </p></div>

<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
    <p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/766226#766226">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
                        </tr>
                    </tbody>
                </table>


                </td>
            </tr>
        </tbody>
    </table>

</div>

</body>
</html>