JBPM 6 with Mysql configuration

[anishjr]

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

[zcc39r]

Chapter 3. jBPM Installer - Using your own database...

[anishjr]

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

[zcc39r]

See WildFly's log to find out the reason.

[anishjr]

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

\"}}"

[anishjr]

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

[zcc39r]

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

[zcc39r]

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

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

[anishjr]

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"]

    }

}

[zcc39r]

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.

[anishjr]

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>

[zcc39r]

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

[anishjr]

/jbpm-installer/db/driver 

[zcc39r]

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

[anishjr]

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

Appreciate your valuable time and effort ..