<!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;">
Can't find persistence unit org.jbpm.domain in jbpm-console.war while setting up jBPM 6.0 Beta2 to use MySQL
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/samuele_m">Samuele Mezzasalma</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/822294#822294">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi everybody.</p><p>I'm a complete newbie for what concern business processes and jBPM so I ask for help.</p><p>I installed jBPM 6.0 Beta2 full installer but it's almost two weeks that I'm trying to set up jBPM 6.0 Beta2 to use MySQL and I haven't come up with anything.</p><p>I followed this 5.4 guide <a class="" href="https://community.jboss.org/docs/DOC-48374">Set up jBPM 5.4 Final Installer to use MySQL - or how to run section 3.7 of the User Guide</a> but it didn't seem to work for me.</p><p>I closely followed these four steps:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h5>1)Set up MySQL</h5><p>    mysql> CREATE SCHEMA IF NOT EXISTS jbpm5;</p><p>    mysql> CREATE USER 'jbmp5'@'localhost' IDENTIFIED BY 'jbpm5';</p><p>    mysql> GRANT ALL PRIVILEGES ON jbpm5.* TO 'jbpm5'@'localhost';</p><p>    </p><p>    mysql> CREATE SCHEMA IF NOT EXISTS task;</p><p>    mysql> CREATE USER 'task'@'localhost' IDENTIFIED BY 'task';</p><p>    mysql> GRANT ALL PRIVILEGES ON task.* TO 'task'@'localhost;</p><p>    </p><h5>2)Set up jBPM</h5><p>    </p><h6>    build.properties</h6><p>    </p><pre class="jive-pre"><code class="jive-code"># data base related properties
    db.driver.jar=${install.home}/db/driver/${db.driver.jar.name}
    db.driver.module.dir=${jboss.home}/modules/${db.driver.module.prefix}/main/
    #  default is H2
    #  db.name=h2
    #  db.driver.jar.name=${db.name}.jar
    #  db.driver.download.url=http://repo1.maven.org/maven2/com/h2database/h2/${H2.version}/h2-${H2.version}.jar
    #other options are mysql
  db.name=mysql
  db.driver.module.prefix=com/mysql
  db.driver.jar.name=${db.name}-connector-java.jar
  db.driver.download.url=https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.
</code></pre><h6>  build.xml</h6><pre class="jive-pre"><code class="jive-code jive-xml">  <span class="jive-xml-comment"><!-- Start Demo (DB) -->
    <span class="jive-xml-tag"><target name="start.demo.db" depends="start.jboss, start.eclipse" /></span>
    <!-- Start Demo (DB, No Eclipse) -->
    <span class="jive-xml-tag"><target name="start.demo.db.noeclipse" depends="start.jboss" /></span>
    <!-- Stop Demo (DB)--></span>
    <span class="jive-xml-tag"><target name="stop.demo.db" depends="stop.jboss" /></span>
