rollback issue?

[ponds]

hey there,

I tried to rollback using

connection.setAutoCommit(false);
connection.rollback();

but, data was updated in database with out any commit();

Any idea how to correct this problem? Please reply.
Thankz. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

The default storage engine appears to be MyISAM, which doesn't support transactions. Switching to InnoDB fixes it. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --