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

A

ACCESS_IS_DENIED - Static variable in class org.hsqldb.Trace
 
ASSERT_FAILED - Static variable in class org.hsqldb.Trace
 
ArrayUtil - class org.hsqldb.lib.ArrayUtil.
Collection of static methods for operations on arrays
ArrayUtil() - Constructor for class org.hsqldb.lib.ArrayUtil
 
AsciiStringInputStream - class org.hsqldb.lib.AsciiStringInputStream.
minimal InputStream subclass to fetch low order bytes form a String
AsciiStringInputStream(String) - Constructor for class org.hsqldb.lib.AsciiStringInputStream
 
absolute(int) - Method in class org.hsqldb.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.
action(Event, Object) - Method in class org.hsqldb.util.QueryTool
This is function handles the events when a button is clicked or when the used double-clicked on the listbox of recent commands.
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.ZaurusConnectionDialog
Method declaration
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.ZaurusDatabaseManager
Method declaration
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.ZaurusEditor
actionPerformed method is the main entry point which interprets the buttons and initiates the actions.
actionPerformed(ActionEvent) - Method in class org.hsqldb.util.ZaurusTableForm
 
add(Object) - Method in class org.hsqldb.lib.HsqlDeque
 
add(String, String) - Method in class org.hsqldb.util.ZaurusChoice
 
addBatch() - Method in class org.hsqldb.jdbcPreparedStatement
Adds a set of parameters to this PreparedStatement object's batch of commands.
addBatch(String) - Method in class org.hsqldb.jdbcStatement
Adds the given SQL command to the current list of commmands for this Statement object.
addFirst(Object) - Method in class org.hsqldb.lib.HsqlDeque
 
addLast(Object) - Method in class org.hsqldb.lib.HsqlDeque
 
addProperties(HsqlProperties) - Method in class org.hsqldb.HsqlProperties
 
afterLast() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the end of this ResultSet object, just after the last row.
allProceduresAreCallable() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether the current user can call all the procedures returned by the method getProcedures.
allTablesAreSelectable() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.
argArrayToProps(String[], String) - Static method in class org.hsqldb.HsqlProperties
 
available() - Method in class org.hsqldb.lib.AsciiStringInputStream
 
available() - Method in class org.hsqldb.lib.StringInputStream
 

B

BAD_ADD_COLUMN_DEFINITION - Static variable in class org.hsqldb.Trace
 
BAD_INDEX_CONSTRAINT_NAME - Static variable in class org.hsqldb.Trace
 
beforeFirst() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the front of this ResultSet object, just before the first row.

C

COLUMN_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
COLUMN_COUNT_DOES_NOT_MATCH - Static variable in class org.hsqldb.Trace
 
COLUMN_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
COLUMN_TYPE_MISMATCH - Static variable in class org.hsqldb.Trace
 
CONNECTION_IS_BROKEN - Static variable in class org.hsqldb.Trace
 
CONNECTION_IS_CLOSED - Static variable in class org.hsqldb.Trace
 
CONSTRAINT_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
CONSTRAINT_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
CodeSwitcher - class org.hsqldb.util.CodeSwitcher.
Modifies the source code to support different JDK or profile settings.
ConnectionTypesSample - class org.hsqldb.sample.ConnectionTypesSample.
 
ConnectionTypesSample() - Constructor for class org.hsqldb.sample.ConnectionTypesSample
 
cancel() - Method in class org.hsqldb.jdbcStatement
Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
cancelChanges() - Method in class org.hsqldb.util.ZaurusTableForm
 
cancelRowUpdates() - Method in class org.hsqldb.jdbcResultSet
Cancels the updates made to the current row in this ResultSet object.
checkFileExists() - Method in class org.hsqldb.HsqlProperties
 
clear() - Method in class org.hsqldb.lib.HsqlDeque
 
clearBatch() - Method in class org.hsqldb.jdbcStatement
Empties this Statement object's current list of SQL commands.
clearChanges() - Method in class org.hsqldb.util.ZaurusChoice
 
clearChanges() - Method in interface org.hsqldb.util.ZaurusComponent
 
clearChanges() - Method in class org.hsqldb.util.ZaurusTextField
 
clearContent() - Method in class org.hsqldb.util.ZaurusChoice
 
clearContent() - Method in interface org.hsqldb.util.ZaurusComponent
 
clearContent() - Method in class org.hsqldb.util.ZaurusTextField
 
clearParameters() - Method in class org.hsqldb.jdbcPreparedStatement
Clears the current parameter values immediately.
clearStatus() - Static method in class org.hsqldb.util.ZaurusEditor
The class method clearStatus deletes the status line.
clearWarnings() - Method in class org.hsqldb.jdbcConnection
Clears all warnings reported for this Connection object.
clearWarnings() - Method in class org.hsqldb.jdbcResultSet
Clears all warnings reported on this ResultSet object.
clearWarnings() - Method in class org.hsqldb.jdbcStatement
Clears all the warnings reported on this Statement object.
close() - Method in class org.hsqldb.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.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.jdbcStatement
Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
commit() - Method in class org.hsqldb.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.
copyAdjustArray(Object[], Object[], Object, int, int) - Static method in class org.hsqldb.lib.ArrayUtil
Copies elements of source to dest.
copyArray(int[], int[], int) - Static method in class org.hsqldb.lib.ArrayUtil
 
copyColumnValues(Object[], int[], Object[]) - Static method in class org.hsqldb.lib.ArrayUtil
Copies some elements of row into colobject by using colindex as the list of indexes into row.
createConnection(Frame, String, Insets) - Static method in class org.hsqldb.util.ZaurusConnectionDialog
Method declaration
createHsqlServer(String, boolean, boolean) - Static method in class org.hsqldb.HsqlServerFactory
 
createStatement() - Method in class org.hsqldb.jdbcConnection
Creates a Statement object for sending SQL statements to the database.
createStatement(int, int) - Method in class org.hsqldb.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.jdbcConnection
Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.

D

DATABASE_ALREADY_IN_USE - Static variable in class org.hsqldb.Trace
 
DATABASE_IS_MEMORY_ONLY - Static variable in class org.hsqldb.Trace
 
DATABASE_IS_READONLY - Static variable in class org.hsqldb.Trace
 
DATABASE_IS_SHUTDOWN - Static variable in class org.hsqldb.Trace
 
DATA_IS_READONLY - Static variable in class org.hsqldb.Trace
 
DEFAULT_HSQLDB_PORT - Static variable in class org.hsqldb.jdbcConnection
Used when no port is explicitly specified in the url for a network Connection of type HSQLDB.
DIVISION_BY_ZERO - Static variable in class org.hsqldb.Trace
 
DOASSERT - Static variable in class org.hsqldb.Trace
 
DROP_FK_INDEX - Static variable in class org.hsqldb.Trace
 
DROP_PRIMARY_KEY - Static variable in class org.hsqldb.Trace
 
DROP_SYSTEM_CONSTRAINT - Static variable in class org.hsqldb.Trace
 
DatabaseManager - class org.hsqldb.util.DatabaseManager.
AWT Tool for manageing a JDBC database.
DatabaseManager() - Constructor for class org.hsqldb.util.DatabaseManager
 
DatabaseManagerSample - class org.hsqldb.sample.DatabaseManagerSample.
 
DatabaseManagerSample() - Constructor for class org.hsqldb.sample.DatabaseManagerSample
 
DatabaseManagerSwing - class org.hsqldb.util.DatabaseManagerSwing.
Swing Tool for manageing a JDBC database.
DatabaseManagerSwing() - Constructor for class org.hsqldb.util.DatabaseManagerSwing
 
dataDefinitionCausesTransactionCommit() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a data definition statement within a transaction forces the transaction to commit.
dataDefinitionIgnoredInTransactions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database ignores a data definition statement within a transaction.
datasetPath - Static variable in class org.hsqldb.test.TestSubselect
 
