From: Robert Klemme <shortcutter@...>
Date: 2008-02-20T16:35:37+09:00
Subject: Re: Multidatabase transactions

2008/2/20, coolgeng coolgeng <coolgeng410@gmail.com>:
>     I build a application with SQL server and Oracle. At the beginning,
> there is no requirement to operate data between two database. But now I must
> access both database at the same time. I chose the ActiveRecord, but it
> could not resolve this problem. Now how can I deal with that?

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