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 !

Jon Skeet · Accepted Answer · 2012-02-22 07:52:26Z

4

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

answered Feb 22, 2012 at 7:52

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Balaswamy Vaddeman · Accepted Answer · 2012-02-22 08:44:47Z

1

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

auto-commit option may be off.

answered Feb 22, 2012 at 8:44

8,6003 gold badges33 silver badges40 bronze badges