Index (HSQLDB 1.8.0.10 API)

Overview | Package | Class | Use | Tree | Deprecated | Index | Help

PREV NEXT | FRAMES NO FRAMES

A B C D E F G H I J L M N O P R S T U W

## A

absolute(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the given row number in this `ResultSet` object.
acceptsURL(String) - Method in class org.hsqldb.jdbcDriver
  Returns true if the driver thinks that it can open a connection to the given URL.
addBatch() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Adds a set of parameters to this `PreparedStatement` object's batch of commands.
addBatch(String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  This method should always throw if called for a PreparedStatement or CallableStatment.
addBatch(String) - Method in class org.hsqldb.jdbc.jdbcStatement
  Adds the given SQL command to the current list of commmands for this `Statement` object.
afterLast() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the end of this `ResultSet` object, just after the last row.
allProceduresAreCallable() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether the current user can call all the procedures returned by the method `getProcedures`.
allTablesAreSelectable() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether the current user can use all the tables returned by the method `getTables` in a `SELECT` statement.

## B

beforeFirst() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the front of this `ResultSet` object, just before the first row.

## C

CLOSE_CURSORS_AT_COMMIT - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
CONCUR_READ_ONLY - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
CONCUR_UPDATABLE - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
CONNECTERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
cancel() - Method in class org.hsqldb.jdbc.jdbcStatement
  Cancels this `Statement` object if both the DBMS and driver support aborting an SQL statement.
cancelRowUpdates() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Cancels the updates made to the current row in this `ResultSet` object.
catalogName - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's table's catalog name.
checkRunning(boolean) - Method in class org.hsqldb.Server
  Checks if this Server object is or is not running and throws if the current state does not match the specified value.
clearBatch() - Method in class org.hsqldb.jdbc.jdbcStatement
  Empties this `Statement` object's current list of SQL commands.
clearParameters() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Clears the current parameter values immediately.
clearWarnings() - Method in class org.hsqldb.jdbc.jdbcConnection
  Clears all warnings reported for this `Connection` object.
clearWarnings() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Clears all warnings reported on this `ResultSet` object.
clearWarnings() - Method in class org.hsqldb.jdbc.jdbcStatement
  Clears all the warnings reported on this `Statement` object.
close() - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Does the specialized work required to free this object's resources and that of it's parent classes.
close() - Method in class org.hsqldb.jdbc.jdbcConnection
  Releases this `Connection` object's database and JDBC resources immediately instead of waiting for them to be automatically released.
close() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Does the specialized work required to free this object's resources and that of it's parent class.
close() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
close() - Method in class org.hsqldb.jdbc.jdbcStatement
  Releases this `Statement` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
columnClassName - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.
columnDisplaySize - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's normal max width in chars.
columnLabel - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The suggested column title for use in printouts and displays.
columnName - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's name.
columnType - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's SQL type.
columnTypeName - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's database-specific type name.
commit() - Method in class org.hsqldb.jdbc.jdbcConnection
  Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
connect(String, Properties) - Method in class org.hsqldb.jdbcDriver
  Attempts to make a database connection to the given URL.
connectionClosedException() - Static method in class org.hsqldb.jdbc.Util
createStatement() - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `Statement` object for sending SQL statements to the database.
createStatement(int, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `Statement` object that will generate `ResultSet` objects with the given type and concurrency.
createStatement(int, int, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `Statement` object that will generate `ResultSet` objects with the given type, concurrency, and holdability.

## D

DEFAULT_JDBC_DRIVER - Static variable in class org.hsqldb.util.RCData
DELETE_AFTER - Static variable in interface org.hsqldb.Trigger
DELETE_AFTER_ROW - Static variable in interface org.hsqldb.Trigger
DELETE_BEFORE - Static variable in interface org.hsqldb.Trigger
DELETE_BEFORE_ROW - Static variable in interface org.hsqldb.Trigger
dataDefinitionCausesTransactionCommit() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a data definition statement within a transaction forces the transaction to commit.
dataDefinitionIgnoredInTransactions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database ignores a data definition statement within a transaction.
deleteRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Deletes the current row from this `ResultSet` object and from the underlying database.
deletesAreDetected(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
doesMaxRowSizeIncludeBlobs() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether the return value for the method `getMaxRowSize` includes the SQL data types `LONGVARCHAR` and `LONGVARBINARY`.

## E

execute() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
execute(String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  This method should always throw if called for a PreparedStatement or CallableStatment.
execute(String) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement, which may return multiple results.
execute(String, int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
execute(String, int[]) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
execute(String, String[]) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
executeBatch() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeBatch() - Method in class org.hsqldb.jdbc.jdbcStatement
  Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeQuery() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
executeQuery(String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  This method should always throw if called for a PreparedStatement or CallableStatment.
executeQuery(String) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement, which returns a single `ResultSet` object.
executeUpdate() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Executes the SQL statement in this `PreparedStatement` object, which must be an SQL `INSERT`, `UPDATE` or `DELETE` statement; or an SQL statement that returns nothing, such as a DDL statement.
executeUpdate(String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  This method should always throw if called for a PreparedStatement or CallableStatment.
executeUpdate(String) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement, which may be an `INSERT`, `UPDATE`, or `DELETE` statement or an SQL statement that returns nothing, such as an SQL DDL statement.
executeUpdate(String, int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this `Statement` object should be made available for retrieval.
executeUpdate(String, int[]) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
executeUpdate(String, String[]) - Method in class org.hsqldb.jdbc.jdbcStatement
  Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
expandSysPropVars(String) - Static method in class org.hsqldb.util.RCData

## F

FETCH_FORWARD - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
FETCH_REVERSE - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
FETCH_UNKNOWN - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
FILEERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
findColumn(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Maps the given `ResultSet` column name to its `ResultSet` column index.
fire(int, String, String, Object[], Object[]) - Method in interface org.hsqldb.Trigger
  The method invoked upon each triggered action.
fire(int, String, String, Object[], Object[]) - Method in class org.hsqldb.sample.TriggerSample
  A sample HSQLDB Trigger interface implementation.
first() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the first row in this `ResultSet` object.

## G

getAddress() - Method in class org.hsqldb.Server
  Retrieves, in string form, this server's host address.
getArray(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `ARRAY` parameter as an `Array` object in the Java programming language.
getArray(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `ARRAY` parameter as an `Array` object in the Java programming language.
getArray(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
getArray(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
getAsciiStream() - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves the `CLOB` value designated by this `Clob` object as an ascii stream.
getAsciiStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
getAsciiStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
getAttributes(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.
getAutoCommit() - Method in class org.hsqldb.jdbc.jdbcConnection
  Gets the current auto-commit state.
getBestRowIdentifier(String, String, String, int, boolean) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of a table's optimal set of columns that uniquely identifies a row.
getBigDecimal(int, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Deprecated. use `getBigDecimal(int parameterIndex)` or `getBigDecimal(String parameterName)`
getBigDecimal(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
getBigDecimal(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
getBigDecimal(int, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Deprecated. by java.sun.com as of JDK 1.2
getBigDecimal(String, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Deprecated. by java.sun.com as of JDK 1.2
getBigDecimal(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
getBigDecimal(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
getBinaryStream() - Method in class org.hsqldb.jdbc.jdbcBlob
  Retrieves the `BLOB` value designated by this `Blob` instance as a stream.
getBinaryStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a binary stream of uninterpreted bytes.
getBinaryStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
getBlob(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `BLOB` parameter as a `Blob` object in the Java programming language.
getBlob(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `BLOB` parameter as a `Blob` object in the Java programming language.
getBlob(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
getBlob(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
getBoolean(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `BIT` parameter as a `boolean` in the Java programming language.
getBoolean(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  (JDBC4 modified:) Retrieves the value of a JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
getBoolean(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
getBoolean(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
getByte(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `TINYINT` parameter as a `byte` in the Java programming language.
getByte(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `TINYINT` parameter as a `byte` in the Java programming language.
getByte(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
getByte(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
getBytes(long, int) - Method in class org.hsqldb.jdbc.jdbcBlob
  Retrieves all or part of the `BLOB` value that this `Blob` object represents, as an array of bytes.
getBytes(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
getBytes(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
getBytes(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
getBytes(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
getCatalog() - Method in class org.hsqldb.jdbc.jdbcConnection
  Returns the Connection's current catalog name.
getCatalogName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Gets the designated column's table's catalog name.
getCatalogSeparator() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the `String` that this database uses as the separator between a catalog and table name.
getCatalogTerm() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the database vendor's preferred term for "catalog".
getCatalogs() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the catalog names available in this database.
getCharacterStream() - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves the `CLOB` value designated by this `Clob` object as a `java.io.Reader` object (or as a stream of characters).
getCharacterStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
getCharacterStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
getClob(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `CLOB` parameter as a `Clob` object in the Java programming language.
getClob(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `CLOB` parameter as a `Clob` object in the Java programming language.
getClob(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
getClob(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
getColumnClassName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Returns the fully-qualified name of the Java class whose instances are manufactured if the method `ResultSet.getObject` is called to retrieve a value from the column.
getColumnCount() - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Returns the number of columns in this `ResultSet` object.
getColumnDisplaySize(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates the designated column's normal maximum width in characters.
getColumnLabel(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Gets the designated column's suggested title for use in printouts and displays.
getColumnName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Get the designated column's name.
getColumnPrivileges(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the access rights for a table's columns.
getColumnType(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Retrieves the designated column's SQL type.
getColumnTypeName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Retrieves the designated column's database-specific type name.
getColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of table columns available in the specified catalog.
getConcurrency() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the concurrency mode of this `ResultSet` object.
getConnection() - Method in class org.hsqldb.jdbc.jdbcDataSource
  Attempts to establish a connection with the data source that this `DataSource` object represents.
getConnection(String, String) - Method in class org.hsqldb.jdbc.jdbcDataSource
  Attempts to establish a connection with the data source that this `DataSource` object represents.
getConnection() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the connection that produced this metadata object.
getConnection() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the `Connection` object that produced this `Statement` object.
getConnection(String, Properties) - Static method in class org.hsqldb.jdbcDriver
getConnection() - Method in class org.hsqldb.util.RCData
  Gets a JDBC Connection using the data of this RCData object.
getConnection(String, String, String) - Method in class org.hsqldb.util.RCData
  Gets a JDBC Connection using the data of this RCData object with specified override elements
getCrossReference(String, String, String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key columns of the given primary key table (describe how one table imports another's key).
getCursorName() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the name of the SQL cursor used by this `ResultSet` object.
getDatabase() - Method in class org.hsqldb.jdbc.jdbcDataSource
  Retrieves the jdbc database connection url attribute.
getDatabaseMajorVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the major version number of the underlying database.
getDatabaseMinorVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the minor version number of the underlying database.
getDatabaseName(int, boolean) - Method in class org.hsqldb.Server
  Retrieves the url alias (network name) of the i'th database that this Server hosts.
getDatabasePath(int, boolean) - Method in class org.hsqldb.Server
  Retrieves the HSQLDB path descriptor (uri) of the i'th Database that this Server hosts.
getDatabaseProductName() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the name of this database product.
getDatabaseProductVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the version number of this database product.
getDatabaseType(int) - Method in class org.hsqldb.Server
getDate(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object.
getDate(int, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
getDate(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object.
getDate(String, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
getDate(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
getDate(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
getDate(int, Calendar) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
getDate(String, Calendar) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
getDefaultJdbcDriverName() - Method in class org.hsqldb.util.RCData
getDefaultTransactionIsolation() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves this database's default transaction isolation level.
getDefaultWebPage() - Method in class org.hsqldb.Server
  Retrieves the name of the web page served when no page is specified.
getDefaultWebPage() - Method in class org.hsqldb.WebServer
  Retrieves the name of the web page served when no page is specified.
getDouble(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `DOUBLE` parameter as a `double` in the Java programming language.
getDouble(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `DOUBLE` parameter as a `double` in the Java programming language.
getDouble(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
getDouble(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
getDriverMajorVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves this JDBC driver's major version number.
getDriverMinorVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves this JDBC driver's minor version number.
getDriverName() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the name of this JDBC driver.
getDriverVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the version number of this JDBC driver as a `String`.
getErrWriter() - Method in class org.hsqldb.Server
  Retrieves the PrintWriter to which server errors are printed.
getExportedKeys(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
getExtraNameCharacters() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
getFetchDirection() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the fetch direction for this `ResultSet` object.
getFetchDirection() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this `Statement` object.
getFetchSize() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the fetch size for this `ResultSet` object.
getFetchSize() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the number of result set rows that is the default fetch size for `ResultSet` objects generated from this `Statement` object.
getFloat(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `FLOAT` parameter as a `float` in the Java programming language.
getFloat(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `FLOAT` parameter as a `float` in the Java programming language.
getFloat(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
getFloat(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
getForEachSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
getGeneratedKeys() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves any auto-generated keys created as a result of executing this `Statement` object.
getHelpString() - Method in class org.hsqldb.Server
  Retrieves a String object describing the command line and properties options for this Server.
getHelpString() - Method in class org.hsqldb.WebServer
  Retrieves a String object describing the command line and properties options for this Server.
getHoldability() - Method in class org.hsqldb.jdbc.jdbcConnection
  Retrieves the current holdability of `ResultSet` objects created using this `Connection` object.
getIdentifierQuoteString() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the string used to quote SQL identifiers.
getImportedKeys(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
getIndexInfo(String, String, String, boolean, boolean) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the given table's indices and statistics.
getInt(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `INTEGER` parameter as an `int` in the Java programming language.
getInt(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `INTEGER` parameter as an `int` in the Java programming language.
getInt(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
getInt(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
getJDBCMajorVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the major JDBC version number for this driver.
getJDBCMinorVersion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the minor JDBC version number for this driver.
getLogWriter() - Method in class org.hsqldb.Server
  Retrieves the PrintWriter to which server messages are printed.
getLogWriter() - Method in class org.hsqldb.jdbc.jdbcDataSource
  Retrieves the log writer for this `DataSource` object.
getLoginTimeout() - Method in class org.hsqldb.jdbc.jdbcDataSource
  Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
getLong(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `BIGINT` parameter as a `long` in the Java programming language.
getLong(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `BIGINT` parameter as a `long` in the Java programming language.
getLong(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
getLong(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
getMajorVersion() - Method in class org.hsqldb.jdbcDriver
  Gets the driver's major version number.
getMaxBinaryLiteralLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of hex characters this database allows in an inline binary literal.
getMaxCatalogNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters that this database allows in a catalog name.
getMaxCharLiteralLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters this database allows for a character literal.
getMaxColumnNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters this database allows for a column name.
getMaxColumnsInGroupBy() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of columns this database allows in a `GROUP BY` clause.
getMaxColumnsInIndex() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of columns this database allows in an index.
getMaxColumnsInOrderBy() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of columns this database allows in an `ORDER BY` clause.
getMaxColumnsInSelect() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of columns this database allows in a `SELECT` list.
getMaxColumnsInTable() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of columns this database allows in a table.
getMaxConnections() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of concurrent connections to this database that are possible.
getMaxCursorNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters that this database allows in a cursor name.
getMaxFieldSize() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the maximum number of bytes that can be returned for character and binary column values in a `ResultSet` object produced by this `Statement` object.
getMaxIndexLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.
getMaxProcedureNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters that this database allows in a procedure name.
getMaxRowSize() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of bytes this database allows in a single row.
getMaxRows() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the maximum number of rows that a `ResultSet` object produced by this `Statement` object can contain.
getMaxSchemaNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters that this database allows in a schema name.
getMaxStatementLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters this database allows in an SQL statement.
getMaxStatements() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of active statements to this database that can be open at the same time.
getMaxTableNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters this database allows in a table name.
getMaxTablesInSelect() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of tables this database allows in a `SELECT` statement.
getMaxUserNameLength() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the maximum number of characters this database allows in a user name.
getMetaData() - Method in class org.hsqldb.jdbc.jdbcConnection
  Gets the metadata regarding this connection's database.
getMetaData() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Retrieves a `ResultSetMetaData` object that contains information about the columns of the `ResultSet` object that will be returned when this `PreparedStatement` object is executed.
getMetaData() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the number, types and properties of this `ResultSet` object's columns.
getMinorVersion() - Method in class org.hsqldb.jdbcDriver
  Gets the driver's minor version number.
getMoreResults() - Method in class org.hsqldb.jdbc.jdbcStatement
  Moves to this `Statement` object's next result, returns `true` if it is a `ResultSet` object, and implicitly closes any current `ResultSet` object(s) obtained with the method `getResultSet`.
getMoreResults(int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Moves to this `Statement` object's next result, deals with any current `ResultSet` object(s) according to the instructions specified by the given flag, and returns `true` if the next result is a `ResultSet` object.
getNumericFunctions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a comma-separated list of math functions available with this database.
getObject(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated parameter as an `Object` in the Java programming language.
getObject(int, Map) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Returns an object representing the value of OUT parameter `parameterIndex` and uses `map` for the custom mapping of the parameter value.
getObject(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a parameter as an `Object` in the Java programming language.
getObject(String, Map) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Returns an object representing the value of OUT parameter `parameterName` and uses `map` for the custom mapping of the parameter value.
getObject(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
getObject(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
getObject(int, Map) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
getObject(String, Map) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
getObjectInstance(Object, Name, Context, Hashtable) - Method in class org.hsqldb.jdbc.jdbcDataSourceFactory
  Creates a jdbcDatasource object using the location or reference information specified.
getOperationSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
getParameterClassName(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject.
getParameterCount() - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object provides information.
getParameterMetaData() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
getParameterMode(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the designated parameter's mode.
getParameterType(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the designated parameter's SQL type.
getParameterTypeName(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the designated parameter's database-specific type name.
getPort() - Method in class org.hsqldb.Server
  Retrieves this server's host port.
getPrecision(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the designated parameter's number of decimal digits.
getPrecision(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Get the designated column's number of decimal digits.
getPrimaryKeys(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the given table's primary key columns.
getProcedureColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the given catalog's stored procedure parameter and result columns.
getProcedureTerm() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the database vendor's preferred term for "procedure".
getProcedures(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the stored procedures available in the given catalog.
getProductName() - Method in class org.hsqldb.Server
  Retrieves this server's product name.
getProductName() - Method in class org.hsqldb.WebServer
  Retrieves this server's product name.
getProductVersion() - Method in class org.hsqldb.Server
  Retrieves the server's product version, as a String.
getPropertyInfo(String, Properties) - Method in class org.hsqldb.jdbcDriver
  Gets information about the possible properties for this driver.
getProtocol() - Method in class org.hsqldb.Server
  Retrieves a string respresentaion of the network protocol this server offers, typically one of 'HTTP', HTTPS', 'HSQL' or 'HSQLS'.
getProtocol() - Method in class org.hsqldb.WebServer
  Retrieves a string respresentaion of the network protocol this server offers, typically one of 'HTTP', HTTPS', 'HSQL' or 'HSQLS'.
getQueryTimeout() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the number of seconds the driver will wait for a `Statement` object to execute.
getQueueSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
getRef(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `REF(<structured-type>)` parameter as a `Ref` object in the Java programming language.
getRef(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `REF(<structured-type>)` parameter as a `Ref` object in the Java programming language.
getRef(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
getRef(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
getReference() - Method in class org.hsqldb.jdbc.jdbcDataSource
getResultSet() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the current result as a `ResultSet` object.
getResultSetConcurrency() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the result set concurrency for `ResultSet` objects generated by this `Statement` object.
getResultSetHoldability() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the default holdability of this `ResultSet` object.
getResultSetHoldability() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the result set holdability for `ResultSet` objects generated by this `Statement` object.
getResultSetType() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the result set type for `ResultSet` objects generated by this `Statement` object.
getRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the current row number.
getSQLKeywords() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL92 keywords.
getSQLStateType() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Indicates whether the SQLSTATEs returned by `SQLException.getSQLState` is X/Open (now known as Open Group) SQL CLI or SQL99.
getSavepointId() - Method in class org.hsqldb.jdbc.jdbcSavepoint
  Retrieves the generated ID for the savepoint that this `Savepoint` object represents.
getSavepointName() - Method in class org.hsqldb.jdbc.jdbcSavepoint
  Retrieves the name of the savepoint that this `Savepoint` object represents.
getScale(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves the designated parameter's number of digits to right of the decimal point.
getScale(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Gets the designated column's number of digits to right of the decimal point.
getSchemaName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Get the designated column's table's schema.
getSchemaTerm() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the database vendor's preferred term for "schema".
getSchemas() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the schema names available in this database.
getSearchStringEscape() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the string that can be used to escape wildcard characters.
getServerError() - Method in class org.hsqldb.Server
  Retrieves a Throwable indicating the last server error, if any.
getServerId() - Method in class org.hsqldb.Server
  Retrieves a String identifying this Server object.
getShort(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `SMALLINT` parameter as a `short` in the Java programming language.
getShort(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `SMALLINT` parameter as a `short` in the Java programming language.
getShort(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
getShort(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
getState() - Method in class org.hsqldb.Server
  Retrieves current state of this server in numerically coded form.
getStateDescriptor() - Method in class org.hsqldb.Server
  Retrieves a character sequence describing this server's current state, including the message of the last exception, if there is one and it is still in context.
getStatement() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the `Statement` object that produced this `ResultSet` object.
getString(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
getString(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
getString(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
getString(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
getStringFunctions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a comma-separated list of string functions available with this database.
getSubString(long, int) - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves a copy of the specified substring in the `CLOB` value designated by this `Clob` object.
getSuperTables(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the table hierarchies defined in a particular schema in this database.
getSuperTypes(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
getSystemFunctions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a comma-separated list of system functions available with this database.
getTableName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Gets the designated column's table name.
getTablePrivileges(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the access rights for each table available in a catalog.
getTableTypes() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the table types available in this database.
getTables(String, String, String, String[]) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the tables available in the given catalog.
getTime(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object.
getTime(int, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
getTime(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object.
getTime(String, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
getTime(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
getTime(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
getTime(int, Calendar) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
getTime(String, Calendar) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
getTimeDateFunctions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a comma-separated list of the time and date functions available with this database.
getTimestamp(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
getTimestamp(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
getTimestamp(String, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
getTimestamp(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
getTimestamp(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object.
getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming anguage.
getTimestamp(String, Calendar) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
getTransactionIsolation() - Method in class org.hsqldb.jdbc.jdbcConnection
  Retrieves this `Connection` object's current transaction isolation level.
getTriggerDDL(String, int, String, int, String) - Static method in class org.hsqldb.sample.TriggerSample
getTriggerDescriptor(String, int, String) - Static method in class org.hsqldb.sample.TriggerSample
getType() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the type of this `ResultSet` object.
getTypeInfo() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of all the standard SQL types supported by this database.
getTypeMap() - Method in class org.hsqldb.jdbc.jdbcConnection
  Gets the type map object associated with this connection.
getUDTs(String, String, String, int[]) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
getURL(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of the designated JDBC `DATALINK` parameter as a `java.net.URL` object.
getURL(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves the value of a JDBC `DATALINK` parameter as a `java.net.URL` object.
getURL() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the URL for this DBMS.
getURL(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
getURL(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
getUnicodeStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Deprecated. use `getCharacterStream` in place of `getUnicodeStream`
getUnicodeStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Deprecated. use `getCharacterStream` instead
getUpdateCount() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the current result as an update count; if the result is a `ResultSet` object or there are no more results, -1 is returned.
getUser() - Method in class org.hsqldb.jdbc.jdbcDataSource
  Retrieves the user ID for the connection.
getUserName() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves the user name as known to this database.
getVersionColumns(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.
getWarnings() - Method in class org.hsqldb.jdbc.jdbcConnection
  Retrieves the first warning reported by calls on this `Connection` object.
getWarnings() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves the first warning reported by calls on this `ResultSet` object.
getWarnings() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves the first warning reported by calls on this `Statement` object.
getWebRoot() - Method in class org.hsqldb.Server
  Retrieves the root context (directory) from which web content is served.
getWebRoot() - Method in class org.hsqldb.WebServer
  Retrieves the root context (directory) from which web content is served.
getWhenSpec(int) - Static method in class org.hsqldb.sample.TriggerSample

## H

HOLD_CURSORS_OVER_COMMIT - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
handleConnection(Socket) - Method in class org.hsqldb.Server
  Assigns the specified socket to a new conection handler and starts the handler in a new Thread.

## I

INPUTERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
INSERT_AFTER - Static variable in interface org.hsqldb.Trigger
INSERT_AFTER_ROW - Static variable in interface org.hsqldb.Trigger
INSERT_BEFORE - Static variable in interface org.hsqldb.Trigger
INSERT_BEFORE_ROW - Static variable in interface org.hsqldb.Trigger
IOERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
insertRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Inserts the contents of the insert row into this `ResultSet` object and into the database.
insertsAreDetected(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
invalidArgument() - Static method in class org.hsqldb.jdbc.Util
invalidArgument(String) - Static method in class org.hsqldb.jdbc.Util
isAfterLast() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether the cursor is after the last row in this `ResultSet` object.
isAutoIncrement - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether the value of the column are automatically numbered.
isAutoIncrement(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether the designated column is automatically numbered, thus read-only.
isBeforeFirst() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether the cursor is before the first row in this `ResultSet` object.
isCaseSensitive - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether the column's value's case matters.
isCaseSensitive(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether a column's case matters.
isCatalogAtStart() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a catalog appears at the start of a fully qualified table name.
isClosed() - Method in class org.hsqldb.jdbc.jdbcConnection
  Tests to see if a Connection is closed.
isClosed() - Method in class org.hsqldb.jdbc.jdbcStatement
  Retrieves whether this statement is closed.
isCurrency - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether the values in the column are cash values.
isCurrency(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether the designated column is a cash value.
isDefinitelyWritable - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether a write on the column will definitely succeed.
isDefinitelyWritable(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether a write on the designated column will definitely succeed.
isFirst() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether the cursor is on the first row of this `ResultSet` object.
isLast() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether the cursor is on the last row of this `ResultSet` object.
isNoSystemExit() - Method in class org.hsqldb.Server
  Retrieves whether this server calls System.exit() when shutdown.
isNullable - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The nullability of values in the column.
isNullable(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves whether null values are allowed in the designated parameter.
isNullable(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates the nullability of values in the designated column.
isReadOnly - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether the column's values are definitely not writable.
isReadOnly() - Method in class org.hsqldb.jdbc.jdbcConnection
  Tests to see if the connection is in read-only mode.
isReadOnly() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database is in read-only mode.
isReadOnly(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether the designated column is definitely not writable.
isRestartOnShutdown() - Method in class org.hsqldb.Server
  Retrieves whether this server restarts on shutdown.
isSearchable - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether the column's values can be used in a where clause.
isSearchable(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether the designated column can be used in a where clause.
isSigned - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether values in the column are signed numbers.
isSigned(int) - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves whether values for the designated parameter can be signed numbers.
isSigned(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether values in the designated column are signed numbers.
isSilent() - Method in class org.hsqldb.Server
  Retrieves whether silent mode operation was requested in the server properties.
isTls() - Method in class org.hsqldb.Server
  Retrieves whether the use of secure sockets was requested in the server properties.
isTrace() - Method in class org.hsqldb.Server
  Retrieves whether JDBC trace messages are to go to System.out or the DriverManger PrintStream/PrintWriter, if any.
isWritable - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  Whether it is possible for a write on the column to succeed.
isWritable(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
  Indicates whether it is possible for a write on the designated column to succeed.

## J

jdbcBlob - class org.hsqldb.jdbc.jdbcBlob.
  The representation (mapping) in the JavaTM programming language of an SQL BLOB value.
jdbcBlob(byte[]) - Constructor for class org.hsqldb.jdbc.jdbcBlob
  Constructs a new jdbcBlob instance wrapping the given octet sequence.
jdbcCallableStatement - class org.hsqldb.jdbc.jdbcCallableStatement.
  The interface used to execute SQL stored procedures.
jdbcCallableStatement(jdbcConnection, String, int) - Constructor for class org.hsqldb.jdbc.jdbcCallableStatement
  Constructs a new jdbcCallableStatement with the specified connection and result type.
jdbcClob - class org.hsqldb.jdbc.jdbcClob.
  The mapping in the JavaTM programming language for the SQL CLOB type.
jdbcClob(String) - Constructor for class org.hsqldb.jdbc.jdbcClob
  Constructs a new jdbcClob object wrapping the given character sequence.
jdbcColumnMetaData - class org.hsqldb.jdbc.jdbcColumnMetaData.
  Provides a site for holding the ResultSetMetaData for individual ResultSet columns.
jdbcColumnMetaData() - Constructor for class org.hsqldb.jdbc.jdbcColumnMetaData
jdbcCompliant() - Method in class org.hsqldb.jdbcDriver
  Reports whether this driver is a genuine JDBC COMPLIANTTM driver.
jdbcConnection - class org.hsqldb.jdbc.jdbcConnection.
  A connection (session) with a specific database.
jdbcConnection(HsqlProperties) - Constructor for class org.hsqldb.jdbc.jdbcConnection
  Constructs a new external `Connection` to an HSQLDB `Database`.
jdbcConnection(Session) - Constructor for class org.hsqldb.jdbc.jdbcConnection
  Constructs an `INTERNAL` `Connection`, using the specified `Session`.
jdbcDataSource - class org.hsqldb.jdbc.jdbcDataSource.
  A factory for connections to the physical data source that this `DataSource` object represents.
jdbcDataSource() - Constructor for class org.hsqldb.jdbc.jdbcDataSource
  Constructor
jdbcDataSourceFactory - class org.hsqldb.jdbc.jdbcDataSourceFactory.
  A JNDI ObjectFactory for creating `jdbcDatasource` object instances.
jdbcDataSourceFactory() - Constructor for class org.hsqldb.jdbc.jdbcDataSourceFactory
jdbcDatabaseMetaData - class org.hsqldb.jdbc.jdbcDatabaseMetaData.
  Comprehensive information about the database as a whole.
jdbcDriver - class org.hsqldb.jdbcDriver.
  Each JDBC driver must supply a class that implements the Driver interface.
jdbcDriver() - Constructor for class org.hsqldb.jdbcDriver
jdbcParameterMetaData - class org.hsqldb.jdbc.jdbcParameterMetaData.
  An object that can be used to get information about the types and properties of the parameters in a PreparedStatement object.
jdbcPreparedStatement - class org.hsqldb.jdbc.jdbcPreparedStatement.
  An object that represents a precompiled SQL statement.
jdbcResultSet - class org.hsqldb.jdbc.jdbcResultSet.
  A table of data representing a database result set, which is usually generated by executing a statement that queries the database.
jdbcResultSetMetaData - class org.hsqldb.jdbc.jdbcResultSetMetaData.
  An object that can be used to get information about the types and properties of the columns in a `ResultSet` object.
jdbcSavepoint - class org.hsqldb.jdbc.jdbcSavepoint.
  The representation of a savepoint, which is a point within the current transaction that can be referenced from the `Connection.rollback` method.
jdbcStatement - class org.hsqldb.jdbc.jdbcStatement.
  The object used for executing a static SQL statement and returning the results it produces.

## L

LS - Static variable in class org.hsqldb.util.SqlTool
last() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the last row in this `ResultSet` object.
length() - Method in class org.hsqldb.jdbc.jdbcBlob
  Returns the number of bytes in the `BLOB` value designated by this `Blob` object.
length() - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves the number of characters in the `CLOB` value designated by this `Clob` object.
locatorsUpdateCopy() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Indicates whether updates made to a LOB are made on a copy or directly to the LOB.

## M

main(String[]) - Static method in class org.hsqldb.Server
  Creates and starts a new Server.
main(String[]) - Static method in class org.hsqldb.WebServer
  Starts a new WebServer.
main(String[]) - Static method in class org.hsqldb.sample.TriggerSample
main(String[]) - Static method in class org.hsqldb.util.SqlTool
  A static wrapper for objectMain, so that that method may be executed as a Java "program".
moveToCurrentRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the remembered cursor position, usually the current row.
moveToInsertRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the insert row.

## N

nativeSQL(String) - Method in class org.hsqldb.jdbc.jdbcConnection
  Converts the given SQL statement into the system's native SQL grammar.
next() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor down one row from its current position.
nullArgument() - Static method in class org.hsqldb.jdbc.Util
nullPlusNonNullIsNull() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports concatenations between `NULL` and non-`NULL` values being `NULL`.
nullsAreSortedAtEnd() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether `NULL` values are sorted at the end regardless of sort order.
nullsAreSortedAtStart() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether `NULL` values are sorted at the start regardless of sort order.
nullsAreSortedHigh() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether `NULL` values are sorted high.
nullsAreSortedLow() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether `NULL` values are sorted low.

## O

objectMain(String[]) - Static method in class org.hsqldb.util.SqlTool
  Connect to a JDBC Database and execute the commands given on stdin or in SQL file(s).
org.hsqldb.jdbc - package org.hsqldb.jdbc
othersDeletesAreVisible(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether deletes made by others are visible.
othersInsertsAreVisible(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether inserts made by others are visible.
othersUpdatesAreVisible(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether updates made by others are visible.
outOfRangeArgument() - Static method in class org.hsqldb.jdbc.Util
outOfRangeArgument(String) - Static method in class org.hsqldb.jdbc.Util
ownDeletesAreVisible(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a result set's own deletes are visible.
ownInsertsAreVisible(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a result set's own inserts are visible.
ownUpdatesAreVisible(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether for the given type of `ResultSet` object, the result set's own updates are visible.

## P

position(byte[], long) - Method in class org.hsqldb.jdbc.jdbcBlob
  Retrieves the byte position at which the specified byte array `pattern` begins within the `BLOB` value that this `Blob` object represents.
position(Blob, long) - Method in class org.hsqldb.jdbc.jdbcBlob
  Retrieves the byte position in the `BLOB` value designated by this `Blob` object at which `pattern` begins.
position(String, long) - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves the character position at which the specified substring `searchstr` appears in the SQL `CLOB` value represented by this `Clob` object.
position(Clob, long) - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves the character position at which the specified `Clob` object `searchstr` appears in this `Clob` object.
precision - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's value's number of decimal digits.
prepareCall(String) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `CallableStatement` object for calling database stored procedures.
prepareCall(String, int, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `CallableStatement` object that will generate `ResultSet` objects with the given type and concurrency.
prepareCall(String, int, int, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `CallableStatement` object that will generate `ResultSet` objects with the given type and concurrency.
prepareStatement(String) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `PreparedStatement` object for sending parameterized SQL statements to the database.
prepareStatement(String, int, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `PreparedStatement` object that will generate `ResultSet` objects with the given type and concurrency.
prepareStatement(String, int, int, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a `PreparedStatement` object that will generate `ResultSet` objects with the given type, concurrency, and holdability.
prepareStatement(String, int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a default `PreparedStatement` object that has the capability to retrieve auto-generated keys.
prepareStatement(String, int[]) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a default `PreparedStatement` object capable of returning the auto-generated keys designated by the given array.
prepareStatement(String, String[]) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a default `PreparedStatement` object capable of returning the auto-generated keys designated by the given array.
previous() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor to the previous row in this `ResultSet` object.
putPropertiesFromFile(String) - Method in class org.hsqldb.Server
  Attempts to put properties from the file with the specified path.
putPropertiesFromString(String) - Method in class org.hsqldb.Server
  Puts properties from the supplied string argument.

## R

RCData - class org.hsqldb.util.RCData.
  All the info we need to connect up to a database.
RCData(File, String) - Constructor for class org.hsqldb.util.RCData
  Creates a RCDataObject by looking up the given key in the given authentication file.
RCData(String, String, String, String, String, String, String) - Constructor for class org.hsqldb.util.RCData
  Convenience constructor for backward compatibility.
RCData(String, String, String, String, String, String, String, String) - Constructor for class org.hsqldb.util.RCData
  Creates a new `RCData` object.
RCERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
rResult - Variable in class org.hsqldb.jdbc.jdbcResultSet
  The internal representation.
refreshRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Refreshes the current row with its most recent value in the database.
registerOutParameter(int, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
registerOutParameter(int, int, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
registerOutParameter(int, int, String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Registers the designated output parameter.
registerOutParameter(String, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
registerOutParameter(String, int, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
registerOutParameter(String, int, String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Registers the designated output parameter.
relative(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Moves the cursor a relative number of rows, either positive or negative.
releaseSavepoint(Savepoint) - Method in class org.hsqldb.jdbc.jdbcConnection
  Removes the given `Savepoint` object from the current transaction.
report() - Method in class org.hsqldb.util.RCData
  Just for testing and debugging.
reset() - Method in class org.hsqldb.jdbc.jdbcConnection
  Resets this connection so it can be used again.
rollback() - Method in class org.hsqldb.jdbc.jdbcConnection
  Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.
rollback(Savepoint) - Method in class org.hsqldb.jdbc.jdbcConnection
  Undoes all changes made after the given `Savepoint` object was set.
rowDeleted() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether a row has been deleted.
rowInserted() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether the current row has had an insertion.
rowUpdated() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Retrieves whether the current row has been updated.

## S

SQLERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
SQLTOOLERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
SYNTAXERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
Server - class org.hsqldb.Server.
  The HSQLDB HSQL protocol network database server.
Server() - Constructor for class org.hsqldb.Server
  Creates a new Server instance handling HSQL protocol connections.
SqlTool - class org.hsqldb.util.SqlTool.
  Sql Tool.
SqlTool() - Constructor for class org.hsqldb.util.SqlTool
SqlTool.SqlToolException - exception org.hsqldb.util.SqlTool.SqlToolException.
scale - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's value's number of digits to right of the decimal point.
schemaName - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's table's schema.
setAddress(String) - Method in class org.hsqldb.Server
  Sets the InetAddress with which this server's ServerSocket will be constructed.
setArray(int, Array) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `Array` object.
setAsciiStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAsciiStream(long) - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves a stream to be used to write Ascii characters to the `CLOB` value that this `Clob` object represents, starting at position `pos`.
setAsciiStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAutoCommit(boolean) - Method in class org.hsqldb.jdbc.jdbcConnection
  Sets this connection's auto-commit mode to the given state.
setBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.math.BigDecimal` value.
setBigDecimal(int, BigDecimal) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.math.BigDecimal` value.
setBinaryStream(long) - Method in class org.hsqldb.jdbc.jdbcBlob
  Retrieves a stream that can be used to write to the `BLOB` value that this `Blob` object represents.
setBinaryStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBinaryStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBlob(int, Blob) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `Blob` object.
setBoolean(String, boolean) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `boolean` value.
setBoolean(int, boolean) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `boolean` value.
setByte(String, byte) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `byte` value.
setByte(int, byte) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `byte` value.
setBytes(long, byte[]) - Method in class org.hsqldb.jdbc.jdbcBlob
  Writes the given array of bytes to the `BLOB` value that this `Blob` object represents, starting at position `pos`, and returns the number of bytes written.
setBytes(long, byte[], int, int) - Method in class org.hsqldb.jdbc.jdbcBlob
  Writes all or part of the given `byte` array to the `BLOB` value that this `Blob` object represents and returns the number of bytes written.
setBytes(String, byte[]) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java array of bytes.
setBytes(int, byte[]) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java array of bytes.
setCatalog(String) - Method in class org.hsqldb.jdbc.jdbcConnection
  Sets a catalog name in order to select a subspace of this Connection's database in which to work.
setCharacterStream(String, Reader, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
setCharacterStream(long) - Method in class org.hsqldb.jdbc.jdbcClob
  Retrieves a stream to be used to write a stream of Unicode characters to the `CLOB` value that this `Clob` object represents, at position `pos`.
setCharacterStream(int, Reader, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
setClob(int, Clob) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `Clob` object.
setCursorName(String) - Method in class org.hsqldb.jdbc.jdbcStatement
  Sets the SQL cursor name to the given `String`, which will be used by subsequent `Statement` object `execute` methods.
setDatabase(String) - Method in class org.hsqldb.jdbc.jdbcDataSource
  Assigns the value of this object's jdbc database connection url attribute.
setDatabaseName(int, String) - Method in class org.hsqldb.Server
  Sets the external name (url alias) of the i'th hosted database.
setDatabasePath(int, String) - Method in class org.hsqldb.Server
  Sets the path of the hosted database.
setDate(String, Date) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  (JDBC4 clarification:) Sets the designated parameter to the given `java.sql.Date` value using the default time zone of the virtual machine that is running the application.
setDate(String, Date, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
setDate(int, Date) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.sql.Date` value.
setDate(int, Date, Calendar) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
setDefaultJdbcDriver(String) - Method in class org.hsqldb.util.RCData
setDefaultWebPage(String) - Method in class org.hsqldb.Server
  Sets the name of the web page served when no page is specified.
setDouble(String, double) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `double` value.
setDouble(int, double) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `double` value.
setErrWriter(PrintWriter) - Method in class org.hsqldb.Server
  Sets the PrintWriter to which server errors are logged.
setEscapeProcessing(boolean) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets escape processing on or off.
setEscapeProcessing(boolean) - Method in class org.hsqldb.jdbc.jdbcStatement
  Sets escape processing on or off.
setFetchDirection(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
setFetchDirection(int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Gives the driver a hint as to the direction in which rows will be processed in `ResultSet` objects created using this `Statement` object.
setFetchSize(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this `ResultSet` object.
setFetchSize(int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
setFloat(String, float) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `float` value.
setFloat(int, float) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `float` value.
setHoldability(int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Changes the holdability of `ResultSet` objects created using this `Connection` object to the given holdability.
setInt(String, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `int` value.
setInt(int, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `int` value.
setLogWriter(PrintWriter) - Method in class org.hsqldb.Server
  Sets the PrintWriter to which server messages are logged.
setLogWriter(PrintWriter) - Method in class org.hsqldb.jdbc.jdbcDataSource
  Sets the log writer for this `DataSource` object to the given `java.io.PrintWriter` object.
setLoginTimeout(int) - Method in class org.hsqldb.jdbc.jdbcDataSource
  Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
setLong(String, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `long` value.
setLong(int, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `long` value.
setMaxFieldSize(int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Sets the limit for the maximum number of bytes in a `ResultSet` column storing character or binary values to the given number of bytes.
setMaxRows(int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Sets the limit for the maximum number of rows that any `ResultSet` object can contain to the given number.
setNoSystemExit(boolean) - Method in class org.hsqldb.Server
  Sets whether this server calls System.exit() when shutdown.
setNull(String, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to SQL `NULL`.
setNull(String, int, String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to SQL `NULL`.
setNull(int, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to SQL `NULL`.
setNull(int, int, String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to SQL `NULL`.
setObject(String, Object, int, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the value of the designated parameter with the given object.
setObject(String, Object, int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the value of the designated parameter with the given object.
setObject(String, Object) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the value of the designated parameter with the given object.
setObject(int, Object, int, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the value of the designated parameter with the given object.
setObject(int, Object, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the value of the designated parameter with the given object.
setObject(int, Object) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the value of the designated parameter using the given object.
setPassword(String) - Method in class org.hsqldb.jdbc.jdbcDataSource
  Sets the password to use for connecting to the database
setPort(int) - Method in class org.hsqldb.Server
  Sets the server listen port.
setProperties(HsqlProperties) - Method in class org.hsqldb.Server
  Sets server properties using the specified properties object
setQueryTimeout(int) - Method in class org.hsqldb.jdbc.jdbcStatement
  Sets the number of seconds the driver will wait for a `Statement` object to execute to the given number of seconds.
setReadOnly(boolean) - Method in class org.hsqldb.jdbc.jdbcConnection
  Puts this connection in read-only mode as a hint to enable database optimizations.
setRef(int, Ref) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `REF(<structured-type>)` value.
setRestartOnShutdown(boolean) - Method in class org.hsqldb.Server
  Sets whether this server restarts on shutdown.
setSavepoint() - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates an unnamed savepoint in the current transaction and returns the new `Savepoint` object that represents it.
setSavepoint(String) - Method in class org.hsqldb.jdbc.jdbcConnection
  Creates a savepoint with the given name in the current transaction and returns the new `Savepoint` object that represents it.
setShort(String, short) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `short` value.
setShort(int, short) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `short` value.
setSilent(boolean) - Method in class org.hsqldb.Server
  Sets silent mode operation
setString(String, String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given Java `String` value.
setString(long, String) - Method in class org.hsqldb.jdbc.jdbcClob
  Writes the given Java `String` to the `CLOB` value that this `Clob` object designates at the position `pos`.
setString(long, String, int, int) - Method in class org.hsqldb.jdbc.jdbcClob
  Writes `len` characters of `str`, starting at character `offset`, to the `CLOB` value that this `Clob` represents.
setString(int, String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given Java `String` value.
setTime(String, Time) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.sql.Time` value.
setTime(String, Time, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
setTime(int, Time) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.sql.Time` value.
setTime(int, Time, Calendar) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
setTimestamp(String, Timestamp) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.sql.Timestamp` value.
setTimestamp(String, Timestamp, Calendar) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
setTimestamp(int, Timestamp) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.sql.Timestamp` value.
setTimestamp(int, Timestamp, Calendar) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
setTls(boolean) - Method in class org.hsqldb.Server
  Sets whether to use secure sockets
setTrace(boolean) - Method in class org.hsqldb.Server
  Sets whether trace messages go to System.out or the DriverManger PrintStream/PrintWriter, if any.
setTransactionIsolation(int) - Method in class org.hsqldb.jdbc.jdbcConnection
  Attempts to change the transaction isolation level for this `Connection` object to the one given.
setTypeMap(Map) - Method in class org.hsqldb.jdbc.jdbcConnection
  Installs the given `TypeMap` object as the type map for this `Connection` object.
setURL(String, URL) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Sets the designated parameter to the given `java.net.URL` object.
setURL(int, URL) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Sets the designated parameter to the given `java.net.URL` value.
setUnicodeStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Deprecated. Sun does not include a reason, but presumably this is because setCharacterStream is now prefered
setUser(String) - Method in class org.hsqldb.jdbc.jdbcDataSource
  Sets the userid
setWebRoot(String) - Method in class org.hsqldb.Server
  Sets the path of the root directory from which web content is served.
shutdown() - Method in class org.hsqldb.Server
  External method to shut down this server.
signalCloseAllServerConnections() - Method in class org.hsqldb.Server
  Closes all connections to this Server.
sqlException(HsqlException) - Static method in class org.hsqldb.jdbc.Util
sqlWarning(HsqlException) - Static method in class org.hsqldb.jdbc.Util
start() - Method in class org.hsqldb.Server
  Starts this server synchronously.
stop() - Method in class org.hsqldb.Server
  Stops this server asynchronously.
storesLowerCaseIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
storesLowerCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
storesMixedCaseIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
storesMixedCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
storesUpperCaseIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
storesUpperCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
supportsANSI92EntryLevelSQL() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the ANSI92 entry level SQL grammar.
supportsANSI92FullSQL() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the ANSI92 full SQL grammar supported.
supportsANSI92IntermediateSQL() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
supportsAlterTableWithAddColumn() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports `ALTER TABLE` with add column.
supportsAlterTableWithDropColumn() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports `ALTER TABLE` with drop column.
supportsBatchUpdates() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports batch updates.
supportsCatalogsInDataManipulation() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a catalog name can be used in a data manipulation statement.
supportsCatalogsInIndexDefinitions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a catalog name can be used in an index definition statement.
supportsCatalogsInPrivilegeDefinitions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a catalog name can be used in a privilege definition statement.
supportsCatalogsInProcedureCalls() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a catalog name can be used in a procedure call statement.
supportsCatalogsInTableDefinitions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a catalog name can be used in a table definition statement.
supportsColumnAliasing() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports column aliasing.
supportsConvert() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the `CONVERT` function between SQL types.
supportsConvert(int, int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the `CONVERT` for two given SQL types.
supportsCoreSQLGrammar() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the ODBC Core SQL grammar.
supportsCorrelatedSubqueries() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
supportsDataManipulationTransactionsOnly() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports only data manipulation statements within a transaction.
supportsDifferentTableCorrelationNames() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
supportsExpressionsInOrderBy() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports expressions in `ORDER BY` lists.
supportsExtendedSQLGrammar() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the ODBC Extended SQL grammar.
supportsFullOuterJoins() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports full nested outer joins.
supportsGetGeneratedKeys() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
supportsGroupBy() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports some form of `GROUP BY` clause.
supportsGroupByBeyondSelect() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports using columns not included in the `SELECT` statement in a `GROUP BY` clause provided that all of the columns in the `SELECT` statement are included in the `GROUP BY` clause.
supportsGroupByUnrelated() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports using a column that is not in the `SELECT` statement in a `GROUP BY` clause.
supportsIntegrityEnhancementFacility() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the SQL Integrity Enhancement Facility.
supportsLikeEscapeClause() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports specifying a `LIKE` escape clause.
supportsLimitedOuterJoins() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database provides limited support for outer joins.
supportsMinimumSQLGrammar() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the ODBC Minimum SQL grammar.
supportsMixedCaseIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
supportsMixedCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
supportsMultipleOpenResults() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether it is possible to have multiple `ResultSet` objects returned from a `CallableStatement` object simultaneously.
supportsMultipleResultSets() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports getting multiple `ResultSet` objects from a single call to the method `execute`.
supportsMultipleTransactions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database allows having multiple transactions open at once (on different connections).
supportsNamedParameters() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports named parameters to callable statements.
supportsNonNullableColumns() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether columns in this database may be defined as non-nullable.
supportsOpenCursorsAcrossCommit() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports keeping cursors open across commits.
supportsOpenCursorsAcrossRollback() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports keeping cursors open across rollbacks.
supportsOpenStatementsAcrossCommit() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports keeping statements open across commits.
supportsOpenStatementsAcrossRollback() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports keeping statements open across rollbacks.
supportsOrderByUnrelated() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports using a column that is not in the `SELECT` statement in an `ORDER BY` clause.
supportsOuterJoins() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports some form of outer join.
supportsPositionedDelete() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports positioned `DELETE` statements.
supportsPositionedUpdate() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports positioned `UPDATE` statements.
supportsResultSetConcurrency(int, int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the given concurrency type in combination with the given result set type.
supportsResultSetHoldability(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the given result set holdability.
supportsResultSetType(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the given result set type.
supportsSavepoints() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports savepoints.
supportsSchemasInDataManipulation() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a schema name can be used in a data manipulation statement.
supportsSchemasInIndexDefinitions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a schema name can be used in an index definition statement.
supportsSchemasInPrivilegeDefinitions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a schema name can be used in a privilege definition statement.
supportsSchemasInProcedureCalls() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a schema name can be used in a procedure call statement.
supportsSchemasInTableDefinitions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether a schema name can be used in a table definition statement.
supportsSelectForUpdate() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports `SELECT FOR UPDATE` statements.
supportsStatementPooling() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports statement pooling.
supportsStoredProcedures() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
supportsSubqueriesInComparisons() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports subqueries in comparison expressions.
supportsSubqueriesInExists() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports subqueries in `EXISTS` expressions.
supportsSubqueriesInIns() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  JDBC4 correction: Retrieves whether this database supports subqueries in `IN` expressions.
supportsSubqueriesInQuantifieds() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports subqueries in quantified expressions.
supportsTableCorrelationNames() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports table correlation names.
supportsTransactionIsolationLevel(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports the given transaction isolation level.
supportsTransactions() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports transactions.
supportsUnion() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports SQL `UNION`.
supportsUnionAll() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database supports SQL `UNION ALL`.

## T

TYPE_FORWARD_ONLY - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
TYPE_SCROLL_INSENSITIVE - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
TYPE_SCROLL_SENSITIVE - Static variable in class org.hsqldb.jdbc.jdbcResultSet
  Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
Trigger - interface org.hsqldb.Trigger.
  The interface an HSQLDB TRIGGER must implement.
TriggerSample - class org.hsqldb.sample.TriggerSample.
  Sample code for use of triggers in hsqldb.
TriggerSample() - Constructor for class org.hsqldb.sample.TriggerSample
tableName - Variable in class org.hsqldb.jdbc.jdbcColumnMetaData
  The column's table's name.
toString() - Method in class org.hsqldb.jdbc.jdbcColumnMetaData
  Retrieves a String representation of this object.
toString() - Method in class org.hsqldb.jdbc.jdbcParameterMetaData
  Retrieves a String repsentation of this object.
toString() - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
  Retrieves a String representation of this object.
toString() - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
toString() - Method in class org.hsqldb.jdbc.jdbcSavepoint
truncate(long) - Method in class org.hsqldb.jdbc.jdbcBlob
  Truncates the `BLOB` value that this `Blob` object represents to be `len` bytes in length.
truncate(long) - Method in class org.hsqldb.jdbc.jdbcClob
  Truncates the `CLOB` value that this `Clob` designates to have a length of `len` characters.

## U

UPDATE_AFTER - Static variable in interface org.hsqldb.Trigger
UPDATE_AFTER_ROW - Static variable in interface org.hsqldb.Trigger
UPDATE_BEFORE - Static variable in interface org.hsqldb.Trigger
UPDATE_BEFORE_ROW - Static variable in interface org.hsqldb.Trigger
Util - class org.hsqldb.jdbc.Util.
  Provides driver constants and a gateway from internal HsqlExceptions to external SQLExceptions.
Util() - Constructor for class org.hsqldb.jdbc.Util
updateArray(int, Array) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Array` value.
updateArray(String, Array) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Array` value.
updateAsciiStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an ascii stream value.
updateAsciiStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an ascii stream value.
updateBigDecimal(int, BigDecimal) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.math.BigDecimal` value.
updateBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.BigDecimal` value.
updateBinaryStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a binary stream value.
updateBinaryStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a binary stream value.
updateBlob(int, Blob) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Blob` value.
updateBlob(String, Blob) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Blob` value.
updateBoolean(int, boolean) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `boolean` value.
updateBoolean(String, boolean) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `boolean` value.
updateByte(int, byte) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `byte` value.
updateByte(String, byte) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `byte` value.
updateBytes(int, byte[]) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `byte` array value.
updateBytes(String, byte[]) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a byte array value.
updateCharacterStream(int, Reader, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a character stream value.
updateCharacterStream(String, Reader, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a character stream value.
updateClob(int, Clob) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Clob` value.
updateClob(String, Clob) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Clob` value.
updateDate(int, Date) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Date` value.
updateDate(String, Date) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Date` value.
updateDouble(int, double) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `double` value.
updateDouble(String, double) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `double` value.
updateFloat(int, float) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `float` value.
updateFloat(String, float) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `float` value.
updateInt(int, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an `int` value.
updateInt(String, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an `int` value.
updateLong(int, long) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `long` value.
updateLong(String, long) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `long` value.
updateNull(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Gives a nullable column a null value.
updateNull(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `null` value.
updateObject(int, Object, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an `Object` value.
updateObject(int, Object) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an `Object` value.
updateObject(String, Object, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an `Object` value.
updateObject(String, Object) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with an `Object` value.
updateRef(int, Ref) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Ref` value.
updateRef(String, Ref) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Ref` value.
updateRow() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the underlying database with the new contents of the current row of this `ResultSet` object.
updateShort(int, short) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `short` value.
updateShort(String, short) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `short` value.
updateString(int, String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `String` value.
updateString(String, String) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `String` value.
updateTime(int, Time) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Time` value.
updateTime(String, Time) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Time` value.
updateTimestamp(int, Timestamp) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Timestamp` value.
updateTimestamp(String, Timestamp) - Method in class org.hsqldb.jdbc.jdbcResultSet
  Updates the designated column with a `java.sql.Timestamp` value.
updatesAreDetected(int) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
usesLocalFilePerTable() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database uses a file for each table.
usesLocalFiles() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
  Retrieves whether this database stores tables in a local file.

## W

WebServer - class org.hsqldb.WebServer.
  The HSQLDB HTTP protocol network database server.
WebServer() - Constructor for class org.hsqldb.WebServer
wasNull() - Method in class org.hsqldb.jdbc.jdbcCallableStatement
  Retrieves whether the last OUT parameter read had the value of SQL `NULL`.
wasNull() - Method in class org.hsqldb.jdbc.jdbcResultSet
  Reports whether the last column read had a value of SQL `NULL`.

A B C D E F G H I J L M N O P R S T U W

Overview | Package | Class | Use | Tree | Deprecated | Index | Help

PREV NEXT | FRAMES NO FRAMES

Copyright © 2001 - 2005 HSQL Development Group. All Rights Reserved.