I'm trying to detect if the mysql connection supports transactions. I'm using DatabaseMetaData.supportsTransactions() to test if it supports transactions. The problem is that this is returning true even when I'm exclusively using MyISAM tables.

I'm assumming that this behavior is because the mysql database technically does support transactions. So, the question is how can I properly test for transaction support???

My only thought is to insert a row, do a rollback, and then test for that row. But, that's pretty ugly...

thanks, mike