Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep
Overview  Package  Class  Use  Deprecated   Index 
Home >> All >> org >> [ hsqldb overview ]  PREV  NEXT
A B C D E F G H I J L M N O P Q R S T U V W Y

A

ACCESS_IS_DENIED - Static variable in class org.hsqldb.Trace
 
ADD - Static variable in class org.hsqldb.Expression
 
ALL - Static variable in class org.hsqldb.UserManager
 
ALTER - Static variable in class org.hsqldb.Database
 
AND - Static variable in class org.hsqldb.Expression
 
ASSERT_FAILED - Static variable in class org.hsqldb.Trace
 
ASTERIX - Static variable in class org.hsqldb.Expression
 
AVG - Static variable in class org.hsqldb.Expression
 
aAccess - Variable in class org.hsqldb.Database
 
aAccess - Variable in class org.hsqldb.DatabaseInformation
 
abs(double) - Static method in class org.hsqldb.Library
Method declaration
absolute(int) - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the given row number in this ResultSet object.
acceptsURL(String) - Method in class org.hsqldb.jdbcDriver
Returns true if the driver thinks that it can open a connection to the given URL.
add(CachedRow) - Method in class org.hsqldb.Cache
Adds a Row to the Cache.
add(Object, Object, int) - Static method in class org.hsqldb.Column
Add two object of a given type
add(Object[]) - Method in class org.hsqldb.Result
Method declaration
addAggregateRow(Result, Object[], int, int) - Method in class org.hsqldb.Select
Method declaration
addAndCondition(Expression) - Method in class org.hsqldb.TableFilter
Method declaration
addBatch() - Method in class org.hsqldb.jdbcPreparedStatement
Adds a set of parameters to this PreparedStatement object's batch of commands.
addBatch(String) - Method in class org.hsqldb.jdbcStatement
Adds the given SQL command to the current list of commmands for this Statement object.
addColumn(String, int) - Method in class org.hsqldb.Table
Method declaration
addColumn(Column) - Method in class org.hsqldb.Table
Performs the table level checks and adds a column to the table at the DDL level.
addColumns(Result) - Method in class org.hsqldb.Table
Method declaration
addColumns(Result) - Method in class org.hsqldb.View
 
addCondition(Expression, Expression) - Method in class org.hsqldb.Parser
Method declaration
addConstraint(Constraint) - Method in class org.hsqldb.Table
Method declaration
addIndexOn(Tokenizer, Session, String, boolean, Table, boolean) - Method in class org.hsqldb.Database
Indexes defined in DDL scripts are handled by this method.
addOrDropColumn(Column, int, int) - Method in class org.hsqldb.TableWorks
 
addProperties(HsqlProperties) - Method in class org.hsqldb.HsqlProperties
 
addQuotes(String, String) - Method in class org.hsqldb.QuotedTextDatabaseRowOutput
 
addQuotes(byte[], String) - Method in class org.hsqldb.QuotedTextDatabaseRowOutput
 