</code></pre><h6>    db/jbpm-persistence-JPA2.xml</h6><pre class="jive-pre"><code class="jive-code jive-xml">    <span class="jive-xml-tag"><property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h6>    db/task-persistence-JPA2.xml</h6><pre class="jive-pre"><code class="jive-code jive-xml">    <span class="jive-xml-tag"><property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h6>    standalone.xml</h6><pre class="jive-pre"><code class="jive-code jive-xml">    <span class="jive-xml-tag"><datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"></span>
        <span class="jive-xml-tag"><connection-url></span>jdbc:mysql://localhost:3306/task<span class="jive-xml-tag"></connection-url></span>
        <span class="jive-xml-tag"><driver></span>mysql<span class="jive-xml-tag"></driver></span>
        <span class="jive-xml-tag"><security></span>
            <span class="jive-xml-tag"><user-name></span>task<span class="jive-xml-tag"></user-name></span>
            <span class="jive-xml-tag"><password></span>task<span class="jive-xml-tag"></password></span>
        <span class="jive-xml-tag"></security></span>
    <span class="jive-xml-tag"></datasource></span>
    <span class="jive-xml-tag"><datasource jta="true" jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" use-java-context="true" use-ccm="true"></span>
        <span class="jive-xml-tag"><connection-url></span>jdbc:mysql://localhost:3306/jbpm6<span class="jive-xml-tag"></connection-url></span>
        <span class="jive-xml-tag"><driver></span>mysql<span class="jive-xml-tag"></driver></span>
        <span class="jive-xml-tag"><pool></span>
            <span class="jive-xml-tag"><min-pool-size></span>1<span class="jive-xml-tag"></min-pool-size></span>
            <span class="jive-xml-tag"><max-pool-size></span>4<span class="jive-xml-tag"></max-pool-size></span>
            <span class="jive-xml-tag"><prefill></span>false<span class="jive-xml-tag"></prefill></span>
            <span class="jive-xml-tag"><use-strict-min></span>false<span class="jive-xml-tag"></use-strict-min></span>
            <span class="jive-xml-tag"><flush-strategy></span>FailingConnectionOnly<span class="jive-xml-tag"></flush-strategy></span>
        <span class="jive-xml-tag"></pool></span>
        <span class="jive-xml-tag"><security></span>
            <span class="jive-xml-tag"><user-name></span>jbpm6<span class="jive-xml-tag"></user-name></span>
            <span class="jive-xml-tag"><password></span>jbpm6<span class="jive-xml-tag"></password></span>
        <span class="jive-xml-tag"></security></span>
        <span class="jive-xml-tag"><validation></span>
            <span class="jive-xml-tag"><check-valid-connection-sql></span>SELECT 1<span class="jive-xml-tag"></check-valid-connection-sql></span>
            <span class="jive-xml-tag"><validate-on-match></span>false<span class="jive-xml-tag"></validate-on-match></span>
            <span class="jive-xml-tag"><background-validation></span>false<span class="jive-xml-tag"></background-validation></span>
        <span class="jive-xml-tag"></validation></span>
    <span class="jive-xml-tag"></datasource></span>
    <span class="jive-xml-tag"><datasource jta="true" jndi-name="java:jboss/datasources/BamAppDS" pool-name="BamAppDS" enabled="true" use-java-context="true" use-ccm="true"></span>
        <span class="jive-xml-tag"><connection-url></span>jdbc:mysql://localhost:3306/jbpm6<span class="jive-xml-tag"></connection-url></span>
        <span class="jive-xml-tag"><driver></span>mysql<span class="jive-xml-tag"></driver></span>
        <span class="jive-xml-tag"><pool></span>
            <span class="jive-xml-tag"><min-pool-size></span>1<span class="jive-xml-tag"></min-pool-size></span>
            <span class="jive-xml-tag"><max-pool-size></span>4<span class="jive-xml-tag"></max-pool-size></span>
            <span class="jive-xml-tag"><prefill></span>false<span class="jive-xml-tag"></prefill></span>
            <span class="jive-xml-tag"><use-strict-min></span>false<span class="jive-xml-tag"></use-strict-min></span>
            <span class="jive-xml-tag"><flush-strategy></span>FailingConnectionOnly<span class="jive-xml-tag"></flush-strategy></span>
        <span class="jive-xml-tag"></pool></span>
        <span class="jive-xml-tag"><security></span>
            <span class="jive-xml-tag"><user-name></span>jbpm6<span class="jive-xml-tag"></user-name></span>
            <span class="jive-xml-tag"><password></span>jbpm6<span class="jive-xml-tag"></password></span>
        <span class="jive-xml-tag"></security></span>
        <span class="jive-xml-tag"><validation></span>
            <span class="jive-xml-tag"><check-valid-connection-sql></span>SELECT 1<span class="jive-xml-tag"></check-valid-connection-sql></span>
            <span class="jive-xml-tag"><validate-on-match></span>false<span class="jive-xml-tag"></validate-on-match></span>
            <span class="jive-xml-tag"><background-validation></span>false<span class="jive-xml-tag"></background-validation></span>
        <span class="jive-xml-tag"></validation></span>
    <span class="jive-xml-tag"></datasource></span>
    <span class="jive-xml-tag"><drivers></span>
        <span class="jive-xml-tag"><driver name="mysql" module="com.mysql"></span>
            <span class="jive-xml-tag"><xa-datasource-class></span>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource<span class="jive-xml-tag"></xa-datasource-class></span>
        <span class="jive-xml-tag"></driver></span>
    <span class="jive-xml-tag"></drivers></span>
