5:23 p.m.
Shamal Karunarathne [https://community.jboss.org/people/shamalk] created the discussion
"Re: Error - Table 'jbpm5.task' doesn't exist after trying to set mysql
db"
To view the discussion, visit: https://community.jboss.org/message/743831#743831
--------------------------------------------------------------
As mentioned in the guide, I changed 3 files.
Here's my db/persistence.xml
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$
Here's my task-service/resources/META-INF/persistence.xml
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$
And here's my standalone.xml
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#FRAME...
--> <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$
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/743831#743831]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]