<!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: Error - Table 'jbpm5.task' doesn't exist after trying to set mysql db
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/shamalk">Shamal Karunarathne</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/743831#743831">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>As mentioned in the guide, I changed 3 files. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here's my db/persistence.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code">Shamals-MacBook-Air:jbpm-installer shamalk$ cat db/persistence.xml <?xml version="1.0" encoding="UTF-8" standalone="yes"?><persistence version="1.0"             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence                                 http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd                                 http://java.sun.com/xml/ns/persistence/orm                                  http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"             xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"             xmlns="http://java.sun.com/xml/ns/persistence">  <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA">    <provider>org.hibernate.ejb.HibernatePersistence</provider>    <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source>           <mapping-file>META-INF/JBPMorm.xml</mapping-file>    <mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file>    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>    <class>org.drools.persistence.info.SessionInfo</class>    <class>org.drools.persistence.info.WorkItemInfo</class>    <class>org.jbpm.process.audit.ProcessInstanceLog</class>    <class>org.jbpm.process.audit.NodeInstanceLog</class>    <class>org.jbpm.process.audit.VariableInstanceLog</class>    <properties>      <!-- <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/> -->      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>      <property name="hibernate.max_fetch_depth" value="3"/>      <!-- hbm2ddl.auto MUST BE update! The console will otherwise overwrite the schema with each new thread -->      <property name="hibernate.hbm2ddl.auto" value="update" />      <property name="hibernate.show_sql" value="false" />      <!-- for AS7 -->      <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" />      <!-- for AS5 -->      <!-- <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /> -->    </properties>          </persistence-unit>    </persistence>Shamals-MacBook-Air:jbpm-installer shamalk$ </code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here's my task-service/resources/META-INF/persistence.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code">
Shamals-MacBook-Air:jbpm-installer shamalk$ cat task-service/resources/META-INF/persistence.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<persistence version="1.0"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
                                 http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
                                 http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
             xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xmlns="http://java.sun.com/xml/ns/persistence">
  <persistence-unit name="org.jbpm.task">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <mapping-file>META-INF/Taskorm.xml</mapping-file>
    <class>org.jbpm.task.Attachment</class>
    <class>org.jbpm.task.Content</class>
    <class>org.jbpm.task.BooleanExpression</class>
    <class>org.jbpm.task.Comment</class>
    <class>org.jbpm.task.Deadline</class>
    <class>org.jbpm.task.Comment</class>
    <class>org.jbpm.task.Deadline</class>
    <class>org.jbpm.task.Delegation</class>
    <class>org.jbpm.task.Escalation</class>
    <class>org.jbpm.task.Group</class>
    <class>org.jbpm.task.I18NText</class>
    <class>org.jbpm.task.Notification</class>
    <class>org.jbpm.task.EmailNotification</class>
    <class>org.jbpm.task.EmailNotificationHeader</class>
    <class>org.jbpm.task.PeopleAssignments</class>
    <class>org.jbpm.task.Reassignment</class>
    <class>org.jbpm.task.Status</class>
    <class>org.jbpm.task.Task</class>
    <class>org.jbpm.task.TaskData</class>
    <class>org.jbpm.task.SubTasksStrategy</class>
    <class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class>
    <class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class>
    <class>org.jbpm.task.User</class>
    <properties>
      <!--<property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
      <property name="hibernate.connection.driver_class" value="org.h2.Driver"/>
      <property name="hibernate.connection.url" value="jdbc:h2:tcp://localhost/runtime/task" />
      <property name="hibernate.connection.username" value="sa"/>
      <property name="hibernate.connection.password" value=""/> -->
      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
      <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
      <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/task" />
      <property name="hibernate.connection.username" value="task"/>
      <property name="hibernate.connection.password" value="task"/>
      <property name="hibernate.connection.autocommit" value="false" />
      <property name="hibernate.max_fetch_depth" value="3"/>
      <property name="hibernate.hbm2ddl.auto" value="create" />
      <property name="hibernate.show_sql" value="false" />
    </properties>
  </persistence-unit>
