# Transactions in RoR

**URL:** <https://www.ruby-forum.com/t/transactions-in-ror/60622>\
**Category:** Rails\
**Created:** [May 16, 2006, 9:19am UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622 "2006-05-16T09:19:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ovidiu\_EFTIMIE](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/b9bd4f/32.png) [@Ovidiu\_EFTIMIE](https://www.ruby-forum.com/u/Ovidiu_EFTIMIE)\
**Post date:** [May 16, 2006, 9:19am UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622/1 "2006-05-16T09:19:58Z")

</div>

Hi,  
Does anyone knows how to manage transactions in RoR.

Thanx

---

<div class="post-metadata">

**Author:** ![Ovidiu\_EFTIMIE](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/b9bd4f/32.png) [@Ovidiu\_EFTIMIE](https://www.ruby-forum.com/u/Ovidiu_EFTIMIE)\
**Post date:** [May 16, 2006, 10:39am UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622/2 "2006-05-16T10:39:39Z")

</div>

On May 16, 2006, at 12:18 AM, Ovidiu EFTIMIE wrote:

> Does anyone knows how to manage transactions in RoR.

[http://api.rubyonrails.com/classes/ActiveRecord/Transactions/](http://api.rubyonrails.com/classes/ActiveRecord/Transactions/)  
ClassMethods.html

–  
– Tom M.

---

<div class="post-metadata">

**Author:** ![Ovidiu\_EFTIMIE](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/b9bd4f/32.png) [@Ovidiu\_EFTIMIE](https://www.ruby-forum.com/u/Ovidiu_EFTIMIE)\
**Post date:** [May 16, 2006, 3:15pm UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622/3 "2006-05-16T15:15:41Z")

</div>

You can’t do transactions over multiple databases though.

Tom M. wrote:

> On May 16, 2006, at 12:18 AM, Ovidiu EFTIMIE wrote:
> 
> > Does anyone knows how to manage transactions in RoR.
> 
> [http://api.rubyonrails.com/classes/ActiveRecord/Transactions/](http://api.rubyonrails.com/classes/ActiveRecord/Transactions/)  
> ClassMethods.html
> 
> –  
> – Tom M.

---

<div class="post-metadata">

**Author:** ![Ovidiu\_EFTIMIE](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/b9bd4f/32.png) [@Ovidiu\_EFTIMIE](https://www.ruby-forum.com/u/Ovidiu_EFTIMIE)\
**Post date:** [May 16, 2006, 4:45pm UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622/4 "2006-05-16T16:45:28Z")

</div>

Kris-

At this point, to my knowledge, there isn’t a shabam! sort of way to do  
multiple database transactions in a super clean way.

But, there are two ‘hackish’ solutions. If your database has inline  
transaction handling then just use the facilities to write your own SQL  
to  
one db to perform the transaction on both. (Some dbs can do this).

You can also nest your transactions. Its not perfect, nor is it pretty,  
but  
as long as each model has a seperate connection, then you are cool.

Check out the API for “transaction”.

-hampton.

---

<div class="post-metadata">

**Author:** ![Ovidiu\_EFTIMIE](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/b9bd4f/32.png) [@Ovidiu\_EFTIMIE](https://www.ruby-forum.com/u/Ovidiu_EFTIMIE)\
**Post date:** [May 16, 2006, 8:51pm UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622/5 "2006-05-16T20:51:02Z")

</div>

Hopefully JRuby will allow us to connect to a Java backend at some point  
in the future.

When you say SOA, you mean a web service? So you would have a the Rails  
app connect to a Java web service, passing one or more records. The Java  
app would do the transaction and respond with OK or Fail??

Would you have just the database stuff in Java or the models as well?

Isak H. wrote:

> On 5/16/06, Hampton [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > as long as each model has a seperate connection, then you are cool.
> > 
> > Check out the API for “transaction”.
> > 
> > -hampton.
> 
> I’d say you’re better off with Java for distributed transactions. In  
> these SOA-times you could still do the web tier in Rails, though.
> 
> Isak

---

<div class="post-metadata">

**Author:** ![Ovidiu\_EFTIMIE](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/b9bd4f/32.png) [@Ovidiu\_EFTIMIE](https://www.ruby-forum.com/u/Ovidiu_EFTIMIE)\
**Post date:** [May 16, 2006, 5:07pm UTC](https://www.ruby-forum.com/t/transactions-in-ror/60622/6 "2006-05-16T17:07:43Z")

</div>

On 5/16/06, Hampton [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> as long as each model has a seperate connection, then you are cool.
> 
> Check out the API for “transaction”.
> 
> -hampton.

I’d say you’re better off with Java for distributed transactions. In  
these SOA-times you could still do the web tier in Rails, though.

Isak