title: PreparedStatement.addBatch in java has any restrictions?
body: <p>I'm trying to optimize the process of inserting a large number of results to a remote mySQL database. I'm using simple jdbc for that. </p>
  
  <p>Currently I'm replacing exiting statements with PreparedStatement and execute methods with addBatch/executeBatch methods. Does anyone know which are the limits of a batch execution? How many batches can I add before execution to make sure the process doesn't fail? The queries are not special queries, they don't have blobs or other large fields.</p>