From: coolgeng coolgeng <coolgeng410@...>
Date: 2008-02-20T17:03:18+09:00
Subject: Re: Multidatabase transactions

------=_Part_9337_19572112.1203494605240
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Now I just try use commander like "transaction" to resolve this . However it
still some bug in this. It can not act as ACID. So .....
By the way, shall I migrate the data from one of database to another? But I
do not think it is a good idea.

On Feb 20, 2008 3:35 PM, Robert Klemme <shortcutter@googlemail.com> wrote:

>
> I do not know of anything in Ruby land that would be able to do this
> (which does not mean there is none).  Basically you would need XA
> support for this because we are talking distributed transactions here.
> So the XA transaction would either have to be coordinated by Ruby code
> or you would need a TX manager which you can access from Ruby like
> this one for example:
>
> http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_dtcwp.asp
>
> It may be that you can solve this using database links in Oracle.
> However I was not able to determine whether the linked database needs
> to be an Oracle DB as well (I would guess so).
>
> If you do not have strict TX requirements and do not need queries to
> return data from both databases you might get away with using two
> independent DB connections.  But this does not give you 2PC.
>
> Kind regards
>
> robert
>
> --
> use.inject do |as, often| as.you_can - without end
>
>


-- 
Best Regards
Cooper Geng

------=_Part_9337_19572112.1203494605240--