1 Reply Latest reply on Mar 16, 2012 2:37 AM by swiderski.maciej

    jbpm bitronix.tm.resource.ResourceConfigurationException: cannot create JDBC datasource named jdbc/testDS1

    ous2k
    ous2k Mar 14, 2012 11:38 AM

      Hi,

      when trying to run the example in the folowing link https://community.jboss.org/people/bpmn2user/blog/2011/03/25/jbpm5--persistence-hello-process-example i got this errors

       

      bitronix.tm.resource.ResourceConfigurationException: cannot create JDBC datasource named jdbc/testDS1

                at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:80)

                at com.sample.ProcessTest.main(ProcessTest.java:95)

      Caused by: bitronix.tm.recovery.RecoveryException: cannot start recovery on a PoolingDataSource containing an XAPool of resource jdbc/testDS1 with 0 connection(s) (0 still available)

                at bitronix.tm.resource.jdbc.PoolingDataSource.startRecovery(PoolingDataSource.java:278)

                at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:62)

                at bitronix.tm.resource.ResourceRegistrar.register(ResourceRegistrar.java:78)

                at bitronix.tm.resource.jdbc.PoolingDataSource.buildXAPool(PoolingDataSource.java:92)

                at bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:76)

                ... 1 more

      Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

       

       

      The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

                at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

                at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

                at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

                at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)

                at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)

                at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)

                at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)

                at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)

                at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

                at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

                at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

                at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)

                at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

                at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:440)

                at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:138)

                at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:108)

                at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:48)

                at bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(PoolingDataSource.java:331)

                at bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:291)

                at bitronix.tm.resource.common.XAPool.grow(XAPool.java:408)

                at bitronix.tm.resource.common.XAPool.getInPool(XAPool.java:387)

                at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:129)

                at bitronix.tm.resource.jdbc.PoolingDataSource.startRecovery(PoolingDataSource.java:274)

                ... 5 more

      Caused by: java.net.UnknownHostException: mysqlserver: Name or service not known

                at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)

                at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:866)

                at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1258)

                at java.net.InetAddress.getAllByName0(InetAddress.java:1211)

                at java.net.InetAddress.getAllByName(InetAddress.java:1127)

                at java.net.InetAddress.getAllByName(InetAddress.java:1063)

                at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:247)

                at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)

                ... 27 more


       

      in attachement you can find the project

      Best Regards