dateValue(String) - Static method in class org.hsqldb.lib.HsqlDateTime
Converts a string in JDBC date escape format to a Date value.
deleteRow() - Method in class org.hsqldb.jdbcResultSet
Deletes the current row from this ResultSet object and from the underlying database.
deleteRow() - Method in class org.hsqldb.util.ZaurusTableForm
 
deletesAreDetected(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.
doGet(HttpServletRequest, HttpServletResponse) - Method in class org.hsqldb.Servlet
Method declaration
doPost(HttpServletRequest, HttpServletResponse) - Method in class org.hsqldb.Servlet
Method declaration
doesMaxRowSizeIncludeBlobs() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

E

ERROR_IN_FUNCTION - Static variable in class org.hsqldb.Trace
 
EXTERNAL_STOP - Static variable in class org.hsqldb.Trace
 
elements() - Method in class org.hsqldb.lib.HsqlDeque
 
error(int) - Static method in class org.hsqldb.Trace
Method declaration
error(int, String) - Static method in class org.hsqldb.Trace
Method declaration
error(int, int) - Static method in class org.hsqldb.Trace
Method declaration
execute() - Method in class org.hsqldb.jdbcPreparedStatement
Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
execute(String) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which may return multiple results.
execute(String, int) - Method in class org.hsqldb.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.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.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[]) - Method in class org.hsqldb.util.ScriptTool
 
executeBatch() - Method in class org.hsqldb.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.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.jdbcStatement
Executes the given SQL statement, which returns a single ResultSet object.
executeUpdate() - Method in class org.hsqldb.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.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.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.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.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.

F

FILE_IO_ERROR - Static variable in class org.hsqldb.Trace
 
FOREIGN_KEY_NOT_ALLOWED - Static variable in class org.hsqldb.Trace
 
FUNCTION_NOT_SUPPORTED - Static variable in class org.hsqldb.Trace
 
FindFile - class org.hsqldb.sample.FindFile.
Extract a directory tree and store in an HSQLDB database.
FindFile() - Constructor for class org.hsqldb.sample.FindFile
 
finalize() - Method in class org.hsqldb.jdbcConnection
The default implementation simply attempts to silently close() this Connection
findColumn(String) - Method in class org.hsqldb.jdbcResultSet
Maps the given ResultSet column name to its ResultSet column index.
fire(String, String, Object[]) - Method in interface org.hsqldb.Trigger
Method declaration
fire(String, String, Object[]) - Method in class org.hsqldb.sample.TriggerSample
fire method declaration
first() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the first row in this ResultSet object.

G

GENERAL_ERROR - Static variable in class org.hsqldb.Trace
 
get(int) - Method in class org.hsqldb.lib.HsqlDeque
 
