Displaying 2 results from an estimated 2 matches for "howtousetransactions".
2006 Jan 10
2
Transactions with multiple databases
...onnections, when i use only
one model:
Object1.transaction do
object1.value1 = "123456"
object1.save
do_some_error
end
it''s ok, error is produced, nothing is commited and database is unchanged.
when i use 2 models, described at
http://wiki.rubyonrails.com/rails/pages/HowToUseTransactions:
Object2.transaction do
Object1.transaction do
object1.value1 = "123456"
object1.save
do_some_error
end
end
- error is produced, but object1 is commited and database is changed
- imho transaction is active(autocommit false) only for Object2 connection
- ruby-1.8.4,...
2006 Mar 24
10
innodb vs myisam
Hi,
I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really:
1. are transactions in activerecord dependent on innodb or do