</code></pre><h6>    task-service/resources/META-INF/persistence.xml</h6><pre class="jive-pre"><code class="jive-code jive-xml">    <span class="jive-xml-tag"><property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/></span>
    <span class="jive-xml-tag"><property name="hibernate.connection.driver_class" value="org.jdbc.Driver"/></span>
    <span class="jive-xml-tag"><property name="hibernate.connection.url" value="jdbc:mysql:://localhost:3306/task" /></span>
    <span class="jive-xml-tag"><property name="hibernate.connection.username" value="task"/></span>
    <span class="jive-xml-tag"><property name="hibernate.connection.password" value="task"/></span>
    <span class="jive-xml-tag"><property name="hibernate.connection.autocommit" value="false" /></span>
    <span class="jive-xml-tag"><property name="hibernate.max_fetch_depth" value="3"/></span>
    <span class="jive-xml-tag"><property name="hibernate.hbm2ddl.auto" value="create" /></span>
    <span class="jive-xml-tag"><property name="hibernate.show_sql" value="false" /></span>
</code></pre><h6>    lib/jbpm-console-6.0.0.Beta2.war/WEB-INF/classes/META-INF/persistence.xml</h6><pre class="jive-pre"><code class="jive-code jive-xml">    <span class="jive-xml-tag"><property name="hibernate.dialect" value="org.hibernate.dialect.MySQLialect" /></span>
        <span class="jive-xml-tag"><property name="hibernate.max_fetch_depth" value="3" /></span>
        <span class="jive-xml-tag"><property name="hibernate.hbm2ddl.auto" value="update" /></span>
        <span class="jive-xml-tag"><property name="hibernate.show_sql" value="false" /></span>
</code></pre><p>    </p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-comment"><!-- BZ 841786: AS7/EAP 6/Hib 4 uses new (sequence) generators which seem to cause problems --></span>
        <span class="jive-xml-tag"><property name="hibernate.id.new_generator_mappings" value="false" /></span>
        <span class="jive-xml-tag"><property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" /></span>
       
    <span class="jive-xml-tag"></properties></span>
