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, pureQuery 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 parameters
With
pureQuery, 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.
Batch heterogeneous updates without parameters
With pureQuery, 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 performing heterogeneous batch
updates, you supply the SQL statements as a list of strings or in
an array of String objects.
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.