Re: Oracle XA RAR for G1.0?

2006-02-09 Thread lichtner
On Thu, 9 Feb 2006, Jason Dillon wrote: Thanks! My DBA cleared this for me and now XA is working with 1 Oracle DS and 1 ActiveMQ CF. I still can not get the 2 Oracle datasources working together with XA though. Glad it worked out. Did anyone have a chance to peek at that URL I mailed

Re: Oracle XA RAR for G1.0?

2006-02-08 Thread Jason Dillon
Oracle XA flag needs to be set for loosly coupled branches? --jason -Original Message- From: lichtner [EMAIL PROTECTED] Date: Tue, 7 Feb 2006 22:24:38 To:dev@geronimo.apache.org Subject: Re: Oracle XA RAR for G1.0? Since you crashed so many times and then had to delete the log, which

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
Using the ojdbc14-9.2.0.5.jar driver, connecting to a Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production instance. I have a feeling that something else is wrong, as I mentioned before I see hanging transactions when using the local adapter in local-tx mode. And when I ctrl-c G it

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread lichtner
I have a feeling that something else is wrong, as I mentioned before I see hanging transactions when using the local adapter in local-tx mode. And when I ctrl-c G it corrupts the txlog each time... which is very bad IMO. What do you mean by corrupts? Do you mean that the transaction manager

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
I'm going to retest everything with the 10.2.0.1.0_g driver... since 9.2.* was whack for non-xa I'm not sure that anything would work as expected. --jason On 2/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have a feeling that something else is wrong, as I mentioned before I see hanging

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
What do you mean by corrupts? Do you mean that the transaction manager does not perform recovery properly upon boot? So, at some point the remote EJB call appears to hang (looking into that more now), it never times out, just sits there. So I kill the process (not a -9), so the vm shutdown

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
I hacked in some code to TransactionImpl so that I can get at the OracleXAException, and it is this error: ORA-24774 Is there a better way that we can expose these problems w/o having to hack up the impl? The XA Error code (-3) is logged, but the rest of the exception detail is eaten, and

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
It finally dawned on my that my connection to ActiveMQ using: vm://localhost?asyncSend=true Was a bad idea. So I tired using these: * vm://localhost * tcp://localhost:61616 Both of which don't hang... but now were back to more Oracle exceptions: snip 18:24:47,683 WARN

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
I'm not saying it won't work... but its defintetly not happy with TranQL with its throwing an exception for a metadata query instead of returning false. --jason On 2/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 9.2.x.x does work with XA. I'm going to retest everything with the

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread lichtner
It just sounds like a bug, I guess. On Tue, 7 Feb 2006, Jason Dillon wrote: I'm not saying it won't work... but its defintetly not happy with TranQL with its throwing an exception for a metadata query instead of returning false. --jason On 2/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread Jason Dillon
I've got a db looking into fixing that for me... And created https://issues.apache.org/jira/browse/GERONIMO-1599 I'm not sure how to fix this though :-( --jason On 2/7/06, lichtner [EMAIL PROTECTED] wrote: Since you crashed so many times and then had to delete the log, which knows how to

Re: Oracle XA RAR for G1.0?

2006-02-07 Thread lichtner
On Tue, 7 Feb 2006, Jason Dillon wrote: I've got a db looking into fixing that for me... And created https://issues.apache.org/jira/browse/GERONIMO-1599 I'm not sure how to fix this though :-( It looks like line 219 is setting a null xidFactory. It looks like xidFactory is a GBean

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread Jason Dillon
No love :-( When I configure both of my datasources to use the oracle xa adapter, and use the xa adapter for activemq, I get exceptions like: snip [2/6/06 16:35:17:456 PST] [ERROR] - org.apache.geronimo.kernel.log.GeronimoLog.error(line:104) - ORA-02089: COMMIT is not allowed in a subordinate

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread lichtner
ORA-02089: COMMIT is not allowed in a subordinate session Cause: COMMIT was issued in a session that is not the two-phase commit global coordinator. Action: Issue commit at the global coordinator only. http://oraclesvca2.oracle.com/docs/cd/B19306_01/server.102/b14219/e1500.htm#sthref32

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread Aaron Mulder
That's about as helpful as Sanskrit. Aaron On 2/6/06, lichtner [EMAIL PROTECTED] wrote: ORA-02089: COMMIT is not allowed in a subordinate session Cause: COMMIT was issued in a session that is not the two-phase commit global coordinator. Action: Issue commit at the global

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread Jason Dillon
Thanks But I'm still clueless as to why this happens :-( --jason -Original Message- From: lichtner [EMAIL PROTECTED] Date: Mon, 6 Feb 2006 22:06:48 To:dev@geronimo.apache.org Subject: Re: Oracle XA RAR for G1.0? ORA-02089: COMMIT is not allowed in a subordinate session Cause

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread lichtner
as to why this happens :-( --jason -Original Message- From: lichtner [EMAIL PROTECTED] Date: Mon, 6 Feb 2006 22:06:48 To:dev@geronimo.apache.org Subject: Re: Oracle XA RAR for G1.0? ORA-02089: COMMIT is not allowed in a subordinate session Cause: COMMIT was issued in a session

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread lichtner
It's my sanskrit-only support contract. Here on dejanews you can see other people suffering from a similar problem: http://groups.google.com/groups?q=COMMIT+is+not+allowed+in+a+subordinate+sessionhl=en On Mon, 6 Feb 2006, Aaron Mulder wrote: That's about as helpful as Sanskrit. Aaron On

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread Jason Dillon
And the plot thickens... this warning is issued before the exceptions are dumped: snip 21:21:23,050 WARN [Transaction] Unable to enlist XAResource [EMAIL PROTECTED], e rrorCode: -3 oracle.jdbc.xa.OracleXAException at oracle.jdbc.xa.OracleXAResource.checkError

Re: Oracle XA RAR for G1.0?

2006-02-06 Thread lichtner
-3 should be javax.transaction.xa.XAException.XA_RMERR: http://java.sun.com/j2ee/1.4/docs/api/constant-values.html#javax.transaction Anyhow, you are not actually enlisting the oracle resource manager, so that's a step in the right direction. I think that Geronimo is not printing the stack

Re: Oracle XA RAR for G1.0?

2006-02-05 Thread Jason Dillon
Any clue on the required config to get the rar deployed? I'm trying to convert this URL to the params for the RAR: jdbc:oracle:thin:@mydbhost:1621:devdb Unfortunately the Oracle XA RAR does not take a URL, but wants granular configuration. Some obvious stuff I get (like the port

Re: Oracle XA RAR for G1.0?

2006-02-05 Thread lichtner
I think the properties were ConnectionURL, UserName and Password, but don't spend a lot of time on these because I could be wrong .. On Sun, 5 Feb 2006, Jason Dillon wrote: Any clue on the required config to get the rar deployed? I'm trying to convert this URL to the params for the RAR:

Oracle XA RAR for G1.0?

2006-02-03 Thread Jason Dillon
I've been digging around the net for a while, found some pages that indicate that there is support for Oracle XA, some that say there is a a TranQL RAR for it... and others that list that the only XA RAR is the one for Derby. Anyone know definitively what the story is? And if possible

Re: Oracle XA RAR for G1.0?

2006-02-03 Thread David Jencks
On Feb 3, 2006, at 12:45 AM, Jason Dillon wrote: I've been digging around the net for a while, found some pages that indicate that there is support for Oracle XA, some that say there is a a TranQL RAR for it... and others that list that the only XA RAR is the one for Derby. Anyone know

Re: Oracle XA RAR for G1.0?

2006-02-03 Thread lichtner
On Fri, 3 Feb 2006, David Jencks wrote: It is likely to work if you build it. However I don't know that it has been used in the last year or more, so I won't make any promises. Matt might have tried it, I don't know. We have been a bit reluctant to publish it without more evidence that it

Re: Oracle XA RAR for G1.0?

2006-02-03 Thread Matt Hogstrom
I think David means that it has not been extensively tested and so there are no gurantees that you'll simply be able to drop it in. I'm currently working on a DB2 XA RAR and am still working out some kinks. It should work well, we're just not sure its been testd enough to know that it does.

Re: Oracle XA RAR for G1.0?

2006-02-03 Thread Jason Dillon
Awesome. I will given 'em a shot. Thanks :-) --jason On 2/3/06, Matt Hogstrom [EMAIL PROTECTED] wrote: I think David means that it has not been extensively tested and so there are no gurantees that you'll simply be able to drop it in. I'm currently working on a DB2 XA RAR and am still

Re: Oracle XA RAR for G1.0?

2006-02-03 Thread Aaron Mulder
If the RAR is specific to the driver, don't we want to compile against a JDK 1.4 driver not a JDK 1.2 driver? Thanks, Aaron On 2/3/06, Matt Hogstrom [EMAIL PROTECTED] wrote: I think David means that it has not been extensively tested and so there are no gurantees that you'll simply be

Re: Oracle XA RAR for G1.0?

2006-02-03 Thread Matt Hogstrom
Good point. Although I suspect it won't matter. I'll take a look at that and update as appropriate. Thanks Aaron Mulder wrote: If the RAR is specific to the driver, don't we want to compile against a JDK 1.4 driver not a JDK 1.2 driver? Thanks, Aaron On 2/3/06, Matt Hogstrom [EMAIL