Cursor attributes for query statements
You can set cursor
attributes for query results from queries
that you run from annotated and inline methods. With these attributes,
you can create scrollable or updatable query results.
Exception handling in pureQuery code
Although pureQuery is based on JDBC, the pureQuery Data
interface does not to require applications to handle checked exceptions.
You do not have to enclose calls to pureQuery methods in try blocks.
Batch heterogeneous updates
With the pureQuery API, you can batch INSERT, UPDATE, and
DELETE statements that refer to different tables. These heterogeneous
batch updates allow all associated tables to be updated in one network
round trip to the server. With this means of heterogeneous batch updates,
you call a method to indicate to pureQuery that you are starting a
batch update.
Passing values from data structures into SQL statements
pureQuery has default rules for using the parameters that
you pass to the annotated or inline methods as values for the parameters
in SQL statements. pureQuery also has default rules for using the
passed parameters when it registers OUT and INOUT parameters. When
you use annotated methods, you can override these default rules with
an implementation of the ParameterHandler<T> interface.