Results of 1 - 2 of about 2 for getObject (0.001 sec.)
- Run Queries 11228
- 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
..., UNION , and ENUM . The JDBC driver maps each of these to an idiomatic Java object. Read the values from a ResultSet with getObject , which returns the following types: DuckDB type Java type returned by getObject LIST , ARRAY org.duckdb.DuckDBArray (impl...mt.executeQuery("SELECT [1, 2, 3] AS l, {'a': 1, 'b': 2} AS s")) { while (rs.next()) { DuckDBArray list = (DuckDBArray) rs.getObject(1); Object[] values = (Object[]) list.getArray(); DuckDBStruct struct = (DuckDBStruct) rs.getObject(2); Map<String, Object...t set: try (ResultSet rs = stmt.executeQuery("SELECT [10, 20, 30] AS l")) { rs.next(); DuckDBArray list = (DuckDBArray) rs.getObject(1); try (ResultSet elements = list.getResultSet()) { while (elements.next()) { int index = elements.getInt("INDEX"); // 1-... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Troubleshoot 7485
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...files written by some legacy writers do not set the UTF8 flag on string columns, so DuckDB reads them as BLOB . ResultSet.getObject() then returns a DuckDBBlobResult and ResultSet.getString() returns the bytes rendered as an escaped string rather than th... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work