A B C D E F G H I J L M N O P R S T U W
All Classes All Packages
All Classes All Packages
All Classes All Packages
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.
- AclFormatException(String) - Constructor for exception org.hsqldb.server.ServerAcl.AclFormatException
- 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 aSELECT
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) - 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
- authenticate(String, String, String) - Static method in class org.hsqldb.auth.AuthBeanMultiplexer
-
HyperSQL Java Function Method.
- AuthFunctionBean - Interface in org.hsqldb.auth
-
N.b.
- autoCommitFailureClosesAllResultSets() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
-
Retrieves whether a
SQLException
while autoCommit istrue
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() - 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(int) - Method in class org.hsqldb.jdbc.JDBCPool
-
Closes the pool immediately.
- 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.
- 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.JDBCUtil
- 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 generateResultSet
objects with the given type and concurrency. - createStatement(int, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
-
Creates a
Statement
object that will generateResultSet
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
- DbBackupMain - Class in org.hsqldb.lib.tar
- DbBackupMain() - Constructor for class org.hsqldb.lib.tar.DbBackupMain
- 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 typesLONGVARCHAR
andLONGVARBINARY
. - 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
- 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) - 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.JDBCPreparedStatement
- 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.JDBCPreparedStatement
- 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.JDBCPreparedStatement
- 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 theResultSet
object generated by the query. - executeQuery() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Executes the SQL query in this
PreparedStatement
object and returns theResultSet
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 asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement. - executeUpdate(String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
This method should always throw if called for a PreparedStatement or CallableStatment.
- executeUpdate(String) - Method in class org.hsqldb.jdbc.JDBCStatement
-
Executes the given SQL statement, which may be an
INSERT
,UPDATE
, orDELETE
statement or an SQL statement that returns nothing, such as an SQL DDL statement. - 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.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.JDBCPreparedStatement
- 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.JDBCPreparedStatement
- 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 itsResultSet
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 thisArray
object in the form of an array in the Java programming language. - getArray() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
-
Retrieves the contents of the SQL
ARRAY
value designated by thisArray
object in the form of an array in the Java programming language. - getArray(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
ARRAY
parameter as anArray
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 anArray
object in the Java programming language. - getArray(long, int) - Method in class org.hsqldb.jdbc.JDBCArray
-
Retrieves a slice of the SQL
ARRAY
value designated by thisArray
object, beginning with the specifiedindex
and containing up tocount
successive elements of the SQL array. - getArray(long, int) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
-
Retrieves a slice of the SQL
ARRAY
value designated by thisArray
object, beginning with the specifiedindex
and containing up tocount
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 thisArray
object, beginning with the specifiedindex
and containing up tocount
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 thisArray
object, beginning with the specifiedindex
and containing up tocount
successive elements of the SQL array. - getArray(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
ARRAY
parameter as anArray
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 anArray
object 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 thisArray
object. - getArray(Map<String, Class<?>>) - Method in class org.hsqldb.jdbc.JDBCArrayBasic
-
Retrieves the contents of the SQL
ARRAY
value designated by thisArray
object. - getArrayInternal() - Method in class org.hsqldb.jdbc.JDBCArray
- getAsciiStream() - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves the
CLOB
value designated by thisClob
object as an ASCII stream. - getAsciiStream() - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves the
CLOB
value designated by thisClob
object as an ascii stream. - getAsciiStream() - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves the
CLOB
value designated by thisClob
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) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
NUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains. - 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 ajava.math.BigDecimal
with full precision. - getBigDecimal(int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Deprecated.use
getBigDecimal(int parameterIndex)
orgetBigDecimal(String parameterName)
- getBigDecimal(int, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Deprecated.by java.sun.com as of JDK 1.2
- getBigDecimal(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
NUMERIC
parameter as ajava.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.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as ajava.math.BigDecimal
with full precision. - getBigDecimal(String, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Deprecated.by java.sun.com as of JDK 1.2
- getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCBlob
-
Retrieves the
BLOB
value designated by thisBlob
instance as a stream. - getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCBlobClient
-
Retrieves the
BLOB
value designated by thisBlob
instance as a stream. - getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCBlobFile
-
Retrieves the
BLOB
value designated by thisBlob
instance as a stream. - getBinaryStream() - Method in class org.hsqldb.jdbc.JDBCSQLXML
-
Retrieves the XML value designated by this SQLXML instance as a stream.
- getBinaryStream(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as a stream of uninterpreted bytes. - getBinaryStream(long, long) - Method in class org.hsqldb.jdbc.JDBCBlob
-
Returns an
InputStream
object that contains a partialBlob
value, starting with the byte specified by pos, which is length bytes in length. - getBinaryStream(long, long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
-
Returns an
InputStream
object that contains a partialBlob
value, starting with the byte specified by pos, which is length bytes in length. - getBinaryStream(long, long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
-
Returns an
InputStream
object that contains a partialBlob
value, starting with the byte specified by pos, which is length bytes in length. - 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 uninterpretedbyte
s. - 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 aBlob
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 aBlob
object in the Java programming language. - getBlob(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
BLOB
parameter as aBlob
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 aBlob
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
orBOOLEAN
parameter as aboolean
in the Java programming language. - getBoolean(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as aboolean
in the Java programming language. - getBoolean(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
(JDBC4 modified:)
- 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 aboolean
in the Java programming language. - getByte(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
TINYINT
parameter as abyte
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 abyte
in the Java programming language. - getByte(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
TINYINT
parameter as abyte
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 abyte
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 thisjava.sql.RowId
object. - getBytes(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
BINARY
orVARBINARY
parameter as an array ofbyte
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 abyte
array in the Java programming language. - getBytes(long, int) - Method in class org.hsqldb.jdbc.JDBCBlob
-
Retrieves all or part of the
BLOB
value that thisBlob
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 thisBlob
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 thisBlob
object represents, as an array of bytes. - getBytes(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
BINARY
orVARBINARY
parameter as an array ofbyte
values 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 abyte
array in the Java programming language. - 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() - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves the
CLOB
value designated by thisClob
object as ajava.io.Reader
object (or as a stream of characters). - getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves the
CLOB
value designated by thisClob
object as ajava.io.Reader
object (or as a stream of characters). - getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves the
CLOB
value designated by thisClob
object as ajava.io.Reader
object (or as a stream of characters). - getCharacterStream() - Method in class org.hsqldb.jdbc.JDBCSQLXML
-
Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.
- 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(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as ajava.io.Reader
object. - getCharacterStream(long, long) - Method in class org.hsqldb.jdbc.JDBCClob
-
Returns a
Reader
object that contains a partialClob
value, starting with the character specified by pos, which is length characters in length. - getCharacterStream(long, long) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Returns a
Reader
object that contains a partialClob
value, starting with the character specified by pos, which is length characters in length. - getCharacterStream(long, long) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Returns a
Reader
object that contains a partialClob
value, starting with the character specified by pos, which is length characters in length. - 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(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as ajava.io.Reader
object. - 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.
- getClientInfo(String) - Method in class org.hsqldb.jdbc.JDBCConnection
-
Returns the value of the client info property specified by name.
- getClientInfoProperties() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
-
Retrieves a list of the client info properties that the driver supports.
- getClob() - Method in class org.hsqldb.jdbc.JDBCClobClient
- getClob(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
CLOB
parameter as ajava.sql.Clob
object in the Java programming language. - getClob(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as aClob
object in the Java programming language. - getClob(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
CLOB
parameter as aClob
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 aClob
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() - Method in class org.hsqldb.jdbc.JDBCPool
-
Retrieves a new connection using the properties that have already been set.
- getConnection() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Retrieves the
Connection
object that produced thisStatement
object. - getConnection() - Method in class org.hsqldb.jdbc.JDBCStatement
-
Retrieves the
Connection
object that produced thisStatement
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.jdbc.JDBCDataSource
-
Retrieves a new connection using the given username and password, and the database url that has 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(String, String) - Method in class org.hsqldb.lib.RCData
-
Gets a JDBC Connection using the data of this RCData object with specified override elements
- getConnection(String, Properties) - Static method in class org.hsqldb.jdbc.JDBCDriver
-
The static equivalent of the
connect(String,Properties)
method. - 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 ajava.sql.Date
object. - 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 ajava.sql.Date
object in the Java programming language. - getDate(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
DATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date. - 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 ajava.sql.Date
object in the Java programming language. - getDate(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
DATE
parameter as ajava.sql.Date
object. - 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 ajava.sql.Date
object in the Java programming language. - getDate(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
DATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date. - 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 ajava.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 adouble
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 adouble
in the Java programming language. - getDouble(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
DOUBLE
parameter as adouble
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 adouble
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 thisStatement
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 thisStatement
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 afloat
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 afloat
in the Java programming language. - getFloat(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
FLOAT
parameter as afloat
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 afloat
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 thisConnection
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 anint
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 anint
in the Java programming language. - getInt(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
INTEGER
parameter as anint
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 anint
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) - 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.
- 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.
- 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 along
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 along
in the Java programming language. - getLong(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
BIGINT
parameter as along
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 along
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.
- 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 thisStatement
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 thisStatement
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 thisStatement
object can contain. - getMaxRows() - Method in class org.hsqldb.jdbc.JDBCStatement
-
Retrieves the maximum number of rows that a
ResultSet
object produced by thisStatement
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 thisConnection
object represents a connection. - getMetaData() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Retrieves a
ResultSetMetaData
object that contains information about the columns of theResultSet
object that will be returned when thisPreparedStatement
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.
- getMoreResults() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Moves to this
Statement
object's next result, returnstrue
if it is aResultSet
object, and implicitly closes any currentResultSet
object(s) obtained with the methodgetResultSet
. - getMoreResults() - Method in class org.hsqldb.jdbc.JDBCStatement
-
Moves to this
Statement
object's next result, returnstrue
if it is aResultSet
object, and implicitly closes any currentResultSet
object(s) obtained with the methodgetResultSet
. - getMoreResults(int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Moves to this
Statement
object's next result, deals with any currentResultSet
object(s) according to the instructions specified by the given flag, and returnstrue
if the next result is aResultSet
object. - getMoreResults(int) - Method in class org.hsqldb.jdbc.JDBCStatement
-
Moves to this
Statement
object's next result, deals with any currentResultSet
object(s) according to the instructions specified by the given flag, and returnstrue
if the next result is aResultSet
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(int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as ajava.io.Reader
object. - 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(String) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as ajava.io.Reader
object. - getNClob(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
NCLOB
parameter as ajava.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 aNClob
object in the Java programming language. - getNClob(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
NCLOB
parameter as ajava.sql.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 aNClob
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
orLONGNVARCHAR
parameter as aString
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 aString
in the Java programming language. - getNString(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated
NCHAR
,NVARCHAR
orLONGNVARCHAR
parameter as aString
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 aString
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) - Method in class org.hsqldb.jdbc.JDBCResultSet
- 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(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(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 anObject
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 usesmap
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) - Method in class org.hsqldb.jdbc.JDBCResultSet
- 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(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. - getObject(String, Map) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
- 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 anObject
in the Java programming language. - 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 thisParameterMetaData
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.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.
- 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 aRef
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 aRef
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 aRef
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 aRef
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 thisArray
object. - getResultSet() - Method in class org.hsqldb.jdbc.JDBCArrayBasic
-
Retrieves a result set that contains the elements of the SQL
ARRAY
value designated by thisArray
object. - getResultSet() - Method in class org.hsqldb.jdbc.JDBCCallableStatement
- 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. - 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 tocount
successive elements. - 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 tocount
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 tocount
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 tocount
successive elements. - 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 thisArray
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 thisArray
object. - getResultSetConcurrency() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Retrieves the result set concurrency for
ResultSet
objects generated by thisStatement
object. - getResultSetConcurrency() - Method in class org.hsqldb.jdbc.JDBCStatement
-
Retrieves the result set concurrency for
ResultSet
objects generated by thisStatement
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 thisStatement
object. - getResultSetHoldability() - Method in class org.hsqldb.jdbc.JDBCStatement
-
Retrieves the result set holdability for
ResultSet
objects generated by thisStatement
object. - getResultSetType() - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Retrieves the result set type for
ResultSet
objects generated by thisStatement
object. - getResultSetType() - Method in class org.hsqldb.jdbc.JDBCStatement
-
Retrieves the result set type for
ResultSet
objects generated by thisStatement
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 ajava.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 ajava.sql.RowId
object in the Java programming language. - getRowId(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
ROWID
parameter as ajava.sql.RowId
object. - 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 ajava.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 aRowId
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 ashort
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 ashort
in the Java programming language. - getShort(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
SMALLINT
parameter as ashort
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 ashort
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 ajava.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 ajava.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 ajava.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 ajava.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 thisResultSet
object. - getString() - Method in class org.hsqldb.jdbc.JDBCSQLXML
-
Returns a string representation of the XML value designated by this SQLXML instance.
- getString(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
CHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
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 aString
in the Java programming language. - getString(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
CHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
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 aString
in the Java programming language. - getStringFunctions() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
-
Retrieves a comma-separated list of string functions available with this database.
- getSubString(long, int) - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves a copy of the specified substring in the
CLOB
value designated by thisClob
object. - getSubString(long, int) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves a copy of the specified substring in the
CLOB
value designated by thisClob
object. - getSubString(long, int) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves a copy of the specified substring in the
CLOB
value designated by thisClob
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 ajava.sql.Time
object. - 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 ajava.sql.Time
object in the Java programming language. - getTime(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
TIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time. - 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 ajava.sql.Time
object in the Java programming language. - getTime(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
TIME
parameter as ajava.sql.Time
object. - 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 ajava.sql.Time
object in the Java programming language. - getTime(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
TIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time. - 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 ajava.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 ajava.sql.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 ajava.sql.Timestamp
object in the Java programming language. - getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
TIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object. - getTimestamp(int, Calendar) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Retrieves the value of the designated column in the current row of this
ResultSet
object as ajava.sql.Timestamp
object in the Java programming language. - getTimestamp(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
TIMESTAMP
parameter as ajava.sql.Timestamp
object. - 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 ajava.sql.Timestamp
object in the Java programming language. - getTimestamp(String, Calendar) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
TIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object. - 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 ajava.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 thisConnection
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 ofgetUnicodeStream
- 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() - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
-
Retrieves the jdbc database connection url attribute.
- getUrl() - Method in class org.hsqldb.jdbc.JDBCPool
-
Retrieves the jdbc database connection url attribute.
- getURL() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
-
Retrieves the URL for this DBMS.
- getURL(int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of the designated JDBC
DATALINK
parameter as ajava.net.URL
object. - 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 ajava.net.URL
object in the Java programming language. - getURL(String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Retrieves the value of a JDBC
DATALINK
parameter as ajava.net.URL
object. - 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 ajava.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.JDBCUtil
- invalidArgument(String) - Static method in class org.hsqldb.jdbc.JDBCUtil
- 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() - Method in class org.hsqldb.jdbc.JDBCSQLXML
-
Retrieves the object's readability status.
- isWritable(int) - Method in class org.hsqldb.jdbc.JDBCResultSetMetaData
-
Indicates whether it is possible for a write on the designated column to succeed.
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
- 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(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.
- 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.
- 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.
- JDBCConnection - Class in org.hsqldb.jdbc
- JDBCConnection(JDBCConnection, JDBCConnectionEventListener) - Constructor for class org.hsqldb.jdbc.JDBCConnection
-
Constructor for use with connection pooling and XA.
- JDBCConnection(HsqlProperties) - Constructor for class org.hsqldb.jdbc.JDBCConnection
-
Constructs a new external
Connection
to an HSQLDBDatabase
. - JDBCConnection(SessionInterface) - Constructor for class org.hsqldb.jdbc.JDBCConnection
-
Constructs an
INTERNAL
Connection
, using the specifiedSessionInterface
. - 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() - 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 andorg.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(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.
- 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.
- 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. - JDBCStatement - Class in org.hsqldb.jdbc
- JDBCUtil - Class in org.hsqldb.jdbc
-
Provides driver constants and a gateway from internal HsqlExceptions to external SQLExceptions.
- JDBCUtil() - Constructor for class org.hsqldb.jdbc.JDBCUtil
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
- LdapAuthBeanTester - Class in org.hsqldb.auth
- LdapAuthBeanTester() - Constructor for class org.hsqldb.auth.LdapAuthBeanTester
- length() - Method in class org.hsqldb.jdbc.JDBCBlob
-
Returns the number of bytes in the
BLOB
value designated by thisBlob
object. - length() - Method in class org.hsqldb.jdbc.JDBCBlobClient
-
Returns the number of bytes in the
BLOB
value designated by thisBlob
object. - length() - Method in class org.hsqldb.jdbc.JDBCBlobFile
-
Returns the number of bytes in the
BLOB
value designated by thisBlob
object. - length() - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves the number of characters in the
CLOB
value designated by thisClob
object. - length() - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves the number of characters in the
CLOB
value designated by thisClob
object. - length() - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves the number of characters in the
CLOB
value designated by thisClob
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) - Method in class org.hsqldb.lib.FrameworkLogger
- log(Level, String, Throwable) - Method in class org.hsqldb.lib.FrameworkLogger
-
Just like FrameworkLogger.log(Level, String), but also logs a stack trace.
- 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.LdapAuthBeanTester
-
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.DbBackupMain
-
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.
- newEptyResultSet() - Static method in class org.hsqldb.jdbc.JDBCResultSet
- 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) - 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.JDBCUtil
- nullPlusNonNullIsNull() - Method in class org.hsqldb.jdbc.JDBCDatabaseMetaData
-
Retrieves whether this database supports concatenations between
NULL
and non-NULL
values beingNULL
. - 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.JDBCUtil
- outOfRangeArgument(String) - Static method in class org.hsqldb.jdbc.JDBCUtil
- 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(byte[]) - Method in class org.hsqldb.server.ServerAcl
- 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.
- position(byte[], long) - Method in class org.hsqldb.jdbc.JDBCBlob
-
Retrieves the byte position at which the specified byte array
pattern
begins within theBLOB
value that thisBlob
object represents. - position(byte[], long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
-
Retrieves the byte position at which the specified byte array
pattern
begins within theBLOB
value that thisBlob
object represents. - position(byte[], long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
-
Retrieves the byte position at which the specified byte array
pattern
begins within theBLOB
value that thisBlob
object represents. - position(char[], long) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves the character position at which the specified char[]
pattern
appears in theCLOB
value represented by thisClob
object. - position(String, long) - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves the character position at which the specified substring
searchstr
appears in the SQLCLOB
value represented by thisClob
object. - position(String, long) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves the character position at which the specified substring
searchstr
appears in the SQLCLOB
value represented by thisClob
object. - position(String, long) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves the character position at which the specified
Clob
objectsearchstr
appears in thisClob
object. - position(Blob, long) - Method in class org.hsqldb.jdbc.JDBCBlob
-
Retrieves the byte position in the
BLOB
value designated by thisBlob
object at whichpattern
begins. - position(Blob, long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
-
Retrieves the byte position in the
BLOB
value designated by thisBlob
object at whichpattern
begins. - position(Blob, long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
-
Retrieves the byte position in the
BLOB
value designated by thisBlob
object at whichpattern
begins. - position(Clob, long) - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves the character position at which the specified
Clob
objectsearchstr
appears in thisClob
object. - position(Clob, long) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves the character position at which the specified
Clob
objectsearchstr
appears in thisClob
object. - position(Clob, long) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves the character position at which the specified
Clob
objectsearchstr
appears in thisClob
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 generateResultSet
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 generateResultSet
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) - 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, int, int) - Method in class org.hsqldb.jdbc.JDBCConnection
-
Creates a
PreparedStatement
object that will generateResultSet
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 generateResultSet
objects with the given type, concurrency, and holdability. - 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 typesqlType
. - registerOutParameter(int, int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Registers the parameter in ordinal position
parameterIndex
to be of JDBC typesqlType
. - 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 typesqlType
. - registerOutParameter(String, int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Registers the parameter named
parameterName
to be of JDBC typesqlType
. - 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 subsequentSavepoint
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
- SAX2XMLStreamWriter(XMLStreamWriter) - Constructor for class org.hsqldb.jdbc.JDBCSQLXML.SAX2XMLStreamWriter
-
Constructs a new SAX2XMLStreamWriter that writes SAX events to the designated XMLStreamWriter.
- 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
- 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(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given input stream.
- 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(long) - Method in class org.hsqldb.jdbc.JDBCClob
-
Retrieves a stream to be used to write ASCII characters to the
CLOB
value that thisClob
object represents, starting at positionpos
. - setAsciiStream(long) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Retrieves a stream to be used to write Ascii characters to the
CLOB
value that thisClob
object represents, starting at positionpos
. - setAsciiStream(long) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Retrieves a stream to be used to write Ascii characters to the
CLOB
value that thisClob
object represents, starting at positionpos
. - setAsciiStream(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given input stream.
- 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.
- 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.
- 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.
- 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.
- setAuthFunctionBeans(Connection, List<AuthFunctionBean>) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
-
Wrapper for setAuthFunctioNBeans(String, List
) - setAuthFunctionBeans(Map<String, List<AuthFunctionBean>>) - Method in class org.hsqldb.auth.AuthBeanMultiplexer
-
Primary purpose of this class is to manage this static map.
- 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(int, BigDecimal) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given
java.math.BigDecimal
value. - setBigDecimal(String, BigDecimal) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given
java.math.BigDecimal
value. - 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.
- setBinaryStream(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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(long) - Method in class org.hsqldb.jdbc.JDBCBlob
-
Retrieves a stream that can be used to write to the
BLOB
value that thisBlob
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 thisBlob
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 thisBlob
object represents. - setBinaryStream(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given input stream.
- 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.
- setBlob(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to a
InputStream
object. - setBlob(int, InputStream, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to a
InputStream
object. - 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. - setBoolean(int, boolean) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
boolean
value. - setBoolean(String, boolean) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given Java
boolean
value. - setByte(int, byte) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
byte
value. - setByte(String, byte) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given Java
byte
value. - setBytes(int, byte[]) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java array of bytes.
- setBytes(long, byte[]) - Method in class org.hsqldb.jdbc.JDBCBlob
-
Writes the given array of bytes to the
BLOB
value that thisBlob
object represents, starting at positionpos
, 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 thisBlob
object represents, starting at positionpos
, 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 thisBlob
object represents, starting at positionpos
, 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 theBLOB
value that thisBlob
object represents 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 theBLOB
value that thisBlob
object represents 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 theBLOB
value that thisBlob
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.
- 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() - Method in class org.hsqldb.jdbc.JDBCSQLXML
-
Retrieves a stream to be used to write the XML value that this SQLXML instance represents.
- setCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given
Reader
object. - 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(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 thisClob
object represents, at positionpos
. - 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 thisClob
object represents, at positionpos
. - 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 thisClob
object represents, at positionpos
. - setCharacterStream(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given
Reader
object. - 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. - 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(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to a
Reader
object. - setClob(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to a
Reader
object. - 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. - 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 subsequentStatement
objectexecute
methods. - setCursorName(String) - Method in class org.hsqldb.jdbc.JDBCStatement
-
Sets the SQL cursor name to the given
String
, which will be used by subsequentStatement
objectexecute
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(int, String) - Method in class org.hsqldb.server.Server
-
Sets the external name (url alias) of the i'th hosted database.
- 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).
- setDatabasePath(int, String) - Method in class org.hsqldb.server.Server
-
Sets the path of the hosted database.
- 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 givenCalendar
object. - 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 givenCalendar
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(int, double) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
double
value. - setDouble(String, double) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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 thisStatement
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 thisStatement
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 thisStatement
. - 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 thisStatement
. - setFileIgnore(String) - Method in class org.hsqldb.lib.tar.DbBackup
- setFloat(int, float) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
float
value. - setFloat(String, float) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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 thisConnection
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(int, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
int
value. - setInt(String, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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 givenjava.io.PrintWriter
object. - setLogWriter(PrintWriter) - Method in class org.hsqldb.jdbc.JDBCPool
-
Sets the log writer for this
DataSource
object to the givenjava.io.PrintWriter
object. - setLogWriter(PrintWriter) - Method in class org.hsqldb.server.Server
-
Sets the PrintWriter to which server messages are logged.
- setLong(int, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
long
value. - setLong(String, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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 aResultSet
object produced by thisStatement
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 aResultSet
object produced by thisStatement
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 thisStatement
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 thisStatement
object can contain to the given number. - setNCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to a
Reader
object. - setNCharacterStream(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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. - setNClob(int, Reader, long) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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(String, Reader) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to a
Reader
object. - setNClob(String, Reader, long) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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. - setNetworkTimeout(Executor, int) - Method in class org.hsqldb.jdbc.JDBCConnection
-
Sets the maximum period a
Connection
or objects created from theConnection
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(int, String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated paramter to the given
String
object. - setNString(String, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given
String
object. - 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
. - 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
. - setObject(int, Object) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
- 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, int, int) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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(String, Object, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the value of the designated parameter with the given object.
- setObject(String, Object, int, int) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the value of the designated parameter with the given object.
- 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(int, RowId) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given
java.sql.RowId
object. - setRowId(String, RowId) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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(int, short) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given Java
short
value. - setShort(String, short) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given Java
short
value. - setSilent(boolean) - Method in class org.hsqldb.server.Server
-
Sets silent mode operation
- setSQLXML(int, SQLXML) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
Sets the designated parameter to the given
java.sql.SQLXML
object. - setSQLXML(String, SQLXML) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
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(int, String) - Method in class org.hsqldb.jdbc.JDBCPreparedStatement
-
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 theCLOB
value that thisClob
object designates at the positionpos
. - setString(long, String) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Writes the given Java
String
to theCLOB
value that thisClob
object designates at the positionpos
. - setString(long, String) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Writes the given Java
String
to theCLOB
value that thisClob
object designates at the positionpos
. - setString(long, String, int, int) - Method in class org.hsqldb.jdbc.JDBCClob
-
Writes
len
characters ofstr
, starting at characteroffset
, to theCLOB
value that thisClob
represents. - setString(long, String, int, int) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Writes
len
characters ofstr
, starting at characteroffset
, to theCLOB
value that thisClob
represents. - setString(long, String, int, int) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Writes
len
characters ofstr
, starting at characteroffset
, to theCLOB
value that thisClob
represents. - setString(String) - Method in class org.hsqldb.jdbc.JDBCSQLXML
-
Sets the XML value designated by this SQLXML instance to the given String representation.
- setString(String, String) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given Java
String
value. - setTI(Connection, String) - Static method in class org.hsqldb.lib.RCData
-
Set Transaction Isolation level on the specified JDBC Connection
- 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 givenCalendar
object. - 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 givenCalendar
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 givenCalendar
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 givenCalendar
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 thisConnection
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) - 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. - setURL(String) - Method in class org.hsqldb.jdbc.JDBCCommonDataSource
-
Sets the jdbc database URL.
- setURL(String, URL) - Method in class org.hsqldb.jdbc.JDBCCallableStatement
-
Sets the designated parameter to the given
java.net.URL
object. - 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(int) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(int, int) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(int, String) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(int, String, Throwable) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(String, String, int, Throwable) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(Throwable) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(HsqlException) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(HsqlException, Throwable) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlException(Result) - Static method in class org.hsqldb.jdbc.JDBCUtil
- sqlExceptionSQL(int) - Static method in class org.hsqldb.jdbc.JDBCUtil
- 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(Reader, String, PrintStream, String, boolean, File) - Constructor for class org.hsqldb.cmdline.SqlFile
-
Instantiate a SqlFile instance for SQL input from 'reader'.
- SqlFile(String, boolean) - Constructor for class org.hsqldb.cmdline.SqlFile
-
Constructor for interactive usage with stdin/stdout
- 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.JDBCUtil
- 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 aGROUP BY
clause provided that all of the columns in theSELECT
statement are included in theGROUP 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 aGROUP 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 aCallableStatement
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 methodexecute
. - 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 anORDER 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.
- 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 thisBlob
object represents to belen
bytes in length. - truncate(long) - Method in class org.hsqldb.jdbc.JDBCBlobClient
-
Truncates the
BLOB
value that thisBlob
object represents to belen
bytes in length. - truncate(long) - Method in class org.hsqldb.jdbc.JDBCBlobFile
-
Truncates the
BLOB
value that thisBlob
object represents to belen
bytes in length. - truncate(long) - Method in class org.hsqldb.jdbc.JDBCClob
-
Truncates the
CLOB
value that thisClob
designates to have a length oflen
characters. - truncate(long) - Method in class org.hsqldb.jdbc.JDBCClobClient
-
Truncates the
CLOB
value that thisClob
designates to have a length oflen
characters. - truncate(long) - Method in class org.hsqldb.jdbc.JDBCClobFile
-
Truncates the
CLOB
value that thisClob
designates to have a length oflen
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.
- UPCallbackHandler(String, String) - Constructor for class org.hsqldb.auth.JaasAuthBean.UPCallbackHandler
- 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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with an ascii stream 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(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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with an ascii stream value.
- updateAsciiStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
(JDBC4 clarification:) 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..
- 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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a binary stream 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(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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a binary stream value.
- updateBinaryStream(String, InputStream, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
(JDBC4 clarification:) 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.
- updateBlob(int, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column using the given input stream.
- 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(int, Blob) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.Blob
value. - updateBlob(String, InputStream) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column using the given input stream.
- 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(String, Blob) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.Blob
value. - updateBoolean(int, boolean) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
boolean
value. - updateBoolean(String, boolean) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
boolean
value. - updateByte(int, byte) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
byte
value. - updateByte(String, byte) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
byte
value. - updateBytes(int, byte[]) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
byte
array value. - updateBytes(String, byte[]) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a byte array value.
- updateCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a character stream 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(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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a character stream value.
- updateCharacterStream(String, Reader, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
(JDBC4 clarification) Updates the designated column with a character stream value, which will have the specified number of (CHECKME: characters?) 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.
- updateClob(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column using the given
Reader
object. - 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(int, Clob) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.Clob
value. - updateClob(String, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column using the given
Reader
object. - 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(String, Clob) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.Clob
value. - updateDate(int, Date) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.Date
value. - updateDate(String, Date) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.Date
value. - updateDouble(int, double) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
double
value. - updateDouble(String, double) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
double
value. - updateFloat(int, float) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
float
value. - updateFloat(String, float) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
float
value. - updateInt(int, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with an
int
value. - updateInt(String, int) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with an
int
value. - updateLong(int, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
long
value. - updateLong(String, long) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
long
value. - updateNCharacterStream(int, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a character stream 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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a character stream value.
- 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.
- 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(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(int, NClob) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.NClob
value. - updateNClob(String, Reader) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column using the given
Reader
object. - 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(String, NClob) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with a
java.sql.NClob
value. - 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) - Method in class org.hsqldb.jdbc.JDBCResultSet
-
Updates the designated column with an
Object
value. - updateObject(int, 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. - updateObject(String, Object, int) - 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.
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.
- writeAsFiles() - Method in class org.hsqldb.lib.tar.DbBackup
All Classes All Packages