Article View: borland.public.jbuilder.java.api
Article #153Distributed transactions?
From: Scott
Date: Sun, 13 Jun 2004 19:48
Date: Sun, 13 Jun 2004 19:48
21 lines
1557 bytes
1557 bytes
Hi, We are writing a web application in Cold Fusion. But in a few places it looks like the app will need to write data to at least two different databases and maintain transaction integrity. CF runs as a J2EE application so we are evaluating tapping into the underlying JVM to do these critical database writes. Is it possible using JDBC to manage transactions this way? Would it be enough to open the two connections I need (turning auto commit off), issue my two statements and if either fails, rollback both transactions (or commit if there are no errors)? Or do we need to look to JTA for distributed transactions? Any advice appreciated. Thanks Scott
Technical Details
Message-ID:
<40ccdb5d@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!irazu.switch.ch!switch.ch!news.belwue.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 1089d0,55bcad8bab85c179,start X-Google-Attributes: gid1089d0,public Reply-To: "Scott" <scotthpowell@yahoo.com> From: "Scott" <scotthpowell@yahoo.com> Newsgroups: borland.public.jbuilder.java.api Subject: Distributed transactions? Date: Sun, 13 Jun 2004 15:48:54 -0400 Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 NNTP-Posting-Host: 208.54.15.1 Message-ID: <40ccdb5d@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1087167325 208.54.15.1 (13 Jun 2004 15:55:25 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!irazu.switch.ch!switch.ch!news.belwue.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail