This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use Stack Overflow.

myisam RollBack

Notes and reports about symfony 1.0.x stable

myisam RollBack

by benakacha » Fri Feb 18, 2011 10:35 am

hello,
I have a mysql database that contains various table with innodb and myisam I use propel ORM,
my problem that I have a transactional function, but the rollback does not work with the myisam table
benakacha
Member
 
Posts: 30
Joined: Thu Aug 20, 2009 11:44 am

Re: myisam RollBack

by woolfas » Fri Feb 18, 2011 10:46 am

MyISAM does not support transactions. Read this:
http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html


http://www.symfonyreference.com - Symfony Configuration Reference (schema.yml, databases.yml, settings.yml, etc..)
User avatar
woolfas
Member
 
Posts: 61
Joined: Mon Nov 08, 2010 2:31 pm
Location: Lithuania

Re: myisam RollBack

by benakacha » Fri Feb 18, 2011 11:37 am

thank you, but we must find a solution in these cases because the migration of tables to myisam innodb very dangerous :uhoh:
benakacha
Member
 
Posts: 30
Joined: Thu Aug 20, 2009 11:44 am

symfony framework forum • Post a reply

by Impurl » Fri Mar 18, 2011 7:26 pm

hello,I have a mysql database that contains various table with innodb and myisam I use propel ORM,my problem that I have a transactional function, but the rollback does not work with the myisam table

...
Impurl
Junior Member
 
Posts: 1
Joined: Tue Mar 15, 2011 4:35 pm
Location: United States