Getting issue with JDBC resource for informix driver in EAP
Issue
-
We try to setup JDBC resource for connect to
Informix DBvia 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.