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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.