getAdjustedColumnArray(int[], int, int, int) - Static method in class org.hsqldb.lib.ArrayUtil
Convenience wrapper for toAdjustedColumnArray() that creates the new array.
getArray(int) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
getArray(int) - Method in class org.hsqldb.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.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(int) - Method in class org.hsqldb.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.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.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.jdbcConnection
Gets the current auto-commit state.
getBestRowIdentifier(String, String, String, int, boolean) - Method in class org.hsqldb.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.jdbcPreparedStatement
Deprecated. use getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)
getBigDecimal(int) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
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.jdbcResultSet
Deprecated.  
getBigDecimal(String, int) - Method in class org.hsqldb.jdbcResultSet
Deprecated.  
getBigDecimal(int) - Method in class org.hsqldb.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.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(int) - Method in class org.hsqldb.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.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.jdbcPreparedStatement
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.jdbcPreparedStatement
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
getBlob(int) - Method in class org.hsqldb.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.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.jdbcPreparedStatement
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language.
getBoolean(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.
getBoolean(int) - Method in class org.hsqldb.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.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.jdbcPreparedStatement
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
getByte(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
getByte(int) - Method in class org.hsqldb.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.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(int) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
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.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.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.jdbcConnection
Returns the Connection's current catalog name.
getCatalogName(int) - Method in class org.hsqldb.jdbcResultSet
Gets the designated column's table's catalog name.
getCatalogSeparator() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the String that this database uses as the separator between a catalog and table name.
getCatalogTerm() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the database vendor's preferred term for "catalog".
getCatalogs() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the catalog names available in this database.
getCharacterStream(int) - Method in class org.hsqldb.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.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.jdbcPreparedStatement
Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming l anguage.
getClob(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
getClob(int) - Method in class org.hsqldb.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.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.jdbcResultSet
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.jdbcResultSet
Returns the number of columns in this ResultSet object.
getColumnDisplaySize(int) - Method in class org.hsqldb.jdbcResultSet
Indicates the designated column's normal maximum width in characters.
getColumnLabel(int) - Method in class org.hsqldb.jdbcResultSet
Gets the designated column's suggested title for use in printouts and displays.
getColumnName(int) - Method in class org.hsqldb.jdbcResultSet
Get the designated column's name.
getColumnPrivileges(String, String, String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the access rights for a table's columns.
getColumnType(int) - Method in class org.hsqldb.jdbcResultSet
Retrieves the designated column's SQL type.
getColumnTypeName(int) - Method in class org.hsqldb.jdbcResultSet
Retrieves the designated column's database-specific type name.
getColumns(String, String, String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of table columns available in the specified catalog.
getConcurrency() - Method in class org.hsqldb.jdbcResultSet
Retrieves the concurrency mode of this ResultSet object.
getConnection() - Method in class org.hsqldb.jdbcDataSource
Forward with current user/password
getConnection(String, String) - Method in class org.hsqldb.jdbcDataSource
getConnection method comment.
getConnection() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the connection that produced this metadata object.
getConnection() - Method in class org.hsqldb.jdbcStatement
Retrieves the Connection object that produced this Statement object.
getContent() - Method in class org.hsqldb.util.ZaurusChoice
 
getContent() - Method in interface org.hsqldb.util.ZaurusComponent
 
getContent() - Method in class org.hsqldb.util.ZaurusTextField
 
getCrossReference(String, String, String, String, String, String) - Method in class org.hsqldb.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.jdbcResultSet
Retrieves the name of the SQL cursor used by this ResultSet object.
getDatabase() - Method in class org.hsqldb.jdbcDataSource
Return database
getDatabaseMajorVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the major version number of the underlying database.
getDatabaseMinorVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the minor version number of the underlying database.
getDatabaseProductName() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the name of this database product.
getDatabaseProductVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the version number of this database product.
getDate(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.
getDate(int, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
getDate(String, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
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.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.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.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.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) - Static method in class org.hsqldb.lib.HsqlDateTime
 
getDateString(Date, Calendar) - Static method in class org.hsqldb.lib.HsqlDateTime
 
getDefaultTransactionIsolation() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves this database's default transaction isolation level.
getDouble(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
getDouble(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
getDouble(int) - Method in class org.hsqldb.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.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.jdbcDatabaseMetaData
Retrieves this JDBC driver's major version number.
getDriverMinorVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves this JDBC driver's minor version number.
getDriverName() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the name of this JDBC driver.
getDriverVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the version number of this JDBC driver as a String.
getExportedKeys(String, String, String) - Method in class org.hsqldb.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.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.jdbcResultSet
Retrieves the fetch direction for this ResultSet object.
getFetchDirection() - Method in class org.hsqldb.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.jdbcResultSet
Retrieves the fetch size for this ResultSet object.
getFetchSize() - Method in class org.hsqldb.jdbcStatement
Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
getFirst() - Method in class org.hsqldb.lib.HsqlDeque
 
getFloat(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
getFloat(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
getFloat(int) - Method in class org.hsqldb.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.jdbcResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
getGeneratedKeys() - Method in class org.hsqldb.jdbcStatement
Retrieves any auto-generated keys created as a result of executing this Statement object.
getHoldability() - Method in class org.hsqldb.jdbcConnection
Retrieves the current holdability of ResultSet objects created using this Connection object.
getIdentifierQuoteString() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the string used to quote SQL identifiers.
getImportedKeys(String, String, String) - Method in class org.hsqldb.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.jdbcDatabaseMetaData
Retrieves a description of the given table's indices and statistics.
getInt(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
getInt(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
getInt(int) - Method in class org.hsqldb.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.jdbcResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
getIntegerProperty(String, int) - Method in class org.hsqldb.HsqlProperties
 
getJDBCMajorVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the major JDBC version number for this driver.
getJDBCMinorVersion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the minor JDBC version number for this driver.
getLast() - Method in class org.hsqldb.lib.HsqlDeque
 
getList(String[], String, String) - Static method in class org.hsqldb.lib.StringUtil
Builds a CSV list from the String[].
getList(int[], String, String) - Static method in class org.hsqldb.lib.StringUtil
Builds a CSV list from the int[].
getList(String[][], String, String) - Static method in class org.hsqldb.lib.StringUtil
Builds a CSV list from the specified String[][].
getLogWriter() - Method in class org.hsqldb.jdbcDataSource
getLogWriter method comment.
getLoginTimeout() - Method in class org.hsqldb.jdbcDataSource
getLoginTimeout method comment.
getLong(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
getLong(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
getLong(int) - Method in class org.hsqldb.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.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.jdbcDatabaseMetaData
Retrieves the maximum number of hex characters this database allows in an inline binary literal.
getMaxCatalogNameLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a catalog name.
getMaxCharLiteralLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters this database allows for a character literal.
getMaxColumnNameLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters this database allows for a column name.
getMaxColumnsInGroupBy() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of columns this database allows in a GROUP BY clause.
getMaxColumnsInIndex() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of columns this database allows in an index.
getMaxColumnsInOrderBy() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of columns this database allows in an ORDER BY clause.
getMaxColumnsInSelect() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of columns this database allows in a SELECT list.
getMaxColumnsInTable() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of columns this database allows in a table.
getMaxConnections() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of concurrent connections to this database that are possible.
getMaxCursorNameLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a cursor name.
getMaxFieldSize() - Method in class org.hsqldb.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.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.jdbcDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a procedure name.
getMaxRowSize() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of bytes this database allows in a single row.
getMaxRows() - Method in class org.hsqldb.jdbcStatement
Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
getMaxSchemaNameLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a schema name.
getMaxStatementLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters this database allows in an SQL statement.
getMaxStatements() - Method in class org.hsqldb.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.jdbcDatabaseMetaData
Retrieves the maximum number of characters this database allows in a table name.
getMaxTablesInSelect() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of tables this database allows in a SELECT statement.
getMaxUserNameLength() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the maximum number of characters this database allows in a user name.
getMetaData() - Method in class org.hsqldb.jdbcConnection
Gets the metadata regarding this connection's database.
getMetaData() - Method in class org.hsqldb.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.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.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.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.jdbcDatabaseMetaData
Retrieves a comma-separated list of math functions available with this database.
getObject(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated parameter as an Object in the Java programming language.
getObject(int, Map) - Method in class org.hsqldb.jdbcPreparedStatement
Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.
getObject(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a parameter as an Object in the Java programming language.
getObject(String, Map) - Method in class org.hsqldb.jdbcPreparedStatement
Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.
getObject(int) - Method in class org.hsqldb.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.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.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.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.jdbcDataSourceFactory
getObjectInstance method comment.
getParameterMetaData() - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the number, types and properties of this PreparedStatement object's parameters.
getPrecision(int) - Method in class org.hsqldb.jdbcResultSet
Get the designated column's number of decimal digits.
getPrimaryKeys(String, String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the given table's primary key columns.
getPrimaryKeysString() - Method in class org.hsqldb.util.ZaurusTableForm
 
getProcedureColumns(String, String, String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the given catalog's stored procedure parameter and result columns.
getProcedureTerm() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the database vendor's preferred term for "procedure".
getProcedures(String, String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the stored procedures available in the given catalog.
getProperty(String) - Method in class org.hsqldb.HsqlProperties
 
getProperty(String, String) - Method in class org.hsqldb.HsqlProperties
 
getPropertyInfo(String, Properties) - Method in class org.hsqldb.jdbcDriver
Gets information about the possible properties for this driver.
getQueryTimeout() - Method in class org.hsqldb.jdbcStatement
Retrieves the number of seconds the driver will wait for a Statement object to execute.
getRef(int) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
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.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.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.jdbcDataSource
getReference method comment.
getResultSet() - Method in class org.hsqldb.jdbcStatement
Retrieves the current result as a ResultSet object.
getResultSetConcurrency() - Method in class org.hsqldb.jdbcStatement
Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
getResultSetHoldability() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the default holdability of this ResultSet object.
getResultSetHoldability() - Method in class org.hsqldb.jdbcStatement
Retrieves the result set holdability for ResultSet objects generated by this Statement object.
getResultSetType() - Method in class org.hsqldb.jdbcStatement
Retrieves the result set type for ResultSet objects generated by this Statement object.
getRow() - Method in class org.hsqldb.jdbcResultSet
Retrieves the current row number.
getSQLKeywords() - Method in class org.hsqldb.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.jdbcDatabaseMetaData
Indicates whether the SQLSTATEs returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL99.
getScale(int) - Method in class org.hsqldb.jdbcResultSet
Gets the designated column's number of digits to right of the decimal point.
getSchemaName(int) - Method in class org.hsqldb.jdbcResultSet
Get the designated column's table's schema.
getSchemaTerm() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the database vendor's preferred term for "schema".
getSchemas() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the schema names available in this database.
getSearchStringEscape() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the string that can be used to escape wildcard characters.
getShort(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
getShort(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
getShort(int) - Method in class org.hsqldb.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.jdbcResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
getStatement() - Method in class org.hsqldb.jdbcResultSet
Retrieves the Statement object that produced this ResultSet object.
getString(int) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
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.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.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.jdbcDatabaseMetaData
Retrieves a comma-separated list of string functions available with this database.
getSuperTables(String, String, String) - Method in class org.hsqldb.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.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.jdbcDatabaseMetaData
Retrieves a comma-separated list of system functions available with this database.
getTableName(int) - Method in class org.hsqldb.jdbcResultSet
Gets the designated column's table name.
getTablePrivileges(String, String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the access rights for each table available in a catalog.
getTableTypes() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the table types available in this database.
getTables(String, String, String, String[]) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the tables available in the given catalog.
getTime(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.
getTime(int, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
getTime(String, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
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.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.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.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.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) - Static method in class org.hsqldb.lib.HsqlDateTime
 
getTimeDateFunctions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a comma-separated list of the time and date functions available with this database.
getTimeString(Time, Calendar) - Static method in class org.hsqldb.lib.HsqlDateTime
 
getTimestamp(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
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.jdbcPreparedStatement
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
getTimestamp(String, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
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.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.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.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.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, Calendar) - Static method in class org.hsqldb.lib.HsqlDateTime
 
getTimestampString(Timestamp, Calendar) - Static method in class org.hsqldb.lib.HsqlDateTime
 
getTransactionIsolation() - Method in class org.hsqldb.jdbcConnection
Retrieves this Connection object's current transaction isolation level.
getType() - Method in class org.hsqldb.jdbcResultSet
Retrieves the type of this ResultSet object.
getTypeInfo() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of all the standard SQL types supported by this database.
getTypeMap() - Method in class org.hsqldb.jdbcConnection
Gets the type map object associated with this connection.
getUDTs(String, String, String, int[]) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
getURL() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the URL for this DBMS.
getURL(int) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
getURL(String) - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
getURL(int) - Method in class org.hsqldb.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.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.jdbcResultSet
Deprecated. use getCharacterStream in place of getUnicodeStream
getUnicodeStream(String) - Method in class org.hsqldb.jdbcResultSet
Deprecated. use getCharacterStream instead
getUpdateCount() - Method in class org.hsqldb.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.jdbcDataSource
 
getUserName() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves the user name as known to this database.
getVersionColumns(String, String, String) - Method in class org.hsqldb.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.jdbcConnection
Retrieves the first warning reported by calls on this Connection object.
getWarnings() - Method in class org.hsqldb.jdbcResultSet
Retrieves the first warning reported by calls on this ResultSet object.
getWarnings() - Method in class org.hsqldb.jdbcStatement
Retrieves the first warning reported by calls on this Statement object.

H

HsqlDateTime - class org.hsqldb.lib.HsqlDateTime.
collection of static methods to convert Date, Time and Timestamp strings into corresponding Java objects.
HsqlDateTime() - Constructor for class org.hsqldb.lib.HsqlDateTime
 
HsqlDeque - class org.hsqldb.lib.HsqlDeque.
jdk 1.1 compatible minimal implementation of a list object suitable for stack, queue and deque usage patterns backed by an Object[].
HsqlDeque() - Constructor for class org.hsqldb.lib.HsqlDeque
 
HsqlProperties - class org.hsqldb.HsqlProperties.
Wrapper for java.util.Properties to limit values to String objects and allow saving and loading.
HsqlProperties() - Constructor for class org.hsqldb.HsqlProperties
 
HsqlProperties(String) - Constructor for class org.hsqldb.HsqlProperties
 
HsqlProperties(Properties) - Constructor for class org.hsqldb.HsqlProperties
 
HsqlServerFactory - class org.hsqldb.HsqlServerFactory.
HsqlServerFactory
HsqlServerFactory() - Constructor for class org.hsqldb.HsqlServerFactory
 
HsqlSocketRequestHandler - interface org.hsqldb.HsqlSocketRequestHandler.
Interface HsqlSocketRequestHandler
HsqlSocketRequestHandlerImpl - class org.hsqldb.HsqlSocketRequestHandlerImpl.
Interface HsqlSocketRequestHandlerImpl
HsqlSocketRequestHandlerImpl(Server) - Constructor for class org.hsqldb.HsqlSocketRequestHandlerImpl
 
handleConnection(Socket) - Method in interface org.hsqldb.HsqlSocketRequestHandler
 
handleConnection(Socket) - Method in class org.hsqldb.HsqlSocketRequestHandlerImpl
 
hasChanged() - Method in class org.hsqldb.util.ZaurusChoice
 
hasChanged() - Method in interface org.hsqldb.util.ZaurusComponent
 
hasChanged() - Method in class org.hsqldb.util.ZaurusTextField
 
haveCommonElement(int[], int[], int) - Static method in class org.hsqldb.lib.ArrayUtil
Checks for any overlap between two arrays of column indexes.
haveEqualArrays(int[], int[], int) - Static method in class org.hsqldb.lib.ArrayUtil
Returns true if the first count elements of a and b are identical subarrays of integers
haveEqualSets(int[], int[], int) - Static method in class org.hsqldb.lib.ArrayUtil
Returns true if the first count elements of a and b are identical sets of integers
haveEquality(int[], int[], int, boolean) - Static method in class org.hsqldb.lib.ArrayUtil
For sets == true returns true if a and b are the same length and contain the same set of integers.

I

INDEX_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
INDEX_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
INPUTSTREAM_ERROR - Static variable in class org.hsqldb.Trace
 
INTEGRITY_CONSTRAINT_VIOLATION - Static variable in class org.hsqldb.Trace
 
INVALID_ESCAPE - Static variable in class org.hsqldb.Trace
 
INVALID_JDBC_ARGUMENT - Static variable in class org.hsqldb.Trace
 
init(ServletConfig) - Method in class org.hsqldb.Servlet
Method declaration
init() - Method in class org.hsqldb.util.DatabaseManager
Method declaration
init() - Method in class org.hsqldb.util.DatabaseManagerSwing
 
init() - Method in class org.hsqldb.util.QueryTool
Initializes the window and the database and inserts some test data.
init() - Method in class org.hsqldb.util.Transfer
Method declaration
insertNewRow() - Method in class org.hsqldb.util.ZaurusTableForm
 
insertRow() - Method in class org.hsqldb.jdbcResultSet
Inserts the contents of the insert row into this ResultSet object and into the database.
insertsAreDetected(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.
isAfterLast() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether the cursor is after the last row in this ResultSet object.
isAutoIncrement(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether the designated column is automatically numbered, thus read-only.
isBeforeFirst() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether the cursor is before the first row in this ResultSet object.
isCaseSensitive(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether a column's case matters.
isCatalogAtStart() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a catalog appears at the start of a fully qualified table name.
isClosed() - Method in class org.hsqldb.jdbcConnection
Tests to see if a Connection is closed.
isCurrency(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether the designated column is a cash value.
isDefinitelyWritable(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether a write on the designated column will definitely succeed.
isEmpty() - Method in class org.hsqldb.lib.HsqlDeque
 
isFirst() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether the cursor is on the first row of this ResultSet object.
isLast() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether the cursor is on the last row of this ResultSet object.
isNullable(int) - Method in class org.hsqldb.jdbcResultSet
Indicates the nullability of values in the designated column.
isPropertyTrue(String) - Method in class org.hsqldb.HsqlProperties
 
isPropertyTrue(String, boolean) - Method in class org.hsqldb.HsqlProperties
 
isReadOnly() - Method in class org.hsqldb.jdbcConnection
Tests to see if the connection is in read-only mode.
isReadOnly() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database is in read-only mode.
isReadOnly(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether the designated column is definitely not writable.
isSearchable(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether the designated column can be used in a where clause.
isSigned(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether values in the designated column are signed numbers.
isWritable(int) - Method in class org.hsqldb.jdbcResultSet
Indicates whether it is possible for a write on the designated column to succeed.
itemStateChanged(ItemEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
itemStateChanged(ItemEvent) - Method in class org.hsqldb.util.ZaurusConnectionDialog
Method declaration
itemStateChanged(ItemEvent) - Method in class org.hsqldb.util.ZaurusTableForm
 

J

jdbcCompliant() - Method in class org.hsqldb.jdbcDriver
Reports whether this driver is a genuine JDBC COMPLIANTTM driver.
jdbcConnection - class org.hsqldb.jdbcConnection.
A connection (session) with a specific database.
jdbcDataSource - class org.hsqldb.jdbcDataSource.
 
jdbcDataSource() - Constructor for class org.hsqldb.jdbcDataSource
Constructor
jdbcDataSourceFactory - class org.hsqldb.jdbcDataSourceFactory.
 
jdbcDataSourceFactory() - Constructor for class org.hsqldb.jdbcDataSourceFactory
 
jdbcDatabaseMetaData - class org.hsqldb.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
 
jdbcPreparedStatement - class org.hsqldb.jdbcPreparedStatement.
Implements both the java.sql.PreparedStatement and java.sql.CallableStatement interfaces.
jdbcResultSet - class org.hsqldb.jdbcResultSet.
Implements both the java.sql.ResultSet and java.sql.ResultSetMetaData interfaces.
jdbcStatement - class org.hsqldb.jdbcStatement.
The object used for executing a static SQL statement and returning the results it produces.
jdbcSystem - class org.hsqldb.util.jdbcSystem.
Handles the differences between jdk 1.1.x and 1.2.x and above
jdbcSystem() - Constructor for class org.hsqldb.util.jdbcSystem
 

K

keyPressed(KeyEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
keyPressed(KeyEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
keyPressed(KeyEvent) - Method in class org.hsqldb.util.ZaurusConnectionDialog
 
keyPressed(KeyEvent) - Method in class org.hsqldb.util.ZaurusDatabaseManager
 
keyReleased(KeyEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
keyReleased(KeyEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
keyReleased(KeyEvent) - Method in class org.hsqldb.util.ZaurusConnectionDialog
 
keyTyped(KeyEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
keyTyped(KeyEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
keyTyped(KeyEvent) - Method in class org.hsqldb.util.ZaurusConnectionDialog
 
keyTyped(KeyEvent) - Method in class org.hsqldb.util.ZaurusDatabaseManager
Method declaration

L

LABEL_REQUIRED - Static variable in class org.hsqldb.Trace
 
last() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the last row in this ResultSet object.
load() - Method in class org.hsqldb.HsqlProperties
 
locatorsUpdateCopy() - Method in class org.hsqldb.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
Method declaration
main(String[]) - Static method in class org.hsqldb.WebServer
Method declaration
main(String[]) - Static method in class org.hsqldb.sample.FindFile
Extracts a directory tree and stores it ina HSQLDB database.
Usage:
main(String[]) - Static method in class org.hsqldb.test.TestCacheSize
 
main(String[]) - Static method in class org.hsqldb.test.TestCascade
 
main(String[]) - Static method in class org.hsqldb.test.TestHsql
 
main(String[]) - Static method in class org.hsqldb.test.TestInstantiation
 
main(String[]) - Static method in class org.hsqldb.test.TestMultipleConnections
 
main(String[]) - Static method in class org.hsqldb.test.TestSql
 
main(String[]) - Static method in class org.hsqldb.test.TestSqlPersistent
 
main(String[]) - Static method in class org.hsqldb.test.TestSubselect
 
main(String[]) - Static method in class org.hsqldb.test.TestTextTables
 
main(String[]) - Static method in class org.hsqldb.util.CodeSwitcher
Method declaration
main(String[]) - Static method in class org.hsqldb.util.DatabaseManager
Method declaration
main(String[]) - Static method in class org.hsqldb.util.DatabaseManagerSwing
 
main(String[]) - Static method in class org.hsqldb.util.QueryTool
Method declaration
main(String[]) - Static method in class org.hsqldb.util.ScriptTool
Main method
main(String[]) - Static method in class org.hsqldb.util.ShutdownServer
 
main(String[]) - Static method in class org.hsqldb.util.Transfer
Method declaration
main(String[]) - Static method in class org.hsqldb.util.ZaurusDatabaseManager
Method declaration
moveToCurrentRow() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the remembered cursor position, usually the current row.
moveToInsertRow() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the insert row.

N

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

O

OUTER_JOIN_CONDITION - Static variable in class org.hsqldb.Trace
 
org.hsqldb - package org.hsqldb
 
org.hsqldb.lib - package org.hsqldb.lib
 
org.hsqldb.sample - package org.hsqldb.sample
 
org.hsqldb.test - package org.hsqldb.test
 
org.hsqldb.util - package org.hsqldb.util
 
othersDeletesAreVisible(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether deletes made by others are visible.
othersInsertsAreVisible(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether inserts made by others are visible.
othersUpdatesAreVisible(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether updates made by others are visible.
ownDeletesAreVisible(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a result set's own deletes are visible.
ownInsertsAreVisible(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a result set's own inserts are visible.
ownUpdatesAreVisible(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

P

prepareCall(String) - Method in class org.hsqldb.jdbcConnection
Creates a CallableStatement object for calling database stored procedures.
prepareCall(String, int, int) - Method in class org.hsqldb.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.jdbcConnection
Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
prepareStatement(String) - Method in class org.hsqldb.jdbcConnection
Creates a PreparedStatement object for sending parameterized SQL statements to the database.
prepareStatement(String, int, int) - Method in class org.hsqldb.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.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.jdbcConnection
Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.
prepareStatement(String, int[]) - Method in class org.hsqldb.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.jdbcConnection
Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
prevRow() - Method in class org.hsqldb.util.ZaurusTableForm
 
previous() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the previous row in this ResultSet object.
printStatus(String) - Static method in class org.hsqldb.util.ZaurusEditor
printStatus prints a text into the status line below the panel.
println(char[]) - Method in class org.hsqldb.Trace
Method declaration
println(String) - Method in class org.hsqldb.Trace
 

Q

QueryTool - class org.hsqldb.util.QueryTool.
Class declaration
QueryTool() - Constructor for class org.hsqldb.util.QueryTool
 

R

RESULTSET_FORWARD_ONLY - Static variable in class org.hsqldb.Trace
 
read() - Method in class org.hsqldb.lib.AsciiStringInputStream
 
read() - Method in class org.hsqldb.lib.StringInputStream
 
refresh(Connection) - Method in class org.hsqldb.util.ZaurusEditor
refresh will read again the meta data of the actual database.
refreshRow() - Method in class org.hsqldb.jdbcResultSet
Refreshes the current row with its most recent value in the database.
registerOutParameter(int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
registerOutParameter(int, int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
registerOutParameter(int, int, String) - Method in class org.hsqldb.jdbcPreparedStatement
Registers the designated output parameter.
registerOutParameter(String, int) - Method in class org.hsqldb.jdbcPreparedStatement
Registers the OUT parameter named parameterName to the JDBC type sqlType.
registerOutParameter(String, int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Registers the parameter named parameterName to be of JDBC type sqlType.
registerOutParameter(String, int, String) - Method in class org.hsqldb.jdbcPreparedStatement
Registers the designated output parameter.
relative(int) - Method in class org.hsqldb.jdbcResultSet
Moves the cursor a relative number of rows, either positive or negative.
releaseSavepoint(Savepoint) - Method in class org.hsqldb.jdbcConnection
Removes the given Savepoint object from the current transaction.
removeFirst() - Method in class org.hsqldb.lib.HsqlDeque
 
removeLast() - Method in class org.hsqldb.lib.HsqlDeque
 
removeProperty(String) - Method in class org.hsqldb.HsqlProperties
 
requestFocus() - Method in class org.hsqldb.util.ZaurusChoice
 
requestFocus() - Method in interface org.hsqldb.util.ZaurusComponent
 
requestFocus() - Method in class org.hsqldb.util.ZaurusTextField
 
rollback() - Method in class org.hsqldb.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.jdbcConnection
Undoes all changes made after the given Savepoint object was set.
rowDeleted() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether a row has been deleted.
rowInserted() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether the current row has had an insertion.
rowUpdated() - Method in class org.hsqldb.jdbcResultSet
Retrieves whether the current row has been updated.

S

SAVEPOINT_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
SECOND_PRIMARY_KEY - Static variable in class org.hsqldb.Trace
 
SERIALIZATION_FAILURE - Static variable in class org.hsqldb.Trace
 
SINGLE_VALUE_EXPECTED - Static variable in class org.hsqldb.Trace
 
STOP - Static variable in class org.hsqldb.Trace
 
SUM_OF_NON_NUMERIC - Static variable in class org.hsqldb.Trace
 
SYSTEM_INDEX - Static variable in class org.hsqldb.Trace
 
ScriptTool - class org.hsqldb.util.ScriptTool.
Script tool - command line tool to read in sql script and execute it.
ScriptTool() - Constructor for class org.hsqldb.util.ScriptTool
 
Server - class org.hsqldb.Server.
Server acts as a database server and is one way of using the client-server mode of HSQL Database Engine.
Server() - Constructor for class org.hsqldb.Server
 
Servlet - class org.hsqldb.Servlet.
Servlet acts as a interface between the applet and the database for the the client / server mode of HSQL Database Engine.
Servlet() - Constructor for class org.hsqldb.Servlet
 
ShutdownServer - class org.hsqldb.util.ShutdownServer.
 
ShutdownServer() - Constructor for class org.hsqldb.util.ShutdownServer
 
StringInputStream - class org.hsqldb.lib.StringInputStream.
minimal InputStream subclass to fetch bytes form a String
StringInputStream(String) - Constructor for class org.hsqldb.lib.StringInputStream
 
StringUtil - class org.hsqldb.lib.StringUtil.
 
save() - Method in class org.hsqldb.HsqlProperties
Method declaration
saveChanges() - Method in class org.hsqldb.util.ZaurusTableForm
 
saveNewRow() - Method in class org.hsqldb.util.ZaurusTableForm
 
searchRows(String[], boolean, boolean, boolean) - Method in class org.hsqldb.util.ZaurusTableForm
 
set(int, Object) - Method in class org.hsqldb.lib.HsqlDeque
 
setArray(int, Array) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Array object.
setAsciiStream(int, InputStream, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAsciiStream(String, InputStream, int) - Method in class org.hsqldb.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.jdbcConnection
Sets this connection's auto-commit mode to the given state.
setBigDecimal(int, BigDecimal) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.math.BigDecimal value.
setBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.math.BigDecimal value.
setBinaryStream(int, InputStream, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBinaryStream(String, InputStream, int) - Method in class org.hsqldb.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.jdbcPreparedStatement
Sets the designated parameter to the given Blob object.
setBoolean(int, boolean) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java boolean value.
setBoolean(String, boolean) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java boolean value.
setByte(int, byte) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java byte value.
setByte(String, byte) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java byte value.
setBytes(int, byte[]) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java array of bytes.
setBytes(String, byte[]) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java array of bytes.
setCatalog(String) - Method in class org.hsqldb.jdbcConnection
Sets a catalog name in order to select a subspace of this Connection's database in which to work.
setChanged() - Method in class org.hsqldb.util.ZaurusChoice
 
setChanged() - Method in interface org.hsqldb.util.ZaurusComponent
 
setChanged() - Method in class org.hsqldb.util.ZaurusTextField
 
setCharacterStream(int, Reader, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setCharacterStream(String, Reader, int) - Method in class org.hsqldb.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.jdbcPreparedStatement
Sets the designated parameter to the given Clob object.
setContent(String) - Method in class org.hsqldb.util.ZaurusChoice
 
setContent(String) - Method in interface org.hsqldb.util.ZaurusComponent
 
setContent(String) - Method in class org.hsqldb.util.ZaurusTextField
 
setCursorName(String) - Method in class org.hsqldb.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.jdbcDataSource
Set database location
setDate(int, Date) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Date value.
setDate(int, Date, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
setDate(String, Date) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Date value.
setDate(String, Date, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
setDouble(int, double) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java double value.
setDouble(String, double) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java double value.
setEditable(boolean) - Method in class org.hsqldb.util.ZaurusChoice
 
setEditable(boolean) - Method in interface org.hsqldb.util.ZaurusComponent
 
setEditable(boolean) - Method in class org.hsqldb.util.ZaurusTextField
 
setEscapeProcessing(boolean) - Method in class org.hsqldb.jdbcPreparedStatement
Sets escape processing on or off.
setEscapeProcessing(boolean) - Method in class org.hsqldb.jdbcStatement
Sets escape processing on or off.
setFetchDirection(int) - Method in class org.hsqldb.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.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.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.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.
setFileName(String) - Method in class org.hsqldb.HsqlProperties
 
setFloat(int, float) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java float value.
setFloat(String, float) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java float value.
setHoldability(int) - Method in class org.hsqldb.jdbcConnection
Changes the holdability of ResultSet objects created using this Connection object to the given holdability.
setInt(int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java int value.
setInt(String, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java int value.
setLogToSystem(boolean) - Static method in class org.hsqldb.util.jdbcSystem
 
setLogWriter(PrintWriter) - Method in class org.hsqldb.jdbcDataSource
setLogWriter method comment.
setLoginTimeout(int) - Method in class org.hsqldb.jdbcDataSource
Not yet implemented
setLong(int, long) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java long value.
setLong(String, long) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java long value.
setMaxFieldSize(int) - Method in class org.hsqldb.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.jdbcStatement
Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number.
setNull(int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to SQL NULL.
setNull(int, int, String) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to SQL NULL.
setNull(String, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to SQL NULL.
setNull(String, int, String) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to SQL NULL.
setObject(int, Object, int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the value of the designated parameter with the given object.
setObject(int, Object, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the value of the designated parameter with the given object.
setObject(int, Object) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the value of the designated parameter using the given object.
setObject(String, Object, int, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the value of the designated parameter with the given object.
setObject(String, Object, int) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the value of the designated parameter with the given object.
setObject(String, Object) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the value of the designated parameter with the given object.
setPassword(String) - Method in class org.hsqldb.jdbcDataSource
Sets the password to use for connecting to the database
setProperty(String, int) - Method in class org.hsqldb.HsqlProperties
 
setProperty(String, boolean) - Method in class org.hsqldb.HsqlProperties
 
setProperty(String, String) - Method in class org.hsqldb.HsqlProperties
 
setPropertyIfNotExists(String, String) - Method in class org.hsqldb.HsqlProperties
 
setQueryTimeout(int) - Method in class org.hsqldb.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.jdbcConnection
Puts this connection in read-only mode as a hint to enable database optimizations.
setRef(int, Ref) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given REF(<structured-type>) value.
setSavepoint() - Method in class org.hsqldb.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.jdbcConnection
Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.
setShort(int, short) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java short value.
setShort(String, short) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java short value.
setString(int, String) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java String value.
setString(String, String) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given Java String value.
setTime(int, Time) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Time value.
setTime(int, Time, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
setTime(String, Time) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Time value.
setTime(String, Time, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
setTimestamp(int, Timestamp) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(int, Timestamp, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
setTimestamp(String, Timestamp) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(String, Timestamp, Calendar) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
setTransactionIsolation(int) - Method in class org.hsqldb.jdbcConnection
Attempts to change the transaction isolation level for this Connection object to the one given.
setTypeMap(Map) - Method in class org.hsqldb.jdbcConnection
Installs the given TypeMap object as the type map for this Connection object.
setURL(int, URL) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.net.URL value.
setURL(String, URL) - Method in class org.hsqldb.jdbcPreparedStatement
Sets the designated parameter to the given java.net.URL object.
setUnicodeStream(int, InputStream, int) - Method in class org.hsqldb.jdbcPreparedStatement
Deprecated. Sun does not include a reason, but presumably setCharacterStream is now prefered?
setUser(String) - Method in class org.hsqldb.jdbcDataSource
Sets the userid
size() - Method in class org.hsqldb.lib.HsqlDeque
 
sortArray(int[]) - Static method in class org.hsqldb.lib.ArrayUtil
Basic sort for small arrays.
storesLowerCaseIdentifiers() - Method in class org.hsqldb.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.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.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.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.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.jdbcDatabaseMetaData
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
suite() - Static method in class org.hsqldb.test.TestHsql
 
suite() - Static method in class org.hsqldb.test.TestQuotes
Run all related test methods
supportsANSI92EntryLevelSQL() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the ANSI92 entry level SQL grammar.
supportsANSI92FullSQL() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the ANSI92 full SQL grammar supported.
supportsANSI92IntermediateSQL() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
supportsAlterTableWithAddColumn() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports ALTER TABLE with add column.
supportsAlterTableWithDropColumn() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports ALTER TABLE with drop column.
supportsBatchUpdates() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports batch updates.
supportsCatalogsInDataManipulation() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a catalog name can be used in a data manipulation statement.
supportsCatalogsInIndexDefinitions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a catalog name can be used in an index definition statement.
supportsCatalogsInPrivilegeDefinitions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a catalog name can be used in a privilege definition statement.
supportsCatalogsInProcedureCalls() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a catalog name can be used in a procedure call statement.
supportsCatalogsInTableDefinitions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a catalog name can be used in a table definition statement.
supportsColumnAliasing() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports column aliasing.
supportsConvert() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the CONVERT function between SQL types.
supportsConvert(int, int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the CONVERT for two given SQL types.
supportsCoreSQLGrammar() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the ODBC Core SQL grammar.
supportsCorrelatedSubqueries() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
supportsDataManipulationTransactionsOnly() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports only data manipulation statements within a transaction.
supportsDifferentTableCorrelationNames() - Method in class org.hsqldb.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.jdbcDatabaseMetaData
Retrieves whether this database supports expressions in ORDER BY lists.
supportsExtendedSQLGrammar() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the ODBC Extended SQL grammar.
supportsFullOuterJoins() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports full nested outer joins.
supportsGetGeneratedKeys() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
supportsGroupBy() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports some form of GROUP BY clause.
supportsGroupByBeyondSelect() - Method in class org.hsqldb.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.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.jdbcDatabaseMetaData
Retrieves whether this database supports the SQL Integrity Enhancement Facility.
supportsLikeEscapeClause() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports specifying a LIKE escape clause.
supportsLimitedOuterJoins() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database provides limited support for outer joins.
supportsMinimumSQLGrammar() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the ODBC Minimum SQL grammar.
supportsMixedCaseIdentifiers() - Method in class org.hsqldb.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.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.jdbcDatabaseMetaData
Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.
supportsMultipleResultSets() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.
supportsMultipleTransactions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database allows having multiple transactions open at once (on different connections).
supportsNamedParameters() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports named parameters to callable statements.
supportsNonNullableColumns() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether columns in this database may be defined as non-nullable.
supportsOpenCursorsAcrossCommit() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports keeping cursors open across commits.
supportsOpenCursorsAcrossRollback() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports keeping cursors open across rollbacks.
supportsOpenStatementsAcrossCommit() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports keeping statements open across commits.
supportsOpenStatementsAcrossRollback() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports keeping statements open across rollbacks.
supportsOrderByUnrelated() - Method in class org.hsqldb.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.jdbcDatabaseMetaData
Retrieves whether this database supports some form of outer join.
supportsPositionedDelete() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports positioned DELETE statements.
supportsPositionedUpdate() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports positioned UPDATE statements.
supportsResultSetConcurrency(int, int) - Method in class org.hsqldb.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.jdbcDatabaseMetaData
Retrieves whether this database supports the given result set holdability.
supportsResultSetType(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the given result set type.
supportsSavepoints() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports savepoints.
supportsSchemasInDataManipulation() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a schema name can be used in a data manipulation statement.
supportsSchemasInIndexDefinitions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a schema name can be used in an index definition statement.
supportsSchemasInPrivilegeDefinitions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a schema name can be used in a privilege definition statement.
supportsSchemasInProcedureCalls() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a schema name can be used in a procedure call statement.
supportsSchemasInTableDefinitions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a schema name can be used in a table definition statement.
supportsSelectForUpdate() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports SELECT FOR UPDATE statements.
supportsStatementPooling() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports statement pooling.
supportsStoredProcedures() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
supportsSubqueriesInComparisons() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports subqueries in comparison expressions.
supportsSubqueriesInExists() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports subqueries in EXISTS expressions.
supportsSubqueriesInIns() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports subqueries in IN statements.
supportsSubqueriesInQuantifieds() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports subqueries in quantified expressions.
supportsTableCorrelationNames() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports table correlation names.
supportsTransactionIsolationLevel(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports the given transaction isolation level.
supportsTransactions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports transactions.
supportsUnion() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports SQL UNION.
supportsUnionAll() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database supports SQL UNION ALL.

T

TABLE_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
TABLE_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
TRACE - Static variable in class org.hsqldb.Trace
 
TRACESYSTEMOUT - Static variable in class org.hsqldb.Trace
 
TRANSFER_CORRUPTED - Static variable in class org.hsqldb.Trace
 
TRIGGER_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
TRY_TO_INSERT_NULL - Static variable in class org.hsqldb.Trace
 
TestCacheSize - class org.hsqldb.test.TestCacheSize.
Test large cached tables by setting up a cached table of 100000 records or more and a much smaller memory table with about 1/100th rows used.
TestCacheSize() - Constructor for class org.hsqldb.test.TestCacheSize
 
TestCascade - class org.hsqldb.test.TestCascade.
Test case to demonstrate catastrophic bug in cascade delete code.
TestCascade() - Constructor for class org.hsqldb.test.TestCascade
 
TestHsql - class org.hsqldb.test.TestHsql.
Main test class, containing several JDBC and script based tests to verify correct operation of the engine.TestHsql(String) - Constructor for class org.hsqldb.test.TestHsql
 
TestInstantiation - class org.hsqldb.test.TestInstantiation.
Test the HsqlServerFactory interface.
TestInstantiation() - Constructor for class org.hsqldb.test.TestInstantiation
 
TestMultipleConnections - class org.hsqldb.test.TestMultipleConnections.
 
TestMultipleConnections() - Constructor for class org.hsqldb.test.TestMultipleConnections
 
TestQuotes - class org.hsqldb.test.TestQuotes.
Test handling of quote characters in strings
TestQuotes(String) - Constructor for class org.hsqldb.test.TestQuotes
 
TestSql - class org.hsqldb.test.TestSql.
Test sql statements via jdbc against in-memory database
TestSql(String) - Constructor for class org.hsqldb.test.TestSql
 
TestSqlPersistent - class org.hsqldb.test.TestSqlPersistent.
Test sql statements via jdbc against a persistent database
TestSqlPersistent(String) - Constructor for class org.hsqldb.test.TestSqlPersistent
 
TestSubselect - class org.hsqldb.test.TestSubselect.
Test cases for HSQL subselects.
TestSubselect(String) - Constructor for class org.hsqldb.test.TestSubselect
Constructs a new SubselectTest.
TestTextTables - class org.hsqldb.test.TestTextTables.
Test large cached tables by setting up a cached table of 100000 records or more and a much smaller memory table with about 1/100th rows used.
TestTextTables() - Constructor for class org.hsqldb.test.TestTextTables
 
Trace - class org.hsqldb.Trace.
handles creation and reporting of error messages and throwing SQLException
Transfer - class org.hsqldb.util.Transfer.
Utility program (or applet) for transferring tables between different databases via JDBC.
Transfer() - Constructor for class org.hsqldb.util.Transfer
 
Trigger - interface org.hsqldb.Trigger.
Interface declaration
TriggerSample - class org.hsqldb.sample.TriggerSample.
Sample code for use of triggers in hsqldb.
TriggerSample() - Constructor for class org.hsqldb.sample.TriggerSample
 
testAliasScope() - Method in class org.hsqldb.test.TestSubselect
Inner select reusing alias names from outer select, but using them for different tables
testAndedSubselects() - Method in class org.hsqldb.test.TestSubselect
Tests two subselects, anded.
testDoubleNaN() - Method in class org.hsqldb.test.TestSql
Demonstration of a reported bug.
testFillUp() - Method in class org.hsqldb.test.TestCacheSize
Fill up the cache
testFillUp() - Method in class org.hsqldb.test.TestTextTables
Fill up the cache
testHiddenCollision() - Method in class org.hsqldb.test.TestSubselect
Inner select with two tables having columns with the same name, one of which is referred to in the subselect, the other of which is not used in the query (both FRUITS and TREES have NAME column, but we're only selecting FRUITS.NAME and we're not referring to TREES.NAME at all).
testHiddenCollisionWithAliases() - Method in class org.hsqldb.test.TestSubselect
As above, with table aliases.
testHsql() - Method in class org.hsqldb.test.TestHsql
 
testInsertObject() - Method in class org.hsqldb.test.TestSqlPersistent
demonstration of bug fix #482109 - inserting Integers and Strings with preparedStatement.insertObject() did not work; String, Integer and Array types are inserted and retrieved demonstration of retrieving values using different getXXX methods
testMetaData() - Method in class org.hsqldb.test.TestSql
 
testNestedSubselects() - Method in class org.hsqldb.test.TestSubselect
Test nested subselects.
testNotIn() - Method in class org.hsqldb.test.TestSubselect
Inner select with "not in" in outer select where clause.
testNotInSameTableAndColumn() - Method in class org.hsqldb.test.TestSubselect
Inner select with "not in" in outer select where clause and same table in inner select where clause.
testSameTable() - Method in class org.hsqldb.test.TestSubselect
Inner select involving same table
testSameTableWithAliases() - Method in class org.hsqldb.test.TestSubselect
As above with aliases.
testSameTableWithJoin() - Method in class org.hsqldb.test.TestSubselect
Inner select involving same table as one of two joined tables in outer select
testSetString() - Method in class org.hsqldb.test.TestQuotes
 
testSimpleJoin() - Method in class org.hsqldb.test.TestSubselect
This test is basically a sanity check of the data set.
testWhereClausesColliding() - Method in class org.hsqldb.test.TestSubselect
Inner select with where clause in outer select having column with same name as where clause in inner select
testWhereClausesCollidingWithAliases() - Method in class org.hsqldb.test.TestSubselect
As above, with table aliases.
testWhereSelectColliding() - Method in class org.hsqldb.test.TestSubselect
Inner select with where clause in outer select having column with same name as select clause in inner select
testWhereSelectCollidingWithAliases() - Method in class org.hsqldb.test.TestSubselect
As above, with aliases.
textValueChanged(TextEvent) - Method in class org.hsqldb.util.ZaurusTableForm
 
timeValue(String) - Static method in class org.hsqldb.lib.HsqlDateTime
Converts a string in JDBC date escape format to a Time value.
timestampValue(String) - Static method in class org.hsqldb.lib.HsqlDateTime
Converts a string in JDBC timestamp escape format to a Timestamp value.
timestampValue(long, int) - Static method in class org.hsqldb.lib.HsqlDateTime
 
toAdjustedColumnArray(int[], int, int) - Static method in class org.hsqldb.lib.ArrayUtil
Returns new array with the elements in collar ajusted to reflect changes at colindex.
toLowerSubset(String, char) - Static method in class org.hsqldb.lib.StringUtil
Returns a string with non alphanumeric chars converted to the substitute character.
trace(String) - Method in class org.hsqldb.util.Transfer
Method declaration

U

UNEXPECTED_END_OF_COMMAND - Static variable in class org.hsqldb.Trace
 
UNEXPECTED_TOKEN - Static variable in class org.hsqldb.Trace
 
UNKNOWN_DATA_SOURCE - Static variable in class org.hsqldb.Trace
 
UNKNOWN_FUNCTION - Static variable in class org.hsqldb.Trace
 
USER_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
USER_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
updateArray(int, Array) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Array value.
updateArray(String, Array) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Array value.
updateAsciiStream(int, InputStream, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an ascii stream value.
updateAsciiStream(String, InputStream, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an ascii stream value.
updateBigDecimal(int, BigDecimal) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.math.BigDecimal value.
updateBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.BigDecimal value.
updateBinaryStream(int, InputStream, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a binary stream value.
updateBinaryStream(String, InputStream, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a binary stream value.
updateBlob(int, Blob) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Blob value.
updateBlob(String, Blob) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Blob value.
updateBoolean(int, boolean) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a boolean value.
updateBoolean(String, boolean) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a boolean value.
updateByte(int, byte) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a byte value.
updateByte(String, byte) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a byte value.
updateBytes(int, byte[]) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a byte array value.
updateBytes(String, byte[]) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a byte array value.
updateCharacterStream(int, Reader, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a character stream value.
updateCharacterStream(String, Reader, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a character stream value.
updateClob(int, Clob) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Clob value.
updateClob(String, Clob) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Clob value.
updateDate(int, Date) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Date value.
updateDate(String, Date) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Date value.
updateDouble(int, double) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a double value.
updateDouble(String, double) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a double value.
updateFloat(int, float) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a float value.
updateFloat(String, float) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a float value.
updateInt(int, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an int value.
updateInt(String, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an int value.
updateLong(int, long) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a long value.
updateLong(String, long) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a long value.
updateNull(int) - Method in class org.hsqldb.jdbcResultSet
Gives a nullable column a null value.
updateNull(String) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a null value.
updateObject(int, Object, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an Object value.
updateObject(int, Object) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an Object value.
updateObject(String, Object, int) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an Object value.
updateObject(String, Object) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with an Object value.
updateRef(int, Ref) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Ref value.
updateRef(String, Ref) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Ref value.
updateRow() - Method in class org.hsqldb.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.jdbcResultSet
Updates the designated column with a short value.
updateShort(String, short) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a short value.
updateString(int, String) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a String value.
updateString(String, String) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a String value.
updateTime(int, Time) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Time value.
updateTime(String, Time) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Time value.
updateTimestamp(int, Timestamp) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Timestamp value.
updateTimestamp(String, Timestamp) - Method in class org.hsqldb.jdbcResultSet
Updates the designated column with a java.sql.Timestamp value.
updatesAreDetected(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.
usesLocalFilePerTable() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database uses a file for each table.
usesLocalFiles() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database stores tables in a local file.

V

VIEW_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
VIEW_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
VIOLATION_OF_UNIQUE_INDEX - Static variable in class org.hsqldb.Trace
 

W

WRONG_DATABASE_FILE_VERSION - Static variable in class org.hsqldb.Trace
 
WRONG_DATA_TYPE - Static variable in class org.hsqldb.Trace
 
WRONG_DEFAULT_CLAUSE - Static variable in class org.hsqldb.Trace
 
WRONG_OUT_PARAMETER - Static variable in class org.hsqldb.Trace
 
WebServer - class org.hsqldb.WebServer.
WebServer acts as an HTTP server and is one way of using the client / server mode of HSQL Database Engine.
WebServer() - Constructor for class org.hsqldb.WebServer
 
wasNull() - Method in class org.hsqldb.jdbcPreparedStatement
Retrieves whether the last OUT parameter read had the value of SQL NULL.
wasNull() - Method in class org.hsqldb.jdbcResultSet
Reports whether the last column read had a value of SQL NULL.
windowActivated(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowActivated(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowActivated(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowActivated(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
windowClosed(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowClosed(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowClosed(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowClosed(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
windowClosing(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowClosing(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowClosing(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowClosing(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
windowClosing(WindowEvent) - Method in class org.hsqldb.util.ZaurusConnectionDialog
Method declaration
windowDeactivated(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowDeactivated(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowDeactivated(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowDeactivated(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
windowDeiconified(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowDeiconified(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowDeiconified(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowDeiconified(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
windowIconified(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowIconified(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowIconified(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowIconified(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
windowOpened(WindowEvent) - Method in class org.hsqldb.util.DatabaseManager
Method declaration
windowOpened(WindowEvent) - Method in class org.hsqldb.util.DatabaseManagerSwing
 
windowOpened(WindowEvent) - Method in class org.hsqldb.util.QueryTool
Method declaration
windowOpened(WindowEvent) - Method in class org.hsqldb.util.Transfer
Method declaration
work(String[]) - Static method in class org.hsqldb.util.Transfer
Method declaration
write(String) - Method in class org.hsqldb.Trace
 

Z

ZaurusChoice - class org.hsqldb.util.ZaurusChoice.
Class declaration
ZaurusChoice() - Constructor for class org.hsqldb.util.ZaurusChoice
 
ZaurusComponent - interface org.hsqldb.util.ZaurusComponent.
Interface declaration
ZaurusConnectionDialog - class org.hsqldb.util.ZaurusConnectionDialog.
Class declaration
ZaurusDatabaseManager - class org.hsqldb.util.ZaurusDatabaseManager.
Class declaration
ZaurusDatabaseManager() - Constructor for class org.hsqldb.util.ZaurusDatabaseManager
 
ZaurusEditor - class org.hsqldb.util.ZaurusEditor.
ZaurusEditor implements an search/input/edit form to search/view/update/insert table records.
ZaurusEditor() - Constructor for class org.hsqldb.util.ZaurusEditor
Constructor declaration
ZaurusTableForm - class org.hsqldb.util.ZaurusTableForm.
Class declaration
ZaurusTableForm(String, Connection) - Constructor for class org.hsqldb.util.ZaurusTableForm
 
ZaurusTextField - class org.hsqldb.util.ZaurusTextField.
Class declaration
ZaurusTextField(int) - Constructor for class org.hsqldb.util.ZaurusTextField
 

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

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