How do java make comit in sql if I want to commit a lot of objects?

1. Do not create a PreparedStatement each time. The advantage of PreparedStatement over a regular Statement is that it can be sent in advance to the database server for compilation and reused.

2. Send batch inserts. You may have to find the optimal package size.

3. Use explicit transaction management. By default, the transaction is completed for each database request ( autoCommit = true ).

Here is an example using these three guidelines (using try-with-resources ):

 private static final String INSERT_STATEMENT = "INSERT INTO mydbcall1.Call0(date,direction,operator,abonentTel,duration,coast1,coast2,corpPhone) VALUES(?, ?, ?, ?, ?, ?, ?, ?)"; // .... try ( Connection connection = database.getConnection(); PreparedStatement ps = connection.prepareStatement(INSERT_STATEMENT); ) { int i = 0; connection.setAutoCommit(false) for (Call call : calls) { ps.setDate(1, new java.sql.Date(call.date.getTime()) ); ps.setString(2, call.direction); ps.setString(3, call.operator); ps.setString(4, call.abonentTel); ps.setInt(5, call.duration); ps.setDouble(6, call.coast1); ps.setDouble(7, call.coast2); ps.setString(8, call.corpPhone); // ... ps.addBatch(); i++; if (i % 1000 == 0 || i == calls.size()) { ps.executeBatch(); // ограничиваем размер одного пакета тысячей вставок } } connection.commit(); } catch(SQLException e) { connection.rollback(); }