addRow(Result, String) - Static method in class org.hsqldb.DatabaseScript
Method declaration
addTransactionDelete(Table, Object[]) - Method in class org.hsqldb.Session
Method declaration
addTransactionInsert(Table, Object[]) - Method in class org.hsqldb.Session
Method declaration
addTrigger(TriggerDef) - Method in class org.hsqldb.Table
Method declaration
addWhere(String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Catenates the specified "where" clause with the specified String s, inserting an " AND " conjunction between them.
afterLast() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the end of this ResultSet object, just after the last row.
aggregateCount - Variable in class org.hsqldb.Select
 
aggregateRow - Variable in class org.hsqldb.Select
 
aliasQuoted - Variable in class org.hsqldb.Expression
 
allProceduresAreCallable() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether the current user can call all the procedures returned by the method getProcedures.
allTablesAreSelectable() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.
append(Result) - Method in class org.hsqldb.Result
Method declaration
argArrayToProps(String[], String) - Static method in class org.hsqldb.HsqlProperties
 
ascii(String) - Static method in class org.hsqldb.Library
Method declaration
asciiToUnicode(String) - Static method in class org.hsqldb.StringConverter
Hsqldb specific decoding used only for log files.
available() - Method in interface org.hsqldb.DatabaseRowInputInterface
 
avg(Object, int, int) - Static method in class org.hsqldb.Column
Divide numeric object a by int count.

B

BAD_ADD_COLUMN_DEFINITION - Static variable in class org.hsqldb.Trace
 
BAD_INDEX_CONSTRAINT_NAME - Static variable in class org.hsqldb.Trace
 
BETWEEN - Static variable in class org.hsqldb.Expression
 
BIGDECIMAL_0 - Static variable in class org.hsqldb.Column
 
BIGGER - Static variable in class org.hsqldb.Expression
 
BIGGER_EQUAL - Static variable in class org.hsqldb.Expression
 
BinaryDatabaseRowInput - class org.hsqldb.BinaryDatabaseRowInput.
Provides methods for reading the data for a row from a byte array.
BinaryDatabaseRowInput(byte[], int) - Constructor for class org.hsqldb.BinaryDatabaseRowInput
 
BinaryDatabaseRowOutput - class org.hsqldb.BinaryDatabaseRowOutput.
Provides methods for writing the data for a row to a byte array.
BinaryDatabaseRowOutput() - Constructor for class org.hsqldb.BinaryDatabaseRowOutput
Constructor used for a Result row
BinaryDatabaseRowOutput(int) - Constructor for class org.hsqldb.BinaryDatabaseRowOutput
Constructor used for persistent storage of a Table row
BinaryServerRowInput - class org.hsqldb.BinaryServerRowInput.
Provides methods for reading the data for a row from a byte array.
BinaryServerRowInput(byte[]) - Constructor for class org.hsqldb.BinaryServerRowInput
 
BinaryServerRowInput(byte[], int) - Constructor for class org.hsqldb.BinaryServerRowInput
 
BinaryServerRowOutput - class org.hsqldb.BinaryServerRowOutput.
Provides methods for writing the data for a row to a byte array.
BinaryServerRowOutput() - Constructor for class org.hsqldb.BinaryServerRowOutput
Constructor used for a Result row
BinaryServerRowOutput(int) - Constructor for class org.hsqldb.BinaryServerRowOutput
Constructor used for persistent storage of a Table row
ByteArray - class org.hsqldb.ByteArray.
This class allows HSQLDB to store binary data as an array of bytes.
ByteArray() - Constructor for class org.hsqldb.ByteArray
Private constructor, no instance of this is available.
bAdministrator - Variable in class org.hsqldb.User
 
bArgNullable - Variable in class org.hsqldb.Function
 
bAutoCommit - Variable in class org.hsqldb.Session
 
bCascade - Variable in class org.hsqldb.ConstraintCore
 
bChanged - Variable in class org.hsqldb.CachedRow
 
bClosed - Variable in class org.hsqldb.Session
 
bClosed - Variable in class org.hsqldb.jdbcConnection
Is this connection closed?
bConnection - Variable in class org.hsqldb.Function
 
bDelete - Variable in class org.hsqldb.Transaction
 
bDescending - Variable in class org.hsqldb.Expression
 
bEscapeProcessing - Variable in class org.hsqldb.jdbcStatement
Is escape processing enabled?
bIgnoreCase - Variable in class org.hsqldb.Database
 
bIgnoreCase - Variable in class org.hsqldb.Like
 
bInit - Variable in class org.hsqldb.jdbcResultSet
Is current row before the first row?
bNeedFlush - Variable in class org.hsqldb.Log
 
bNestedOldAutoCommit - Variable in class org.hsqldb.Session
 
bNestedTransaction - Variable in class org.hsqldb.Session
 
bOuterJoin - Variable in class org.hsqldb.TableFilter
 
bReadOnly - Variable in class org.hsqldb.Database
 
bReadOnly - Variable in class org.hsqldb.Log
 
bReadOnly - Variable in class org.hsqldb.Session
 
bReferentialIntegrity - Variable in class org.hsqldb.Database
 
bRestoring - Variable in class org.hsqldb.Log
 
bShutdown - Variable in class org.hsqldb.Database
 
bUnique - Variable in class org.hsqldb.Index
 
bWait - Variable in class org.hsqldb.Tokenizer
 
bWasNull - Variable in class org.hsqldb.jdbcResultSet
Did the last getXXX method encounter a null value?
bWriteDelay - Variable in class org.hsqldb.Log
 
back() - Method in class org.hsqldb.Tokenizer
Method declaration
backup() - Method in class org.hsqldb.Log
Saves the *.data file as compressed *.backup.
balance(Node, boolean) - Method in class org.hsqldb.Index
 
beforeFirst() - Method in class org.hsqldb.jdbcResultSet
Moves the cursor to the front of this ResultSet object, just before the first row.
beginIndex - Variable in class org.hsqldb.Tokenizer
 
beginNestedTransaction() - Method in class org.hsqldb.Session
Method declaration
bitand(int, int) - Static method in class org.hsqldb.Library
Method declaration
bitor(int, int) - Static method in class org.hsqldb.Library
Method declaration
build() - Method in class org.hsqldb.jdbcPreparedStatement
Builds SQL from the combination of the statement string supplied in the constructor and any parameter values currently in effect via the use of setXXX methods.
buildDistinctAggregates(Result) - Method in class org.hsqldb.Select
 
buildResult(Result, int) - Method in class org.hsqldb.Select
 
byteOut - Variable in class org.hsqldb.BinaryDatabaseRowOutput
 
byteOut - Variable in class org.hsqldb.BinaryServerRowOutput
 
byteOut - Variable in class org.hsqldb.TextDatabaseRowOutput
 
byteToHex(byte[]) - Static method in class org.hsqldb.StringConverter
Method declaration

C

CACHED_TABLE - Static variable in class org.hsqldb.Table
 
CALL - Static variable in class org.hsqldb.Database
 
CASEWHEN - Static variable in class org.hsqldb.Expression
 
CAST - Static variable in class org.hsqldb.Expression
 
CHECKPOINT - Static variable in class org.hsqldb.Database
 
CLOSE - Static variable in class org.hsqldb.Expression
 
COLUMN - Static variable in class org.hsqldb.Expression
 
COLUMN_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
COLUMN_COUNT_DOES_NOT_MATCH - Static variable in class org.hsqldb.Trace
 
COLUMN_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
COLUMN_TYPE_MISMATCH - Static variable in class org.hsqldb.Trace
 
COMMA - Static variable in class org.hsqldb.Expression
 
COMMIT - Static variable in class org.hsqldb.Database
 
CONCAT - Static variable in class org.hsqldb.Expression
 
CONNECT - Static variable in class org.hsqldb.Database
 
CONNECTION_CLOSED - Static variable in class org.hsqldb.Server
Description of the Field
CONNECTION_IS_BROKEN - Static variable in class org.hsqldb.Trace
 
CONNECTION_IS_CLOSED - Static variable in class org.hsqldb.Trace
 
CONSTRAINT_ALREADY_EXISTS - Static variable in class org.hsqldb.Trace
 
CONSTRAINT_NOT_FOUND - Static variable in class org.hsqldb.Trace
 
CONVERT - Static variable in class org.hsqldb.Expression
 
COPY_BLOCK_SIZE - Static variable in class org.hsqldb.Log
 
COUNT - Static variable in class org.hsqldb.Expression
 
CREATE - Static variable in class org.hsqldb.Database
 
Cache - class org.hsqldb.Cache.
Handles cached tables through a .data file and memory cache.
Cache(String, HsqlDatabaseProperties) - Constructor for class org.hsqldb.Cache
Construct a new Cache object with the given database path name and the properties object to get the initial settings from.
CacheFree - class org.hsqldb.CacheFree.
This class is essetially an object used to create a singly linked list of the free space available in a HSQL database file.
CacheFree() - Constructor for class org.hsqldb.CacheFree
 
CachedRow - class org.hsqldb.CachedRow.
Disk and In-memory representation of a database row object with storage independent methods for serialization and de-serialization.
CachedRow(Table, Object[]) - Constructor for class org.hsqldb.CachedRow
Constructor declaration
CachedRow(Table, DatabaseRowInputInterface) - Constructor for class org.hsqldb.CachedRow
constructor when read from cache
Column - class org.hsqldb.Column.
Implementation of SQL table columns as defined in DDL statements with static methods to process their values.
Column(HsqlName, boolean, int, int, int, boolean, boolean, String) - Constructor for class org.hsqldb.Column
Creates a column defined in DDL statement.
Constraint - class org.hsqldb.Constraint.
Implementation of a table constraint with references to the indexes used by the constraint.
Constraint(HsqlName, Table, Index) - Constructor for class org.hsqldb.Constraint
Constructor declaration
Constraint(HsqlName, Constraint) - Constructor for class org.hsqldb.Constraint
Constructor for main constraints (foreign key references in PK table)
Constraint(HsqlName, HsqlName, Table, Table, int[], int[], Index, Index, boolean) - Constructor for class org.hsqldb.Constraint
Constructor for foreign key constraints
Constraint() - Constructor for class org.hsqldb.Constraint
 
ConstraintCore - class org.hsqldb.ConstraintCore.
 
ConstraintCore() - Constructor for class org.hsqldb.ConstraintCore
 
cCache - Variable in class org.hsqldb.Log
 
cCache - Variable in class org.hsqldb.Table
 
cConnection - Variable in class org.hsqldb.jdbcDatabaseMetaData
The connection this object uses to retrieve instance-specific metadata.
cConnection - Variable in class org.hsqldb.jdbcStatement
The connection used to execute this statement.
cLike - Variable in class org.hsqldb.Like
 
cLikeEscape - Variable in class org.hsqldb.Expression
 
cSession - Variable in class org.hsqldb.Database
 
cSession - Variable in class org.hsqldb.Function
 
cSession - Variable in class org.hsqldb.Parser
 
cSession - Variable in class org.hsqldb.jdbcConnection
This connection's corresponding in-process Session.
cacheLength - Variable in class org.hsqldb.Cache
 
cancel() - Method in class org.hsqldb.jdbcStatement
Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
cancelRowUpdates() - Method in class org.hsqldb.jdbcResultSet
Cancels the updates made to the current row in this ResultSet object.
cascade - Variable in class org.hsqldb.Database.TempConstraint
 
changed() - Method in class org.hsqldb.CachedRow
 
character(int) - Static method in class org.hsqldb.Library
Method declaration
check(String, int) - Method in class org.hsqldb.Session
Method declaration
check(boolean, int) - Static method in class org.hsqldb.Trace
Method declaration
check(boolean, int, Object) - Static method in class org.hsqldb.Trace
Method declaration
check(String, int) - Method in class org.hsqldb.User
Method declaration
checkAdmin() - Method in class org.hsqldb.Session
Method declaration
checkAdmin() - Method in class org.hsqldb.User
Method declaration
checkAvailable() - Method in class org.hsqldb.jdbcResultSet
Internal row data availability check.
checkCascadeDelete(Object[], Session, boolean) - Method in class org.hsqldb.Table
Method is called recursively on a tree of tables from the current one until no referring foreign-key table is left.
checkClosed() - Method in class org.hsqldb.jdbcConnection
An internal check for closed connections.
checkClosed() - Method in class org.hsqldb.jdbcStatement
An internal check for closed connections.
checkColumn(int) - Method in class org.hsqldb.jdbcResultSet
Internal check for column index validity.
checkColumnsMatch(int[], Table, int[]) - Method in class org.hsqldb.Table
Match two columns arrays for length and type of coluns
checkDelete(Object[]) - Method in class org.hsqldb.Constraint
Check if a row in the referenced (parent) table can be deleted.
checkDropIndex(String, Hashtable) - Method in class org.hsqldb.Table
Checks for use of a named index in table constraints
checkFileExists() - Method in class org.hsqldb.HsqlProperties
 
checkInsert(Object[]) - Method in class org.hsqldb.Constraint
Checks for foreign key violation when inserting a row in the child table.
checkNull() - Method in class org.hsqldb.BinaryDatabaseRowInput
 
checkNull() - Method in class org.hsqldb.BinaryServerRowInput
 
checkNull() - Method in class org.hsqldb.DatabaseRowInput
 
checkNull() - Method in class org.hsqldb.TextDatabaseRowInput
 
checkNull(Object) - Method in class org.hsqldb.jdbcResultSet
Internal wasNull tracker.
checkPassword(String) - Method in class org.hsqldb.User
Method declaration
checkReadWrite() - Method in class org.hsqldb.Session
Method declaration
checkResolved() - Method in class org.hsqldb.Expression
Method declaration
checkResolved() - Method in class org.hsqldb.Function
Checks each of this object's arguments for resolution, throwing a SQLException if any arguments have not yet been resolved.
checkResolved() - Method in class org.hsqldb.Select
Method declaration
checkTypeConcurrency(int, int) - Static method in class org.hsqldb.jdbcConnection
An internal check for unsupported combinations of ResultSet type and concurrency.
checkUpdate(int[], Result, Result) - Method in class org.hsqldb.Constraint
Checks if updating a set of columns in a table row breaks the referential integrity constraint.
checkUpdate(int[], Result, Result) - Method in class org.hsqldb.Table
Method declaration
checkUpdate(int[], Result, Result) - Method in class org.hsqldb.TextTable
 
checkpoint() - Method in class org.hsqldb.Database.Logger
Checkpoints the database.
checkpoint() - Method in class org.hsqldb.Log
Method declaration
child(Node, boolean) - Method in class org.hsqldb.Index
Method declaration
cleanUp() - Method in class org.hsqldb.Cache
Cleans up this Cache object.
cleanUp() - Method in class org.hsqldb.Database.Logger
Releases any cached data rows above the maximum set for any Cache objects existing within the context of this logger.
cleanUp - Variable in class org.hsqldb.Index
 
cleanUp() - Method in class org.hsqldb.Table
 
clearBatch() - Method in class org.hsqldb.jdbcStatement
Empties this Statement object's current list of SQL commands.
clearParameters() - Method in class org.hsqldb.jdbcPreparedStatement
Clears the current parameter values immediately.
clearWarnings() - Method in class org.hsqldb.jdbcConnection
Clears all warnings reported for this Connection object.
clearWarnings() - Method in class org.hsqldb.jdbcResultSet
Clears all warnings reported on this ResultSet object.
clearWarnings() - Method in class org.hsqldb.jdbcStatement
Clears all the warnings reported on this Statement object.
close(int) - Method in class org.hsqldb.Database
Method declaration
close() - Method in class org.hsqldb.DatabaseFile
 
close() - Method in class org.hsqldb.HsqlDatabaseProperties
 
close(boolean) - Method in class org.hsqldb.Log
Method declaration
close() - Method in class org.hsqldb.ServerConnection
 
close() - Method in class org.hsqldb.jdbcConnection
Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.
close() - Method in class org.hsqldb.jdbcResultSet
Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
close() - Method in class org.hsqldb.jdbcStatement
Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
closeAllServerConnections() - Method in class org.hsqldb.Server
Description of the Method
closeAllTextCaches(boolean) - Method in class org.hsqldb.Log
 
closeFile() - Method in class org.hsqldb.Cache
Closes this object's database file without flushing pending writes.
closeLog(int) - Method in class org.hsqldb.Database.Logger
Shuts down the logging process using the specified mode.
closeOldResult() - Method in class org.hsqldb.jdbcStatement
Closes the current result, if any.
closeScript() - Method in class org.hsqldb.Log
Method declaration
closeStandalone() - Method in class org.hsqldb.jdbcConnection
Closing a Connection to a standalone database will cause the usage count to be decremented and a disconnect SQL command issued to the db.
closeTextCache(String) - Method in class org.hsqldb.Database.Logger
Closes the TextCache object if a Log object exists.
closeTextCache(String) - Method in class org.hsqldb.Log
 
colScale - Variable in class org.hsqldb.Column
 
colScale - Variable in class org.hsqldb.Result
 
colSize - Variable in class org.hsqldb.Column
 
colSize - Variable in class org.hsqldb.Result
 
colType - Variable in class org.hsqldb.Column
 
colType - Variable in class org.hsqldb.Result
 
colTypes - Variable in class org.hsqldb.Table
 
columnName - Variable in class org.hsqldb.Column
 
columnQuoted - Variable in class org.hsqldb.Expression
 
commit() - Method in class org.hsqldb.Session
Method declaration
commit() - Method in class org.hsqldb.jdbcConnection
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
compare(Object, Object, int) - Static method in class org.hsqldb.Column
Compare a with b and return int value as result.
compare(Object) - Method in class org.hsqldb.Like
Method declaration
compareAt(String, int, int, int) - Method in class org.hsqldb.Like
Method declaration
comparePartialRowNonUnique(Object[], Object[]) - Method in class org.hsqldb.Index
This method is used for finding foreign key references.
compareRecord(Object[], Object[], int[], int[]) - Method in class org.hsqldb.Result
Method declaration
compareRecord(Object[], Object[], int) - Method in class org.hsqldb.Result
Method declaration
compareRow(Object[], Object[]) - Method in class org.hsqldb.Index
Method declaration
compareRowNonUnique(Object[], Object[]) - Method in class org.hsqldb.Index
compares two full table rows based on the columns of the index
compareTo(byte[], byte[]) - Static method in class org.hsqldb.ByteArray
Compares a byte[] with another specified byte[] for order.
compareValue(Object, Object) - Method in class org.hsqldb.Index
Method declaration
concat(Object, Object) - Static method in class org.hsqldb.Column
Concat two objects by turning them into strings first.
concat(String, String) - Static method in class org.hsqldb.Library
Method declaration
connProperties - Variable in class org.hsqldb.jdbcConnection
Properties for the connection
connProperties - Variable in class org.hsqldb.jdbcResultSet
Properties for the connectin
connect(String, String) - Method in class org.hsqldb.Database
Constructs a new Session that operates within (is connected to) the context of this Database object.
connect(String, Properties) - Method in class org.hsqldb.jdbcDriver
Attempts to make a database connection to the given URL.
constName - Variable in class org.hsqldb.Constraint
 
convertObject(Object) - Static method in class org.hsqldb.Column
Return a java string representation of a java object.
convertObject(Object, int) - Static method in class org.hsqldb.Column
Convert an object into a Java object that represents its SQL type.
convertString(String, int) - Static method in class org.hsqldb.Column
Return a java object based on a SQL string.
core - Variable in class org.hsqldb.Constraint
 
cot(double) - Static method in class org.hsqldb.Library
Method declaration
count - Variable in class org.hsqldb.DatabaseFile
 
create() - Method in class org.hsqldb.Log
 
createAdjustedIndex(Index, int, int) - Method in class org.hsqldb.Table
Create new index taking into account removal or addition a column of the table.
createForeignKey(int[], int[], HsqlName, Table, boolean) - Method in class org.hsqldb.TableWorks
Creates a foreign key according to current sql.strict_fk or sql.strong_fk settings.
createHsqlServer(String, boolean, boolean) - Static method in class org.hsqldb.HsqlServerFactory
 
createIndex(int[], HsqlName, boolean) - Method in class org.hsqldb.TableWorks
Because of the way indexes and column data are held in memory and on disk, it is necessary to recreate the table when an index is added to a non-empty table.
createIndexPrivate(int[], HsqlName, boolean) - Method in class org.hsqldb.Table
Method declaration
createIndexPrivate(int[], HsqlName, boolean) - Method in class org.hsqldb.TextTable
Method declaration
createPrimaryKey() - Method in class org.hsqldb.Table
Shortcut for creating default PK's
createPrimaryKey(HsqlName, int[]) - Method in class org.hsqldb.Table
Adds the SYSTEM_ID column if no primary key is specified in DDL.
createPrimaryKey(String, int[]) - Method in class org.hsqldb.TextTable
 
createSQLString(Object, int) - Static method in class org.hsqldb.Column
Return an SQL representation of an object.
createSQLString(double) - Static method in class org.hsqldb.Column
 
createSQLString(String) - Static method in class org.hsqldb.Column
Turns a java string into a quoted SQL string
createStatement() - Method in class org.hsqldb.jdbcConnection
Creates a Statement object for sending SQL statements to the database.
createStatement(int, int) - Method in class org.hsqldb.jdbcConnection
Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
createStatement(int, int, int) - Method in class org.hsqldb.jdbcConnection
Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.
createTable(HsqlName) - Method in class org.hsqldb.DatabaseInformation
Method declaration
createUniqueConstraint(int[], HsqlName) - Method in class org.hsqldb.TableWorks
A unique constraint relies on a unique indexe on the table.
createUser(String, String, boolean) - Method in class org.hsqldb.UserManager
This method is used to create a new user.
curdate() - Static method in class org.hsqldb.Library
Method declaration
curtime() - Static method in class org.hsqldb.Library
Method declaration

D

DATA - Static variable in class org.hsqldb.Result
 
DATABASE_ALREADY_IN_USE - Static variable in class org.hsqldb.Trace
 
DATABASE_IS_MEMORY_ONLY - Static variable in class org.hsqldb.Trace
 
DATABASE_IS_READONLY - Static variable in class org.hsqldb.Trace
 
DATABASE_IS_SHUTDOWN - Static variable in class org.hsqldb.Trace
 
DATA_IS_READONLY - Static variable in class org.hsqldb.Trace
 
DECIMAL - Static variable in class org.hsqldb.Tokenizer
 
DEFAULT_HSQLDB_PORT - Static variable in class org.hsqldb.jdbcConnection
Used when no port is explicitly specified in the url for a network Connection of type HSQLDB 55 .
DEFAULT_PK - Static variable in class org.hsqldb.Table
 
DELETE - Static variable in class org.hsqldb.Database
 
DELETE - Static variable in class org.hsqldb.UserManager
 
DELETE_AFTER - Static variable in class org.hsqldb.TriggerDef
 
DELETE_AFTER_ROW - Static variable in class org.hsqldb.TriggerDef
 
DELETE_BEFORE - Static variable in class org.hsqldb.TriggerDef
 
DELETE_BEFORE_ROW - Static variable in class org.hsqldb.TriggerDef
 
DISCONNECT - Static variable in class org.hsqldb.Database
 
DISK_INDEX - Static variable in class org.hsqldb.Index
 
DIST_COUNT - Static variable in class org.hsqldb.Expression
 
DIVIDE - Static variable in class org.hsqldb.Expression
 
DIVISION_BY_ZERO - Static variable in class org.hsqldb.Trace
 
DOASSERT - Static variable in class org.hsqldb.Trace
 
DROP - Static variable in class org.hsqldb.Database
 
DROP_FK_INDEX - Static variable in class org.hsqldb.Trace
 
DROP_PRIMARY_KEY - Static variable in class org.hsqldb.Trace
 
DROP_SYSTEM_CONSTRAINT - Static variable in class org.hsqldb.Trace
 
Database - class org.hsqldb.Database.
Database is the root class for HSQL Database Engine database.
Database(String) - Constructor for class org.hsqldb.Database
Constructs a new Database object that mounts or creates the database files specified by the supplied name.
Database.Logger - class org.hsqldb.Database.Logger.
Transitional interface for log and cache management.
Database.Logger() - Constructor for class org.hsqldb.Database.Logger
 
Database.TempConstraint - class org.hsqldb.Database.TempConstraint.
temporary attributes for constraints used in processCreateTable()
Database.TempConstraint(HsqlName, int[], Table, int[], int, boolean) - Constructor for class org.hsqldb.Database.TempConstraint
 
DatabaseFile - class org.hsqldb.DatabaseFile.
This class provides methods for reading and writing data from a database file such as that used for storing a cached table.
DatabaseFile(String, String, int) - Constructor for class org.hsqldb.DatabaseFile
 
DatabaseInformation - class org.hsqldb.DatabaseInformation.
Provides information about the database.
DatabaseInformation(Database, Vector, UserManager) - Constructor for class org.hsqldb.DatabaseInformation
Constructor declaration
DatabaseRowInput - class org.hsqldb.DatabaseRowInput.
Base class for reading the data for a database row in different formats.
DatabaseRowInput(InputStream) - Constructor for class org.hsqldb.DatabaseRowInput
 
DatabaseRowInput(byte[], int) - Constructor for class org.hsqldb.DatabaseRowInput
 
DatabaseRowInputInterface - interface org.hsqldb.DatabaseRowInputInterface.
Public interface for reading the data for a database row.
DatabaseRowOutput - class org.hsqldb.DatabaseRowOutput.
Base class for writing the data for a database row in different formats.
DatabaseRowOutput(OutputStream) - Constructor for class org.hsqldb.DatabaseRowOutput
 
DatabaseRowOutputInterface - interface org.hsqldb.DatabaseRowOutputInterface.
Public interface for writing the data for a database row.
DatabaseScript - class org.hsqldb.DatabaseScript.
Script generation.
DatabaseScript() - Constructor for class org.hsqldb.DatabaseScript
 
DiskNode - class org.hsqldb.DiskNode.
Cached table Node implementation.
Only integral references to left, right and parent nodes in the AVL tree are held and used as offsets to disk data.
tTable is a reference to the table for this node and is used to get a linked node in the tree.
iId is a reference to the Index object that contains this node.
These fields can be eliminated in the future, by changing the method signatures to take a Table parameter from Index.java (fredt@users)
DiskNode(CachedRow, DatabaseRowInputInterface, int) - Constructor for class org.hsqldb.DiskNode
 
DiskNode(CachedRow, int) - Constructor for class org.hsqldb.DiskNode
 
dDatabase - Variable in class org.hsqldb.DatabaseInformation
 
dDatabase - Variable in class org.hsqldb.Log
 
dDatabase - Variable in class org.hsqldb.Parser
 
dDatabase - Variable in class org.hsqldb.Servlet
 
dDatabase - Variable in class org.hsqldb.Session
 
dDatabase - Variable in class org.hsqldb.Table
 
dDatabase - Variable in class org.hsqldb.jdbcConnection
This connection's in-process Database.
dInfo - Variable in class org.hsqldb.Database
 
dInput - Variable in class org.hsqldb.jdbcConnection
The stream used to receive results from this connection's Database.
dOutput - Variable in class org.hsqldb.jdbcConnection
The stream used to send requests to this connection's Database.
data - Variable in class org.hsqldb.Record
 
dataDefinitionCausesTransactionCommit() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether a data definition statement within a transaction forces the transaction to commit.
dataDefinitionIgnoredInTransactions() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether this database ignores a data definition statement within a transaction.
dataSource - Variable in class org.hsqldb.TextTable
 
database - Variable in class org.hsqldb.HypersonicDBServlet
 
database(Connection) - Static method in class org.hsqldb.Library
Method declaration
database - Variable in class org.hsqldb.jdbcDataSource
Database location
databaseProperties - Variable in class org.hsqldb.Database
 
dayname(Date) - Static method in class org.hsqldb.Library
Method declaration
dayofmonth(Date) - Static method in class org.hsqldb.Library
Method declaration
dayofweek(Date) - Static method in class org.hsqldb.Library
Method declaration
dayofyear(Date) - Static method in class org.hsqldb.Library
Method declaration
defaultQueueSize - Static variable in class org.hsqldb.TriggerDef
 
defaultString - Variable in class org.hsqldb.Column
 
delete() - Method in class org.hsqldb.CachedRow
Method declaration
delete() - Method in class org.hsqldb.DiskNode
 
delete(Object[], boolean) - Method in class org.hsqldb.Index
Method declaration
delete() - Method in class org.hsqldb.MemoryNode
Method declaration
delete() - Method in class org.hsqldb.Node
Method declaration
delete() - Method in class org.hsqldb.PointerNode
 
delete() - Method in class org.hsqldb.Row
Method declaration
delete(Object[], Session) - Method in class org.hsqldb.Table
Method declaration
delete(Object[], Session) - Method in class org.hsqldb.TextTable
 
deleteNoCheck(Object[], Session, boolean) - Method in class org.hsqldb.Table
Method declaration
deleteNoRefCheck(Object[], Session) - Method in class org.hsqldb.Table
Method declaration
deleteRow() - Method in class org.hsqldb.jdbcResultSet
Deletes the current row from this ResultSet object and from the underlying database.
deletesAreDetected(int) - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.
deserialize(byte[]) - Static method in class org.hsqldb.ByteArray
Deserializes the specified byte array to an Object instance.
difference(String, String) - Static method in class org.hsqldb.Library
Method declaration
disconnect() - Method in class org.hsqldb.Session
Method declaration
divide(Object, Object, int) - Static method in class org.hsqldb.Column
Divide numeric object a by object b.
doAssert(boolean) - Static method in class org.hsqldb.Trace
Method declaration
doAssert(boolean, String) - Static method in class org.hsqldb.Trace
Method declaration
doGet(HttpServletRequest, HttpServletResponse) - Method in class org.hsqldb.HypersonicDBServlet
Delivers the database status.
doGet(HttpServletRequest, HttpServletResponse) - Method in class org.hsqldb.Servlet
Method declaration
doOrderGroup(Expression, Vector) - Method in class org.hsqldb.Parser
Description of the Method
doPost(HttpServletRequest, HttpServletResponse) - Method in class org.hsqldb.HypersonicDBServlet
Handles the database access.
doPost(HttpServletRequest, HttpServletResponse) - Method in class org.hsqldb.Servlet
Method declaration
doesMaxRowSizeIncludeBlobs() - Method in class org.hsqldb.jdbcDatabaseMetaData
Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
dropConstraint(String) - Method in class org.hsqldb.TableWorks
Method declaration
dropIndex(String) - Method in class org.hsqldb.TableWorks
Because of the way indexes and column data are held in memory and on disk, it is necessary to recreate the table when an index is added to a non-empty table.
dropTable(String, boolean, boolean, Session) - Method in class org.hsqldb.Database
Drops the specified user-defined view or table from this Database object.
dropTempTables(Session) - Method in class org.hsqldb.Database
 
dropTrigger(String, Session) - Method in class org.hsqldb.Database
Method declaration
dropUser(String) - Method in class org.hsqldb.UserManager
This method is used to drop a user.
duplicate() - Method in class org.hsqldb.Table
 
duplicate() - Method in class org.hsqldb.TextTable
 

E

ENCODING - Static variable in class org.hsqldb.jdbcConnection
The encoding used to communicate with a WebServer mode Database, when this connection is of type HTTP 55 .
END - Static variable in class org.hsqldb.Expression
 
EQUAL - Static variable in class org.hsqldb.Expression
 
ERROR - Static variable in class org.hsqldb.Result
 
ERROR_IN_FUNCTION - Static variable in class org.hsqldb.Trace
 
EXCEPT - Static variable in class org.hsqldb.Select
 
EXISTS - Static variable in class org.hsqldb.Expression
 
EXTERNAL_STOP - Static variable in class org.hsqldb.Trace
 
Expression - class org.hsqldb.Expression.
Expression class declaration
Expression(Function) - Constructor for class org.hsqldb.Expression
Constructor declaration
Expression(Expression) - Constructor for class org.hsqldb.Expression
Constructor declaration
Expression(Select) - Constructor for class org.hsqldb.Expression
Constructor declaration
Expression(Vector) - Constructor for class org.hsqldb.Expression
Constructor declaration
Expression(int, Expression, Expression) - Constructor for class org.hsqldb.Expression
Constructor declaration
Expression(String, String) - Constructor for class org.hsqldb.Expression
Constructor declaration
Expression(String, String, boolean) - Constructor for class org.hsqldb.Expression
 
Expression(int, Object) - Constructor for class org.hsqldb.Expression
Constructor declaration
eAnd - Variable in class org.hsqldb.TableFilter
 
eArg - Variable in class org.hsqldb.Expression
 
eArg - Variable in class org.hsqldb.Function
 
eArg2 - Variable in class org.hsqldb.Expression
 
eColumn - Variable in class org.hsqldb.Select
 
eCondition - Variable in class org.hsqldb.Select
 
eEnd - Variable in class org.hsqldb.TableFilter
 
eStart - Variable in class org.hsqldb.TableFilter
 
emptyIsNull - Variable in class org.hsqldb.TextDatabaseRowInput
 
emptyRoots - Variable in class org.hsqldb.TextTable
 
endNestedTransaction(boolean) - Method in class org.hsqldb.Session
Method declaration
enforceSize(Object, int, int, boolean) - Static method in class org.hsqldb.Parser
Check an object for type CHAR and VARCHAR and truncate/pad based on the size
equals(Node) - Method in class org.hsqldb.DiskNode
 
equals(HsqlName) - Method in class org.hsqldb.HsqlName
 
equals(Node) - Method in class org.hsqldb.MemoryNode
 
equals(Node) - Method in class org.hsqldb.Node
 
equals(Node) - Method in class org.hsqldb.PointerNode
 
equals(String, Session) - Method in class org.hsqldb.Table
 
equals(String) - Method in class org.hsqldb.Table
 
equals(String, Session) - Method in class org.hsqldb.TextTable
 
equals(String) - Method in class org.hsqldb.TextTable
 
error(int) - Static method in class org.hsqldb.Trace
Method declaration
error(int, String) - Static method in class org.hsqldb.Trace
Method declaration
error(int, int) - Static method in class org.hsqldb.Trace
Method declaration
errorCode - Variable in class org.hsqldb.Result
 
execute(String, String, String) - Method in class org.hsqldb.Database
A specialized SQL statement executor, tailored for use by WebServerConnection.
execute(String, Session) - Method in class org.hsqldb.Database
The main SQL statement executor.
execute(String) - Method in class org.hsqldb.jdbcConnection
The internal statement execution request router.
execute() - Method in class org.hsqldb.jdbcPreparedStatement
Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
execute(String) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which may return multiple results.
execute(String, int) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
execute(String, int[]) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
execute(String, String[]) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
executeBatch() - Method in class org.hsqldb.jdbcStatement
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeHSQL(String) - Method in class org.hsqldb.jdbcConnection
A connection-type specific SQL statement executor.
executeHTTP(String) - Method in class org.hsqldb.jdbcConnection
A connection-type specific SQL statement executor.
executeQuery() - Method in class org.hsqldb.jdbcPreparedStatement
Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
executeQuery(String) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which returns a single ResultSet object.
executeSelect(String, String) - Method in class org.hsqldb.jdbcDatabaseMetaData
Executes a select statement using the specified table and where clause.
executeStandalone(String) - Method in class org.hsqldb.jdbcConnection
A connection-type specific SQL statement executor.
executeUpdate() - Method in class org.hsqldb.jdbcPreparedStatement
Executes the SQL statement in this PreparedStatement object, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement.
executeUpdate(String) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
executeUpdate(String, int) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
executeUpdate(String, int[]) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
executeUpdate(String, String[]) - Method in class org.hsqldb.jdbcStatement
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
expCol - Variable in class org.hsqldb.Database.TempConstraint
 
expTable - Variable in class org.hsqldb.Database.TempConstraint
 

F

FILE_IO_ERROR - Static variable in class org.hsqldb.Trace
 
FLOAT - Static variable in class org.hsqldb.Tokenizer
 
FOREIGN_KEY - Static variable in class org.hsqldb.Constraint
 
FOREIGN_KEY_NOT_ALLOWED - Static variable in class org.hsqldb.Trace
 
FOUND_QUOTE - Static variable in class org.hsqldb.QuotedTextDatabaseRowInput
 
FREE_POS_POS - Static variable in class org.hsqldb.Cache
 
FUNCTION - Static variable in class org.hsqldb.Expression
 
FUNCTION_NOT_SUPPORTED - Static variable in class org.hsqldb.Trace
 
Function - class org.hsqldb.Function.
Provides services to evaluate Java methods in the context of SQL function and stored procedure calls.
Function(String, Session) - Constructor for class org.hsqldb.Function
Constructs a new Function object with the given function call name and using the specified Session context.
fFunction - Variable in class org.hsqldb.Expression
 
fNext - Variable in class org.hsqldb.CacheFree
 
fRoot - Variable in class org.hsqldb.Cache
 
fetchResult(String) - Method in class org.hsqldb.jdbcStatement
The internal result producer.
field - Variable in class org.hsqldb.TextDatabaseRowInput
 
fieldSep - Variable in class org.hsqldb.TextDatabaseRowInput
 
fieldSep - Variable in class org.hsqldb.TextDatabaseRowOutput
 
fieldSepEnd - Variable in class org.hsqldb.TextDatabaseRowInput
 
fieldSepEnd - Variable in class org.hsqldb.TextDatabaseRowOutput
 
fieldSepLen - Variable in class org.hsqldb.TextDatabaseRowInput
 
fileName - Variable in class org.hsqldb.HsqlProperties
 
filename - Variable in class org.hsqldb.HypersonicDBServlet
 
finalize() - Method in class org.hsqldb.Database
Called by the garbage collector on this Databases object when garbage collection determines that there are no more references to it.
finalize() - Method in class org.hsqldb.Session
closes the session.
finalize() - Method in class org.hsqldb.jdbcConnection
The default implementation simply attempts to silently close() 55 this Connection
find(Object[]) - Method in class org.hsqldb.Index
Method declaration
findColumn(String) - Method in class org.hsqldb.jdbcResultSet
Maps the given ResultSet column name to its ResultSet column index.
findFirst(Object, int) - Method in class org.hsqldb.Index
Method declaration
findFir