Getting issue with JDBC resource for informix driver in EAP

Solution Verified - Updated -

Issue

  • We try to setup JDBC resource for connect to Informix DB via deploy JDBC driver as a jar deployment (ifxjdbc.jar) but It's not work since test connection.

  • We are getting below warnings and exception in server.log file:

17:15:30,493 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 72) 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.getLocalManagedConnection(LocalManagedConnectionFactory.java:324) [ironjacamar-jdbc-1.0.26.Final-redhat-1.jar:1.0.26.Final-redhat-1]
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:281) [ironjacamar-jdbc-1.0.26.Final-redhat-1.jar:1.0.26.Final-redhat-1]
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:842) [ironjacamar-core-impl-1.0.26.Final-redhat-1.jar:1.0.26.Final-redhat-1]
...

Caused by: java.sql.SQLException: Unable to load locale categories.
    at .informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1351)
    at .informix.jdbc.IfxDriver.connect(IfxDriver.java:245)
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:296) [ironjacamar-jdbc-1.0.26.Final-redhat-1.jar:1.0.26.Final-redhat-1]
    ... 30 more
Caused by: com.informix.asf.IfxASFRemoteException: 
    at .informix.asf.Connection.recvConnectionResponse(Connection.java:667)
    at .informix.asf.Connection.establishConnection(Connection.java:1565)
    at .informix.asf.Connection.<init>(Connection.java:395)
    at .informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1246)
...
....

Also found below exception:

Caused by: java.sql.SQLException: Database not found or no system permission.
    at informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
    at informix.jdbc.IfxSqli.addException(IfxSqli.java:3178)
    at informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3458)
    at informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2369)
    at informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2294)
    at informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1870)
    at informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1801)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_75]
    at informix.jdbc.IfxDriver.connect(IfxDriver.java:245)
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:296) [ironjacamar-jdbc-1.0.26.Final-redhat-1.jar:1.0.26.Final-redhat-1]
    ... 30 more
Caused by: java.sql.SQLException: ISAM error: no record found.
    at informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
    at informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3463)
    ... 40 more

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.3.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content