The following must be considered when using the
next(). This returns true if there is a result, but more importantly, it prepares the row for processing.
close()once you have finished using it.
Statementused to create a
ResultSet, the currently open
ResultSetinstance is closed automatically.
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,
prepareThresholdwhen conversion to object method switches to one matching the return mode.