Results of 1 - 1 of about 1 for addBatch (0.000 sec.)
- Import Data 9414
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...y to use the batch writer, because the statement is parsed once and reused for every row. Bind each row's parameters, call addBatch() to queue the row, and call executeBatch() to write all queued rows in a single operation. import java.sql.DriverManager;...nt("INSERT INTO test (x, y, z) VALUES (?, ?, ?);"); stmt.setObject(1, 1); stmt.setObject(2, 2); stmt.setObject(3, 3); stmt.addBatch(); stmt.setObject(1, 4); stmt.setObject(2, 5); stmt.setObject(3, 6); stmt.addBatch(); stmt.executeBatch(); stmt.close(); B...tch writer also accepts plain SQL statements that carry their values inline, without parameters. Queue each statement with addBatch(String) and submit them together with executeBatch() . This avoids parameter binding but does not benefit from the reuse t... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work