ExecuteUpdate sql statement in Java not working
Remove c.setAutoCommit(false)
line from the openDatabase
method.
Or
Add c.commit()
at the end of the updateSchool
method.
After the auto-commit mode is disabled, no SQL statements are committed until you call the method commit explicitly. All statements executed after the previous call to the method commit are included in the current transaction and committed together as a unit.