14 Replies Latest reply on Apr 29, 2016 5:55 AM by Anish Jr

    JBPM 6 with Mysql  configuration

    Anish Jr Newbie

      Can anyone please guide me to configure JBPM 6 with Mysql.

        • 2. Re: JBPM 6 with Mysql  configuration
          Anish Jr Newbie

          Thank you... I have tried these steps before but i got 404..

          • 3. Re: JBPM 6 with Mysql  configuration
            Rustam Usmanov Apprentice

            See WildFly's log to find out the reason.

            • 4. Re: JBPM 6 with Mysql  configuration
              Anish Jr Newbie

              I have tried installing mysql by following Chapter 3. jBPM Installer but failed to deploy war...

               

              Any one have an idea

               

               

              "{\"JBAS014671: Failed services\" => {\"jboss.deployment.unit.\\\"jbpm-console.war\\\".WeldStartService\" => \"org.jboss.msc.service.StartException in service jboss.deployment.unit.\\\"jbpm-console.war\\\".WeldStartService: Failed to start service

                  Caused by: org.jboss.weld.exceptions.DeploymentException: Exception List with 1 exceptions:

              Exception 0 :

              org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.jbpm.executor.cdi.impl.ExecutorServiceLifeCycleController.init() on org.jbpm.executor.cdi.impl.ExecutorServiceLifeCycleController@1913a27

                  at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:91)

                  at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:72)

                  at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:95)

                  at org.jboss.weld.injection.producer.BeanInjectionTarget.postConstruct(BeanInjectionTarget.java:63)

                  at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162)

                  at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96)

                  at org.jboss.weld.bean.proxy.ContextBeanInstance.getInstance(ContextBeanInstance.java:98)

                  at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:78)

                  at org.jbpm.executor.cdi.impl.ExecutorServiceLifeCycleController$Proxy$_$$_WeldClientProxy.toString(Unknown Source)

                  at org.uberfire.backend.server.cdi.SystemConfigProducer.runPostConstruct(SystemConfigProducer.java:143)

                  at org.uberfire.backend.server.cdi.SystemConfigProducer.afterDeploymentValidation(SystemConfigProducer.java:126)

                  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:606)

                  at org.jboss.weld.injection.MethodInjectionPoint.invokeOnInstanceWithSpecialValue(MethodInjectionPoint.java:93)

                  at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:266)

                  at org.jboss.weld.event.ExtensionObserverMethodImpl.sendEvent(ExtensionObserverMethodImpl.java:125)

                  at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:253)

                  at org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:232)

                  at org.jboss.weld.event.ObserverNotifier.notifyObserver(ObserverNotifier.java:169)

                  at org.jboss.weld.event.ObserverNotifier.notifyObservers(ObserverNotifier.java:128)

                  at org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:102)

                  at org.jboss.weld.bootstrap.events.AbstractContainerEvent.fire(AbstractContainerEvent.java:63)

                  at org.jboss.weld.bootstrap.events.AbstractDeploymentContainerEvent.fire(AbstractDeploymentContainerEvent.java:35)

                  at org.jboss.weld.bootstrap.events.AfterDeploymentValidationImpl.fire(AfterDeploymentValidationImpl.java:28)

                  at org.jboss.weld.bootstrap.WeldStartup.validateBeans(WeldStartup.java:396)

                  at org.jboss.weld.bootstrap.WeldBootstrap.validateBeans(WeldBootstrap.java:85)

                  at org.jboss.as.weld.WeldStartService.start(WeldStartService.java:93)

                  at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)

                  at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)

                  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:745)

              Caused by: java.lang.reflect.InvocationTargetException

                  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:606)

                  at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:89)

                  ... 33 more

              Caused by: java.lang.RuntimeException: Unable to commit transaction

                  at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:239)

                  at org.jbpm.shared.services.impl.TransactionalCommandService.execute(TransactionalCommandService.java:58)

                  at org.jbpm.executor.impl.jpa.ExecutorRequestAdminServiceImpl.requeue(ExecutorRequestAdminServiceImpl.java:77)

                  at org.jbpm.executor.impl.ExecutorServiceImpl.requeue(ExecutorServiceImpl.java:232)

                  at org.jbpm.executor.impl.ExecutorServiceImpl.init(ExecutorServiceImpl.java:136)

                  at org.jbpm.executor.cdi.impl.ExecutorServiceLifeCycleController.init(ExecutorServiceLifeCycleController.java:38)

                  ... 38 more

              Caused by: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.

                  at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1178)

                  at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)

                  at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                  at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:173)

                  at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:236)

                  ... 43 more

              Caused by: java.lang.Throwable: setRollbackOnly called from:

                  at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.setRollbackOnly(TransactionImple.java:314)

                  at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.setRollbackOnly(BaseTransaction.java:159)

                  at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.setRollbackOnly(BaseTransactionManagerDelegate.java:123)

                  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.markForRollbackOnly(AbstractEntityManagerImpl.java:1544)

                  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.handlePersistenceException(AbstractEntityManagerImpl.java:1660)

                  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1764)

                  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)

                  at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)

                  at org.jbpm.shared.services.impl.JpaPersistenceContext.queryInTransaction(JpaPersistenceContext.java:73)

                  at org.jbpm.executor.impl.jpa.ExecutorRequestAdminServiceImpl$RequeueRunningJobsCommand.execute(ExecutorRequestAdminServiceImpl.java:103)

                  at org.jbpm.executor.impl.jpa.ExecutorRequestAdminServiceImpl$RequeueRunningJobsCommand.execute(ExecutorRequestAdminServiceImpl.java:85)

                  at org.jbpm.shared.services.impl.TransactionalCommandService.execute(TransactionalCommandService.java:57)

                  ... 42 more

              \"}}"

              • 5. Re: JBPM 6 with Mysql  configuration
                Anish Jr Newbie

                2016-04-28 18:20:32,687 WARN  [org.hibernate.engine.jdbc.internal.JdbcServicesImpl] (ServerService Thread Pool -- 62) HHH000342: Could not obtain connection to query metadata : javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/jbpmDS

                2016-04-28 18:20:32,697 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 62) HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect

                2016-04-28 18:20:32,707 INFO  [org.hibernate.engine.jdbc.internal.LobCreatorBuilder] (ServerService Thread Pool -- 62) HHH000422: Disabling contextual LOB creation as connection was null

                2016-04-28 18:20:32,950 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 62) HHH000397: Using ASTQueryTranslatorFactory

                2016-04-28 18:20:33,384 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 62) HHH000228: Running hbm2ddl schema update

                2016-04-28 18:20:33,385 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 62) HHH000102: Fetching database metadata

                2016-04-28 18:20:34,632 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 62) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:340)

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:347)

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:281)

                    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1158)

                    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:447)

                    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:454)

                    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:426)

                    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:379)

                    at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:422)

                    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:513)

                    at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)

                    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:219) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:522) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]

                    at org.jboss.as.jpa.hibernate4.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44) [jipijapa-hibernate4-3-1.0.1.Final.jar:]

                    at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:154) [wildfly-jpa-8.1.0.Final.jar:8.1.0.Final]

                    at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:117) [wildfly-jpa-8.1.0.Final.jar:8.1.0.Final]

                    at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_71]

                    at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:474) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]

                    at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:182) [wildfly-jpa-8.1.0.Final.jar:8.1.0.Final]

                    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_71]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_71]

                    at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]

                    at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final.jar:2.1.1.Final]

                Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.ConnectException: Connection refused: localhost" [90067-173]

                    at org.h2.message.DbException.getJdbcSQLException(DbException.java:331) [h2-1.3.168.jar:1.3.168]

                    at org.h2.message.DbException.get(DbException.java:160) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:407) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:295) [h2-1.3.168.jar:1.3.168]

                    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) [h2-1.3.168.jar:1.3.168]

                    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) [h2-1.3.168.jar:1.3.168]

                    at org.h2.Driver.connect(Driver.java:73) [h2-1.3.168.jar:1.3.168]

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:315)

                    ... 30 more

                Caused by: java.net.ConnectException: Connection refused

                    at java.net.PlainSocketImpl.socketConnect(Native Method) [rt.jar:1.7.0_71]

                    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) [rt.jar:1.7.0_71]

                    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) [rt.jar:1.7.0_71]

                    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) [rt.jar:1.7.0_71]

                    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) [rt.jar:1.7.0_71]

                    at java.net.Socket.connect(Socket.java:579) [rt.jar:1.7.0_71]

                    at org.h2.util.NetUtils.createSocket(NetUtils.java:119) [h2-1.3.168.jar:1.3.168]

                    at org.h2.util.NetUtils.createSocket(NetUtils.java:100) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:95) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:403) [h2-1.3.168.jar:1.3.168]

                    ... 35 more

                 

                2016-04-28 18:20:34,703 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 62) HHH000319: Could not get database metadata: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/jbpmDS

                    at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:154)

                    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:219) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:522) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]

                    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]

                    at org.jboss.as.jpa.hibernate4.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44) [jipijapa-hibernate4-3-1.0.1.Final.jar:]

                    at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:154) [wildfly-jpa-8.1.0.Final.jar:8.1.0.Final]

                    at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:117) [wildfly-jpa-8.1.0.Final.jar:8.1.0.Final]

                    at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_71]

                    at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:474) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]

                    at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:182) [wildfly-jpa-8.1.0.Final.jar:8.1.0.Final]

                    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_71]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_71]

                    at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]

                    at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final.jar:2.1.1.Final]

                Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/jbpmDS

                    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:440)

                    at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:422)

                    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:513)

                    at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)

                    ... 20 more

                Caused by: javax.resource.ResourceException: Could not create connection

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:340)

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:347)

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:281)

                    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1158)

                    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:447)

                    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:454)

                    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:426)

                    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:379)

                    ... 23 more

                Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.ConnectException: Connection refused: localhost" [90067-173]

                    at org.h2.message.DbException.getJdbcSQLException(DbException.java:331) [h2-1.3.168.jar:1.3.168]

                    at org.h2.message.DbException.get(DbException.java:160) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:407) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:295) [h2-1.3.168.jar:1.3.168]

                    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) [h2-1.3.168.jar:1.3.168]

                    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) [h2-1.3.168.jar:1.3.168]

                    at org.h2.Driver.connect(Driver.java:73) [h2-1.3.168.jar:1.3.168]

                    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:315)

                    ... 30 more

                Caused by: java.net.ConnectException: Connection refused

                    at java.net.PlainSocketImpl.socketConnect(Native Method) [rt.jar:1.7.0_71]

                    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) [rt.jar:1.7.0_71]

                    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) [rt.jar:1.7.0_71]

                    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) [rt.jar:1.7.0_71]

                    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) [rt.jar:1.7.0_71]

                    at java.net.Socket.connect(Socket.java:579) [rt.jar:1.7.0_71]

                    at org.h2.util.NetUtils.createSocket(NetUtils.java:119) [h2-1.3.168.jar:1.3.168]

                    at org.h2.util.NetUtils.createSocket(NetUtils.java:100) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:95) [h2-1.3.168.jar:1.3.168]

                    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:403) [h2-1.3.168.jar:1.3.168]

                    ... 35 more

                • 6. Re: JBPM 6 with Mysql  configuration
                  Rustam Usmanov Apprentice

                  It seems that your datasource makes use of DB server running at localhost and unable to contact it.

                  • 7. Re: JBPM 6 with Mysql  configuration
                    Rustam Usmanov Apprentice

                    Ensure your datasource configuration on a running server. E.g. with jboss-cli:

                    /subsystem=datasources/data-source=MySQLDS:read-resource

                    • 8. Re: JBPM 6 with Mysql  configuration
                      Anish Jr Newbie

                      Getting something like this. Seems i have missed out something...I have my myqsl driver in db/driver directory ..

                       

                      2016-04-29 12:09:06,358 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("add") failed - address: ([

                          ("subsystem" => "datasources"),

                          ("data-source" => "MySQLDS")

                      ]) - failure description: {

                          "JBAS014771: Services with missing/unavailable dependencies" => [

                              "jboss.driver-demander.java:jboss/datasources/jbpmDS is missing [jboss.jdbc-driver.mysql]",

                              "jboss.data-source.java:jboss/datasources/jbpmDS is missing [jboss.jdbc-driver.mysql]"

                          ],

                          "JBAS014879: One or more services were unable to start due to one or more indirect dependencies not being available." => {

                              "Services that were unable to start:" => [

                                  "jboss.data-source.reference-factory.MySQLDS",

                                  "jboss.naming.context.java.jboss.datasources.jbpmDS"

                              ],

                              "Services that may be the cause:" => ["jboss.jdbc-driver.mysql"]

                          }

                      }

                      • 9. Re: JBPM 6 with Mysql  configuration
                        Rustam Usmanov Apprentice

                        I have my myqsl driver in db/driver directory

                        It's not enough. Did you install the driver jar as a module? Make sure that module definition and driver are installed to the right folder inside the modules directory of your server.

                        • 10. Re: JBPM 6 with Mysql  configuration
                          Anish Jr Newbie

                          Yes am installing like that...

                           

                           

                          db.name=mysql

                          db.driver.module.prefix=com/mysql

                          db.driver.jar.name=mysql-connector-java-5.1.18.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.jar

                           

                           

                          mysql_module.xml

                           

                           

                           

                          <module xmlns="urn:jboss:module:1.0" name="com.mysql">

                             <resources>

                               <resource-root path="mysql-connector-java-5.1.18.jar"/>

                             </resources>

                           

                             <dependencies>

                                <module name="javax.api"/>

                                <module name="javax.transaction.api"/>

                              </dependencies>

                          </module>

                          • 11. Re: JBPM 6 with Mysql  configuration
                            Rustam Usmanov Apprentice

                            These are the sources for install script. What are the full path and content of the folder where com.mysql module is installed?

                            • 12. Re: JBPM 6 with Mysql  configuration
                              Anish Jr Newbie

                              /jbpm-installer/db/driver 

                              • 13. Re: JBPM 6 with Mysql  configuration
                                Rustam Usmanov Apprentice

                                Not correct. This is the path for the source. WildFly module could be installed somewhere under jbpm-installer/wildfly-8.2.1.Final/modules/.

                                • 14. Re: JBPM 6 with Mysql  configuration
                                  Anish Jr Newbie

                                  Finaly it works.....Thanks for your support...

                                   

                                  Appreciate your valuable time and effort ..