geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zhi Xie <daxie...@gmail.com>
Subject Re: Does anybody know how to configure a datasource for informix
Date Tue, 17 Sep 2013 09:03:08 GMT
Thank,David. I have updated the DB's log module. It works.


2013/9/16 David Jencks <david_jencks@yahoo.com>

> 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 <daxiezhi@gmail.com> 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

Mime
View raw message