Does anybody know how to configure a datasource for informix

[Zhi Xie]

I have installed informix jdbc driver 3.50 ifxjdbc.jar,ifxjdbcx.jar into
geronimo2.1.7.
Then configure a datasource to informix. But I got the exeption below.
I don't know why database does not have logging.

Any comment is appreciated.

2013-09-16 16:28:36,258 ERROR [RecoveryController] Recovery error
javax.transaction.SystemException: Could not get XAResource for recovery
for mcf: geronimo:J2EEApplication=null,J2EEServer=geronim
o,JCAConnectionFactory=TestInfo,JCAManagedConnectionFactory=TestInfo,JCAResource=console.dbpool/TestInfo/1.0/car,ResourceAdapter=c
onsole.dbpool/TestInfo/1.0/car,ResourceAdapterModule=console.dbpool/TestInfo/1.0/car,j2eeType=JCAConnectionManager,name=TestInfo
at
org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory
.java:61)
at
org.apache.geronimo.transaction.manager.RecoverTask.run(RecoverTask.java:49)
at
org.apache.geronimo.transaction.manager.ExponentialtIntervalRetryScheduler$TaskWrapper.run(ExponentialtIntervalRetrySch
eduler.java:50)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)
Caused by:
javax.resource.spi.ResourceAdapterInternalException: Unable to obtain
physical connection to ***@77
d777d7
at
org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:77)
at
org.tranql.connector.informix.XAMCF.createManagedConnection(XAMCF.java:58)
at
org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
at
org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java
:41)
at
org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterc
eptor.java:69)
at
org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnecti
onInterceptor.java:80)
at
org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.ja
va:49)
at
org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:1
09)
at
org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
at
org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory
.java:56)
... 4 more
Caused by:
java.sql.SQLException: Database does not have logging.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3549)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3871)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2661)
at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:116)
at com.informix.jdbcx.IfxXASqli.executeXAOpen(IfxXASqli.java:182)
at
com.informix.jdbcx.IfxXAPooledConnection.openDBforXA(IfxXAPooledConnection.java:226)
at
com.informix.jdbcx.IfxXAPooledConnection.<init>(IfxXAPooledConnection.java:139)
at
com.informix.jdbcx.IfxXADataSource.getXAConnection(IfxXADataSource.java:98)
at
org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:75)
... 13 more
Caused by:
java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3876)
... 20 more

[David Jencks]

I see some hints in informix documentation that it is possible to create a database with no transaction log ("WITH NO LOG"). Is it possible that your database was created this way?

thanks
david jencks

I have installed informix jdbc driver 3.50 ifxjdbc.jar,ifxjdbcx.jar into geronimo2.1.7.
Then configure a datasource to informix. But I got the exeption below.
I don't know why database does not have logging.
Any comment is appreciated.
2013-09-16 16:28:36,258 ERROR [RecoveryController] Recovery error
javax.transaction.SystemException: Could not get XAResource for recovery for mcf: geronimo:J2EEApplication=null,J2EEServer=geronim
o,JCAConnectionFactory=TestInfo,JCAManagedConnectionFactory=TestInfo,JCAResource=console.dbpool/TestInfo/1.0/car,ResourceAdapter=c
onsole.dbpool/TestInfo/1.0/car,ResourceAdapterModule=console.dbpool/TestInfo/1.0/car,j2eeType=JCAConnectionManager,name=TestInfo
at org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory
.java:61)
at org.apache.geronimo.transaction.manager.RecoverTask.run(RecoverTask.java:49)
at org.apache.geronimo.transaction.manager.ExponentialtIntervalRetryScheduler$TaskWrapper.run(ExponentialtIntervalRetrySch
eduler.java:50)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)
d777d7
at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:77)
at org.tranql.connector.informix.XAMCF.createManagedConnection(XAMCF.java:58)
at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
at org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java
:41)
at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterc
eptor.java:69)
at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnecti
onInterceptor.java:80)
at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.ja
va:49)
at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:1
09)
at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
at org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory
.java:56)
... 4 more
java.sql.SQLException: Database does not have logging.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3549)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3871)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2661)
at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:116)
at com.informix.jdbcx.IfxXASqli.executeXAOpen(IfxXASqli.java:182)
at com.informix.jdbcx.IfxXAPooledConnection.openDBforXA(IfxXAPooledConnection.java:226)
at com.informix.jdbcx.IfxXAPooledConnection.<init>(IfxXAPooledConnection.java:139)
at com.informix.jdbcx.IfxXADataSource.getXAConnection(IfxXADataSource.java:98)
at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:75)
... 13 more
java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3876)
... 20 more
--
Best Regards
Gary