</persistence>
Shamals-MacBook-Air:jbpm-installer shamalk$ </code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And here's my standalone.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code">Shamals-MacBook-Air:jbpm-installer shamalk$ cat standalone.xml <!--  ~ JBoss, Home of Professional Open Source.  ~ Copyright 2011, Red Hat, Inc., and individual contributors  ~ as indicated by the @author tags. See the copyright.txt file in the  ~ distribution for a full listing of individual contributors.  ~  ~ This is free software; you can redistribute it and/or modify it  ~ under the terms of the GNU Lesser General Public License as  ~ published by the Free Software Foundation; either version 2.1 of  ~ the License, or (at your option) any later version.  ~  ~ This software is distributed in the hope that it will be useful,  ~ but WITHOUT ANY WARRANTY; without even the implied warranty of  ~ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU  ~ Lesser General Public License for more details.  ~  ~ You should have received a copy of the GNU Lesser General Public  ~ License along with this software; if not, write to the Free  ~ Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  ~ 02110-1301 USA, or see the FSF site: http://www.fsf.org.  --><server xmlns="urn:jboss:domain:1.0">    <extensions>        <extension module="org.jboss.as.clustering.infinispan"/>        <extension module="org.jboss.as.connector"/>        <extension module="org.jboss.as.deployment-scanner"/>        <extension module="org.jboss.as.ee"/>        <extension module="org.jboss.as.ejb3"/>        <extension module="org.jboss.as.jaxrs"/>        <extension module="org.jboss.as.jmx"/>        <!--extension module="org.jboss.as.jpa"/-->        <extension module="org.jboss.as.logging"/>        <extension module="org.jboss.as.naming"/>        <extension module="org.jboss.as.osgi"/>        <extension module="org.jboss.as.pojo"/>        <extension module="org.jboss.as.remoting"/>        <extension module="org.jboss.as.sar"/>        <extension module="org.jboss.as.security"/>        <extension module="org.jboss.as.threads"/>        <extension module="org.jboss.as.transactions"/>        <extension module="org.jboss.as.web" />        <extension module="org.jboss.as.weld" />    </extensions>    <management>              <security-realms>                        <security-realm name="PropertiesMgmtSecurityRealm">                                  <authentication>                                            <properties path="mgmt-users.properties" relative-to="jboss.server.config.dir" />                                  </authentication>                        </security-realm>              </security-realms>        <management-interfaces>           <native-interface interface="management" port="9999" />           <http-interface interface="management" port="9990"/>        </management-interfaces>    </management>    <profile>        <subsystem xmlns="urn:jboss:domain:logging:1.1">            <console-handler name="CONSOLE">                <level name="INFO"/>                <formatter>                    <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>                </formatter>            </console-handler>            <periodic-rotating-file-handler name="FILE">                <level name="INFO"/>                <formatter>                    <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>                </formatter>                <file relative-to="jboss.server.log.dir" path="server.log"/>                <suffix value=".yyyy-MM-dd"/>            </periodic-rotating-file-handler>            <logger category="org.jboss.modules">                <level name="INFO"/>            </logger>            <logger category="org.jboss.vfs.util">                <level name="INFO"/>            </logger>            <logger category="org.jboss.weld">                <level name="INFO"/>            </logger>                        <logger category="com.arjuna">                <level name="WARN"/>            </logger>            <logger category="org.apache.tomcat.util.modeler">                <level name="WARN"/>            </logger>            <logger category="sun.rmi">                <level name="WARN"/>            </logger>            <root-logger>                <level name="INFO"/>                <handlers>                    <handler name="CONSOLE"/>                    <handler name="FILE"/>                </handlers>            </root-logger>        </subsystem>        <subsystem xmlns="urn:jboss:domain:datasources:1.0">            <datasources>                <datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true">                    <!-- <connection-url>jdbc:h2:tcp://localhost/runtime/jbpm</connection-url> -->                    <connection-url>jdbc:mysql://localhost:3306/jbpm5</connection-url>                    <driver>mysql</driver>                    <pool>                        <min-pool-size>1</min-pool-size>                        <max-pool-size>4</max-pool-size>                        <prefill>false</prefill>                        <use-strict-min>false</use-strict-min>                        <flush-strategy>FailingConnectionOnly</flush-strategy>                    </pool>                    <security>                       <user-name>jbpm5</user-name>                       <password>jbpm5</password>                    </security>                    <validation>                       <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>                       <validate-on-match>false</validate-on-match>                       <background-validation>false</background-validation>                    </validation>                </datasource>                <drivers>                    <!-- <driver name="h2" module="com.h2database.h2"> -->                    <driver name="mysql" module="com.mysql">                        <!-- <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> -->                        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>                    </driver>                </drivers>            </datasources>        </subsystem>        <subsystem xmlns="urn:jboss:domain:deployment-scanner:1.0">            <deployment-scanner scan-interval="5000" deployment-timeout="600" relative-to="jboss.server.base.dir" path="deployments" />        </subsystem>        <subsystem xmlns="urn:jboss:domain:ee:1.0" />        <subsystem xmlns="urn:jboss:domain:ejb3:1.1" lite="true">            <!-- EJB3 pools -->            <pools>                <bean-instance-pools>                    <strict-max-pool name="slsb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5"                                     instance-acquisition-timeout-unit="MINUTES"/>                </bean-instance-pools>            </pools>            <!-- Session bean configurations -->            <session-bean>                <stateless>                    <bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>                </stateless>            </session-bean>        </subsystem>        <subsystem xmlns="urn:jboss:domain:infinispan:1.0" default-cache-container="hibernate">            <cache-container name="hibernate" default-cache="local-query">                <local-cache name="entity">                    <eviction strategy="LRU" max-entries="10000"/>                    <expiration max-idle="100000"/>                </local-cache>                <local-cache name="local-query">                    <eviction strategy="LRU" max-entries="10000"/>                    <expiration max-idle="100000"/>                </local-cache>                <local-cache name="timestamps">                    <eviction strategy="NONE"/>                </local-cache>            </cache-container>        </subsystem>        <subsystem xmlns="urn:jboss:domain:jaxrs:1.0"/>        <subsystem xmlns="urn:jboss:domain:jca:1.0">            <archive-validation enabled="false" />            <bean-validation enabled="false" />            <default-workmanager>                <short-running-threads blocking="true">                        <core-threads count="10" per-cpu="20"/>                        <queue-length count="10" per-cpu="20"/>                        <max-threads count="10" per-cpu="20"/>                        <keepalive-time time="10" unit="seconds"/>                </short-running-threads>                <long-running-threads blocking="true">                        <core-threads count="10" per-cpu="20"/>                        <queue-length count="10" per-cpu="20"/>                        <max-threads count="10" per-cpu="20"/>                        <keepalive-time time="10" unit="seconds"/>                </long-running-threads>            </default-workmanager>        </subsystem>        <subsystem xmlns="urn:jboss:domain:jmx:1.0">            <jmx-connector registry-binding="jmx-connector-registry" server-binding="jmx-connector-server" />        </subsystem>        <!--subsystem xmlns="urn:jboss:domain:jpa:1.0">            <jpa default-datasource=""/>        </subsystem-->        <subsystem xmlns="urn:jboss:domain:naming:1.0" />        <subsystem xmlns="urn:jboss:domain:pojo:1.0" />        <subsystem xmlns="urn:jboss:domain:osgi:1.0" activation="lazy">            <configuration pid="org.apache.felix.webconsole.internal.servlet.OsgiManager">                <property name="manager.root">jboss-osgi</property>            </configuration>            <properties>                <!--                    A comma seperated list of module identifiers. Each system module                    is added as a dependency to the OSGi framework module. The packages                    from these system modules can be made visible as framework system packages.                    http://www.osgi.org/javadoc/r4v42/org/osgi/framework/Constants.html#FRAMEWORK_SYSTEMPACKAGES_EXTRA                -->                <property name="org.jboss.osgi.system.modules">                org.apache.commons.logging,                org.apache.log4j,                org.jboss.as.osgi,                org.slf4j,                </property>                <!--                    Framework environment property identifying extra packages which the system bundle                    must export from the current execution environment                -->                <property name="org.osgi.framework.system.packages.extra">                org.apache.commons.logging;version=1.1.1,                org.apache.log4j;version=1.2,                org.jboss.as.osgi.service;version=7.0,                org.jboss.osgi.deployment.interceptor;version=1.0,                org.jboss.osgi.spi.capability;version=1.0,                org.jboss.osgi.spi.util;version=1.0,                org.jboss.osgi.testing;version=1.0,                org.jboss.osgi.vfs;version=1.0,                org.slf4j;version=1.5.10,                </property>                <!-- Specifies the beginning start level of the framework -->                <property name="org.osgi.framework.startlevel.beginning">1</property>            </properties>            <modules>                <!-- modules registered with the OSGi layer on startup -->                <module identifier="javaee.api"/>                <module identifier="org.jboss.logging"/>                <!-- bundles installed on startup -->                <module identifier="org.apache.aries.util"/>                <module identifier="org.jboss.osgi.webconsole"/>                <module identifier="org.osgi.compendium"/>                <!-- bundles started in startlevel 1 -->                <module identifier="org.apache.felix.log" startlevel="1"/>                <module identifier="org.jboss.osgi.logging" startlevel="1"/>                <module identifier="org.apache.felix.configadmin" startlevel="1"/>                <module identifier="org.jboss.as.osgi.configadmin" startlevel="1"/>                <!-- bundles started in startlevel 2 -->                <module identifier="org.apache.aries.jmx" startlevel="2"/>                <module identifier="org.apache.felix.eventadmin" startlevel="2"/>                <module identifier="org.apache.felix.metatype" startlevel="2"/>                <module identifier="org.apache.felix.scr" startlevel="2"/>                <module identifier="org.apache.felix.webconsole" startlevel="2"/>                <module identifier="org.jboss.osgi.jmx" startlevel="2"/>                <module identifier="org.jboss.osgi.http" startlevel="2"/>                <!-- bundles started in startlevel 3 -->                <module identifier="org.jboss.osgi.blueprint" startlevel="3"/>                <module identifier="org.jboss.osgi.webapp" startlevel="3"/>                <module identifier="org.jboss.osgi.xerces" startlevel="3"/>            </modules>        </subsystem>        <subsystem xmlns="urn:jboss:domain:remoting:1.0"/>        <subsystem xmlns="urn:jboss:domain:resource-adapters:1.0" />        <subsystem xmlns="urn:jboss:domain:sar:1.0"/>        <subsystem xmlns="urn:jboss:domain:security:1.0">            <security-domains>                <security-domain name="other" cache-type="default">                    <authentication>                        <login-module code="Disabled" flag="required"/>                    </authentication>                </security-domain>                <security-domain name="drools-guvnor" cache-type="default">                    <authentication>                        <login-module code="UsersRoles" flag="required">                            <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/>                            <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/>                        </login-module>                    </authentication>                </security-domain>                <security-domain name="jbpm-console" cache-type="default">                    <authentication>                        <login-module code="UsersRoles" flag="required">                            <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/>                            <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/>                        </login-module>                    </authentication>                </security-domain>                <security-domain name="jbpm-form-builder" cache-type="default">                    <authentication>                        <login-module code="UsersRoles" flag="required">                            <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/>                            <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/>                        </login-module>                    </authentication>                </security-domain>            </security-domains>        </subsystem>        <subsystem xmlns="urn:jboss:domain:threads:1.0"/>        <subsystem xmlns="urn:jboss:domain:transactions:1.0">            <recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>            <core-environment>                <process-id>                    <uuid />                </process-id>            </core-environment>            <coordinator-environment default-timeout="300"/>        </subsystem>        <subsystem xmlns="urn:jboss:domain:web:1.0" default-virtual-server="default-host">            <connector name="http" scheme="http" protocol="HTTP/1.1" socket-binding="http"/>            <virtual-server name="default-host" enable-welcome-root="true">               <alias name="localhost" />               <alias name="example.com" />            </virtual-server>        </subsystem>        <subsystem xmlns="urn:jboss:domain:weld:1.0" />    </profile>    <interfaces>        <interface name="management">            <inet-address value="${jboss.bind.address.management:127.0.0.1}"/>        </interface>        <interface name="public">           <inet-address value="${jboss.bind.address:127.0.0.1}"/>        </interface>    </interfaces>    <socket-binding-group name="standard-sockets" default-interface="public">        <socket-binding name="http" port="8080"/>        <socket-binding name="https" port="8443"/>        <socket-binding name="jmx-connector-registry" interface="management" port="1090"/>        <socket-binding name="jmx-connector-server" interface="management" port="1091"/>        <socket-binding name="jndi" port="1099"/>        <socket-binding name="osgi-http" interface="management" port="8090"/>        <socket-binding name="remoting" port="4447"/>        <socket-binding name="txn-recovery-environment" port="4712"/>        <socket-binding name="txn-status-manager" port="4713"/>    </socket-binding-group></server>Shamals-MacBook-Air:jbpm-installer shamalk$ </code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </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/743831#743831">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>