title: How can I fix java.sql.BatchUpdateException?
body: <p>I write a java program that connect to mysql db with jdbc.It inserts records to mysql.
  The sql is this:</p>
  
  <pre><code> INSERT   INTO my_schema.my_table VALUES ('AMERICAN', '97', '1995-08-28 00:00:00', '10', '1995-08-28 00:00:00', '10', 'United States Dollar', 'USD', '$', '2', 'Y', 'Y', '1995-08-28 00:00:00', '_6064530F8DBAB938E040007F010015E3' );
  </code></pre>
  
  <p>But it gives this error:</p>
  
  <pre><code>e = (java.sql.BatchUpdateException) java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('AMERICAN', '40', '1995-08-28 00:00:00', '10', '1995-08-28 00:00:00', '10', 'Ja' at line 1
  </code></pre>
  
  <p>But the weird thing is : I insert it manually without error.</p>
  
  <p>thanks in advance,</p>