MySQL Transaction
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Hitoshi_Gosen
Posted On:   Thursday, November 21, 2002 01:26 AM

Hey Guys. I am a newbie and I'm gonna ask a newbie like question. When using MySql with mm.MYSQL-2.0.X jdbc and calling Connection.setAutoCommit(false), does the Database itself become Transaction capable? Or does it just work on the JDBC-API side?

Also, how does MySql handle Transaction support?



Thanks



Toshi .

Re: MySQL Transaction

Posted By:   Andrew_Postoyanets  
Posted On:   Thursday, November 21, 2002 07:05 AM

To provide the best performance, the default type of MySQL tables does not support transactions. To use transactions, you should work with innoDB type of tables.


CREATE TABLE my_table(

-- columns list

) TYPE = InnoDB;




I also had to modify "my.cnf" file. The steps are very well described in MySQL manual.

About | Sitemap | Contact