5 Replies Latest reply on Jan 22, 2019 11:36 AM by Marcus Berlinger

    Unable to Create IBM DB2 Connection

    Marcus Berlinger Newbie

      Since Wildfly 14.0 I have the Problem to Create a IBMi -  DB2 Connection. In Wildfly 13 it was Working fine.

       

      this is my standalone.xml from my Wildfly 13

      <datasource jndi-name="java:/DB2DS" pool-name="DB2DS">

                          <connection-url>jdbc:as400://KRPROD/SQLDB</connection-url>

                          <driver>jt400.jar</driver>

                          <pool>

                              <min-pool-size>0</min-pool-size>

                              <max-pool-size>50</max-pool-size>

                          </pool>

                          <security>

                              <user-name>mberlinger</user-name>

                              <password>basf2hd</password>

                          </security>

                          <validation>

                              <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker"/>

                              <background-validation>true</background-validation>

                              <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2StaleConnectionChecker"/>

                              <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.db2.DB2ExceptionSorter"/>

                          </validation>

                      </datasource>

       

      I have tested everything.... copied this to the standalone.xml in wildfly 15.0.1 .

      The server accepts the new standalone.xml but it is not Working getting Error:

       

       

      10:21:15,390 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (External Management Request Threads -- 4) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection

              at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)

              at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)

              at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)

              at org.jboss.ironjacamar.impl@1.4.11.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1326)

              at org.jboss.ironjacamar.impl@1.4.11.Final//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)

              at org.jboss.ironjacamar.impl@1.4.11.Final//org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:1067)

              at org.jboss.ironjacamar.impl@1.4.11.Final//org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:93)

              at org.jboss.as.connector@15.0.1.Final//org.jboss.as.connector.subsystems.common.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:240)

              at org.jboss.as.connector@15.0.1.Final//org.jboss.as.connector.subsystems.common.pool.PoolOperations$1.execute(PoolOperations.java:97)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:999)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:743)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:467)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1411)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:423)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.ModelControllerImpl.lambda$execute$1(ModelControllerImpl.java:243)

              at org.wildfly.security.elytron-private@1.7.0.Final//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:289)

              at org.wildfly.security.elytron-private@1.7.0.Final//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:255)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:243)

              at org.jboss.as.domain-http-interface@7.0.0.Final//org.jboss.as.domain.http.server.DomainApiHandler.handleRequest(DomainApiHandler.java:212)

              at io.undertow.core@2.0.15.Final//io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72)

              at org.jboss.as.domain-http-interface@7.0.0.Final//org.jboss.as.domain.http.server.DomainApiCheckHandler.handleRequest(DomainApiCheckHandler.java:93)

              at org.jboss.as.domain-http-interface@7.0.0.Final//org.jboss.as.domain.http.server.security.ElytronIdentityHandler.lambda$handleRequest$0(ElytronIdentityHandler.java:62)

              at org.wildfly.security.elytron-private@1.7.0.Final//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:313)

              at org.wildfly.security.elytron-private@1.7.0.Final//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:270)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:254)

              at org.jboss.as.controller@7.0.0.Final//org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:225)

              at org.jboss.as.domain-http-interface@7.0.0.Final//org.jboss.as.domain.http.server.security.ElytronIdentityHandler.handleRequest(ElytronIdentityHandler.java:61)

              at io.undertow.core@2.0.15.Final//io.undertow.server.handlers.BlockingHandler.handleRequest(BlockingHandler.java:56)

              at io.undertow.core@2.0.15.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:360)

              at io.undertow.core@2.0.15.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)

              at org.jboss.threads@2.3.2.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)

              at org.jboss.threads@2.3.2.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)

              at org.jboss.threads@2.3.2.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)

              at org.jboss.threads@2.3.2.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)

              at java.base/java.lang.Thread.run(Thread.java:844)

              at org.jboss.threads@2.3.2.Final//org.jboss.threads.JBossThread.run(JBossThread.java:485)

      Caused by: java.sql.SQLNonTransientConnectionException: The application requester cannot establish the connection. (KRPROD)

              at deployment.jt400.jar//com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:881)

              at deployment.jt400.jar//com.ibm.as400.access.JDError.throwSQLException(JDError.java:609)

              at deployment.jt400.jar//com.ibm.as400.access.JDError.throwSQLException(JDError.java:567)

              at deployment.jt400.jar//com.ibm.as400.access.AS400JDBCConnectionImpl.setProperties(AS400JDBCConnectionImpl.java:3499)

              at deployment.jt400.jar//com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1426)

              at deployment.jt400.jar//com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1280)

              at deployment.jt400.jar//com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:403)

              at org.jboss.ironjacamar.jdbcadapters@1.4.11.Final//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)

              ... 35 more

       

      Need Help please.

      I´m using latest Toolbox for Java/JTOpen 9.7