How can I implement batch insert ?

[arsis1]

I am new to clickhouse and clickhouse4j.
And I can't see any helpful document about batch insert.

I think more example codes would be very helpful.
Thanks.

[doom369]

@arsis1 agree, this is something we have to work on. For now you can view the tests as usage reference. Typically this driver follows the regular JDBC syntax:

    try (Connection connection = dataSource.getConnection();
         PreparedStatement ps = connection.prepareStatement("insert into table (id) values (?)")) {
     for (var entry : entries) {
         ps.setInt(1, entry.id);
         ps.addBatch();
     }
     ps.executeBatch();
   }

[arsis1]

@doom369 Thanks, very helpful for me.

[doom369]

I'll reopen and will close when put some examples into the main page.