MySQL Database not updating

Question

Using java to connect to a mySQL database, if I use a update query like

Update <table_name> set SID='143' where SATR='temp';

and query.execute() return two, that is two entries with SATR as 'temp', but if I check the database no change !

Answer 1

If you are not getting any exceptions,you may call commit() method.

auto-commit option may be off.

Answer 2

Have you turned off auto-commit but forgotten to explicitly call commit() by any chance?