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

A

abort(Executor) - Method in class org.hsqldb.jdbc.JDBCConnection
Terminates an open connection.
absolute(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the given row number in this ResultSet object.
acceptsURL(String) - Method in class org.hsqldb.jdbc.JDBCDriver
Returns true if the driver thinks that it can open a connection to the given URL.
acceptsURL(String) - Method in class org.hsqldb.jdbc.JDBCDriver
Returns true if the driver thinks that it can open a connection to the given URL.
addBatch() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Adds a set of parameters to this PreparedStatement object's batch of commands.
addBatch(String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
This method should always throw if called for a PreparedStatement or CallableStatment.
addBatch(String) - Method in class org.hsqldb.jdbc.JDBCStatement
Adds the given SQL command to the current list of commmands for this Statement object.
addMacros(Map<String, Token>) - Method in class org.hsqldb.cmdline.SqlFile
 
addUserVars(Map<String, String>) - Method in class org.hsqldb.cmdline.SqlFile
 
afterLast() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the end of this ResultSet object, just after the last row.
allProceduresAreCallable() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether the current user can call all the procedures returned by the method getProcedures.
allTablesAreSelectable() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.
AuthBeanMultiplexer - Class in org.hsqldb.auth
This class provides a method which can be used directly as a HyperSQL static Java function method.
authenticate(String, String, String) - Static method in class org.hsqldb.auth.AuthBeanMultiplexer
HyperSQL Java Function Method.
authenticate(String, String) - Method in interface org.hsqldb.auth.AuthFunctionBean
Return a list of authorized roles or null to indicate that the implementation does not intend to produce a specific role list but only to indicate whether to allow access or not.
authenticate(String, String) - Method in class org.hsqldb.auth.HsqldbSlaveAuthBean
 
authenticate(String, String) - Method in class org.hsqldb.auth.JaasAuthBean
 
authenticate(String, String) - Method in class org.hsqldb.auth.LdapAuthBean
 
AuthFunctionBean - Interface in org.hsqldb.auth
N.b.
autoCommitFailureClosesAllResultSets() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a SQLException while autoCommit is true inidcates that all open ResultSets are closed, even ones that are holdable.

B

beforeFirst() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the front of this ResultSet object, just before the first row.
bitCharsToBytes(String) - Static method in class org.hsqldb.cmdline.SqlFile
Just a stub for now.

C

cancel() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
cancel() - Method in class org.hsqldb.jdbc.JDBCStatement
Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
cancelRowUpdates() - Method in class org.hsqldb.jdbc.JDBCResultSet
Cancels the updates made to the current row in this ResultSet object.
canDisplayType(int) - Static method in class org.hsqldb.cmdline.SqlFile
This method is used to tell SqlFile whether this Sql Type must ALWAYS be loaded to the binary buffer without displaying.
catalogName - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's table's catalog name.
characters(char[], int, int) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of character data.
charset - Variable in class org.hsqldb.lib.RCData
 
checkRunning(boolean) - Method in class org.hsqldb.server.Server
Checks if this Server object is or is not running and throws if the current state does not match the specified value.
clear() - Method in class org.hsqldb.auth.AuthBeanMultiplexer
Clear the set of AuthFunctionBeans
clearBatch() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Empties this Statement object's current list of SQL commands.
clearBatch() - Method in class org.hsqldb.jdbc.JDBCStatement
Empties this Statement object's current list of SQL commands.
clearLoggers(String) - Static method in class org.hsqldb.lib.FrameworkLogger
Frees Logger(s), if any, with the specified category, or that begins with the specified prefix + dot.
clearParameters() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Clears the current parameter values immediately.
clearUpdates() - Method in class org.hsqldb.jdbc.JDBCBlobClient
 
clearUpdates() - Method in class org.hsqldb.jdbc.JDBCClobClient
 
clearWarnings() - Method in class org.hsqldb.jdbc.JDBCConnection
Clears all warnings reported for this Connection object.
clearWarnings() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Clears all the warnings reported on this Statement object.
clearWarnings() - Method in class org.hsqldb.jdbc.JDBCResultSet
Clears all warnings reported on this ResultSet object.
clearWarnings() - Method in class org.hsqldb.jdbc.JDBCStatement
Clears all the warnings reported on this Statement object.
close() - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Does the specialized work required to free this object's resources and that of it's parent classes.
close() - Method in class org.hsqldb.jdbc.JDBCConnection
Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.
close(int) - Method in class org.hsqldb.jdbc.JDBCPool
Closes the pool immediately.
close() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Does the specialized work required to free this object's resources and that of it's parent class.
close() - Method in class org.hsqldb.jdbc.JDBCResultSet
Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
close() - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Closes this object.
close() - Method in class org.hsqldb.jdbc.JDBCStatement
Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
CLOSE_CURSORS_AT_COMMIT - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
closeFully() - Method in class org.hsqldb.jdbc.JDBCConnection
Completely closes a pooled connection
closeOnCompletion() - Method in class org.hsqldb.jdbc.JDBCCallableStatement
 
closeReader() - Method in class org.hsqldb.cmdline.SqlFile
Close the reader.
colonNotation(byte[]) - Static method in class org.hsqldb.server.ServerAcl
 
columnClassName - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.
columnDisplaySize - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's normal max width in chars.
columnLabel - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The suggested column title for use in printouts and displays.
columnName - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's name.
columnType - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's SQL type.
comment(char[], int, int) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
 
commit() - Method in class org.hsqldb.jdbc.JDBCConnection
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object.
CONCUR_READ_ONLY - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
CONCUR_UPDATABLE - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
connect(String, Properties) - Method in class org.hsqldb.jdbc.JDBCDriver
Attempts to make a database connection to the given URL.
connect(String, Properties) - Method in class org.hsqldb.jdbc.JDBCDriver
Attempts to make a database connection to the given URL.
CONNECTERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
connectionClosed() - Method in interface org.hsqldb.jdbc.JDBCConnectionEventListener
 
connectionClosed(ConnectionEvent) - Method in class org.hsqldb.jdbc.JDBCPool
 
connectionClosedException() - Static method in class org.hsqldb.jdbc.Util
 
connectionErrorOccured(SQLException) - Method in interface org.hsqldb.jdbc.JDBCConnectionEventListener
 
connectionErrorOccurred(ConnectionEvent) - Method in class org.hsqldb.jdbc.JDBCPool
 
convertEscapes(String) - Static method in class org.hsqldb.cmdline.SqlFile
Translates user-supplied escapes into the traditionaly corresponding corresponding binary characters.
createArrayOf(String, Object[]) - Method in class org.hsqldb.jdbc.JDBCConnection
Factory method for creating Array objects.
createBlob() - Method in class org.hsqldb.jdbc.JDBCConnection
Constructs an object that implements the Blob interface.
createClob() - Method in class org.hsqldb.jdbc.JDBCConnection
Constructs an object that implements the Clob interface.
createDataSource(Properties) - Static method in class org.hsqldb.jdbc.JDBCDataSourceFactory
Static method to create a JDBCDataSource instance using the given properties for url, user, password, etc.
createNClob() - Method in class org.hsqldb.jdbc.JDBCConnection
Constructs an object that implements the NClob interface.
createSQLXML() - Method in class org.hsqldb.jdbc.JDBCConnection
Constructs an object that implements the SQLXML interface.
createStatement() - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a Statement object for sending SQL statements to the database.
createStatement(int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
createStatement(int, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.
createStruct(String, Object[]) - Method in class org.hsqldb.jdbc.JDBCConnection
Factory method for creating Struct objects.

D

dataDefinitionCausesTransactionCommit() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a data definition statement within a transaction forces the transaction to commit.
dataDefinitionIgnoredInTransactions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database ignores a data definition statement within a transaction.
DbBackup - Class in org.hsqldb.lib.tar
Works with tar archives containing HSQLDB database instance backups.
DbBackup(File, String) - Constructor for class org.hsqldb.lib.tar.DbBackup
Instantiate a DbBackup instance for creating a Database Instance backup.
DbBackup(File, String, boolean) - Constructor for class org.hsqldb.lib.tar.DbBackup
Used for SCRIPT backup
DEFAULT_JDBC_DRIVER - Static variable in class org.hsqldb.lib.RCData
 
DEFAULT_RCFILE - Static variable in class org.hsqldb.cmdline.SqlTool
 
DELETE_AFTER - Static variable in interface org.hsqldb.Trigger
 
DELETE_AFTER_ROW - Static variable in interface org.hsqldb.Trigger
 
DELETE_BEFORE_ROW - Static variable in interface org.hsqldb.Trigger
 
deleteRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Deletes the current row from this ResultSet object and from the underlying database.
deletesAreDetected(int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.
doesMaxRowSizeIncludeBlobs() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
dottedNotation(byte[]) - Static method in class org.hsqldb.server.ServerAcl
 
driver - Variable in class org.hsqldb.lib.RCData
 
driverInstance - Static variable in class org.hsqldb.jdbc.JDBCDriver
 
driverInstance - Static variable in class org.hsqldb.jdbc.JDBCDriver
 
dsvSafe(String) - Method in class org.hsqldb.cmdline.SqlFile
Validate that String is safe to write TO DSV file.

E

endDocument() - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of the end of a document.
endElement(String, String, String) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of the end of an element.
endPrefixMapping(String) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
End the scope of a prefix-URI mapping.
enduserlog(Level, String) - Method in class org.hsqldb.lib.FrameworkLogger
 
equals(Object) - Method in class org.hsqldb.jdbc.JDBCRowId
Compares this RowId to the specified object.
error(String) - Method in class org.hsqldb.lib.FrameworkLogger
This is just a wrapper for FrameworkLogger.warning(), because java.util.logging lacks a method for this critical purpose.
error(String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.error(String), but also logs a stack trace.
escapeHtml(String) - Static method in class org.hsqldb.cmdline.SqlFile
Escaping rules taken from 'Reserved Characters in HTML table at http://www.w3schools.com/tags/ref_entities.asp
execute() - Method in class org.hsqldb.cmdline.SqlFile
Process all the commands from the file or Reader associated with "this" object.
execute() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
execute(String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
This method should always throw if called for a PreparedStatement or CallableStatment.
execute(String, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
 
execute(String, int[]) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
 
execute(String, String[]) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
 
execute(String) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement, which may return multiple results.
execute(String, int) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
execute(String, int[]) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
execute(String, String[]) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
executeBatch() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeBatch() - Method in class org.hsqldb.jdbc.JDBCStatement
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeFiles(String[]) - Method in class org.hsqldb.sample.SqlFileEmbedder
Your own classes can use this method to execute SQL files.
executeQuery() - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
executeQuery() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
executeQuery(String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
This method should always throw if called for a PreparedStatement or CallableStatment.
executeQuery(String) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement, which returns a single ResultSet object.
executeUpdate() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Executes the SQL statement in this PreparedStatement object, (JDBC4 clarification:) which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
executeUpdate(String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
This method should always throw if called for a PreparedStatement or CallableStatment.
executeUpdate(String, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Statement methods that must be overridden in this class and throw an exception.
executeUpdate(String, int[]) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
 
executeUpdate(String, String[]) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
 
executeUpdate(String) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
executeUpdate(String, int) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
executeUpdate(String, int[]) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
executeUpdate(String, String[]) - Method in class org.hsqldb.jdbc.JDBCStatement
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
expandSysPropVars(String) - Static method in class org.hsqldb.lib.RCData
Returns a copy of the given String with System property names in the format ${system.property} replaced by the corresponding Java System Properties.

F

FETCH_FORWARD - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
FETCH_REVERSE - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
FETCH_UNKNOWN - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
FILEERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
findColumn(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Maps the given ResultSet column label to its ResultSet column index.
finer(String) - Method in class org.hsqldb.lib.FrameworkLogger
 
finer(String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.finer(String), but also logs a stack trace.
finest(String) - Method in class org.hsqldb.lib.FrameworkLogger
 
finest(String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.finest(String), but also logs a stack trace.
fire(int, String, String, Object[], Object[]) - Method in class org.hsqldb.sample.TriggerSample
A sample HSQLDB Trigger interface implementation.
fire(int, String, String, Object[], Object[]) - Method in interface org.hsqldb.Trigger
The method invoked upon each triggered action.
first() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the first row in this ResultSet object.
FrameworkLogger - Class in org.hsqldb.lib
A logging framework wrapper that supports java.util.logging and log4j.
free() - Method in class org.hsqldb.jdbc.JDBCArray
This method frees the Array object and releases the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
This method frees the Array object and releases the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCBlob
This method frees the Blob object and releases the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCBlobClient
This method frees the Blob object and releases the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCBlobFile
This method frees the Blob object and releases the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCClob
This method frees the Clob object and releases the resources the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCClobClient
This method frees the Clob object and releases the resources the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCClobFile
This method frees the Clob object and releases the resources the resources that it holds.
free() - Method in class org.hsqldb.jdbc.JDBCSQLXML
This method closes this object and releases the resources that it held.

G

generatedKeyAlwaysReturned() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.
getAbortUponModify() - Method in class org.hsqldb.lib.tar.DbBackup
 
getAddress() - Method in class org.hsqldb.server.Server
Retrieves, in string form, this server's host address.
getArray() - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves the contents of the SQL ARRAY value designated by this Array object in the form of an array in the Java programming language.
getArray(Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves the contents of the SQL ARRAY value designated by this Array object.
getArray(long, int) - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves a slice of the SQL ARRAY value designated by this Array object, beginning with the specified index and containing up to count successive elements of the SQL array.
getArray(long, int, Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArray
Retreives a slice of the SQL ARRAY value designated by this Array object, beginning with the specified index and containing up to count successive elements of the SQL array.
getArray() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves the contents of the SQL ARRAY value designated by this Array object in the form of an array in the Java programming language.
getArray(Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves the contents of the SQL ARRAY value designated by this Array object.
getArray(long, int) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves a slice of the SQL ARRAY value designated by this Array object, beginning with the specified index and containing up to count successive elements of the SQL array.
getArray(long, int, Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retreives a slice of the SQL ARRAY value designated by this Array object, beginning with the specified index and containing up to count successive elements of the SQL array.
getArray(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language.
getArray(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
getArray(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
getArray(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
getArrayInternal() - Method in class org.hsqldb.jdbc.JDBCArray
 
getAsciiStream() - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves the CLOB value designated by this Clob object as an ASCII stream.
getAsciiStream() - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves the CLOB value designated by this Clob object as an ascii stream.
getAsciiStream() - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the CLOB value designated by this Clob object as an ascii stream.
getAsciiStream(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
getAsciiStream(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
getAttributes(String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.
getAutoCommit() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves the current auto-commit mode for this Connection object.
getBanner(Connection) - Static method in class org.hsqldb.cmdline.SqlFile
Returns a String report for the specified JDBC Connection.
getBaseType() - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves the JDBC type of the elements in the array designated by this Array object.
getBaseType() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves the JDBC type of the elements in the array designated by this Array object.
getBaseTypeName() - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves the SQL type name of the elements in the array designated by this Array object.
getBaseTypeName() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves the SQL type name of the elements in the array designated by this Array object.
getBestRowIdentifier(String, String, String, int, boolean) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of a table's optimal set of columns that uniquely identifies a row.
getBigDecimal(int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Deprecated. use getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)
getBigDecimal(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.
getBigDecimal(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.
getBigDecimal(int, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Deprecated. by java.sun.com as of JDK 1.2
getBigDecimal(String, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Deprecated. by java.sun.com as of JDK 1.2
getBigDecimal(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
getBigDecimal(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCBlob
Retrieves the BLOB value designated by this Blob instance as a stream.
getBinaryStream(long, long) - Method in class org.hsqldb.jdbc.JDBCBlob
Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCBlobClient
Retrieves the BLOB value designated by this Blob instance as a stream.
getBinaryStream(long, long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves the BLOB value designated by this Blob instance as a stream.
getBinaryStream(long, long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Returns an InputStream object that contains a partial Blob value, starting with the byte specified by pos, which is length bytes in length.
getBinaryStream(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
getBinaryStream(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Retrieves the XML value designated by this SQLXML instance as a stream.
getBlob() - Method in class org.hsqldb.jdbc.JDBCBlobClient
 
getBlob(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.
getBlob(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
getBlob(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
getBlob(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
getBoolean(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
(JDBC4 modified:) Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
getBoolean(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
(JDBC4 modified:)
getBoolean(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
getBoolean(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
getByte(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
getByte(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
getByte(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
getByte(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
getBytes(long, int) - Method in class org.hsqldb.jdbc.JDBCBlob
Retrieves all or part of the BLOB value that this Blob object represents, as an array of bytes.
getBytes(long, int) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Retrieves all or part of the BLOB value that this Blob object represents, as an array of bytes.
getBytes(long, int) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves all or part of the BLOB value that this Blob object represents, as an array of bytes.
getBytes(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
getBytes(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
getBytes(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
getBytes(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
getBytes() - Method in class org.hsqldb.jdbc.JDBCRowId
Returns an array of bytes representing the value of the SQL ROWID designated by this java.sql.RowId object.
getCatalog() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves this Connection object's current catalog name.
getCatalogName(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Gets the designated column's table's catalog name.
getCatalogs() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the catalog names available in this database.
getCatalogSeparator() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the String that this database uses as the separator between a catalog and table name.
getCatalogTerm() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the database vendor's preferred term for "catalog".
getCharacterStream(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
getCharacterStream(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).
getCharacterStream(long, long) - Method in class org.hsqldb.jdbc.JDBCClob
Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.
getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).
getCharacterStream(long, long) - Method in class org.hsqldb.jdbc.JDBCClobClient
Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.
getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the CLOB value designated by this Clob object as a java.io.Reader object (or as a stream of characters).
getCharacterStream(long, long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Returns a Reader object that contains a partial Clob value, starting with the character specified by pos, which is length characters in length.
getCharacterStream(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getCharacterStream(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.
getClientInfo(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Returns the value of the client info property specified by name.
getClientInfo() - Method in class org.hsqldb.jdbc.JDBCConnection
Returns a list containing the name and current value of each client info property supported by the driver.
getClientInfoProperties() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a list of the client info properties that the driver supports.
getClob(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
getClob(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
getClob() - Method in class org.hsqldb.jdbc.JDBCClobClient
 
getClob(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
getClob(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
getColumnClassName(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
 
getColumnCount() - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Returns the number of columns in this ResultSet object.
getColumnDisplaySize(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates the designated column's normal maximum width in characters.
getColumnLabel(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Gets the designated column's suggested title for use in printouts and displays.
getColumnName(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Get the designated column's name.
getColumnPrivileges(String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the access rights for a table's columns.
getColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of table columns available in the specified catalog.
getColumnType(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Retrieves the designated column's SQL type.
getColumnTypeName(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Retrieves the designated column's database-specific type name.
getConcurrency() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the concurrency mode of this ResultSet object.
getConn() - Method in class org.hsqldb.sample.SqlFileEmbedder
For applications that use a persistent JDBC connection, this class can be used to encapsulate that connection.
getConnection() - Method in class org.hsqldb.cmdline.SqlFile
 
getConnection() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the connection that produced this metadata object.
getConnection() - Method in class org.hsqldb.jdbc.JDBCDataSource
Retrieves a new connection using the properties that have already been set.
getConnection(String, String) - Method in class org.hsqldb.jdbc.JDBCDataSource
Retrieves a new connection using the given username and password, and the database url that has been set.
getConnection(String, Properties) - Static method in class org.hsqldb.jdbc.JDBCDriver
The static equivalent of the connect(String,Properties) method.
getConnection(String, Properties) - Static method in class org.hsqldb.jdbc.JDBCDriver
The static equivalent of the connect(String,Properties) method.
getConnection() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves a new connection using the properties that have already been set.
getConnection(String, String) - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves a new connection using the given username and password, and the database url that has been set.
getConnection() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the Connection object that produced this Statement object.
getConnection() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the Connection object that produced this Statement object.
getConnection() - Method in class org.hsqldb.lib.RCData
Gets a JDBC Connection using the data of this RCData object.
getConnection(String, String) - Method in class org.hsqldb.lib.RCData
Gets a JDBC Connection using the data of this RCData object with specified override elements
getCrossReference(String, String, String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
(JDBC4 clarification:) Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).
getCurrentSchema() - Method in class org.hsqldb.cmdline.SqlFile
 
getCursorName() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the name of the SQL cursor used by this ResultSet object.
getDatabase() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Synonym for getUrl().
getDatabase() - Method in class org.hsqldb.jdbc.JDBCPool
Synonym for getUrl().
getDatabaseMajorVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the major version number of the underlying database.
getDatabaseMinorVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the minor version number of the underlying database.
getDatabaseName() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Synonym for getUrl().
getDatabaseName() - Method in class org.hsqldb.jdbc.JDBCPool
Synonym for getUrl().
getDatabaseName(int, boolean) - Method in class org.hsqldb.server.Server
Retrieves the url alias (network name) of the i'th database that this Server hosts.
getDatabasePath(int, boolean) - Method in class org.hsqldb.server.Server
Retrieves the HSQLDB path descriptor (uri) of the i'th Database that this Server hosts.
getDatabaseProductName() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the name of this database product.
getDatabaseProductVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the version number of this database product.
getDatabaseType(int) - Method in class org.hsqldb.server.Server
 
getDataSourceName() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the name of the data source.
getDataSourceName() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves the name of the data source.
getDate(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.
getDate(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
getDate(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
getDate(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
getDate(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
getDate(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
getDate(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
getDate(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
getDefaultJdbcDriverName() - Method in class org.hsqldb.lib.RCData
 
getDefaultTransactionIsolation() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves this database's default transaction isolation level.
getDefaultWebPage() - Method in class org.hsqldb.server.Server
Retrieves the name of the web page served when no page is specified.
getDefaultWebPage() - Method in class org.hsqldb.server.WebServer
Retrieves the name of the web page served when no page is specified.
getDescription() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the description of the data source.
getDescription() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves the description of the data source.
getDocumentLocator() - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Retrieves the Locator.
getDouble(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
getDouble(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
getDouble(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
getDouble(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
getDriverMajorVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves this JDBC driver's major version number.
getDriverMinorVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves this JDBC driver's minor version number.
getDriverName() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the name of this JDBC driver.
getDriverVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the version number of this JDBC driver as a String.
getEncoding() - Method in class org.hsqldb.jdbc.JDBCClobFile
 
getErrWriter() - Method in class org.hsqldb.server.Server
Retrieves the PrintWriter to which server errors are printed.
getExportedKeys(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
getExtraNameCharacters() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
getFetchDirection() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.
getFetchDirection() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the fetch direction for this ResultSet object.
getFetchDirection() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.
getFetchSize() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
getFetchSize() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the fetch size for this ResultSet object.
getFetchSize() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
getFile() - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves the canonical File object denoting the file that backs this BLOB.
getFile() - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the canonical File object denoting the file that backs this CLOB.
getFloat(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
getFloat(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
getFloat(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
getFloat(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
getForEachSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
 
getFunctionColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the given catalog's system or user function parameters and return type.
getFunctions(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the JDBC 4.1[ system and ]user functions available in the given catalog.
getGeneratedKeys() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves any auto-generated keys created as a result of executing this Statement object.
getGeneratedKeys() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves any auto-generated keys created as a result of executing this Statement object.
getHelpString() - Method in class org.hsqldb.server.Server
Retrieves a String object describing the command line and properties options for this Server.
getHelpString() - Method in class org.hsqldb.server.WebServer
Retrieves a String object describing the command line and properties options for this Server.
getHoldability() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves the current holdability of ResultSet objects created using this Connection object.
getHoldability() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the holdability of this ResultSet object
getIdentifierQuoteString() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the string used to quote SQL identifiers.
getImportedKeys(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).
getIndexInfo(String, String, String, boolean, boolean) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the given table's indices and statistics.
getInt(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
getInt(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
getInt(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
getInt(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
getJDBCMajorVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the major JDBC version number for this driver.
getJDBCMinorVersion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the minor JDBC version number for this driver.
getLog(Class) - Static method in class org.hsqldb.lib.FrameworkLogger
User's entry-point into this logging system.
getLog(Class, String) - Static method in class org.hsqldb.lib.FrameworkLogger
This method just defers to the getLog(Class) method unless default (no local configuration) JDK logging is being used; In that case, this method assures that the returned logger has an associated FileHander using the supplied String identifier.
getLog(String, String) - Static method in class org.hsqldb.lib.FrameworkLogger
This method just defers to the getLog(String) method unless default (no local configuration) JDK logging is being used; In that case, this method assures that the returned logger has an associated FileHander using the supplied String identifier.
getLog(String) - Static method in class org.hsqldb.lib.FrameworkLogger
Alternative entry-point into this logging system, for cases where you want to share a single logger instance among multiple classes, or you want to use multiple logger instances from a single class.
getLoginTimeout() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
getLoginTimeout() - Method in class org.hsqldb.jdbc.JDBCPool
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
getLogWriter() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the log writer for this DataSource object.
getLogWriter() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves the log writer for this DataSource object.
getLogWriter() - Method in class org.hsqldb.server.Server
Retrieves the PrintWriter to which server messages are printed.
getLong(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
getLong(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
getLong(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
getLong(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
getMacros() - Method in class org.hsqldb.cmdline.SqlFile
 
getMajorVersion() - Method in class org.hsqldb.jdbc.JDBCDriver
Gets the driver's major version number.
getMajorVersion() - Method in class org.hsqldb.jdbc.JDBCDriver
Gets the driver's major version number.
getMaxBinaryLiteralLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of hex characters this database allows in an inline binary literal.
getMaxCatalogNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a catalog name.
getMaxCharLiteralLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters this database allows for a character literal.
getMaxColumnNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters this database allows for a column name.
getMaxColumnsInGroupBy() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of columns this database allows in a GROUP BY clause.
getMaxColumnsInIndex() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of columns this database allows in an index.
getMaxColumnsInOrderBy() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of columns this database allows in an ORDER BY clause.
getMaxColumnsInSelect() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of columns this database allows in a SELECT list.
getMaxColumnsInTable() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of columns this database allows in a table.
getMaxConnections() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of concurrent connections to this database that are possible.
getMaxCursorNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a cursor name.
getMaxFieldSize() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
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.
getMaxFieldSize() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
getMaxIndexLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.
getMaxProcedureNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a procedure name.
getMaxRows() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
getMaxRows() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
getMaxRowSize() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of bytes this database allows in a single row.
getMaxSchemaNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters that this database allows in a schema name.
getMaxStatementLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters this database allows in an SQL statement.
getMaxStatements() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of active statements to this database that can be open at the same time.
getMaxTableNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters this database allows in a table name.
getMaxTablesInSelect() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of tables this database allows in a SELECT statement.
getMaxUserNameLength() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the maximum number of characters this database allows in a user name.
getMetaData() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves a DatabaseMetaData object that contains metadata about the database to which this Connection object represents a connection.
getMetaData() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.
getMetaData() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the number, types and properties of this ResultSet object's columns.
getMinorVersion() - Method in class org.hsqldb.jdbc.JDBCDriver
Gets the driver's minor version number.
getMinorVersion() - Method in class org.hsqldb.jdbc.JDBCDriver
Gets the driver's minor version number.
getMoreResults(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
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.
getMoreResults() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
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() - Method in class org.hsqldb.jdbc.JDBCStatement
Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.
getMoreResults(int) - Method in class org.hsqldb.jdbc.JDBCStatement
Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.
getNCharacterStream(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
getNCharacterStream(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
getNCharacterStream(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getNCharacterStream(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
getNClob(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
getNClob(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
getNClob(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
getNClob(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
getNetworkProtocol() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the network protocol of the data source.
getNetworkTimeout() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves the number of milliseconds the driver will wait for a database request to complete.
getNString(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
getNString(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
getNString(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
getNString(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
getNumericFunctions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a comma-separated list of math functions available with this database.
getObject(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated parameter as an Object in the Java programming language.
getObject(int, Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.
getObject(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a parameter as an Object in the Java programming language.
getObject(String, Map) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
 
getObject(int, Class<T>) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
getObject(String, Class<T>) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
getObject(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
 
getObject(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
 
getObject(int, Map) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
getObject(String, Map) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
getObject(int, Class<T>) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
getObject(String, Class<T>) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
getObjectInstance(Object, Name, Context, Hashtable) - Method in class org.hsqldb.jdbc.JDBCDataSourceFactory
Creates a DataSource object using the javax.naming.Reference object specified.
getOperationSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
 
getOverWrite() - Method in class org.hsqldb.lib.tar.DbBackup
 
getParameterClassName(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject.
getParameterCount() - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object contains information.
getParameterMetaData() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the number, types and properties of this PreparedStatement object's parameters.
getParameterMode(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the designated parameter's mode.
getParameterType(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the designated parameter's SQL type.
getParameterTypeName(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the designated parameter's database-specific type name.
getParentLogger() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Return the parent Logger of all the Loggers used by this data source.
getParentLogger() - Method in class org.hsqldb.jdbc.JDBCDriver
Return the parent Logger of all the Loggers used by this driver.
getParentLogger() - Method in class org.hsqldb.jdbc.JDBCDriver
Return the parent Logger of all the Loggers used by this driver.
getParentLogger() - Method in class org.hsqldb.jdbc.JDBCPool
Return the parent Logger of all the Loggers used by this data source.
getPort() - Method in class org.hsqldb.server.Server
Retrieves this server's host port.
getPrecision(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the designated parameter's specified column size.
getPrecision(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
(JDBC4 clarification:) Get the designated column's specified column size.
getPrimaryKeys(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the given table's primary key columns.
getProcedureColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the given catalog's stored procedure parameter and result columns.
getProcedures(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the stored procedures available in the given catalog.
getProcedureTerm() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the database vendor's preferred term for "procedure".
getProductName() - Method in class org.hsqldb.server.Server
Retrieves this server's product name.
getProductName() - Method in class org.hsqldb.server.WebServer
Retrieves this server's product name.
getProductVersion() - Method in class org.hsqldb.server.Server
Retrieves the server's product version, as a String.
getPropertyInfo(String, Properties) - Method in class org.hsqldb.jdbc.JDBCDriver
Gets information about the possible properties for this driver.
getPropertyInfo(String, Properties) - Method in class org.hsqldb.jdbc.JDBCDriver
Gets information about the possible properties for this driver.
getProtocol() - Method in class org.hsqldb.server.Server
Retrieves a string respresentaion of the network protocol this server offers, typically one of 'HTTP', HTTPS', 'HSQL' or 'HSQLS'.
getProtocol() - Method in class org.hsqldb.server.WebServer
Retrieves a string respresentaion of the network protocol this server offers, typically one of 'HTTP', HTTPS', 'HSQL' or 'HSQLS'.
getPseudoColumns(String, String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.
getQueryTimeout() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the number of seconds the driver will wait for a Statement object to execute.
getQueryTimeout() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the number of seconds the driver will wait for a Statement object to execute.
getQueueSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
 
getRef(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.
getRef(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.
getRef(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
getRef(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
getReference() - Method in class org.hsqldb.jdbc.JDBCDataSource
Retrieves the Reference of this object.
getReference() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves the Reference of this object.
getResultSet() - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object.
getResultSet(Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object.
getResultSet(long, int) - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements.
getResultSet(long, int, Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArray
Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements.
getResultSet() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object.
getResultSet(Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object.
getResultSet(long, int) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements.
getResultSet(long, int, Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Retrieves a result set holding the elements of the subarray that starts at index index and contains up to count successive elements.
getResultSet() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the current result as a ResultSet object.
getResultSet() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the current result as a ResultSet object.
getResultSetConcurrency() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
getResultSetConcurrency() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
getResultSetHoldability() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
(JDBC4 clarification:) Retrieves this database's default holdability for ResultSet objects.
getResultSetHoldability() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the result set holdability for ResultSet objects generated by this Statement object.
getResultSetHoldability() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the result set holdability for ResultSet objects generated by this Statement object.
getResultSetType() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the result set type for ResultSet objects generated by this Statement object.
getResultSetType() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the result set type for ResultSet objects generated by this Statement object.
getRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the current row number.
getRowId(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
getRowId(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
getRowId(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
getRowId(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
getRowIdLifetime() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Indicates whether or not this data source supports the SQL ROWID type, and if so the lifetime for which a RowId object remains valid.
getSavepointId() - Method in class org.hsqldb.jdbc.JDBCSavepoint
Retrieves the generated ID for the savepoint that this Savepoint object represents.
getSavepointName() - Method in class org.hsqldb.jdbc.JDBCSavepoint
Retrieves the name of the savepoint that this Savepoint object represents.
getScale(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves the designated parameter's number of digits to right of the decimal point.
getScale(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Gets the designated column's number of digits to right of the decimal point.
getSchema() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves this Connection object's current schema name.
getSchemaName(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Get the designated column's table's schema.
getSchemas() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the schema names available in this database.
getSchemas(String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the schema names available in this database.
getSchemaTerm() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the database vendor's preferred term for "schema".
getSearchStringEscape() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the string that can be used to escape wildcard characters.
getServerError() - Method in class org.hsqldb.server.Server
Retrieves a Throwable indicating the last server error, if any.
getServerId() - Method in class org.hsqldb.server.Server
Retrieves a String identifying this Server object.
getServerName() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the server name attribute.
getServerThread() - Method in class org.hsqldb.server.Server
Returns thread object for "HSQLDB Server" thread
getSession() - Method in class org.hsqldb.jdbc.JDBCConnection
provides cross-package access to the proprietary (i.e.
getShort(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
getShort(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
getShort(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
getShort(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
getSingleton() - Static method in class org.hsqldb.auth.AuthBeanMultiplexer
 
getSource(Class<T>) - Method in class org.hsqldb.jdbc.JDBCSQLXML
Returns a Source for reading the XML value designated by this SQLXML instance.
getSQLKeywords() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.
getSQLStateType() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
(JDBC4 modified:) Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.
getSQLXML(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
getSQLXML(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
getSQLXML(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
getSQLXML(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
getState() - Method in class org.hsqldb.server.Server
Retrieves current state of this server in numerically coded form.
getStateDescriptor() - Method in class org.hsqldb.server.Server
Retrieves a character sequence describing this server's current state, including the message of the last exception, if there is one and it is still in context.
getStatement() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the Statement object that produced this ResultSet object.
getString(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
getString(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
getString(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
getString(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
getString() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Returns a string representation of the XML value designated by this SQLXML instance.
getStringFunctions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a comma-separated list of string functions available with this database.
getSubString(long, int) - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves a copy of the specified substring in the CLOB value designated by this Clob object.
getSubString(long, int) - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves a copy of the specified substring in the CLOB value designated by this Clob object.
getSubString(long, int) - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves a copy of the specified substring in the CLOB value designated by this Clob object.
getSuperTables(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the table hierarchies defined in a particular schema in this database.
getSuperTypes(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
getSystemFunctions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a comma-separated list of system functions available with this database.
getTableName(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Gets the designated column's table name.
getTablePrivileges(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the access rights for each table available in a catalog.
getTables(String, String, String, String[]) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the tables available in the given catalog.
getTableTypes() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the table types available in this database.
getTime(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.
getTime(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
getTime(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
getTime(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
getTime(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
getTime(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
getTime(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
getTime(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
getTimeDateFunctions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a comma-separated list of the time and date functions available with this database.
getTimestamp(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
getTimestamp(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
getTimestamp(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
getTimestamp(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
getTimestamp(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
getTimestamp(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
getTransactionIsolation() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves this Connection object's current transaction isolation level.
getTriggerDDL(String, int, String, int, String) - Static method in class org.hsqldb.sample.TriggerSample
 
getTriggerDescriptor(String, int, String) - Static method in class org.hsqldb.sample.TriggerSample
 
getType() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the type of this ResultSet object.
getTypeInfo() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of all the (JDBC4 clarification:) data types supported by this database.
getTypeMap() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves the Map object associated with this Connection object.
getUDTs(String, String, String, int[]) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
getUnicodeStream(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Deprecated. use getCharacterStream in place of getUnicodeStream
getUnicodeStream(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Deprecated. use getCharacterStream instead
getUpdateCount() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
getUpdateCount() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
getURL(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
getURL(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
getUrl() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the jdbc database connection url attribute.
getURL() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the URL for this DBMS.
getUrl() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves the jdbc database connection url attribute.
getURL(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.
getURL(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.
getUser() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Retrieves the user name for the connection.
getUser() - Method in class org.hsqldb.jdbc.JDBCPool
Retrieves the user name for the connection.
getUserName() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves the user name as known to this database.
getUserVars() - Method in class org.hsqldb.cmdline.SqlFile
Get a reference to the user variable map.
getVersionColumns(String, String, String) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.
getWarnings() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves the first warning reported by calls on this Connection object.
getWarnings() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves the first warning reported by calls on this Statement object.
getWarnings() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves the first warning reported by calls on this ResultSet object.
getWarnings() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves the first warning reported by calls on this Statement object.
getWebRoot() - Method in class org.hsqldb.server.Server
Retrieves the root context (directory) from which web content is served.
getWebRoot() - Method in class org.hsqldb.server.WebServer
Retrieves the root context (directory) from which web content is served.
getWhenSpec(int) - Static method in class org.hsqldb.sample.TriggerSample
 
getWriter() - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
 

H

handle(Callback[]) - Method in class org.hsqldb.auth.JaasAuthBean.UPCallbackHandler
 
handleConnection(Socket) - Method in class org.hsqldb.server.Server
Assigns the specified socket to a new conection handler and starts the handler in a new Thread.
hashCode() - Method in class org.hsqldb.jdbc.JDBCRowId
Returns a hash code value of this RowId object.
hexCharOctetsToBytes(String) - Static method in class org.hsqldb.cmdline.SqlFile
Convert a String to a byte array by interpreting every 2 characters as an octal byte value.
HOLD_CURSORS_OVER_COMMIT - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
HsqldbSlaveAuthBean - Class in org.hsqldb.auth
Delegates authentication decisions, and optionally determination of user roles and schema, to a different HyperSQL catalog, which may be in the same JVM or remote.
HsqldbSlaveAuthBean() - Constructor for class org.hsqldb.auth.HsqldbSlaveAuthBean
 

I

id - Variable in class org.hsqldb.lib.RCData
 
ignorableWhitespace(char[], int, int) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of ignorable whitespace in element content.
importDsv(String, String) - Method in class org.hsqldb.cmdline.SqlFile
Name is self-explanatory.
info(String) - Method in class org.hsqldb.lib.FrameworkLogger
 
info(String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.info(String), but also logs a stack trace.
init() - Method in class org.hsqldb.auth.HsqldbSlaveAuthBean
 
init() - Method in class org.hsqldb.auth.JaasAuthBean
 
init() - Method in class org.hsqldb.auth.LdapAuthBean
 
INPUTERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
INSERT_AFTER - Static variable in interface org.hsqldb.Trigger
 
INSERT_AFTER_ROW - Static variable in interface org.hsqldb.Trigger
 
INSERT_BEFORE_ROW - Static variable in interface org.hsqldb.Trigger
 
insertRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Inserts the contents of the insert row into this ResultSet object and into the database.
insertsAreDetected(int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.
invalidArgument() - Static method in class org.hsqldb.jdbc.Util
 
invalidArgument(String) - Static method in class org.hsqldb.jdbc.Util
 
invoke(String, String[]) - Static method in class org.hsqldb.util.MainInvoker
Invokes the static main(String[]) method from each specified class.
IOERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
isAfterLast() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether the cursor is after the last row in this ResultSet object.
isAutoIncrement - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether the value of the column are automatically numbered.
isAutoIncrement(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether the designated column is automatically numbered.
isBeforeFirst() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether the cursor is before the first row in this ResultSet object.
isCaseSensitive - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether the column's value's case matters.
isCaseSensitive(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether a column's case matters.
isCatalogAtStart() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a catalog appears at the start of a fully qualified table name.
isClosed() - Method in class org.hsqldb.jdbc.JDBCBlobClient
 
isClosed() - Method in class org.hsqldb.jdbc.JDBCClobClient
 
isClosed() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves whether this Connection object has been closed.
isClosed() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves whether this Statement object has been closed.
isClosed() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether this ResultSet object has been closed.
isClosed() - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Retrieves whether this object is closed.
isClosed() - Method in class org.hsqldb.jdbc.JDBCStatement
Retrieves whether this Statement object has been closed.
isCloseOnCompletion() - Method in class org.hsqldb.jdbc.JDBCCallableStatement
 
isCurrency - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether the values in the column are cash values.
isCurrency(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether the designated column is a cash value.
isDefaultJdkConfig() - Static method in class org.hsqldb.lib.FrameworkLogger
Whether this JVM is configured with java.util.logging defaults.
isDefinitelyWritable - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether a write on the column will definitely succeed.
isDefinitelyWritable(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether a write on the designated column will definitely succeed.
isDeleteOnFree() - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves whether an attempt to delete the backing file is made in response to invocation of JDBCBlobFile.free().
isDeleteOnFree() - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves whether an attempt to delete the backing file is made in response to invocation of JDBCClobFile.free().
isFirst() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether the cursor is on the first row of this ResultSet object.
isLast() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether the cursor is on the last row of this ResultSet object.
isNoSystemExit() - Method in class org.hsqldb.server.Server
Retrieves whether this server calls System.exit() when shutdown.
isNullable - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The nullability of values in the column.
isNullable(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves whether null values are allowed in the designated parameter.
isNullable(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates the nullability of values in the designated column.
isPoolable() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Returns a value indicating whether the Statement is poolable or not.
isPoolable() - Method in class org.hsqldb.jdbc.JDBCStatement
Returns a value indicating whether the Statement is poolable or not.
isReadable() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Retrieves the object's readability status.
isReadOnly - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether the column's values are definitely not writable.
isReadOnly() - Method in class org.hsqldb.jdbc.JDBCConnection
Retrieves whether this Connection object is in read-only mode.
isReadOnly() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database is in read-only mode.
isReadOnly(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether the designated column is definitely not writable.
isRestartOnShutdown() - Method in class org.hsqldb.server.Server
Retrieves whether this server restarts on shutdown.
isSearchable - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether the column's values can be used in a where clause.
isSearchable(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether the designated column can be used in a where clause.
isSigned - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether values in the column are signed numbers.
isSigned(int) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves whether values for the designated parameter can be signed numbers.
isSigned(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether values in the designated column are signed numbers.
isSilent() - Method in class org.hsqldb.server.Server
Retrieves whether silent mode operation was requested in the server properties.
isTls() - Method in class org.hsqldb.server.Server
Retrieves whether the use of secure sockets was requested in the server properties.
isTrace() - Method in class org.hsqldb.server.Server
Retrieves whether JDBC trace messages are to go to System.out or the DriverManger PrintStream/PrintWriter, if any.
isValid(int) - Method in class org.hsqldb.jdbc.JDBCConnection
Returns true if the connection has not been closed and is still valid.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCConnection
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCDataSource
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCPool
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCResultSet
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWrapperFor(Class<?>) - Method in class org.hsqldb.jdbc.JDBCStatement
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
isWritable - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
Whether it is possible for a write on the column to succeed.
isWritable(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Indicates whether it is possible for a write on the designated column to succeed.
isWritable() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Retrieves the object's readability status.

J

JaasAuthBean - Class in org.hsqldb.auth
Provides authentication and authorization (roles and initial schema) according to JAAS modules configured by the runtime JAAS implementation.
JaasAuthBean() - Constructor for class org.hsqldb.auth.JaasAuthBean
 
JaasAuthBean.UPCallbackHandler - Class in org.hsqldb.auth
 
JaasAuthBean.UPCallbackHandler(String, String) - Constructor for class org.hsqldb.auth.JaasAuthBean.UPCallbackHandler
 
JDBC_MAJOR - Static variable in class org.hsqldb.jdbc.JDBCDatabaseMetaData
 
JDBCArray - Class in org.hsqldb.jdbc
The mapping in the Java programming language for the SQL type ARRAY.
JDBCArray(Object[], Type, Type, SessionInterface) - Constructor for class org.hsqldb.jdbc.JDBCArray
 
JDBCArrayBasic - Class in org.hsqldb.jdbc
The mapping in the Java programming language for the SQL type ARRAY.
JDBCArrayBasic(Object[], Type) - Constructor for class org.hsqldb.jdbc.JDBCArrayBasic
 
JDBCBlob - Class in org.hsqldb.jdbc
The representation (mapping) in the JavaTM programming language of an SQL BLOB value.
JDBCBlob(byte[]) - Constructor for class org.hsqldb.jdbc.JDBCBlob
Constructs a new JDBCBlob instance wrapping the given octet sequence.
JDBCBlobClient - Class in org.hsqldb.jdbc
A wrapper for HSQLDB BlobData objects.
JDBCBlobClient(SessionInterface, BlobDataID) - Constructor for class org.hsqldb.jdbc.JDBCBlobClient
 
JDBCBlobFile - Class in org.hsqldb.jdbc
JDBCBlobFile() - Constructor for class org.hsqldb.jdbc.JDBCBlobFile
Convenience constructor; equivalent to JDBCBlobFile(true);
JDBCBlobFile(boolean) - Constructor for class org.hsqldb.jdbc.JDBCBlobFile
Constructs a new instance backed by a File object created in response to invoking File.createTempFile(TEMP_FILE_PREFIX,TEMP_FILE_SUFFIX)
JDBCBlobFile(File) - Constructor for class org.hsqldb.jdbc.JDBCBlobFile
Convenience constructor; equivalent to JDBCBlobFile(file, false);
JDBCBlobFile(File, boolean) - Constructor for class org.hsqldb.jdbc.JDBCBlobFile
Constructs a new instance backed by the given File object.
JDBCCallableStatement - Class in org.hsqldb.jdbc
The interface used to execute SQL stored procedures.
JDBCCallableStatement(JDBCConnection, String, int, int, int) - Constructor for class org.hsqldb.jdbc.JDBCCallableStatement
Constructs a new JDBCCallableStatement with the specified connection and result type.
JDBCClob - Class in org.hsqldb.jdbc
The mapping in the JavaTM programming language for the SQL CLOB type.
JDBCClob(String) - Constructor for class org.hsqldb.jdbc.JDBCClob
Constructs a new JDBCClob object wrapping the given character sequence.
JDBCClobClient - Class in org.hsqldb.jdbc
A wrapper for HSQLDB ClobData objects.
JDBCClobClient(SessionInterface, ClobDataID) - Constructor for class org.hsqldb.jdbc.JDBCClobClient
 
JDBCClobFile - Class in org.hsqldb.jdbc
JDBCClobFile() - Constructor for class org.hsqldb.jdbc.JDBCClobFile
Convenience constructor for JDBCClobFile((String)null).
JDBCClobFile(String) - Constructor for class org.hsqldb.jdbc.JDBCClobFile
Constructs a new JDBCClobFile instance backed by an File object created by File.createTempFile(TEMP_FILE_PREFIX, TEMP_FILE_SUFFIX), using the given encoding to read and write file content.
JDBCClobFile(File) - Constructor for class org.hsqldb.jdbc.JDBCClobFile
Convenience constructor for JDBCClobFile(file,null).
JDBCClobFile(File, String) - Constructor for class org.hsqldb.jdbc.JDBCClobFile
Constructs a new JDBCClobFile instance backed by the given File object using the given encoding to read and write file content.
JDBCColumnMetaData - Class in org.hsqldb.jdbc
Provides a site for holding the ResultSetMetaData for individual ResultSet columns.
JDBCColumnMetaData() - Constructor for class org.hsqldb.jdbc.JDBCColumnMetaData
 
JDBCCommonDataSource - Class in org.hsqldb.jdbc
Common base for DataSource implementations.
JDBCCommonDataSource() - Constructor for class org.hsqldb.jdbc.JDBCCommonDataSource
 
jdbcCompliant() - Method in class org.hsqldb.jdbc.JDBCDriver
Reports whether this driver is a genuine JDBC CompliantTM driver.
jdbcCompliant() - Method in class org.hsqldb.jdbc.JDBCDriver
Reports whether this driver is a genuine JDBC CompliantTM driver.
JDBCConnection - Class in org.hsqldb.jdbc
 
JDBCConnection(HsqlProperties) - Constructor for class org.hsqldb.jdbc.JDBCConnection
Constructs a new external Connection to an HSQLDB Database.
JDBCConnection(SessionInterface) - Constructor for class org.hsqldb.jdbc.JDBCConnection
Constructs an INTERNAL Connection, using the specified SessionInterface.
JDBCConnection(JDBCConnection, JDBCConnectionEventListener) - Constructor for class org.hsqldb.jdbc.JDBCConnection
Constructor for use with connection pooling and XA.
JDBCConnectionEventListener - Interface in org.hsqldb.jdbc
 
JDBCDatabaseMetaData - Class in org.hsqldb.jdbc
Comprehensive information about the database as a whole.
JDBCDataSource - Class in org.hsqldb.jdbc
A factory for connections to the physical data source that this DataSource object represents.
JDBCDataSource() - Constructor for class org.hsqldb.jdbc.JDBCDataSource
 
JDBCDataSourceFactory - Class in org.hsqldb.jdbc
A JNDI ObjectFactory for creating data sources supported by HyperSQL JDBCDataSource for plain connections for the end user.
JDBCDataSourceFactory() - Constructor for class org.hsqldb.jdbc.JDBCDataSourceFactory
 
JDBCDriver - Class in org.hsqldb.jdbc
Provides the java.sql.Driver interface implementation required by the JDBC specification.
JDBCDriver - Class in org.hsqldb.jdbc
Provides the java.sql.Driver interface implementation required by the JDBC specification.
JDBCDriver() - Constructor for class org.hsqldb.jdbc.JDBCDriver
Default constructor
JDBCDriver() - Constructor for class org.hsqldb.jdbc.JDBCDriver
Default constructor
JDBCNClob - Class in org.hsqldb.jdbc
The mapping in the JavaTM programming language for the SQL NCLOB type.
JDBCNClob(String) - Constructor for class org.hsqldb.jdbc.JDBCNClob
 
JDBCParameterMetaData - Class in org.hsqldb.jdbc
An object that can be used to get information about the types and properties for each parameter marker in a PreparedStatement object.
JDBCPool - Class in org.hsqldb.jdbc
JDBCPool() - Constructor for class org.hsqldb.jdbc.JDBCPool
Creates a connection pool with the maximum size of 8.
JDBCPool(int) - Constructor for class org.hsqldb.jdbc.JDBCPool
Creates a connection pool with the given maximum size.
JDBCPreparedStatement - Class in org.hsqldb.jdbc
An object that represents a precompiled SQL statement.
JDBCResultSet - Class in org.hsqldb.jdbc
A table of data representing a database result set, which is usually generated by executing a statement that queries the database.
JDBCResultSet(JDBCConnection, JDBCStatementBase, Result, ResultMetaData) - Constructor for class org.hsqldb.jdbc.JDBCResultSet
Constructs a new JDBCResultSet object using the specified navigator and org.hsqldb.result.ResultMetaData.
JDBCResultSet(JDBCConnection, Result, ResultMetaData) - Constructor for class org.hsqldb.jdbc.JDBCResultSet
 
JDBCResultSetMetaData - Class in org.hsqldb.jdbc
An object that can be used to get information about the types and properties of the columns in a ResultSet object.
JDBCRowId - Class in org.hsqldb.jdbc
The representation (mapping) in the Java programming language of an SQL ROWID value.
JDBCRowId(byte[]) - Constructor for class org.hsqldb.jdbc.JDBCRowId
Constructs a new JDBCRowId instance wrapping the given octet sequence.
JDBCRowId(RowId) - Constructor for class org.hsqldb.jdbc.JDBCRowId
Constructs a new JDBCRowId instance whose internal octet sequence is is a copy of the octet sequence of the given RowId object.
JDBCRowId(String) - Constructor for class org.hsqldb.jdbc.JDBCRowId
Constructs a new JDBCRowId instance whose internal octet sequence is is that represented by the given hexidecimal character sequence.
JDBCSavepoint - Class in org.hsqldb.jdbc
The representation of a savepoint, which is a point within the current transaction that can be referenced from the Connection.rollback method.
JDBCSQLXML - Class in org.hsqldb.jdbc
The mapping in the JavaTM programming language for the SQL XML type.
JDBCSQLXML(Source) - Constructor for class org.hsqldb.jdbc.JDBCSQLXML
Constructs a new read-only JDBCSQLXML object from the given Source object.
JDBCSQLXML.SAX2XMLStreamWriter - Class in org.hsqldb.jdbc
Writes to a XMLStreamWriter from SAX events.
JDBCSQLXML.SAX2XMLStreamWriter(XMLStreamWriter) - Constructor for class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Constructs a new SAX2XMLStreamWriter that writes SAX events to the designated XMLStreamWriter.
JDBCStatement - Class in org.hsqldb.jdbc
 

L

last() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the last row in this ResultSet object.
LdapAuthBean - Class in org.hsqldb.auth
Authenticates to a HyperSQL catalog according to entries in a LDAP database.
LdapAuthBean() - Constructor for class org.hsqldb.auth.LdapAuthBean
 
length() - Method in class org.hsqldb.jdbc.JDBCBlob
Returns the number of bytes in the BLOB value designated by this Blob object.
length() - Method in class org.hsqldb.jdbc.JDBCBlobClient
Returns the number of bytes in the BLOB value designated by this Blob object.
length() - Method in class org.hsqldb.jdbc.JDBCBlobFile
Returns the number of bytes in the BLOB value designated by this Blob object.
length() - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves the number of characters in the CLOB value designated by this Clob object.
length() - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves the number of characters in the CLOB value designated by this Clob object.
length() - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the number of characters in the CLOB value designated by this Clob object.
libpath - Variable in class org.hsqldb.lib.RCData
 
loadBinary(File) - Static method in class org.hsqldb.cmdline.SqlFile
Binary file load
locatorsUpdateCopy() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
log(Level, String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.log(Level, String), but also logs a stack trace.
log(Level, String) - Method in class org.hsqldb.lib.FrameworkLogger
 
LS - Static variable in class org.hsqldb.cmdline.SqlFile
Platform-specific line separator
LS - Static variable in class org.hsqldb.cmdline.SqlTool
Platform-specific line separator
LS - Static variable in class org.hsqldb.util.MainInvoker
 

M

main(String[]) - Static method in class org.hsqldb.auth.LdapAuthBean
Run this method to try and test configuration settings for LdapAuthBeans, or to troubleshoot.
main(String[]) - Static method in class org.hsqldb.cmdline.SqlTool
A static wrapper for objectMain, so that that method may be executed as a Java "program".
main(String[]) - Static method in class org.hsqldb.lib.tar.DbBackup
Command line invocation to create, examine, or extract HSQLDB database backup tar archives.
main(String[]) - Static method in class org.hsqldb.sample.SqlFileEmbedder
Run
main(String[]) - Static method in class org.hsqldb.sample.TriggerSample
 
main(String[]) - Static method in class org.hsqldb.server.Server
Creates and starts a new Server.
main(String[]) - Static method in class org.hsqldb.server.ServerAcl
Utility method that allows interactive testing of individal ACL records, as well as the net effect of the ACL record list.
main(String[]) - Static method in class org.hsqldb.server.WebServer
Starts a new WebServer.
main(String[]) - Static method in class org.hsqldb.util.MainInvoker
Invokes the static main(String[]) method from each specified class.
MainInvoker - Class in org.hsqldb.util
Invokes the static main(String[]) method from each class specified.
MainInvoker() - Constructor for class org.hsqldb.util.MainInvoker
 
MAX_POS - Static variable in class org.hsqldb.jdbc.JDBCBlob
 
MIN_POS - Static variable in class org.hsqldb.jdbc.JDBCBlob
 
moveToCurrentRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the remembered cursor position, usually the current row.
moveToInsertRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the insert row.

N

nativeSQL(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Converts the given SQL statement into the system's native SQL grammar.
newJDBCResultSet(Result, ResultMetaData) - Static method in class org.hsqldb.jdbc.JDBCResultSet
Factory method returns a new JDBCResultSet object for use with user defined functions that retrun a ResultSet object.
next() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor froward one row from its current position.
notify(int, int) - Method in class org.hsqldb.server.Server
This is called from org.hsqldb.DatabaseManager when a database is shutdown.
nullArgument() - Static method in class org.hsqldb.jdbc.Util
 
nullPlusNonNullIsNull() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.
nullsAreSortedAtEnd() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether NULL values are sorted at the end regardless of sort order.
nullsAreSortedAtStart() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether NULL values are sorted at the start regardless of sort order.
nullsAreSortedHigh() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether NULL values are sorted high.
nullsAreSortedLow() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether NULL values are sorted low.

O

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

P

password - Variable in class org.hsqldb.lib.RCData
 
permitAccess(String) - Method in class org.hsqldb.server.ServerAcl
Uses system network libraries to resolve the given String to an IP addr, then determine whether this address is permitted or denied.
permitAccess(byte[]) - Method in class org.hsqldb.server.ServerAcl
 
position(byte[], long) - Method in class org.hsqldb.jdbc.JDBCBlob
Retrieves the byte position at which the specified byte array pattern begins within the BLOB value that this Blob object represents.
position(Blob, long) - Method in class org.hsqldb.jdbc.JDBCBlob
Retrieves the byte position in the BLOB value designated by this Blob object at which pattern begins.
position(byte[], long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Retrieves the byte position at which the specified byte array pattern begins within the BLOB value that this Blob object represents.
position(Blob, long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Retrieves the byte position in the BLOB value designated by this Blob object at which pattern begins.
position(byte[], long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves the byte position at which the specified byte array pattern begins within the BLOB value that this Blob object represents.
position(Blob, long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves the byte position in the BLOB value designated by this Blob object at which pattern begins.
position(String, long) - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves the character position at which the specified substring searchstr appears in the SQL CLOB value represented by this Clob object.
position(Clob, long) - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves the character position at which the specified Clob object searchstr appears in this Clob object.
position(String, long) - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves the character position at which the specified substring searchstr appears in the SQL CLOB value represented by this Clob object.
position(Clob, long) - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves the character position at which the specified Clob object searchstr appears in this Clob object.
position(char[], long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the character position at which the specified char[] pattern appears in the CLOB value represented by this Clob object.
position(String, long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the character position at which the specified Clob object searchstr appears in this Clob object.
position(Clob, long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves the character position at which the specified Clob object searchstr appears in this Clob object.
precision - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's value's number of decimal digits.
prepareCall(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a CallableStatement object for calling database stored procedures.
prepareCall(String, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
prepareCall(String, int, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
prepareStatement(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a PreparedStatement object for sending parameterized SQL statements to the database.
prepareStatement(String, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a PreparedStatement object that will generate ResultSet objects with the given type and concurrency.
prepareStatement(String, int, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a PreparedStatement object that will generate ResultSet objects with the given type, concurrency, and holdability.
prepareStatement(String, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.
prepareStatement(String, int[]) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
prepareStatement(String, String[]) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a default PreparedStatement object capable of returning the auto-generated keys designated by the given array.
previous() - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor to the previous row in this ResultSet object.
privlog(Level, String, Throwable, int, Class) - Method in class org.hsqldb.lib.FrameworkLogger
The "priv" prefix is historical.
processingInstruction(String, String) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of a processing instruction.
putPropertiesFromFile(String) - Method in class org.hsqldb.server.Server
Attempts to put properties from the file with the specified path.
putPropertiesFromFile(String, String) - Method in class org.hsqldb.server.Server
Attempts to put properties from the file with given extension.
putPropertiesFromString(String) - Method in class org.hsqldb.server.Server
Puts properties from the supplied string argument.

R

RCData - Class in org.hsqldb.lib
Manages all the details we need to connect up to JDBC database(s), in a declarative way.
RCData(File, String) - Constructor for class org.hsqldb.lib.RCData
Creates a RCDataObject by looking up the given key in the given authentication file.
RCData(String, String, String, String, String, String, String) - Constructor for class org.hsqldb.lib.RCData
Convenience constructor for backward compatibility.
RCData(String, String, String, String, String, String, String, String) - Constructor for class org.hsqldb.lib.RCData
Wrapper for unset Transaction Isolation.
RCData(String, String, String, String, String, String, String, String, String) - Constructor for class org.hsqldb.lib.RCData
Creates a new RCData object.
RCERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
refreshRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Refreshes the current row with its most recent value in the database.
registerOutParameter(int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
registerOutParameter(int, int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
registerOutParameter(int, int, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Registers the designated output parameter.
registerOutParameter(String, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Registers the OUT parameter named parameterName to the JDBC type sqlType.
registerOutParameter(String, int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Registers the parameter named parameterName to be of JDBC type sqlType.
registerOutParameter(String, int, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Registers the designated output parameter.
relative(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Moves the cursor a relative number of rows, either positive or negative.
releaseSavepoint(Savepoint) - Method in class org.hsqldb.jdbc.JDBCConnection
Removes the specified Savepoint (JDBC4 Clarification:) and subsequent Savepoint objects from the current transaction.
report() - Static method in class org.hsqldb.lib.FrameworkLogger
Utility method for integrators.
reset() - Method in class org.hsqldb.jdbc.JDBCConnection
Resets this connection so it can be used again.
result - Variable in class org.hsqldb.jdbc.JDBCResultSet
The underlying result.
rollback() - Method in class org.hsqldb.jdbc.JDBCConnection
Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object.
rollback(Savepoint) - Method in class org.hsqldb.jdbc.JDBCConnection
Undoes all changes made after the given Savepoint object was set.
rowDeleted() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether a row has been deleted.
rowInserted() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether the current row has had an insertion.
rowUpdated() - Method in class org.hsqldb.jdbc.JDBCResultSet
Retrieves whether the current row has been updated.

S

scale - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's value's number of digits to right of the decimal point.
schemaName - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's table's schema.
Server - Class in org.hsqldb.server
The HSQLDB HSQL protocol network database server.
Server() - Constructor for class org.hsqldb.server.Server
Creates a new Server instance handling HSQL protocol connections.
ServerAcl - Class in org.hsqldb.server
A list of ACL permit and deny entries with a permitAccess method which tells whether candidate addresses are permitted or denied by this ACL list.
ServerAcl(File) - Constructor for class org.hsqldb.server.ServerAcl
 
ServerAcl.AclFormatException - Exception in org.hsqldb.server
 
ServerAcl.AclFormatException(String) - Constructor for exception org.hsqldb.server.ServerAcl.AclFormatException
 
setAbortUponModify(boolean) - Method in class org.hsqldb.lib.tar.DbBackup
Defaults to true.
setAccessAttribute(String) - Method in class org.hsqldb.auth.LdapAuthBean
Set the attribute name of the RDN + parentDn entries which will be consulted to decide whether the user can access the HyperSQL database.
setAccessValuePattern(Pattern) - Method in class org.hsqldb.auth.LdapAuthBean
Assign a pattern to detect honored accessAttribute values.
setAccessValuePatternString(String) - Method in class org.hsqldb.auth.LdapAuthBean
String wrapper for method setAccessValuePattern(Pattern) Use the (x?) Pattern constructs to set options.
setAddress(String) - Method in class org.hsqldb.server.Server
Sets the InetAddress with which this server's ServerSocket will be constructed.
setApplicationKey(String) - Method in class org.hsqldb.auth.JaasAuthBean
Set the key into the JAAS runtime configuration.
setArray(int, Array) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Array object.
setAsciiStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAsciiStream(String, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAsciiStream(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given input stream.
setAsciiStream(long) - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves a stream to be used to write ASCII characters to the CLOB value that this Clob object represents, starting at position pos.
setAsciiStream(long) - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents, starting at position pos.
setAsciiStream(long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents, starting at position pos.
setAsciiStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAsciiStream(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAsciiStream(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given input stream.
setAuthFunctionBean(Connection, AuthFunctionBean) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
Exactly the same as setAuthFunctionBeans(String, List) other than taking an open Connection to identify the database.
setAuthFunctionBean(String, AuthFunctionBean) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
This is not an "adder" function, but a "setter" function for the specified dbName , so do not use this to add to a database's FunctionBeans, but to assign ths single given AuthFunctionBean as the specified database's authenticator.
setAuthFunctionBeans(Map<String, List<AuthFunctionBean>>) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
Primary purpose of this class is to manage this static map.
setAuthFunctionBeans(Connection, List<AuthFunctionBean>) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
Wrapper for setAuthFunctioNBeans(String, List)
setAuthFunctionBeans(String, List<AuthFunctionBean>) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
This is not an "adder" function, but a "setter" function for the specified dbName , so do not use this to add to a database's FunctionBeans, but to assign the entire list for that database.
setAutoClose(boolean) - Method in class org.hsqldb.cmdline.SqlFile
Specify whether the supplied or generated input Reader should automatically be closed by the execute() method.
setAutoCommit(boolean) - Method in class org.hsqldb.jdbc.JDBCConnection
Sets this connection's auto-commit mode to the given state.
setBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.math.BigDecimal value.
setBigDecimal(int, BigDecimal) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.math.BigDecimal value.
setBinaryStream(long) - Method in class org.hsqldb.jdbc.JDBCBlob
Retrieves a stream that can be used to write to the BLOB value that this Blob object represents.
setBinaryStream(long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Retrieves a stream that can be used to write to the BLOB value that this Blob object represents.
setBinaryStream(long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Retrieves a stream that can be used to write to the BLOB value that this Blob object represents.
setBinaryStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBinaryStream(String, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBinaryStream(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given input stream.
setBinaryStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBinaryStream(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBinaryStream(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given input stream.
setBinaryStream() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Retrieves a stream that can be used to write the XML value that this SQLXML instance represents.
setBlob(String, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a InputStream object.
setBlob(String, Blob) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Blob object.
setBlob(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a InputStream object.
setBlob(int, Blob) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Blob object.
setBlob(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a InputStream object.
setBlob(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a InputStream object.
setBoolean(String, boolean) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java boolean value.
setBoolean(int, boolean) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java boolean value.
setByte(String, byte) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java byte value.
setByte(int, byte) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java byte value.
setBytes(long, byte[]) - Method in class org.hsqldb.jdbc.JDBCBlob
Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
setBytes(long, byte[], int, int) - Method in class org.hsqldb.jdbc.JDBCBlob
Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.
setBytes(long, byte[]) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
setBytes(long, byte[], int, int) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.
setBytes(long, byte[]) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Writes the given array of bytes to the BLOB value that this Blob object represents, starting at position pos, and returns the number of bytes written.
setBytes(long, byte[], int, int) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Writes all or part of the given byte array to the BLOB value that this Blob object represents and returns the number of bytes written.
setBytes(String, byte[]) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java array of bytes.
setBytes(int, byte[]) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java array of bytes.
setCatalog(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Sets the given catalog name in order to select a subspace of this Connection object's database in which to work.
setCharacterStream(String, Reader, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Reader object.
setCharacterStream(long) - Method in class org.hsqldb.jdbc.JDBCClob
Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at position pos.
setCharacterStream(long) - Method in class org.hsqldb.jdbc.JDBCClobClient
Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at position pos.
setCharacterStream(long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object represents, at position pos.
setCharacterStream(int, Reader, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Reader object.
setCharacterStream() - Method in class org.hsqldb.jdbc.JDBCSQLXML
Retrieves a stream to be used to write the XML value that this SQLXML instance represents.
setClientInfo(String, String) - Method in class org.hsqldb.jdbc.JDBCConnection
Sets the value of the client info property specified by name to the value specified by value.
setClientInfo(Properties) - Method in class org.hsqldb.jdbc.JDBCConnection
Sets the value of the connection's client info properties.
setClob(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a Reader object.
setClob(String, Clob) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Clob object.
setClob(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a Reader object.
setClob(int, Clob) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Clob object.
setClob(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a Reader object.
setClob(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a Reader object.
setConnection(Connection) - Method in class org.hsqldb.cmdline.SqlFile
 
setContinueOnError(boolean) - Method in class org.hsqldb.cmdline.SqlFile
 
setCursorName(String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods.
setCursorName(String) - Method in class org.hsqldb.jdbc.JDBCStatement
Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods.
setDaemon(boolean) - Method in class org.hsqldb.server.Server
Sets whether server thread is a daemon.
setDatabase(String) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Synonym for setUrl(String).
setDatabase(String) - Method in class org.hsqldb.jdbc.JDBCPool
Synonym for setUrl(String).
setDatabaseName(String) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Synonym for setUrl(String).
setDatabaseName(String) - Method in class org.hsqldb.jdbc.JDBCPool
Synonym for setUrl(String).
setDatabaseName(int, String) - Method in class org.hsqldb.server.Server
Sets the external name (url alias) of the i'th hosted database.
setDatabasePath(int, String) - Method in class org.hsqldb.server.Server
Sets the path of the hosted database.
setDate(String, Date) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Date value (JDBC4 clarification:)
setDate(String, Date, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
setDate(int, Date) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
(JDBC4 clarification:) Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
setDate(int, Date, Calendar) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
setDefaultJdbcDriver(String) - Method in class org.hsqldb.lib.RCData
 
setDefaultWebPage(String) - Method in class org.hsqldb.server.Server
Sets the name of the web page served when no page is specified.
setDelegateRolesSchema(boolean) - Method in class org.hsqldb.auth.HsqldbSlaveAuthBean
Defaults to true.
setDeleteOnFree(boolean) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Assigns whether an attempt to delete the backing file is made in response to invocation of JDBCBlobFile.free().
setDeleteOnFree(boolean) - Method in class org.hsqldb.jdbc.JDBCClobFile
Assigns whether an attempt to delete the backing file is made in response to invocation of JDBCClobFile.free().
setDocumentLocator(Locator) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive an object for locating the origin of SAX document events.
setDouble(String, double) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java double value.
setDouble(int, double) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java double value.
setErrWriter(PrintWriter) - Method in class org.hsqldb.server.Server
Sets the PrintWriter to which server errors are logged.
setEscapeProcessing(boolean) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets escape processing on or off.
setEscapeProcessing(boolean) - Method in class org.hsqldb.jdbc.JDBCStatement
Sets escape processing on or off.
setFetchDirection(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement object.
setFetchDirection(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Gives a hint as to the direction in which the rows in this ResultSet object will be processed.
setFetchDirection(int) - Method in class org.hsqldb.jdbc.JDBCStatement
Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement object.
setFetchSize(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
(JDBC4 clarification:) 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 ResultSet objects genrated by this Statement.
setFetchSize(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.
setFetchSize(int) - Method in class org.hsqldb.jdbc.JDBCStatement
(JDBC4 clarification:) 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 ResultSet objects genrated by this Statement.
setFileIgnore(String) - Method in class org.hsqldb.lib.tar.DbBackup
 
setFloat(String, float) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java float value.
setFloat(int, float) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java float value.
setHoldability(int) - Method in class org.hsqldb.jdbc.JDBCConnection
(JDBC4 Clarification:) Changes the default holdability of ResultSet objects created using this Connection object to the given holdability.
setInitialContextFactory(String) - Method in class org.hsqldb.auth.LdapAuthBean
Most users should not call this, and will get the default of "com.sun.jndi.ldap.LdapCtxFactory".
setInt(String, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java int value.
setInt(int, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java int value.
setLdapHost(String) - Method in class org.hsqldb.auth.LdapAuthBean
Do not specify URL scheme ("ldap:") because that is implied.
setLdapPort(int) - Method in class org.hsqldb.auth.LdapAuthBean
 
setLoginTimeout(int) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
setLoginTimeout(int) - Method in class org.hsqldb.jdbc.JDBCPool
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
setLogWriter(PrintWriter) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Sets the log writer for this DataSource object to the given java.io.PrintWriter object.
setLogWriter(PrintWriter) - Method in class org.hsqldb.jdbc.JDBCPool
Sets the log writer for this DataSource object to the given java.io.PrintWriter object.
setLogWriter(PrintWriter) - Method in class org.hsqldb.server.Server
Sets the PrintWriter to which server messages are logged.
setLong(String, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java long value.
setLong(int, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java long value.
setMasterJdbcUrl(String) - Method in class org.hsqldb.auth.HsqldbSlaveAuthBean
 
setMaxFieldSize(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
(JDBC4 clarification:) Sets the limit for the maximum number of bytes in a ResultSet Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
setMaxFieldSize(int) - Method in class org.hsqldb.jdbc.JDBCStatement
(JDBC4 clarification:) Sets the limit for the maximum number of bytes in a ResultSet Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
setMaxHistoryLength(int) - Method in class org.hsqldb.cmdline.SqlFile
 
setMaxRows(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
(JDBC4 clarification:) Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.
setMaxRows(int) - Method in class org.hsqldb.jdbc.JDBCStatement
(JDBC4 clarification:) Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.
setNCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a Reader object.
setNCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a Reader object.
setNCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a Reader object.
setNCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a Reader object.
setNClob(String, NClob) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a java.sql.NClob object.
setNClob(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a Reader object.
setNClob(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to a Reader object.
setNClob(int, NClob) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a java.sql.NClob object.
setNClob(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a Reader object.
setNClob(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to a Reader object.
setNetworkTimeout(Executor, int) - Method in class org.hsqldb.jdbc.JDBCConnection
Sets the maximum period a Connection or objects created from the Connection will wait for the database to reply to any one request.
setNoSystemExit(boolean) - Method in class org.hsqldb.server.Server
Sets whether this server calls System.exit() when shutdown.
setNString(String, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given String object.
setNString(int, String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated paramter to the given String object.
setNull(String, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to SQL NULL.
setNull(String, int, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to SQL NULL.
setNull(int, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to SQL NULL.
setNull(int, int, String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to SQL NULL.
setObject(String, Object, int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the value of the designated parameter with the given object.
setObject(String, Object, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the value of the designated parameter with the given object.
setObject(String, Object) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the value of the designated parameter with the given object.
setObject(int, Object, int, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the value of the designated parameter with the given object.
setObject(int, Object, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the value of the designated parameter with the given object.
setObject(int, Object) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
 
setOverWrite(boolean) - Method in class org.hsqldb.lib.tar.DbBackup
Defaults to false.
setParentDn(String) - Method in class org.hsqldb.auth.LdapAuthBean
Set DN which is parent of the user DNs.
setPassword(String) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Sets the password for the user name.
setPassword(String) - Method in class org.hsqldb.jdbc.JDBCPool
Sets the password for the user name.
setPoolable(boolean) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Requests that a Statement be pooled or not pooled.
setPoolable(boolean) - Method in class org.hsqldb.jdbc.JDBCStatement
Requests that a Statement be pooled or not pooled.
setPort(int) - Method in class org.hsqldb.server.Server
Sets the server listen port.
setPrincipalTemplate(String) - Method in class org.hsqldb.auth.LdapAuthBean
A template String containing place-holder token '${username}'.
setPrintWriter(PrintWriter) - Method in class org.hsqldb.server.ServerAcl
 
setProperties(Properties) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Sets connection properties.
setProperties(Properties) - Method in class org.hsqldb.jdbc.JDBCPool
Sets connection properties.
setProperties(HsqlProperties) - Method in class org.hsqldb.server.Server
Sets server properties using the specified properties object
setQueryTimeout(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
setQueryTimeout(int) - Method in class org.hsqldb.jdbc.JDBCStatement
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
setRdnAttribute(String) - Method in class org.hsqldb.auth.LdapAuthBean
rdnAttribute must hold the user name exactly as the HyperSQL login will be made with.
setReadOnly(boolean) - Method in class org.hsqldb.jdbc.JDBCConnection
Puts this connection in read-only mode as a hint to the driver to enable database optimizations.
setRef(int, Ref) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given REF(<structured-type>) value.
setRestartOnShutdown(boolean) - Method in class org.hsqldb.server.Server
Sets whether this server restarts on shutdown.
setResult(Class<T>) - Method in class org.hsqldb.jdbc.JDBCSQLXML
Returns a Result for setting the XML value designated by this SQLXML instance.
setRoleSchemaValuePattern(Pattern) - Method in class org.hsqldb.auth.JaasAuthBean
Assign a pattern to both detect honored values, and optionally to map from a single principal name or public credential string to a single HyperSQL role or schema string.
setRoleSchemaValuePattern(Pattern) - Method in class org.hsqldb.auth.LdapAuthBean
Assign a pattern to both detect honored values, and to map from a single value of "rolesSchemaAttribute"s to a HyperSQL role or schema string.
setRoleSchemaValuePatternString(String) - Method in class org.hsqldb.auth.JaasAuthBean
String wrapper for method setRoleSchemaValuePattern(Pattern) Use the (x?) Pattern constructs to set options.
setRoleSchemaValuePatternString(String) - Method in class org.hsqldb.auth.LdapAuthBean
String wrapper for method setRoleSchemaValuePattern(Pattern) Use the (x?) Pattern constructs to set options.
setRoleSchemaViaCredential(boolean) - Method in class org.hsqldb.auth.JaasAuthBean
By default, If roleSchemaValuePattern is set, then role and schema values are obtained from principle values; otherwise existing account privileges are used (if any).
setRolesSchemaAttribute(String) - Method in class org.hsqldb.auth.LdapAuthBean
Set the attribute name of the RDN + parentDn entries in which is stored the list of roles and optional schema for the authenticating user.
setRowId(String, RowId) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.RowId object.
setRowId(int, RowId) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.RowId object.
setSaslRealm(String) - Method in class org.hsqldb.auth.LdapAuthBean
Some LDAP servers using a SASL mechanism require a realm to be specified, and some mechanisms allow a realm to be specified if you wish to use that feature.
setSavepoint() - Method in class org.hsqldb.jdbc.JDBCConnection
Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it.
setSavepoint(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it.
setSchema(String) - Method in class org.hsqldb.jdbc.JDBCConnection
Sets the given schema name to access.
setSecurityMechanism(String) - Method in class org.hsqldb.auth.LdapAuthBean
Defaults to "SIMPLE".
setShort(String, short) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java short value.
setShort(int, short) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java short value.
setSilent(boolean) - Method in class org.hsqldb.server.Server
Sets silent mode operation
setSQLXML(String, SQLXML) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.SQLXML object.
setSQLXML(int, SQLXML) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.SQLXML object.
setStartTls(boolean) - Method in class org.hsqldb.auth.LdapAuthBean
If this is set, then the entire (brief) transaction with the LDAP server will be encrypted.
setStream(String, InputStreamInterface) - Method in class org.hsqldb.lib.tar.DbBackup
Overrides file with stream.
setString(String, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given Java String value.
setString(long, String) - Method in class org.hsqldb.jdbc.JDBCClob
Writes the given Java String to the CLOB value that this Clob object designates at the position pos.
setString(long, String, int, int) - Method in class org.hsqldb.jdbc.JDBCClob
Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents.
setString(long, String) - Method in class org.hsqldb.jdbc.JDBCClobClient
Writes the given Java String to the CLOB value that this Clob object designates at the position pos.
setString(long, String, int, int) - Method in class org.hsqldb.jdbc.JDBCClobClient
Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents.
setString(long, String) - Method in class org.hsqldb.jdbc.JDBCClobFile
Writes the given Java String to the CLOB value that this Clob object designates at the position pos.
setString(long, String, int, int) - Method in class org.hsqldb.jdbc.JDBCClobFile
Writes len characters of str, starting at character offset, to the CLOB value that this Clob represents.
setString(int, String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given Java String value.
setString(String) - Method in class org.hsqldb.jdbc.JDBCSQLXML
Sets the XML value designated by this SQLXML instance to the given String representation.
setTI(Connection, String) - Static method in class org.hsqldb.lib.RCData
Set Transaction Isolation level on the specified JDBC Connection
setTime(String, Time) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Time value.
setTime(String, Time, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
setTime(int, Time) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Time value.
setTime(int, Time, Calendar) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
setTimestamp(String, Timestamp) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(String, Timestamp, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
setTimestamp(int, Timestamp) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Timestamp value.
setTimestamp(int, Timestamp, Calendar) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
setTls(boolean) - Method in class org.hsqldb.server.Server
Sets whether to use secure sockets
setTrace(boolean) - Method in class org.hsqldb.server.Server
Sets whether trace messages go to System.out or the DriverManger PrintStream/PrintWriter, if any.
setTransactionIsolation(int) - Method in class org.hsqldb.jdbc.JDBCConnection
Attempts to change the transaction isolation level for this Connection object to the one given.
setTypeMap(Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCConnection
Installs the given TypeMap object as the type map for this Connection object.
setUnicodeStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Deprecated. Sun does not include a reason, but presumably this is because setCharacterStream is now prefered
setURL(String, URL) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Sets the designated parameter to the given java.net.URL object.
setUrl(String) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Sets the jdbc database URL.
setUrl(String) - Method in class org.hsqldb.jdbc.JDBCPool
Sets the jdbc database URL.
setURL(int, URL) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Sets the designated parameter to the given java.net.URL value.
setUser(String) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
Sets the user name.
setUser(String) - Method in class org.hsqldb.jdbc.JDBCPool
Sets the user name.
setValidationPassword(String) - Method in class org.hsqldb.auth.HsqldbSlaveAuthBean
Use this method and setValidationUser if you want access to the master database to be verified upon instance initialization.
setValidationUser(String) - Method in class org.hsqldb.auth.HsqldbSlaveAuthBean
Use this method and setValidationPassword if you want access to the master database to be verified upon instance initialization.
setWebRoot(String) - Method in class org.hsqldb.server.Server
Sets the path of the root directory from which web content is served.
setWritable(JDBCResultSet, int) - Method in class org.hsqldb.jdbc.JDBCBlobClient
 
setWritable(JDBCResultSet, int) - Method in class org.hsqldb.jdbc.JDBCClobClient
 
severe(String) - Method in class org.hsqldb.lib.FrameworkLogger
 
severe(String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.severe(String), but also logs a stack trace.
shutdown() - Method in class org.hsqldb.server.Server
External method to shut down this server.
shutdownCatalogs(int) - Method in class org.hsqldb.server.Server
Shuts down all the database served by this server.
shutdownWithCatalogs(int) - Method in class org.hsqldb.server.Server
Shuts down this server and all the database served by this server.
signalCloseAllServerConnections() - Method in class org.hsqldb.server.Server
Closes all connections to this Server.
skippedEntity(String) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of a skipped entity.
SQLERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
sqlException(HsqlException) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(HsqlException, Throwable) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(int) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(int, String) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(int, String, Throwable) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(int, int) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(Throwable) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(Result) - Static method in class org.hsqldb.jdbc.Util
 
sqlException(String, String, int, Throwable) - Static method in class org.hsqldb.jdbc.Util
 
sqlExceptionSQL(int) - Static method in class org.hsqldb.jdbc.Util
 
SqlFile - Class in org.hsqldb.cmdline
Encapsulation of SQL text and the environment under which it will executed with a JDBC Connection.
SqlFile(File) - Constructor for class org.hsqldb.cmdline.SqlFile
Convenience wrapper for the SqlFile(File, String) constructor
SqlFile(File, String) - Constructor for class org.hsqldb.cmdline.SqlFile
Convenience wrapper for the SqlFile(File, String, boolean) constructor
SqlFile(File, String, boolean) - Constructor for class org.hsqldb.cmdline.SqlFile
Constructor for non-interactive usage with a SQL file, using the specified encoding and sending normal output to stdout.
SqlFile(String, boolean) - Constructor for class org.hsqldb.cmdline.SqlFile
Constructor for interactive usage with stdin/stdout
SqlFile(Reader, String, PrintStream, String, boolean, File) - Constructor for class org.hsqldb.cmdline.SqlFile
Instantiate a SqlFile instance for SQL input from 'reader'.
SqlFileEmbedder - Class in org.hsqldb.sample
Sample class which executes SQL files, by embedding SqlFile.
SqlFileEmbedder(File, String) - Constructor for class org.hsqldb.sample.SqlFileEmbedder
Instantiates SqlFileEmbedder object and connects to specified database.
SqlTool - Class in org.hsqldb.cmdline
A command-line JDBC SQL tool supporting both interactive and non-interactive usage.
SqlTool() - Constructor for class org.hsqldb.cmdline.SqlTool
 
SqlTool.SqlToolException - Exception in org.hsqldb.cmdline
 
SQLTOOLERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 
sqlTypeToString(int) - Static method in class org.hsqldb.cmdline.SqlFile
Return a String representation of the specified java.sql.Types type.
sqlWarning(Result) - Static method in class org.hsqldb.jdbc.Util
 
start() - Method in class org.hsqldb.server.Server
Starts this server synchronously.
startDocument() - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of the beginning of a document.
startElement(String, String, String, Attributes) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Receive notification of the beginning of an element.
startPrefixMapping(String, String) - Method in class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
Begin the scope of a prefix-URI Namespace mapping.
statementClosed(StatementEvent) - Method in class org.hsqldb.jdbc.JDBCPool
 
statementErrorOccurred(StatementEvent) - Method in class org.hsqldb.jdbc.JDBCPool
 
stop() - Method in class org.hsqldb.server.Server
Stops this server asynchronously.
storesLowerCaseIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
storesLowerCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
storesMixedCaseIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
storesMixedCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
storesUpperCaseIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
storesUpperCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
streamToBytes(InputStream) - Static method in class org.hsqldb.cmdline.SqlFile
As the name says...
streamToString(InputStream, String) - Method in class org.hsqldb.cmdline.SqlFile
As the name says...
supportsAlterTableWithAddColumn() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports ALTER TABLE with add column.
supportsAlterTableWithDropColumn() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports ALTER TABLE with drop column.
supportsANSI92EntryLevelSQL() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the ANSI92 entry level SQL grammar.
supportsANSI92FullSQL() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the ANSI92 full SQL grammar supported.
supportsANSI92IntermediateSQL() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
supportsBatchUpdates() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports batch updates.
supportsCatalogsInDataManipulation() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a catalog name can be used in a data manipulation statement.
supportsCatalogsInIndexDefinitions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a catalog name can be used in an index definition statement.
supportsCatalogsInPrivilegeDefinitions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a catalog name can be used in a privilege definition statement.
supportsCatalogsInProcedureCalls() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a catalog name can be used in a procedure call statement.
supportsCatalogsInTableDefinitions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a catalog name can be used in a table definition statement.
supportsColumnAliasing() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports column aliasing.
supportsConvert() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
(JDBC4 clarification:) Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another.
supportsConvert(int, int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
(JDBC4 clarification:) Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType.
supportsCoreSQLGrammar() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the ODBC Core SQL grammar.
supportsCorrelatedSubqueries() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
supportsDataManipulationTransactionsOnly() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports only data manipulation statements within a transaction.
supportsDifferentTableCorrelationNames() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
supportsExpressionsInOrderBy() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports expressions in ORDER BY lists.
supportsExtendedSQLGrammar() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the ODBC Extended SQL grammar.
supportsFullOuterJoins() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports full nested outer joins.
supportsGetGeneratedKeys() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether auto-generated keys can be retrieved after a statement has been executed
supportsGroupBy() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports some form of GROUP BY clause.
supportsGroupByBeyondSelect() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.
supportsGroupByUnrelated() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.
supportsIntegrityEnhancementFacility() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the SQL Integrity Enhancement Facility.
supportsLikeEscapeClause() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports specifying a LIKE escape clause.
supportsLimitedOuterJoins() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database provides limited support for outer joins.
supportsMinimumSQLGrammar() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the ODBC Minimum SQL grammar.
supportsMixedCaseIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
supportsMixedCaseQuotedIdentifiers() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
supportsMultipleOpenResults() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.
supportsMultipleResultSets() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.
supportsMultipleTransactions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database allows having multiple transactions open at once (on different connections).
supportsNamedParameters() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports named parameters to callable statements.
supportsNonNullableColumns() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether columns in this database may be defined as non-nullable.
supportsOpenCursorsAcrossCommit() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports keeping cursors open across commits.
supportsOpenCursorsAcrossRollback() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports keeping cursors open across rollbacks.
supportsOpenStatementsAcrossCommit() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports keeping statements open across commits.
supportsOpenStatementsAcrossRollback() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports keeping statements open across rollbacks.
supportsOrderByUnrelated() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.
supportsOuterJoins() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports some form of outer join.
supportsPositionedDelete() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports positioned DELETE statements.
supportsPositionedUpdate() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports positioned UPDATE statements.
supportsResultSetConcurrency(int, int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the given concurrency type in combination with the given result set type.
supportsResultSetHoldability(int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the given result set holdability.
supportsResultSetType(int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the given result set type.
supportsSavepoints() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports savepoints.
supportsSchemasInDataManipulation() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a schema name can be used in a data manipulation statement.
supportsSchemasInIndexDefinitions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a schema name can be used in an index definition statement.
supportsSchemasInPrivilegeDefinitions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a schema name can be used in a privilege definition statement.
supportsSchemasInProcedureCalls() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a schema name can be used in a procedure call statement.
supportsSchemasInTableDefinitions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether a schema name can be used in a table definition statement.
supportsSelectForUpdate() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports SELECT FOR UPDATE statements.
supportsStatementPooling() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports statement pooling.
supportsStoredFunctionsUsingCallSyntax() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
supportsStoredProcedures() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
supportsSubqueriesInComparisons() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports subqueries in comparison expressions.
supportsSubqueriesInExists() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports subqueries in EXISTS expressions.
supportsSubqueriesInIns() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
(JDBC4 correction:) Retrieves whether this database supports subqueries in IN expressions.
supportsSubqueriesInQuantifieds() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports subqueries in quantified expressions.
supportsTableCorrelationNames() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports table correlation names.
supportsTransactionIsolationLevel(int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports the given transaction isolation level.
supportsTransactions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports transactions.
supportsUnion() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports SQL UNION.
supportsUnionAll() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database supports SQL UNION ALL.
SYNTAXERR_EXITVAL - Static variable in class org.hsqldb.cmdline.SqlTool
 

T

tableName - Variable in class org.hsqldb.jdbc.JDBCColumnMetaData
The column's table's name.
TEMP_FILE_PREFIX - Static variable in class org.hsqldb.jdbc.JDBCBlobFile
 
TEMP_FILE_PREFIX - Static variable in class org.hsqldb.jdbc.JDBCClobFile
 
TEMP_FILE_SUFFIX - Static variable in class org.hsqldb.jdbc.JDBCBlobFile
 
TEMP_FILE_SUFFIX - Static variable in class org.hsqldb.jdbc.JDBCClobFile
 
threadConnection - Variable in class org.hsqldb.jdbc.JDBCDriver
As a separate instance of this class is registered with DriverManager for each class loader, the threadConnection is not declared as static.
threadConnection - Variable in class org.hsqldb.jdbc.JDBCDriver
As a separate instance of this class is registered with DriverManager for each class loader, the threadConnection is not declared as static.
ti - Variable in class org.hsqldb.lib.RCData
 
tiToString(int) - Static method in class org.hsqldb.lib.RCData
Return a String representation for the given numerical java.sql.Connection Transaction level.
toString() - Method in class org.hsqldb.jdbc.JDBCArray
Returns a string representation in the form ARRAY[..., ...]
toString() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
Returns a string representation in the form ARRAY[..., ...]
toString() - Method in class org.hsqldb.jdbc.JDBCColumnMetaData
Retrieves a String representation of this object.
toString() - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Retrieves a String repsentation of this object.
toString() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Retrieves a String representation of this object.
toString() - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Returns a string representation of the object.
toString() - Method in class org.hsqldb.jdbc.JDBCRowId
Returns a String representing the value of the SQL ROWID designated by this java.sql.RowId object.
toString() - Method in class org.hsqldb.jdbc.JDBCSavepoint
 
toString() - Method in class org.hsqldb.server.ServerAcl
 
Trigger - Interface in org.hsqldb
The interface an HSQLDB TRIGGER must implement.
TriggerSample - Class in org.hsqldb.sample
Sample code for use of triggers in hsqldb.
TriggerSample() - Constructor for class org.hsqldb.sample.TriggerSample
 
truncate(long) - Method in class org.hsqldb.jdbc.JDBCBlob
Truncates the BLOB value that this Blob object represents to be len bytes in length.
truncate(long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
Truncates the BLOB value that this Blob object represents to be len bytes in length.
truncate(long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
Truncates the BLOB value that this Blob object represents to be len bytes in length.
truncate(long) - Method in class org.hsqldb.jdbc.JDBCClob
Truncates the CLOB value that this Clob designates to have a length of len characters.
truncate(long) - Method in class org.hsqldb.jdbc.JDBCClobClient
Truncates the CLOB value that this Clob designates to have a length of len characters.
truncate(long) - Method in class org.hsqldb.jdbc.JDBCClobFile
Truncates the CLOB value that this Clob designates to have a length of len characters.
truststore - Variable in class org.hsqldb.lib.RCData
 
TYPE_FORWARD_ONLY - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
TYPE_SCROLL_INSENSITIVE - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.
TYPE_SCROLL_SENSITIVE - Static variable in class org.hsqldb.jdbc.JDBCResultSet
Copy of java.sql.ResultSet constant, for JDK 1.1 clients.

U

unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCConnection
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCDataSource
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCParameterMetaData
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCPool
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCResultSet
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
unwrap(Class<T>) - Method in class org.hsqldb.jdbc.JDBCStatement
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
UPDATE_AFTER - Static variable in interface org.hsqldb.Trigger
 
UPDATE_AFTER_ROW - Static variable in interface org.hsqldb.Trigger
 
UPDATE_BEFORE_ROW - Static variable in interface org.hsqldb.Trigger
 
updateArray(int, Array) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Array value.
updateArray(String, Array) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Array value.
updateAsciiStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification:) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
updateAsciiStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification:) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
updateAsciiStream(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
updateAsciiStream(String, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an ascii stream value, which will have the specified number of bytes..
updateAsciiStream(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an ascii stream value.
updateAsciiStream(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an ascii stream value.
updateBigDecimal(int, BigDecimal) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.math.BigDecimal value.
updateBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.BigDecimal value.
updateBinaryStream(int, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification:) Updates the designated column with a binary stream value, which will have the specified number of bytes.
updateBinaryStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification:) Updates the designated column with a binary stream value, which will have the specified number of bytes.
updateBinaryStream(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a binary stream value, which will have the specified number of bytes.
updateBinaryStream(String, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a binary stream value, which will have the specified number of bytes.
updateBinaryStream(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a binary stream value.
updateBinaryStream(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a binary stream value.
updateBlob(int, Blob) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Blob value.
updateBlob(String, Blob) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Blob value.
updateBlob(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given input stream, which will have the specified number of bytes.
updateBlob(String, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given input stream, which will have the specified number of bytes.
updateBlob(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given input stream.
updateBlob(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given input stream.
updateBoolean(int, boolean) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a boolean value.
updateBoolean(String, boolean) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a boolean value.
updateByte(int, byte) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a byte value.
updateByte(String, byte) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a byte value.
updateBytes(int, byte[]) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a byte array value.
updateBytes(String, byte[]) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a byte array value.
updateCharacterStream(int, Reader, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification:) Updates the designated column with a character stream value, which will have the specified number of (CHECKME: characters?) bytes.
updateCharacterStream(String, Reader, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification) Updates the designated column with a character stream value, which will have the specified number of (CHECKME: characters?) bytes.
updateCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value, which will have the specified number of bytes.
updateCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value, which will have the specified number of bytes.
updateCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value.
updateCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value.
updateClob(int, Clob) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Clob value.
updateClob(String, Clob) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Clob value.
updateClob(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object, which is the given number of characters long.
updateClob(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object, which is the given number of characters long.
updateClob(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object.
updateClob(String, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object.
updateDate(int, Date) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Date value.
updateDate(String, Date) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Date value.
updateDouble(int, double) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a double value.
updateDouble(String, double) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a double value.
updateFloat(int, float) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a float value.
updateFloat(String, float) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a float value.
updateInt(int, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an int value.
updateInt(String, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an int value.
updateLong(int, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a long value.
updateLong(String, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a long value.
updateNCharacterStream(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value, which will have the specified number of bytes.
updateNCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value, which will have the specified number of bytes.
updateNCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value.
updateNCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a character stream value.
updateNClob(int, NClob) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.NClob value.
updateNClob(String, NClob) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.NClob value.
updateNClob(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object, which is the given number of characters long.
updateNClob(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object, which is the given number of characters long.
updateNClob(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached.
updateNClob(String, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column using the given Reader object.
updateNString(int, String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a String value.
updateNString(String, String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a String value.
updateNull(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
(JDBC4 clarification:) Updates the designated column with a null value.
updateNull(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a null value.
updateObject(int, Object, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an Object value.
updateObject(int, Object) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an Object value.
updateObject(String, Object, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an Object value.
updateObject(String, Object) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with an Object value.
updateRef(int, Ref) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Ref value.
updateRef(String, Ref) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Ref value.
updateRow() - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the underlying database with the new contents of the current row of this ResultSet object.
updateRowId(int, RowId) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a RowId value.
updateRowId(String, RowId) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a RowId value.
updatesAreDetected(int) - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.
updateShort(int, short) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a short value.
updateShort(String, short) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a short value.
updateSQLXML(int, SQLXML) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.SQLXML value.
updateSQLXML(String, SQLXML) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.SQLXML value.
updateString(int, String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a String value.
updateString(String, String) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a String value.
updateTime(int, Time) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Time value.
updateTime(String, Time) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Time value.
updateTimestamp(int, Timestamp) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Timestamp value.
updateTimestamp(String, Timestamp) - Method in class org.hsqldb.jdbc.JDBCResultSet
Updates the designated column with a java.sql.Timestamp value.
url - Variable in class org.hsqldb.lib.RCData
 
username - Variable in class org.hsqldb.lib.RCData
 
usesLocalFilePerTable() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database uses a file for each table.
usesLocalFiles() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
Retrieves whether this database stores tables in a local file.
Util - Class in org.hsqldb.jdbc
Provides driver constants and a gateway from internal HsqlExceptions to external SQLExceptions.
Util() - Constructor for class org.hsqldb.jdbc.Util
 

W

warning(String) - Method in class org.hsqldb.lib.FrameworkLogger
 
warning(String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
Just like FrameworkLogger.warning(String), but also logs a stack trace.
wasNull() - Method in class org.hsqldb.jdbc.JDBCCallableStatement
Retrieves whether the last OUT parameter read had the value of SQL NULL.
wasNull() - Method in class org.hsqldb.jdbc.JDBCResultSet
Reports whether the last column read had a value of SQL NULL.
WebServer - Class in org.hsqldb.server
The HSQLDB HTTP protocol network database server.
WebServer() - Constructor for class org.hsqldb.server.WebServer
 
write() - Method in class org.hsqldb.lib.tar.DbBackup
This method always backs up the .properties and .script files.

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

Copyright © 2001 - 2010 HSQL Development Group.