Configuring Workflow for MySQL

You need to make some configuration changes, if you have installed Sun GlassFish Web Space Server on MySQL database. If you are installing the Web Space Server evaluation bundle, no changes are required, as the workflow is configured for HSQL by default.

To Configure Workflow for MySQL

1. Copy the saw-impl-jbpm.jar file from <Web Space Server install dir>\glassfish2\domains\domain1\applications\j2ee-modules\saw-web\WEB-INF\lib.

2. Paste the saw-impl-jbpm.jar file to a temp folder.

3. Extract the saw-impl-jbpm.jar file.

   unjar saw-impl-jbpm.jar

4. Remove the commenting for the following section in the hibernate-cfg.xml file and change the appropriate values to point to the MySQL database.

   <!-- JDBC connection properties (begin) -->
       <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/lportal</property>
       <property name="hibernate.connection.username">lportal</property>
       <property name="hibernate.connection.password">lportal</property>
       <!-- JDBC connection properties (end) -->

5. jar the saw-impl-jbpm.jar file again.

6. Create a directory structure sources/saw-web-5.2.0.1/WEB-INF/lib/ under <root-dir>/webspace-for-gfv2/var/webspace/war-workspace, and paste the saw-impl-jbpm.jar file into it.

7. Change directory to <root-dir>/webspace-for-gfv2/var/webspace/war-workspace.

   cd <root-dir>/webspace-for-gfv2/var/webspace/war-workspace

8. Run ant -f synchronize.xml for saw-web-5.2.0.1.

9. Restart GlassFish server.