Unable to Create IBM DB2 Connection

[marcus.berlinger]

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 [e-mail]//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)

        at [e-mail]//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)

        at [e-mail]//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)

        at [e-mail]//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1326)

        at [e-mail]//org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)

        at [e-mail]//org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:1067)

        at [e-mail]//org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:93)

        at [e-mail]//org.jboss.as.connector.subsystems.common.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:240)

        at [e-mail]//org.jboss.as.connector.subsystems.common.pool.PoolOperations$1.execute(PoolOperations.java:97)

        at [e-mail]//org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:999)

        at [e-mail]//org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:743)

        at [e-mail]//org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:467)

        at [e-mail]//org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1411)

        at [e-mail]//org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:423)

        at [e-mail]//org.jboss.as.controller.ModelControllerImpl.lambda$execute$1(ModelControllerImpl.java:243)

        at [e-mail]//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:289)

        at [e-mail]//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:255)

        at [e-mail]//org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:243)

        at [e-mail]//org.jboss.as.domain.http.server.DomainApiHandler.handleRequest(DomainApiHandler.java:212)

        at [e-mail]//io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72)

        at [e-mail]//org.jboss.as.domain.http.server.DomainApiCheckHandler.handleRequest(DomainApiCheckHandler.java:93)

        at [e-mail]//org.jboss.as.domain.http.server.security.ElytronIdentityHandler.lambda$handleRequest$0(ElytronIdentityHandler.java:62)

        at [e-mail]//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:313)

        at [e-mail]//org.wildfly.security.auth.server.SecurityIdentity.runAs(SecurityIdentity.java:270)

        at [e-mail]//org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:254)

        at [e-mail]//org.jboss.as.controller.AccessAuditContext.doAs(AccessAuditContext.java:225)

        at [e-mail]//org.jboss.as.domain.http.server.security.ElytronIdentityHandler.handleRequest(ElytronIdentityHandler.java:61)

        at [e-mail]//io.undertow.server.handlers.BlockingHandler.handleRequest(BlockingHandler.java:56)

        at [e-mail]//io.undertow.server.Connectors.executeRootHandler(Connectors.java:360)

        at [e-mail]//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)

        at [e-mail]//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)

        at [e-mail]//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)

        at [e-mail]//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)

        at [e-mail]//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)

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

        at [e-mail]//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 [e-mail]//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

[simkam]

Hi,

is it with IBM JDK? It might be similar issue to [WFCORE-4265].

[mayerw01]

Are you shure that your DB2 driver is installed properly?

In my environment this is working fine. But I am using db2jcc4.jar.

Maybe you try this driver instead,

[marcus.berlinger]

Where can i find the DB2 driver for IBMi System i (AS/400) DB2 V7 R2.

I need to Connect to an IBMi System and not to a Linux or Windows DB2.

I have looked for the db2jcc4 but found no driver for the IBMi System i (AS/400)

[mayerw01]

From this link I understand both should be possible IBM Accessing a iSeries DB2 (AS/400) database via JDBC - United States

But anyway, did you verify that your JT400 driver is successfully installed?

[marcus.berlinger]

I´ve got it working. I have extracted the jt400.jar from the last IBMiAccesClient Solution V1.1.8.1. This is the only one who is working for my Wildfly 15.1.

File Name: jt400.jar

Change Date: 12.03.2018 15:13

CRC32: 3BCE2A91

From

IBM i Access Client Solutions

(64-Bit)

Version: 1.1.8.1

Build id: 8452

November 12, 2018 10:31:19 AM CET