</code></pre><h5>3)Install jBPM</h5><pre class="jive-pre"><code class="jive-code">    ant install.demo.noeclipse
</code></pre><p>    </p><h5>4)Run the demo</h5><pre class="jive-pre"><code class="jive-code">    ant start.demo.db.noeclipse
</code></pre><p>    </p><p>I attach to this post all modified files, server.log and jbpm-console.war log.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h6>jbpm-console.war.failed</h6><pre class="jive-pre"><code class="jive-code">{"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"jbpm-console.war\".WeldService" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"jbpm-console.war\".WeldService: org.jboss.weld.exceptions.DeploymentException: Exception List with 1 exceptions:
Exception 0 :
java.lang.IllegalArgumentException: JBAS016069: Error injecting persistence unit into CDI managed bean. Can't find a persistence unit named org.jbpm.domain in deployment jbpm-console.war
    at org.jboss.as.weld.services.bootstrap.WeldJpaInjectionServices.getScopedPUName(WeldJpaInjectionServices.java:96)
    at org.jboss.as.weld.services.bootstrap.WeldJpaInjectionServices.resolvePersistenceUnit(WeldJpaInjectionServices.java:78)
    at org.jboss.weld.util.Beans.injectEEFields(Beans.java:631)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget$1$1.proceed(ManagedBean.java:160)
    at org.jboss.weld.injection.InjectionContextImpl.run(InjectionContextImpl.java:48)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget$1.work(ManagedBean.java:157)
    at org.jboss.weld.bean.ManagedBean$FixInjectionPoint.run(ManagedBean.java:131)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.inject(ManagedBean.java:153)
    at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:290)
    at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:107)
    at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:616)
    at org.jboss.weld.bean.AbstractReceiverBean.getReceiver(AbstractReceiverBean.java:73)
    at org.jboss.weld.bean.ProducerMethod$1.produce(ProducerMethod.java:131)
    at org.jboss.weld.bean.AbstractProducerBean.create(AbstractProducerBean.java:299)
    at org.jboss.weld.context.unbound.DependentContextImpl.get(DependentContextImpl.java:61)
    at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:616)
    at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:681)
    at org.jboss.weld.injection.FieldInjectionPoint.inject(FieldInjectionPoint.java:118)
    at org.jboss.weld.util.Beans.injectBoundFields(Beans.java:703)
    at org.jboss.weld.util.Beans.injectFieldsAndInitializers(Beans.java:712)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget$1$1.proceed(ManagedBean.java:161)
    at org.jboss.weld.injection.InjectionContextImpl.run(InjectionContextImpl.java:48)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget$1.work(ManagedBean.java:157)
    at org.jboss.weld.bean.ManagedBean$FixInjectionPoint.run(ManagedBean.java:131)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.inject(ManagedBean.java:153)
    at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:290)
    at org.jboss.weld.context.unbound.DependentContextImpl.get(DependentContextImpl.java:61)
    at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:616)
    at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:681)
    at org.jboss.weld.injection.FieldInjectionPoint.inject(FieldInjectionPoint.java:118)
    at org.jboss.weld.util.Beans.injectBoundFields(Beans.java:703)
    at org.jboss.weld.util.Beans.injectFieldsAndInitializers(Beans.java:712)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget$1$1.proceed(ManagedBean.java:161)
    at org.jboss.weld.injection.InjectionContextImpl.run(InjectionContextImpl.java:48)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget$1.work(ManagedBean.java:157)
    at org.jboss.weld.bean.ManagedBean$FixInjectionPoint.run(ManagedBean.java:131)
    at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.inject(ManagedBean.java:153)
    at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:290)
    at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:107)
    at org.jboss.weld.bean.proxy.ContextBeanInstance.getInstance(ContextBeanInstance.java:90)
    at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:79)
    at org.jbpm.services.task.impl.TaskDeadlinesServiceImpl$Proxy$_$$_WeldClientProxy.toString(TaskDeadlinesServiceImpl$Proxy$_$$_WeldClientProxy.java)
    at org.kie.commons.services.cdi.StartupBeanExtension.runPostConstruct(StartupBeanExtension.java:81)
    at org.kie.commons.services.cdi.StartupBeanExtension.afterDeploymentValidation(StartupBeanExtension.java:69)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.jboss.weld.util.reflection.SecureReflections$13.work(SecureReflections.java:264)
    at org.jboss.weld.util.reflection.SecureReflectionAccess.run(SecureReflectionAccess.java:52)
    at org.jboss.weld.util.reflection.SecureReflectionAccess.runAsInvocation(SecureReflectionAccess.java:137)
    at org.jboss.weld.util.reflection.SecureReflections.invoke(SecureReflections.java:260)
    at org.jboss.weld.introspector.jlr.WeldMethodImpl.invokeOnInstance(WeldMethodImpl.java:170)
    at org.jboss.weld.introspector.ForwardingWeldMethod.invokeOnInstance(ForwardingWeldMethod.java:51)
    at org.jboss.weld.injection.MethodInjectionPoint.invokeOnInstanceWithSpecialValue(MethodInjectionPoint.java:154)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:241)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:229)
    at org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:207)
    at org.jboss.weld.bootstrap.events.AbstractContainerEvent.fire(AbstractContainerEvent.java:75)
    at org.jboss.weld.bootstrap.events.AbstractDeploymentContainerEvent.fire(AbstractDeploymentContainerEvent.java:46)
    at org.jboss.weld.bootstrap.events.AfterDeploymentValidationImpl.fire(AfterDeploymentValidationImpl.java:31)
    at org.jboss.weld.bootstrap.WeldBootstrap.validateBeans(WeldBootstrap.java:369)
    at org.jboss.as.weld.WeldContainer.start(WeldContainer.java:83)
    at org.jboss.as.weld.services.WeldService.start(WeldService.java:76)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)
"},"JBAS014771: Services with missing/unavailable dependencies" => ["jboss.web.deployment.default-host./jbpm-console.realmjboss.security.security-domain.jbpm-console-ngMissing[jboss.web.deployment.default-host./jbpm-console.realmjboss.security.security-domain.jbpm-console-ng]"]}}}
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Anyone has any thought on this?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any help will be appreciated.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Regards</p><p>Samuele Mezzasalma</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/822294#822294">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>