title: JDBC statement fails to delete row in specific MySql table
body: <p>I have a table, say <code>example1</code> and I'm using a jdbc statement to delete one of its rows. I have tried various methods, from <code>delete from example1 where id = 1</code> to <code>statement.addbatch(sql)</code> but it does not delete the row. If I execute the same sql statement in Toad for Mysql it's able to delete the row just fine.</p>
  
  <p>Weird thing is that using jdbc I am able to delete rows from other tables just fine; it's just this one particular table giving me unexpected results.</p>
  
  <p>There is nothing special about this table. It has a primary key and no constraints/foreign key relationships. </p>
  
  <p>Also, this delete is a part of a transaction so auto-commit is set to <code>false</code> and once all records get updated/inserted/deleted then the commit is done. This does not seem to have any problem with any other table and all the updates/deletes/inserts are done just fine.</p>
  
  <p>Permission-wise this table has same permission for the db user that any other table in the db.</p>
  
  <p>Any ideas or pointers will be greatly appreciated! </p>