# mysql transaction support

**URL:** <https://forum.servoy.com/t/mysql-transaction-support/2089>\
**Category:** Classic Servoy\
**Created:** [June 23, 2004, 8:38pm UTC](https://forum.servoy.com/t/mysql-transaction-support/2089 "2004-06-23T20:38:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wgknowles](https://avatars.discourse-cdn.com/v4/letter/w/ccd318/32.png) [@wgknowles](https://forum.servoy.com/u/wgknowles)\
**Post date:** [June 23, 2004, 8:38pm UTC](https://forum.servoy.com/t/mysql-transaction-support/2089/1 "2004-06-23T20:38:44Z")

</div>

I am attempting to use startTransaction commitTransaction and rollbackTransaction functions of the database manager in my solution

I am using Servoy Version R2 2.0.3-build 276  
MySQL Version 4.017 for pc-linux-gnu (i686)  
jdbc driver 3.0.14-production

My table types as of now are MyISAM  
I have seen a few mentions regarding table types InnoDB vs MyISAM  
however, when using the console, I am able to do transactions. Why would it not work with servoy?

---

<div class="post-metadata">

**Author:** ![stephan](https://avatars.discourse-cdn.com/v4/letter/s/8baadc/32.png) [@stephan](https://forum.servoy.com/u/stephan)\
**Post date:** [June 23, 2004, 8:53pm UTC](https://forum.servoy.com/t/mysql-transaction-support/2089/2 "2004-06-23T20:53:32Z")

</div>

You don’t have transactions with MyISAM tables, that’s just not possible from what I know.

If you want to use transactions you’ll have to convert your MyISAM to InnoDB tables.

To convert the tables to innodb do (see [this](http://dev.mysql.com/doc/mysql/en/Converting_tables_to_InnoDB.html) and [this](http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html) for more details):  
ALTER TABLE TABLE\_NAME TYPE=INNODB