Rails transactions issue with rollback

Rails
1

Hi,

I have a transaction in which a duplicate key exception is being thrown
by MySQL. I assume this happens when I try to do a save. The problem
is that before the save, I do a destroy on another object as part of the
transaction. Catching the exception by doing this,

User.transaction do
begin
objA.destroy
objB.save <-- causing exception
rescue Exception => exc
flash[:notice] = …
end
end

does not rollback the destroy. Any help would be appreciated.

Thanks,

Sam

2

Could this be because of using MyISAM tables rather than InnoDB?

Thanks.

3

On 10/2/06, Sam D. [email protected] wrote:

I have a transaction in which a duplicate key exception is being thrown
by MySQL. I assume this happens when I try to do a save. The problem
is that before the save, I do a destroy on another object as part of the
transaction. Catching the exception by doing this,

Rescue the exception outside of the transaction block. Be sure to use
a
database that supports transactions (not MySQL + MyISAM.)

begin
User.transaction do
objA.destroy
objB.save!
end
rescue Exception => exc
flash[:notice] = …
end

jeremy