MYSQL transaction gets automited

[polrus]

Hi,
I'm using mariaDB, and wanted to experiment with rollback

I have started db.transaction() -> returns true;

Then I declared a query and issues a query.prepare that should INSERT certain values to a table

I never called db.commit (removed all references to db.commit() from the code) but still the values from INSERT query get inserted when I execute query.exec()

and ideas?

adding db.rollback(); makes no change

[jefftee]

Read the section regarding autocommit: https://mariadb.com/kb/en/mariadb/start-transaction/

[polrus]

solved

the table has to be InnoDB - transactions wont run with MyISAM