mysql transaction support

Classic Servoy
1

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?

2

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 and this for more details):
ALTER TABLE TABLE_NAME TYPE=INNODB