PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
AnSqlResult is produced whenever a query is executed usingsqlExecute.execute(),PreparedStatement.execute(), orSession.runSql().
NoSqlResult is produced ifpassResultsToClient is used.
Methods supported bySqlResult are listed here:
close(): Closes the result set. The value returned is undefined.fetchOne(): Retrieves the nextRowin the result set.getAffectedItemsCount(): Retrieves the number of rows affected by the most recent operation.getAutoIncrementValue(): Retrieves the autogenerated ID used for the most recent insert operation.Calling this method is equivalent to executing
LAST_INSERT_ID()in themysql client.getColumnCount(): Gets the number of columns in the result set.getColumnNames(): Retrieves the names of the columns in the current result set.getColumns(): Retrieves the columns metadata in the current result set.getExecutionTime(): Retrieves the time spent executing this query, to the nearest whole second.getWarnings(): Retrieves any warnings (as a list ofWarningobjects) raised by the operation most recently executed.getWarningsCount(): Retrieves the number of warnings raised by the operation last executed.hasData(): Returnstrueif the most recently executed statement yielded a result set,falseotherwise.nextResult(): Moves to the next result set if available. Returnstrueif the result set is available and contains data.
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb