Using the ResultSet Interface
The following must be considered when using the
Before reading any values, you must call
next(). This returns true if there is a result, but more importantly, it prepares the row for processing.
You must close a
close()once you have finished using it.
Once you make another query with the
Statementused to create a
ResultSet, the currently open
ResultSetinstance is closed automatically.
When PreparedStatement API is used,
ResultSetswitches to binary mode after five query executions (this default is set by the
prepareThresholdconnection property, see Server Prepared Statements ). This may cause unexpected behavior when some methods are called. For example, results on method calls such as
getString()on non-string data types, while logically equivalent, may be formatted differently after execution exceeds the set
prepareThresholdwhen conversion to object method switches to one matching the return mode.