Thank,David. I have updated the DB's log module. It works.
2013/9/16 David Jencks <[email protected]> > 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 > > On Sep 16, 2013, at 2:35 AM, Zhi Xie <[email protected]> wrote: > > > 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 com.informix.jdbcx.IfxXADataSource@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 > > > > -- > > Best Regards > > Gary > > -- Best Regards Gary
