- generatedKeyAlwaysReturned() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- 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
-
- 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
-
- getBigDecimal(String, int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- 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(long, long) - Method in class org.hsqldb.jdbc.jdbcBlob
-
- getBinaryStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as a binary stream of
uninterpreted bytes.
- getBinaryStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as a stream of uninterpreted
byte
s.
- getBlob(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of the designated JDBC BLOB
parameter as a Blob
object in the Java
programming language.
- getBlob(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of a JDBC BLOB
parameter as a
Blob
object in the Java programming language.
- getBlob(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as a Blob
object
in the Java programming language.
- getBlob(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as a Blob
object
in the Java programming language.
- getBoolean(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of the designated JDBC BIT
parameter
as a boolean
in the Java programming language.
- getBoolean(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
(JDBC4 modified:) Retrieves the value of a JDBC BIT
or BOOLEAN
parameter as a
boolean
in the Java programming language.
- getBoolean(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as
a boolean
in the Java programming language.
- getBoolean(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as
a boolean
in the Java programming language.
- getByte(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of the designated JDBC TINYINT
parameter as a byte
in the Java programming language.
- getByte(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of a JDBC TINYINT
parameter as a
byte
in the Java programming language.
- getByte(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as
a byte
in the Java programming language.
- getByte(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as
a byte
in the Java programming language.
- getBytes(long, int) - Method in class org.hsqldb.jdbc.jdbcBlob
-
Retrieves all or part of the BLOB
value that this
Blob
object represents, as an array of bytes.
- getBytes(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of the designated JDBC BINARY
or
VARBINARY
parameter as an array of byte
values in the Java programming language.
- getBytes(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
Retrieves the value of a JDBC BINARY
or
VARBINARY
parameter as an array of byte
values in the Java programming language.
- getBytes(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as
a byte
array in the Java programming language.
- getBytes(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the value of the designated column in the current row
of this ResultSet
object as
a byte
array in the Java programming language.
- getCatalog() - Method in class org.hsqldb.jdbc.jdbcConnection
-
Returns the Connection's current catalog name.
- getCatalogName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
-
Gets the designated column's table's catalog name.
- getCatalogs() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the catalog names available in this database.
- 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".
- getCharacterStream(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getCharacterStream(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- 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(long, long) - Method in class org.hsqldb.jdbc.jdbcClob
-
- 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.
- getClientInfo(String) - Method in class org.hsqldb.jdbc.jdbcConnection
-
- getClientInfo() - Method in class org.hsqldb.jdbc.jdbcConnection
-
- getClientInfoProperties() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- 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.
- getColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves a description of table columns available in
the specified catalog.
- 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.
- getConcurrency() - Method in class org.hsqldb.jdbc.jdbcResultSet
-
Retrieves the concurrency mode of this ResultSet
object.
- getConnection() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the connection that produced this metadata 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.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
-
- getFunctionColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- getFunctions(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- 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.
- getHoldability() - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- 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.
- 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.
- getLogWriter() - Method in class org.hsqldb.jdbc.jdbcDataSource
-
Retrieves the log writer for this DataSource
object.
- getLogWriter() - Method in class org.hsqldb.Server
-
Retrieves the PrintWriter to which server messages are printed.
- 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.
- 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.
- getMaxRowSize() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the maximum number of bytes this database allows in
a single row.
- 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.
- getNCharacterStream(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getNCharacterStream(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getNCharacterStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getNCharacterStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getNClob(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getNClob(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getNClob(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getNClob(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getNetworkTimeout() - Method in class org.hsqldb.jdbc.jdbcConnection
-
- getNString(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getNString(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getNString(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getNString(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- 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(String, Class<T>) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getObject(int, Class<T>) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- 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.
- getObject(String, Class<T>) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getObject(int, Class<T>) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- 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.
- getParentLogger() - Method in class org.hsqldb.jdbc.jdbcDataSource
-
- getParentLogger() - Method in class org.hsqldb.jdbcDriver
-
- 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.
- getProcedures(String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves a description of the stored procedures available in the given
catalog.
- getProcedureTerm() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the database vendor's preferred term for "procedure".
- 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'.
- getPseudoColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- 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.
- getRowId(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getRowId(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getRowId(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getRowId(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getRowIdLifetime() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- 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.
- getSchema() - Method in class org.hsqldb.jdbc.jdbcConnection
-
- getSchemaName(int) - Method in class org.hsqldb.jdbc.jdbcResultSetMetaData
-
Get the designated column's table's schema.
- getSchemas() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the schema names available in this database.
- getSchemas(String, String) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- getSchemaTerm() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the database vendor's preferred term for "schema".
- 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.
- 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.
- getSQLXML(int) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getSQLXML(String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- getSQLXML(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getSQLXML(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- 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.
- getTables(String, String, String, String[]) - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves a description of the tables available in the given catalog.
- getTableTypes() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
Retrieves the table types available in this database.
- 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.
- getUnicodeStream(int) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- getUnicodeStream(String) - Method in class org.hsqldb.jdbc.jdbcResultSet
-
- 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.
- 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.
- 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
-
- 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.
- Server - Class in org.hsqldb
-
The HSQLDB HSQL protocol network database server.
- Server() - Constructor for class org.hsqldb.Server
-
Creates a new Server instance handling HSQL protocol connections.
- 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(int, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setAsciiStream(int, InputStream) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setAsciiStream(String, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setAsciiStream(String, InputStream) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- 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.
- setAsciiStream(int, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setAsciiStream(int, InputStream) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBinaryStream(int, InputStream) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBinaryStream(String, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBinaryStream(String, InputStream) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- 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.
- setBinaryStream(int, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setBinaryStream(int, InputStream) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setBlob(int, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBlob(int, InputStream) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBlob(String, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBlob(String, Blob) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBlob(String, InputStream) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setBlob(int, Blob) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
Sets the designated parameter to the given Blob
object.
- setBlob(int, InputStream, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setBlob(int, InputStream) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- 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.
- setCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setClientInfo(String, String) - Method in class org.hsqldb.jdbc.jdbcConnection
-
- setClientInfo(Properties) - Method in class org.hsqldb.jdbc.jdbcConnection
-
- setClob(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setClob(int, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setClob(String, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setClob(String, Clob) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setClob(String, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setClob(int, Clob) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
Sets the designated parameter to the given Clob
object.
- setClob(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setClob(int, Reader) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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.
- 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.
- setLogWriter(PrintWriter) - Method in class org.hsqldb.jdbc.jdbcDataSource
-
Sets the log writer for this DataSource
object to the given java.io.PrintWriter
object.
- setLogWriter(PrintWriter) - Method in class org.hsqldb.Server
-
Sets the PrintWriter to which server messages are logged.
- 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.
- setNCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setNCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setNClob(int, NClob) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNClob(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNClob(int, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNClob(String, NClob) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNClob(String, Reader, long) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNClob(String, Reader) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNClob(int, NClob) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setNClob(int, Reader, long) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setNClob(int, Reader) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setNetworkTimeout(Executor, int) - Method in class org.hsqldb.jdbc.jdbcConnection
-
- setNoSystemExit(boolean) - Method in class org.hsqldb.Server
-
Sets whether this server calls System.exit() when shutdown.
- setNString(int, String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNString(String, String) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setNString(int, String) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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
- setPoolable(boolean) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setPoolable(boolean) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- setPoolable(boolean) - Method in class org.hsqldb.jdbc.jdbcStatement
-
- 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.
- setRowId(int, RowId) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setRowId(String, RowId) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setRowId(int, RowId) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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.
- setSchema(String) - Method in class org.hsqldb.jdbc.jdbcConnection
-
- 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
- setSQLXML(int, SQLXML) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setSQLXML(String, SQLXML) - Method in class org.hsqldb.jdbc.jdbcCallableStatement
-
- setSQLXML(int, SQLXML) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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.
- setUnicodeStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.jdbcPreparedStatement
-
- 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.
- 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.
- SQLERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
-
- sqlException(HsqlException) - Static method in class org.hsqldb.jdbc.Util
-
- SqlTool - Class in org.hsqldb.util
-
Sql Tool.
- SqlTool() - Constructor for class org.hsqldb.util.SqlTool
-
- SqlTool.SqlToolException - Exception in org.hsqldb.util
-
- SQLTOOLERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
-
- 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.
- 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.
- 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.
- 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.
- supportsStoredFunctionsUsingCallSyntax() - Method in class org.hsqldb.jdbc.jdbcDatabaseMetaData
-
- 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
.
- SYNTAXERR_EXITVAL - Static variable in class org.hsqldb.util.SqlTool
-