title: SQL-Escaping and bulk-insert in Java
body: <p>My goal is sql-escaping in bulk-insert query.
  Eg:</p>
  
  <pre><code>INSERT INTO log VALUES (0,5,-7,'str'), (4,0,0,'str'), (0,0,0,'str');
  </code></pre>
  
  <p>The code inserts in table about 100-200 records each 30 seconds. (Log pooling).<br>
  I didn't find way to use PreparedStatement for bulk-insert, so i had to manually build that query through StringBuilder.<br>
  But i have no idea how to escape strings, don't really much want apply something like kludge-fixes (Quotes escaping through regex-replace etc).<br><br></p>
  
  <p>Is there any handy way?</p>