Newsgroups: comp.databases.oracle.misc Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newshub.sdsu.edu!newsfeed.news2me.com!newsfeed2.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed3.dallas1.level3.net!news.level3.com!news.sanjose1.Level3.net!Level3.net!news.indiana.edu!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Duplicate transaction In-Reply-To: <1152630595.488981.287350@m73g2000cwd.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-61.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1152630595.488981.287350@m73g2000cwd.googlegroups.com> Mime-Version: 1.0 Date: Tue, 11 Jul 2006 16:00:21 GMT Lines: 41 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:128433 sfama wrote: > Hi! > I have a problem using XA transaction. > I have two database on the same oracle server. > If I start two transactions with the same XID, one transaction returns > an XA and Oracle error (ORA-24757). > > The two trasactions are started from two different clients. > I'd like to know if there is a workaround about this problem, or if > Oracle is able to understand that the XID is related to two different > databases also if on the same server. > > Then, I read on one google group, that Oracle keeps in memory, for a > while, the XID of the transaction also if they are ended (committed or > rolled-back). Is this true? Is there a way to deny this Oracle > behaviour? > > Thank you! > Why explicitly state a transaction identifier? Let Oracle handle the transactions for you. It's pretty good at doing that job! Please go through the Oracle Concepts manual (http://tahiti.oracle.com) for your specific version to get a better understanding of how Oracle handles transactions. Thanks, Brian -- =================================================================== Brian Peasland dba@nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown