Skip to main content

1. Programmatic API

For general usage, see 5.1 Programmatic API; shared capabilities are covered in Parameters and Rules and Receiving Results. Status links in the table explain data-source-specific behavior.

Data sourceUpdatesQueriesKey-value QueriesBatch OperationsMultiple ResultsStored Procedures and Functions
MySQL✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial
PostgreSQL✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported
Oracle✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial✓ Supported
SQL Server✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial
DB2✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial◐ Partial
H2✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial◐ Partial
ClickHouse✓ Supported✓ Supported✓ Supported◐ Partial✕ Unsupported◐ Partial
Redis✓ Supported✓ Supported✓ Supported◐ Partial✓ Supported◐ Partial
MongoDB✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial
ES 6✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial
ES 7✓ Supported✓ Supported✓ Supported✓ Supported✓ Supported◐ Partial
Milvus✓ Supported✓ Supported✓ Supported◐ Partial✓ Supported✕ Unsupported
  • Updates: execute insert, update, and delete commands and read affected counts; both SQL and database-native commands are accepted.
  • Queries: beans, maps, single values, lists, and counts, including column-name matching and repeated queries.
  • Key-value queries: queryForPairs reads the first two columns as Map keys and values.
  • Batch operations: multiple writes, empty and larger batches, and error handling; JDBC batch execution and atomicity are not guaranteed.
  • Multiple results: multipleExecute and call collect command result sets, including naming and mapping. Reading results through call does not imply database stored-procedure support.
  • Stored procedures and functions: bind parameters and read scalars, records, tables, or cursors; status links describe the available invocation forms.