import java.sql.Blob; import java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; public class Bug8181 { public static void main(String[] args) throws Exception { try{ DriverManager.registerDriver((Driver) Class.forName("com.mysql.jdbc.Driver").newInstance()); Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test"); PreparedStatement pstmt = con.prepareStatement("INSERT INTO bug8181 (col1,col2) VALUES(?,?)"); for(int i = 0 ; i < 20 ; i++){ pstmt.setString(1, "Test "+i); pstmt.setInt(2,i); pstmt.addBatch(); } pstmt.executeBatch(); pstmt.close(); } catch (Exception e){ e.printStackTrace(); } } }