This may be a little out of the topic, but I thought it won't hurt to have a look too: In my attempts to write a resource adapter I've noticed a strange behaviour (I also posted some messages on this forum about it): When the getConnection is called for the first time, everything works fine. For subsequent calls, the associateConnection() was called by the connection manager befor getConnection being invoked as if a handle to my previos connection was being held over method boundaries (I mention that I closed all connection handle in the same method though). Briefly, the cause was this: when a close() is sent, the managed connection calls close() too. Here a CONNECTION_CLOSED event is sent to the cm listener. JBoss expects the connection handle with the event too (for that use setConnectionHandle for an event), otherwise the connection handle is not properly unregistered by CachedConnectionManager and consequently next run it will appear as a connection held over method boundaries.
Radu ----- Original Message ----- From: "David Jencks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 2:01 PM Subject: Re: [JBoss-user] XATxConnectionManager with Oracle? > Thanks for your work on this. Please post the results when you are > satisfied. IMO the entire xa wrapper needs replacing which I unfortunately > won't have time for soon. I'm not sure if associateConnection can be > implemented easily. You can avoid it being called if you always close > connection handles before calling other ejb methods (through home or remote > interfaces) (and do not hold connections over method boundaries). So, try > this: > > Connection c = myds.getConnection(); > //do something > c.close() > myotherRemoteInterface.doSomethingElse(); > c = myds.getConnection(); > //do the rest of your work > c.close(); > > david jencks > > On 2002.06.14 13:35:16 -0400 Igor Fedorenko wrote: > > I spent last two days trying to make this work and it looks like there > > are > > number of issues with both oracle xa datasource and jboss itself. I am > > getting close to have this configuration work (it's oracle 8.1.7.3 in my > > case but this should not make big difference). Problems that I've > > seen/fixed > > so far > > > > 1. Oracle xa driver returns difference XAResource for each call to > > XAConnection.getXAResource (see specs jdbc 2.0, section 7.2.2 why it > > should > > not). This problem causes "xaRes not enlisted". Fixed XAManagedConnection > > to > > cache XAResource, this fix should not break anything else. > > > > 2. Although oracle xa driver accepts non-oracle Xid object, it seems to > > require that both getGlobalTransactionId and getBranchQualifier always > > return byte[64], otherwise it throws "invalid transaction id" during > > XAResource.end. Fixed XidImpl to return such arrays, not sure if it will > > work with all resource managers. > > > > 3. Currently I am trying to understand how > > XAManagedConnection#associateConnection(Object). Currently it > > unconditionally throws "method not implemented" exception. I would > > appreciate if anyone can comment on this... > > > > > -----Original Message----- > > > From: Geer, Benjamin [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, June 14, 2002 1:02 PM > > > To: '[EMAIL PROTECTED]' > > > Cc: Lindsay, Steve; Wink, Stephen > > > Subject: [JBoss-user] XATxConnectionManager with Oracle? > > > > > > > > > I'm trying to get XA transactions to work in JBoss 3.0.0 with > > > Oracle 9i. > > > > > > I've tried the oracle-service.xml provided with JBoss in > > > docs/examples/jca (which uses LocalTxConnectionManager), and it works > > > fine. I modified it to make an oracle-xa-service.xml > > > (attached), using > > > XATxConnectionManager, and I'm testing it with a little MBean service > > > (attached). I can get a DataSource, get a Connection from > > > it, and do a > > > SELECT, but when my service calls Connection.close(), I get the > > > following exception: > > > > > > java.lang.IllegalArgumentException: xaRes not enlisted > > > at org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:546) > > > > > > (Full stack trace attached.) > > > > > > Can anyone tell me what I'm doing wrong? > > > > > > Ben > > > > > > > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > > <HTML> > > <HEAD> > > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > > <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45"> > > <TITLE>RE: [JBoss-user] XATxConnectionManager with Oracle?</TITLE> > > </HEAD> > > <BODY> > > > > <P><FONT SIZE=2>I spent last two days trying to make this work and it > > looks like there are number of issues with both oracle xa datasource and > > jboss itself. I am getting close to have this configuration work (it's > > oracle 8.1.7.3 in my case but this should not make big difference). > > Problems that I've seen/fixed so far</FONT></P> > > > > <P><FONT SIZE=2>1. Oracle xa driver returns difference XAResource for > > each call to XAConnection.getXAResource (see specs jdbc 2.0, section > > 7.2.2 why it should not). This problem causes "xaRes not > > enlisted". Fixed XAManagedConnection to cache XAResource, this fix > > should not break anything else.</FONT></P> > > > > <P><FONT SIZE=2>2. Although oracle xa driver accepts non-oracle Xid > > object, it seems to require that both getGlobalTransactionId and > > getBranchQualifier always return byte[64], otherwise it throws > > "invalid transaction id" during XAResource.end. Fixed XidImpl > > to return such arrays, not sure if it will work with all resource > > managers.</FONT></P> > > > > <P><FONT SIZE=2>3. Currently I am trying to understand how > > XAManagedConnection#associateConnection(Object). Currently it > > unconditionally throws "method not implemented" exception. I > > would appreciate if anyone can comment on this...</FONT></P> > > > > <P><FONT SIZE=2>> -----Original Message-----</FONT> > > <BR><FONT SIZE=2>> From: Geer, Benjamin [<A > > HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]</A>]</F ONT> > > <BR><FONT SIZE=2>> Sent: Friday, June 14, 2002 1:02 PM</FONT> > > <BR><FONT SIZE=2>> To: '[EMAIL PROTECTED]'</FONT> > > <BR><FONT SIZE=2>> Cc: Lindsay, Steve; Wink, Stephen</FONT> > > <BR><FONT SIZE=2>> Subject: [JBoss-user] XATxConnectionManager with > > Oracle?</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> I'm trying to get XA transactions to work in JBoss > > 3.0.0 with </FONT> > > <BR><FONT SIZE=2>> Oracle 9i.</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> I've tried the oracle-service.xml provided with > > JBoss in</FONT> > > <BR><FONT SIZE=2>> docs/examples/jca (which uses > > LocalTxConnectionManager), and it works</FONT> > > <BR><FONT SIZE=2>> fine. I modified it to make an > > oracle-xa-service.xml </FONT> > > <BR><FONT SIZE=2>> (attached), using</FONT> > > <BR><FONT SIZE=2>> XATxConnectionManager, and I'm testing it with a > > little MBean service</FONT> > > <BR><FONT SIZE=2>> (attached). I can get a DataSource, get a > > Connection from </FONT> > > <BR><FONT SIZE=2>> it, and do a</FONT> > > <BR><FONT SIZE=2>> SELECT, but when my service calls > > Connection.close(), I get the</FONT> > > <BR><FONT SIZE=2>> following exception:</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> java.lang.IllegalArgumentException: xaRes not > > enlisted</FONT> > > <BR><FONT SIZE=2>> at > > org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:546)</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> (Full stack trace attached.)</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> Can anyone tell me what I'm doing wrong?</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> Ben</FONT> > > <BR><FONT SIZE=2>> </FONT> > > <BR><FONT SIZE=2>> </FONT> > > </P> > > > > </BODY> > > </HTML> > > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
