function windowTitle() { parent.document.title="Index (HSQLDB 1.8.0.10 API)"; }
Overview Package Class Use Tree Deprecated Index Help
PREV NEXT
FRAMES NO FRAMES
All Classes
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
bytes. 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