Results of 1 - 5 of about 5 for PreparedStatement (0.002 sec.)
- Run Queries 12832
- 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
...em.out.println(rs.getString(1)); System.out.println(rs.getInt(3)); } } stmt.close(); jeans 1 hammer 2 DuckDB also supports prepared statements as per the JDBC API: import java.sql.PreparedStatement; try (PreparedStatement stmt = conn.prepareStatement("INSERT INTO..."); stmt.setDouble(2, 500.0); stmt.setInt(3, 42); stmt.execute(); // more calls to execute() possible } Warning Do not use prepared statements to insert large amounts of data into DuckDB. See the data import documentation for better options. Reading Nested and Co...er.getConnection("jdbc:duckdb:"); // LIST / ARRAY Array list = conn.createArrayOf("INTEGER", new Object[] {1, 2, 3}); try (PreparedStatement stmt = conn.prepareStatement("SELECT ?::INTEGER[]")) { stmt.setObject(1, list); stmt.execute(); } // STRUCT Struct point =... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- C++ API 8640
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...alue(col_idx, row_idx).ToString(); cout << (col_idx + 1 < result->ColumnCount() ? "\t" : "\n"); } } } DuckDB also supports prepared statements in the C++ API with the Prepare() method. This returns an instance of PreparedStatement . This instance can be used to e...xecute the prepared statement with parameters. Below is an example: std::unique_ptr<PreparedStatement> prepare = con.Prepare("SELECT count(*) FROM a WH...ERE i = $1"); std::unique_ptr<QueryResult> result = prepare->Execute(12); Warning Do not use prepared statements to insert large amounts of data into DuckDB. See the data import documentation for better options. UDF API Deprecated Th... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Import Data 8309
- 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
...for existing applications. Batch Writer The DuckDB JDBC driver offers batch write functionality. The batch writer supports prepared statements to mitigate the overhead of query parsing. The preferred method for bulk inserts is to use the Appender due to its highe...ance. However, when using the Appender is not possible, the batch writer is available as an alternative. Batch Writer with Prepared Statements Prepared statements are the recommended way to use the batch writer, because the statement is parsed once and reused for...ow, and call executeBatch() to write all queued rows in a single operation. import java.sql.DriverManager; import java.sql.PreparedStatement; import org.duckdb.DuckDBConnection; DuckDBConnection conn = (DuckDBConnection) DriverManager.getConnection("jdbc:duckdb:"... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- PHP Client 8309
- The DuckDB PHP client is a tertiary client and is maintained by a third-party. Client API for PHP, focused on performance. The DuckDB PHP client uses the official C API internally through FFI , achieving good benchmark results. This library
...previously established connection and should be the preferred option in most cases. In addition, the library also provides prepared statements for binding parameters to our query. Prepared Statements $duckDB = DuckDB::create(); $duckDB->query('CREATE TABLE test (...LOAT);'); $duckDB->query('INSERT INTO test VALUES (3, true, 1.1), (5, true, 1.2), (3, false, 1.1), (3, null, 1.2);'); $boolPreparedStatement = $duckDB->preparedStatement('SELECT * FROM test WHERE b = $1'); $boolPreparedStatement->bindParam(1, true); $result = $bo...olPreparedStatement->execute(); $result->print(); $intPreparedStatement = $duckDB->preparedStatement('SELECT * FROM test WHERE i = ?'); $intPr... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php.html
- Java (JDBC) Client 7831
- Installation To use the DuckDB Java (JDBC) client, visit the Java installation page . The latest stable version of the DuckDB Java (JDBC) client is 2.0.0. The DuckDB Java (JDBC) client lets Java applications query DuckDB through the standar
...own. Connect to a DuckLake — attach or open a DuckLake catalog from JDBC. Run Queries — sending queries with Statement and PreparedStatement , and reading DuckDB's nested types. Import Data — bulk-loading data with the Appender and the JDBC batch writer. Handle R... - https://man.mtool.work/duckdb/2.0/clients/java/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work