[prev in list] [next in list] [prev in thread] [next in thread]
List: geronimo-user
Subject: Re: Does anybody know how to configure a datasource for informix
From: Zhi Xie <daxiezhi () gmail ! com>
Date: 2013-09-17 9:03:08
Message-ID: CABS8ZprwDznu7H0b40VnNK_spXkC5ZVPVnayy=3aWD5pb1UiKw () mail ! gmail ! com
[Download RAW message or body]
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
[Attachment #3 (text/html)]
<div dir="ltr">Thank,David. I have updated the DB's log module. It \
works.</div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/9/16 David \
Jencks <span dir="ltr"><<a href="mailto:david_jencks@yahoo.com" \
target="_blank">david_jencks@yahoo.com</a>></span><br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">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?<br>
<br>
thanks<br>
<span class="HOEnZb"><font color="#888888">david jencks<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
On Sep 16, 2013, at 2:35 AM, Zhi Xie <<a \
href="mailto:daxiezhi@gmail.com">daxiezhi@gmail.com</a>> wrote:<br> <br>
> I have installed informix jdbc driver 3.50 ifxjdbc.jar,ifxjdbcx.jar into \
geronimo2.1.7.<br> > Then configure a datasource to informix. But I got the \
exeption below.<br> > I don't know why database does not have logging.<br>
><br>
> Any comment is appreciated.<br>
><br>
> 2013-09-16 16:28:36,258 ERROR [RecoveryController] Recovery error<br>
> javax.transaction.SystemException: Could not get XAResource for recovery for \
mcf: geronimo:J2EEApplication=null,J2EEServer=geronim<br> > \
o,JCAConnectionFactory=TestInfo,JCAManagedConnectionFactory=TestInfo,JCAResource=console.dbpool/TestInfo/1.0/car,ResourceAdapter=c<br>
> onsole.dbpool/TestInfo/1.0/car,ResourceAdapterModule=console.dbpool/TestInfo/1.0/car,j2eeType=JCAConnectionManager,name=TestInfo<br>
> at org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory<br>
> .java:61)<br>
> at org.apache.geronimo.transaction.manager.RecoverTask.run(RecoverTask.java:49)<br>
> at org.apache.geronimo.transaction.manager.ExponentialtIntervalRetryScheduler$TaskWrapper.run(ExponentialtIntervalRetrySch<br>
> eduler.java:50)<br>
> at java.util.TimerThread.mainLoop(Timer.java:537)<br>
> at java.util.TimerThread.run(Timer.java:487)<br>
> Caused by:<br>
> javax.resource.spi.ResourceAdapterInternalException: Unable to obtain physical \
connection to com.informix.jdbcx.IfxXADataSource@77<br> > d777d7<br>
> at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:77)<br>
> at org.tranql.connector.informix.XAMCF.createManagedConnection(XAMCF.java:58)<br>
> at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)<br>
> at org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java<br>
> :41)<br>
> at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterc<br>
> eptor.java:69)<br>
> at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnecti<br>
> onInterceptor.java:80)<br>
> at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.ja<br>
> va:49)<br>
> at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:1<br>
> 09)<br>
> at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)<br>
> at org.apache.geronimo.connector.outbound.OutboundNamedXAResourceFactory.getNamedXAResource(OutboundNamedXAResourceFactory<br>
> .java:56)<br>
> ... 4 more<br>
> Caused by:<br>
> java.sql.SQLException: Database does not have logging.<br>
> at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)<br>
> at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3549)<br>
> at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3871)<br>
> at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2661)<br>
> at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:116)<br>
> at com.informix.jdbcx.IfxXASqli.executeXAOpen(IfxXASqli.java:182)<br>
> at com.informix.jdbcx.IfxXAPooledConnection.openDBforXA(IfxXAPooledConnection.java:226)<br>
> at com.informix.jdbcx.IfxXAPooledConnection.<init>(IfxXAPooledConnection.java:139)<br>
> at com.informix.jdbcx.IfxXADataSource.getXAConnection(IfxXADataSource.java:98)<br>
> at org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:75)<br>
> ... 13 more<br>
> Caused by:<br>
> java.sql.SQLException<br>
> at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:412)<br>
> at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3876)<br>
> ... 20 more<br>
><br>
> --<br>
> Best Regards<br>
> Gary<br>
<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Best \
Regards<br>Gary<br> </div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic