The Statement class provides the following functions:

• SQL execution
• Creation of a result set (ResultSet object) as a retrieval result
• Return of the number of updated rows as an updating result

For details about and usage of each method provided with the Statement class, see the applicable JDBC manual.

(a) Multi-thread

To use a single Statement object with multiple threads, a series of processing, such as SQL execution, acquisition of result set, and closing of the result set, needs to be serialized per thread. If they are processed in parallel, operation cannot be guaranteed. Therefore, you should allocate a separate Statement object for each thread.

(b) Cursor name

The JDBC driver does not support positioned updating or deletion. Therefore, the setCursorName method does nothing.

(c) Limitation of retrieval time

The JDBC driver does not support the monitoring of a retrieval time. Therefore, the setQueryTimeout method, if specified, is ignored.

(d) Specification of the maximum number of rows to be retrieved

The maximum number of rows to be retrieved cannot be specified in the JDBC driver.