RE: [jotm] Multiple connection to the same Oracle instance.

[david.egolf@xxxxxxxxxxxxx]

Stephen,

From this, we can attempt to reproduce the problem using one of our Oracle 
servers.

While we do that could you please send a copy of the JOTM log produced 
during the running of this transaction.  This will include the transaction 
ID's, Xid's, and exceptions which are raised.  This might be of some help. 
 Please send it as an attachment.  We will not wait on you in order to 
attempt to duplicate the problem.

-- David Egolf

"Stephen Fry" <Stephen.Fry@xxxxxxxx> wrote on 09/23/2004 12:54:38 AM:

> Yes your description is correct. I am connecting to a single oracle
> 9.2.0.3 instance. I have two JDBC connections connected as two different
> users. Within the same JTA transaction I do some work on both of these
> connections. When the XA start gets sent to the second XA resource I get
> the error.
> 
> I have been trying with the latest build of JOTM, where each RM is given
> an xid with a different branch id. (The version I was using before still
> handed out the same xid to all XAResources) I now get ORA-24756, which
> produces an XAER_NOTA, the transaction id is not valid.
> 
> I have tried sending the oracle specific flag to the RM by wrapping the
> XAResource I get from oracle and adding the loosely coupled branches
> flag, but this doesn't seem to help.
> 
> Thanks for your response
> 
> Stephen
> 
> -----Original Message-----
> From: david.egolf@xxxxxxxxxxxxx [mailto:david.egolf@xxxxxxxxxxxxx] 
> Sent: 23 September 2004 01:22
> To: jotm@xxxxxxxxxxxxx
> Cc: Stephen Fry
> Subject: Re: [jotm] Multiple connection to the same Oracle instance.
> 
> 
> Hi Stephen,
> 
> Can you please supply us with more information?  To clarify: a single 
> transaction uses two different connections to the same Oracle instance 
> where the two connections are connected as different users.  Oracle 
> complains when an attempt is made to commit that the transaction
> specified 
> in the call referes to a transaction careated by a different user.  Is 
> this correct? (We were not positive that the two connections mentioned 
> were used by the same transaction.)
> 
> If this is the case, then we can try to duplicate this situation on one
> of 
> our machines.
> 
> *****
> > It seems there is an Oracle specific flag to send to the XA start, 
> > which tells it to use loosely coupled branches, am I looking at the 
> > right area looking into this?
> 
> I am not familiar with this option in Oracle.  There is currently not a 
> way to pass special parameters into the resource manager during the XA 
> start.  Perhaps someone else on the list has an idea.
> 
> *****
> > Also it seems that JOTM used the same xid for all
> > RM's is this correct?
> 
> No, JOTM 1.5.3 is the first version where JOTM fabricates a different 
> bqual field for each XAResource used by a transaction.  Prior to 1.5.3 
> JOTM provided the same Xid to all XAResources of the same transaction. 
> This was a shortcoming which was modified in preparation for the XA 
> recovery implementation.
> 
> In JOTM 1.5.3 there was a shortcoming in the toString() implementation 
> which made the traces look like the Xid was not changing in some cases. 
> This was fixed when we put the hex representation into the toString() 
> method. Could you have been misled by one of these log entries, or is 
> there another reason that you believe that the Xid field is not
> changing?
> 
> -- David Egolf
> 
> 
> "Stephen Fry" <Stephen.Fry@xxxxxxxx> wrote on 09/22/2004 02:35:42 AM:
> 
> > I am trying to commit a transaction using JOTM 1.5.3. I have two 
> > connections to the same oracle instance but they are connected as 
> > different users.
> > 
> > I am getting
> > 
> > javax.transaction.SystemException: Cannot send XA 
> > start:oracle.jdbc.xa.OracleXAException (error code = -3) --null
> > 
> > The oracle trace file contains
> > 
> > /rdbms/oracle/product/9.2.0/admin/haio920/bdump/haio920_s001_17811.trc
> > Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production 
> > JServer Release 9.2.0.3.0 - Production ORACLE_HOME = 
> > /rdbms/oracle/product/9.2.0
> > System name:    HP-UX
> > Node name:      haiti
> > Release:        B.11.11
> > Version:        U
> > Machine:        9000/800
> > Instance name: haio920
> > Redo thread mounted by this instance: 1
> > Oracle process number: 15
> > Unix process pid: 17811, image: oracle@haiti (S001)
> > 
> > *** 2004-09-21 13:01:50.799
> > *** SESSION ID:(20.16897) 2004-09-21 13:01:50.786
> > joxasStart(): Got a 'C' error: 24774
> > jojniStart(): err = 24774
> > 
> > Oracle ORA-24774 is :-
> > 
> > ORA-24774 cannot switch to specified transaction
> > 
> > Cause: The transaction specified in the call refers to a transaction 
> > created by a different user.
> > 
> > Action: Create transactions with the same authentication so that they 
> > can be switched.
> > 
> > It seems there is an Oracle specific flag to send to the XA start, 
> > which tells it to use loosely coupled branches, am I looking at the 
> > right area looking into this? Also it seems that JOTM used the same 
> > xid for all RM's is this correct?
> > 
> > Has anyone else come across this problem?
> > 
> > Thanks
> > 
> > Stephen Fry
> > CODA Plc.
> > 
> > 
> > The information in this message is confidential and may be legally
> > privileged. It may not be disclosed to, or used by, anyone other 
> > than the addressee. If you receive this message in error, please 
> > advise us immediately.  Internet emails are not necessarily secure. 
> > CODA does not accept responsibility for changes to any email which 
> > occur after the email has been sent. Attachments to this email may 
> > contain software viruses, which could damage your systems. CODA has 
> > checked the attachments for viruses before sending, but you should 
> > virus-check them before opening. 
> > 
> > 
> > 
> > --
> > You receive this message as a subscriber of the jotm@xxxxxxxxxxxxx 
> > mailing list.
> > To unsubscribe: mailto:jotm-unsubscribe@xxxxxxxxxxxxx
> > For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> > ObjectWeb mailing lists service home page:
> http://www.objectweb.org/wws
> 
> 
> 
> 
> The information in this message is confidential and may be legally 
> privileged. It may not be disclosed to, or used by, anyone other 
> than the addressee. If you receive this message in error, please 
> advise us immediately.  Internet emails are not necessarily secure. 
> CODA does not accept responsibility for changes to any email which 
> occur after the email has been sent. Attachments to this email may 
> contain software viruses, which could damage your systems. CODA has 
> checked the attachments for viruses before sending, but you should 
> virus-check them before opening. 
>