Results of 1 - 2 of about 2 for setObject (0.001 sec.)
- Import Data 11228
- 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
...tion("jdbc:duckdb:"); PreparedStatement stmt = conn.prepareStatement("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.setOb... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Run Queries 7485
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...bind a LIST / ARRAY , STRUCT , or MAP value as a prepared-statement parameter, build it from the Connection and pass it to setObject() . Each factory method attaches the SQL type name the driver needs to marshal the value. createArrayOf(typeName, elements...yOf("INTEGER", new Object[] {1, 2, 3}); try (PreparedStatement stmt = conn.prepareStatement("SELECT ?::INTEGER[]")) { stmt.setObject(1, list); stmt.execute(); } // STRUCT Struct point = conn.createStruct("STRUCT(x DOUBLE, y DOUBLE)", new Object[] {1.0, 2....", new Object[] {41.1, 42.2}); try (PreparedStatement stmt = conn.prepareStatement("SELECT ?::POINT_2D::GEOMETRY")) { stmt.setObject(1, point); try (ResultSet rs = stmt.executeQuery()) { rs.next(); Blob wkb = rs.getBlob(1); // the geometry as Well-Known B... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work