[Zhi Xie]

Thank,David. I have updated the DB's log module. It works.

Post by David Jencks
I see some hints in informix documentation that it is possible to create a
database with no transaction log ("WITH NO LOG"). Is it possible that your
database was created this way?
thanks
david jencks

Post by Zhi Xie
I have installed informix jdbc driver 3.50 ifxjdbc.jar,ifxjdbcx.jar

into geronimo2.1.7.

Post by Zhi Xie
Then configure a datasource to informix. But I got the exeption below.
I don't know why database does not have logging.
Any comment is appreciated.
2013-09-16 16:28:36,258 ERROR [RecoveryController] Recovery error
javax.transaction.SystemException: Could not get XAResource for recovery

for mcf: geronimo:J2EEApplication=null,J2EEServer=geronim
o,JCAConnectionFactory=TestInfo,JCAManagedConnectionFactory=TestInfo,JCAResource=console.dbpool/TestInfo/1.0/car,ResourceAdapter=c
onsole.dbpool/TestInfo/1.0/car,ResourceAdapterModule=console.dbpool/TestInfo/1.0/car,j2eeType=JCAConnectionManager,name=TestInfo

Post by Zhi Xie
at

org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory

Post by Zhi Xie
.java:61)
at

org.apache.geronimo.transaction.manager.RecoverTask.run(RecoverTask.java:49)

Post by Zhi Xie
at

org.apache.geronimo.transaction.manager.ExponentialtIntervalRetryScheduler$TaskWrapper.run(ExponentialtIntervalRetrySch

Post by Zhi Xie
eduler.java:50)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)
javax.resource.spi.ResourceAdapterInternalException: Unable to obtain
d777d7
at

org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:77)

Post by Zhi Xie
at

org.tranql.connector.informix.XAMCF.createManagedConnection(XAMCF.java:58)

Post by Zhi Xie
at

org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)

Post by Zhi Xie
at

org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java

Post by Zhi Xie
:41)
at

org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterc

Post by Zhi Xie
eptor.java:69)
at

org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnecti

Post by Zhi Xie
onInterceptor.java:80)
at

org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.ja

Post by Zhi Xie
va:49)
at

org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:1

Post by Zhi Xie
09)
at

org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)

Post by Zhi Xie
at

org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory

Post by Zhi Xie
.java:56)
... 4 more
java.sql.SQLException: Database does not have logging.
at

com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)

Post by Zhi Xie
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3549)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3871)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2661)
at

com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:116)

Post by Zhi Xie
at com.informix.jdbcx.IfxXASqli.executeXAOpen(IfxXASqli.java:182)
at

com.informix.jdbcx.IfxXAPooledConnection.openDBforXA(IfxXAPooledConnection.java:226)

Post by Zhi Xie
at

com.informix.jdbcx.IfxXAPooledConnection.<init>(IfxXAPooledConnection.java:139)

Post by Zhi Xie
at

com.informix.jdbcx.IfxXADataSource.getXAConnection(IfxXADataSource.java:98)

Post by Zhi Xie
at

org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:75)

Post by Zhi Xie
... 13 more
java.sql.SQLException
at

com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)

Post by Zhi Xie
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3876)
... 20 more
--
Best Regards
Gary