Using JDBC

The driver supports both queries and updates through the standard JDBC interfaces against any of the tables exposed. This section includes examples of using the JDBC API to retrieve and update information against sample data.

The Querying the Data section shows how to use JDBC interfaces to establish a connection and query data. On executing a query a ResultSet object is returned that can be used to iterate through the results. See SELECT Statements for more example SELECT statements and for the available SQL syntax and operators. You will find more code examples in the UPDATE Statements, INSERT Statements, and DELETE Statements sections. See Schema Discovery for more information on how to use JDBC interfaces to discover the Data Model.

Additionally, the driver supports Caching Data. This section explains the required connection options to enable caching and describes some best practices. You can then cache data automatically or execute explicit CACHE Statements.