All Packages  Class Hierarchy

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

Index of all Fields and Methods

A

acceptsURL(String). Method in class interbase.interclient.Driver
Returns true if the driver thinks that it can open a connection to the given URL.
activateIndices(String, boolean). Method in class interbase.interclient.Server
Toggle use of database indices.
activateShadow(boolean). Method in class interbase.interclient.ConnectionProperties
Activate the database shadow upon connection.
adapt(int, Object). Method in interface interbase.interclient.Adaptor
Adapt the JDBC object which implements this interface to the modification described by one of the above modifiers.
adapt(int, Object). Method in class interbase.interclient.ResultSet
Adapt the JDBC object which implements this interface to the modification described by one of the above modifiers.
addUser(String, String). Method in class interbase.interclient.Server
Register a user in isc4.gdb
allowAsynchronousDiskWrites(boolean). Method in class interbase.interclient.ConnectionProperties
Enable/disable synchronous writes to disk on commit.
allProceduresAreCallable(). Method in class interbase.interclient.DatabaseMetaData
Can all the procedures returned by getProcedures be called by the current user?
allTablesAreSelectable(). Method in class interbase.interclient.DatabaseMetaData
Can all the tables returned by getTable be SELECTed by the current user?
asString(SQLException). Static method in class interbase.interclient.Driver
Get the String representation for a SQLException chain.

B

backup(boolean, boolean, boolean, boolean, boolean, String, String). Method in class interbase.interclient.Server
Backup a database.
backup(boolean, String, String). Method in class interbase.interclient.Server
Backup a database.
BadInstallationException(String). Constructor for class interbase.interclient.BadInstallationException
bestRowNotPseudo. Static variable in class interbase.interclient.DatabaseMetaData
BEST ROW PSEUDO_COLUMN - is NOT a pseudo column.
bestRowPseudo. Static variable in class interbase.interclient.DatabaseMetaData
BEST ROW PSEUDO_COLUMN - is a pseudo column.
bestRowSession. Static variable in class interbase.interclient.DatabaseMetaData
BEST ROW SCOPE - valid for remainder of current session.
bestRowTemporary. Static variable in class interbase.interclient.DatabaseMetaData
BEST ROW SCOPE - very temporary, while using row.
bestRowTransaction. Static variable in class interbase.interclient.DatabaseMetaData
BEST ROW SCOPE - valid for remainder of current transaction.
bestRowUnknown. Static variable in class interbase.interclient.DatabaseMetaData
BEST ROW PSEUDO_COLUMN - may or may not be pseudo column.

C

cancel(). Method in class interbase.interclient.Statement
Cancel can be used by one thread to cancel a statement that is being executed by another thread.
changePassword(String, String). Method in class interbase.interclient.Server
Change the password for a registered user in isc4.gdb.
clearParameters(). Method in class interbase.interclient.PreparedStatement
In general, parameter values remain in force for repeated use of a Statement.
clearWarnings(). Method in class interbase.interclient.Connection
After this call, getWarnings returns null until a new warning is reported for this Connection.
clearWarnings(). Method in class interbase.interclient.ResultSet
After this call getWarnings returns null until a new warning is reported for this ResultSet.
clearWarnings(). Method in class interbase.interclient.Statement
After this call, getWarnings returns null until a new warning is reported for this Statement.
clientServerEdition(). Method in class interbase.interclient.Driver
Are remote connections allowed?
close(). Method in class interbase.interclient.Connection
In some cases, it is desirable to immediately release a Connection's database and JDBC resources instead of waiting for them to be automatically released; the close method provides this immediate release.
close(). Method in class interbase.interclient.ResultSet
In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
close(). Method in class interbase.interclient.Statement
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
columnNoNulls. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN NULLABLE - might not allow NULL values.
columnNoNulls. Static variable in class interbase.interclient.ResultSetMetaData
Does not allow NULL values.
columnNullable. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN NULLABLE - definitely allows NULL values.
columnNullable. Static variable in class interbase.interclient.ResultSetMetaData
Allows NULL values.
columnNullableUnknown. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN NULLABLE - nullability unknown.
columnNullableUnknown. Static variable in class interbase.interclient.ResultSetMetaData
Nullability unknown.
commit(). Method in class interbase.interclient.Connection
Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
commitLimboTransaction(String, int). Method in class interbase.interclient.Server
Attempt to commit a limbo transaction.
commitRefresh(). Method in class interbase.interclient.Connection
Like commit but a new transaction is started immediately with a fresh snapshot (only meaningful for SNAPSHOT isolation mode).
commitRetain(). Method in class interbase.interclient.Connection
Like commit but keep your snapshot and retain your transaction context (only meaningful for SNAPSHOT isolation mode).
connect(String, Properties). Method in class interbase.interclient.Driver
Try to make a database connection to the given URL.
ConnectionProperties(). Constructor for class interbase.interclient.ConnectionProperties
Construct a default InterBase connection properties object.
createDatabase(String). Method in class interbase.interclient.Server
Create a database using the default page size and cache buffers.
createDatabase(String, int, int, String[], int[]). Method in class interbase.interclient.Server
Create a database using the specified page size and stamp the number of cache buffers to use for this database onto the database header page.
createShadow(String, String). Method in class interbase.interclient.Server
Create a database shadow file for the database.
createShadow(String, String, int). Method in class interbase.interclient.Server
Create a database shadow file for the database.
createShadow(String, String, int, String[], int[]). Method in class interbase.interclient.Server
Create a database shadow for a multi-file database.
createStatement(). Method in class interbase.interclient.Connection
SQL statements without parameters are normally executed using Statement objects.

D

dataDefinitionCausesTransactionCommit(). Method in class interbase.interclient.DatabaseMetaData
Does a data definition statement within a transaction force the transaction to commit?
dataDefinitionIgnoredInTransactions(). Method in class interbase.interclient.DatabaseMetaData
Is a data definition statement within a transaction ignored?
deregister(String). Method in class interbase.interclient.Server
Remove a registered database from isc4.gdb
doesMaxRowSizeIncludeBlobs(). Method in class interbase.interclient.DatabaseMetaData
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
Driver(). Constructor for class interbase.interclient.Driver
Create an explicit driver instance.
dropDatabase(String). Method in class interbase.interclient.Server
Remove the database file, and degregister it.
dropShadow(String). Method in class interbase.interclient.Server
Delete a database shadow file.
dropUser(String). Method in class interbase.interclient.Server
Remove a registered user from isc4.gdb

E

enableAllTraces(boolean). Method in class interbase.interclient.Monitor
Trace method invocations by printing messages to this monitor's trace stream.
enableAutomaticSweeping(String, boolean). Method in class interbase.interclient.Server
Enable/disable automatic housekeeping of old record versions.
enableConnectionTrace(boolean). Method in class interbase.interclient.Monitor
Trace connection and database meta data method invocations by printing messages to this monitor's trace stream.
enableDriverTrace(boolean). Method in class interbase.interclient.Monitor
Trace driver method invocations by printing messages to this monitor's trace stream.
enableResultSetTrace(boolean). Method in class interbase.interclient.Monitor
Trace result set method invocations by printing messages to this monitor's trace stream.
enableStatementTrace(boolean). Method in class interbase.interclient.Monitor
Trace statement method invocations by printing messages to this monitor's trace stream.
enableStructureVerification(boolean). Method in class interbase.interclient.ConnectionProperties
On connection, verify the database's internal structures.
execute(). Method in class interbase.interclient.PreparedStatement
Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.
execute(String). Method in class interbase.interclient.Statement
Execute a SQL statement that may return multiple results.
executeQuery(). Method in class interbase.interclient.PreparedStatement
A prepared SQL query is executed and its ResultSet is returned.
executeQuery(String). Method in class interbase.interclient.Statement
Execute a SQL statement that returns a single ResultSet.
executeUpdate(). Method in class interbase.interclient.PreparedStatement
Execute a SQL INSERT, UPDATE, DELETE or DDL statement.
executeUpdate(String). Method in class interbase.interclient.Statement
Execute a SQL INSERT, UPDATE, DELETE or DDL statement.
expiredDriver(). Method in class interbase.interclient.Driver
Has the InterClient driver expired?

F

finalize(). Method in class interbase.interclient.Connection
A connection will be closed when its finalizer is called by the garbage collector.
finalize(). Method in class interbase.interclient.ResultSet
A result set will be closed when its finalizer is called by the garbage collector.
finalize(). Method in class interbase.interclient.Statement
A statement will be closed when its finalizer is called by the garbage collector.
findColumn(String). Method in class interbase.interclient.ResultSet
Map a Resultset column name to a ResultSet column index.

G

getAsciiStream(int). Method in class interbase.interclient.ResultSet
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAsciiStream(String). Method in class interbase.interclient.ResultSet
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAutoCommit(). Method in class interbase.interclient.Connection
Get the current auto-commit state.
getBackoutCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of removals of record versions from table for this connection.
getBestRowIdentifier(String, String, String, int, boolean). Method in class interbase.interclient.DatabaseMetaData
Get a description of a table's optimal set of columns that uniquely identifies a row.
getBigDecimal(int, int). Method in class interbase.interclient.CallableStatement
Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
getBigDecimal(int, int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.lang.BigDecimal object.
getBigDecimal(String, int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.lang.BigDecimal object.
getBinaryStream(int). Method in class interbase.interclient.ResultSet
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBinaryStream(String). Method in class interbase.interclient.ResultSet
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBoolean(int). Method in class interbase.interclient.CallableStatement
Get the value of a BIT parameter as a Java boolean.
getBoolean(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java boolean.
getBoolean(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java boolean.
getBugCode(). Method in class interbase.interclient.BugCheckException
Get the internal bug code for this bug check.
getBuildNumber(). Method in class interbase.interclient.Driver
Get the build number for this driver.
getByte(int). Method in class interbase.interclient.CallableStatement
Get the value of a TINYINT parameter as a Java byte.
getByte(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java byte.
getByte(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java byte.
getBytes(int). Method in class interbase.interclient.CallableStatement
Get the value of a SQL BINARY or VARBINARY parameter as a Java byte[].
getBytes(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java byte array.
getBytes(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java byte array.
getCacheBuffers(). Method in class interbase.interclient.DatabaseMetaData
Get the actual number of cache page buffers being used for this connection.
getCacheBuffers(String). Method in class interbase.interclient.Server
Get the suggested number of cache page buffers to use for a database.
getCatalog(). Method in class interbase.interclient.Connection
Return the Connection's current catalog name.
getCatalogName(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's table's catalog name.
getCatalogs(). Method in class interbase.interclient.DatabaseMetaData
Get the catalog names available in this database.
getCatalogSeparator(). Method in class interbase.interclient.DatabaseMetaData
What's the separator between catalog and table name?
getCatalogTerm(). Method in class interbase.interclient.DatabaseMetaData
What's the database vendor's preferred term for "catalog"?
getColumnCount(). Method in class interbase.interclient.ResultSetMetaData
Get the number of columns in the ResultSet.
getColumnDisplaySize(int). Method in class interbase.interclient.ResultSetMetaData
What's the column's normal max width in chars?
getColumnIndex(). Method in class interbase.interclient.ColumnIndexOutOfBoundsException
Get the invalid column index which caused this exception to be thrown.
getColumnLabel(int). Method in class interbase.interclient.ResultSetMetaData
Get the suggested column title for use in printouts and displays.
getColumnName(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's name.
getColumnPrivileges(String, String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of the access rights for a table's columns.
getColumns(String, String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of table columns available in a catalog.
getColumnType(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's SQL type.
getColumnTypeName(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's data source specific type name.
getCompanyName(). Method in class interbase.interclient.Driver
Who developed this driver?
getComponent(). Method in class interbase.interclient.BugCheckException
Get the component which bug checked.
getComponent(). Method in interface interbase.interclient.ComponentException
Get the component in which the exception occurred.
getComponent(). Method in class interbase.interclient.ExpiredDriverWarning
Get the expired component.
getComponent(). Method in class interbase.interclient.OutOfMemoryException
Get the component which exhausted memory.
getComponent(). Method in class interbase.interclient.UnlicensedComponentException
Get the unlicensed component.
getCrossReference(String, String, String, String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key).
getCursorName(). Method in class interbase.interclient.ResultSet
Get the name of the SQL cursor used by this ResultSet.
getDatabaseProductName(). Method in class interbase.interclient.DatabaseMetaData
What's the name of this database product?
getDatabaseProductVersion(). Method in class interbase.interclient.DatabaseMetaData
What's the version of this database product?
getDate(int). Method in class interbase.interclient.CallableStatement
Get the value of a SQL DATE parameter as a java.sql.Date object.
getDate(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDate(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDefaultCacheBuffers(). Method in class interbase.interclient.Server
Get the default suggested number of cache buffers the server will use for database attachments.
getDefaultPageSize(int). Method in class interbase.interclient.Server
Get the default page size that will be used by the createDatabase() method.
getDefaultTransactionIsolation(). Method in class interbase.interclient.DatabaseMetaData
Get the database's default transaction isolation level.
getDeleteCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of database record deletes from table for this connection.
getDiskReads(). Method in class interbase.interclient.ConnectionStatistics
Number of database page reads from disk since connection was attached.
getDiskReads(). Method in class interbase.interclient.ServerStatistics
Number of disk page reads since server started..
getDiskReads(). Method in interface interbase.interclient.Statistics
Number of database page reads from disk.
getDiskWrites(). Method in class interbase.interclient.ConnectionStatistics
Number of database page writes to disk since connection was attached.
getDiskWrites(). Method in class interbase.interclient.ServerStatistics
Number of disk page writes since server started.
getDiskWrites(). Method in interface interbase.interclient.Statistics
Number of database page writes to disk.
getDouble(int). Method in class interbase.interclient.CallableStatement
Get the value of a DOUBLE parameter as a Java double.
getDouble(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java double.
getDouble(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java double.
getDriverMajorVersion(). Method in class interbase.interclient.DatabaseMetaData
What's this JDBC driver's major version number?
getDriverMinorVersion(). Method in class interbase.interclient.DatabaseMetaData
What's this JDBC driver's minor version number?
getDriverName(). Method in class interbase.interclient.DatabaseMetaData
What's the name of this JDBC driver?
getDriverVersion(). Method in class interbase.interclient.DatabaseMetaData
What's the version of this JDBC driver?
getEscapeClause(). Method in class interbase.interclient.EscapeSyntaxException
Get the bad escape clause which caused this exception to be thrown.
getExpirationDate(). Method in class interbase.interclient.Driver
Get the expiration date for this driver.
getExpirationDate(). Method in class interbase.interclient.ExpiredDriverException
Get the expiration date which caused this exception to be thrown.
getExpirationDate(). Method in class interbase.interclient.ExpiredDriverWarning
Get the expiration date which caused this warning to be set.
getExportedKeys(String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
getExpungeCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of removals of a record and all of its ancestors from table, for records whose deletions have been committed for this connection.
getExtraNameCharacters(). Method in class interbase.interclient.DatabaseMetaData
Get all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
getFloat(int). Method in class interbase.interclient.CallableStatement
Get the value of a FLOAT parameter as a Java float.
getFloat(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java float.
getFloat(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java float.
getHostName(). Method in class interbase.interclient.UnknownHostException
Get the name of the unknown host at the time this exception occurred.
getIdentifierQuoteString(). Method in class interbase.interclient.DatabaseMetaData
Get the string used to quote SQL identifiers.
getImportedKeys(String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
getIndexedReadCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of table reads done via an index for this connection.
getIndexInfo(String, String, String, boolean, boolean). Method in class interbase.interclient.DatabaseMetaData
Get a description of a table's indices and statistics.
getInsertCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of record inserts into table for this connection.
getInt(int). Method in class interbase.interclient.CallableStatement
Get the value of an INTEGER parameter as a Java int.
getInt(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java int.
getInt(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java int.
getInterClientRemoteProtocolVersion(). Method in class interbase.interclient.RemoteProtocolException
Get the version of the local remote protocol being used for InterClient.
getInterServerRemoteProtocolVersion(). Method in class interbase.interclient.RemoteProtocolException
Get the version of the remote protocol of interserver being used when this exception occurred.
getJDBCNetProtocol(). Method in class interbase.interclient.Driver
Get the database URL prefix to use for InterBase connections.
getJDBCNetProtocolVersion(). Method in class interbase.interclient.Driver
Get the version of the messaging protocol between InterClient and InterServer.
getLengths(String). Method in class interbase.interclient.Server
Get the lengths of all secondary files for a multi-file database.
getLimboTransactionIds(String). Method in class interbase.interclient.Server
Get the limbo transactions for the database.
getLockActivity(String). Method in class interbase.interclient.Server
Get a continuous stream of InterBase lock activity for the database.
getLockResolution(). Method in class interbase.interclient.Connection
Get this Connection's current lock resolution mode.
getLoginTimeout(). Method in class interbase.interclient.LoginTimeoutException
Get the login timeout value which was set when this exception occured.
getLong(int). Method in class interbase.interclient.CallableStatement
Get the value of a BIGINT parameter as a Java long.
getLong(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java long.
getLong(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java long.
getMajorVersion(). Method in class interbase.interclient.Driver
Get the driver's major version number.
getMaxBinaryLiteralLength(). Method in class interbase.interclient.DatabaseMetaData
How many hex characters can you have in an inline binary literal?
getMaxCatalogNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of a catalog name?
getMaxCharLiteralLength(). Method in class interbase.interclient.DatabaseMetaData
What's the max length for a character literal?
getMaxColumnNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the limit on column name length?
getMaxColumnsInGroupBy(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum number of columns in a "GROUP BY" clause?
getMaxColumnsInIndex(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum number of columns allowed in an index?
getMaxColumnsInOrderBy(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum number of columns in an "ORDER BY" clause?
getMaxColumnsInSelect(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum number of columns in a "SELECT" list?
getMaxColumnsInTable(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum number of columns in a table?
getMaxConnections(). Method in class interbase.interclient.DatabaseMetaData
How many active connections can we have at a time to this database?
getMaxCursorNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum cursor name length?
getMaxFieldSize(). Method in class interbase.interclient.Statement
The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns.
getMaxIndexLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of an index (in bytes)?
getMaxProcedureNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of a procedure name?
getMaxRows(). Method in class interbase.interclient.Statement
The maxRows limit is the maximum number of rows that a ResultSet can contain.
getMaxRowSize(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of a single row?
getMaxSchemaNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length allowed for a schema name?
getMaxStatementLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of a SQL statement?
getMaxStatements(). Method in class interbase.interclient.DatabaseMetaData
How many active statements can we have open at one time to this database?
getMaxTableNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of a table name?
getMaxTablesInSelect(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum number of tables in a SELECT?
getMaxUserNameLength(). Method in class interbase.interclient.DatabaseMetaData
What's the maximum length of a user name?
getMemoryInUse(). Method in class interbase.interclient.ServerStatistics
Get the server memory in use for all connections to this server.
getMemoryInUse(String). Method in class interbase.interclient.ServerStatistics
Get the server memory in use for all connections to a specific database.
getMemoryReads(). Method in class interbase.interclient.ConnectionStatistics
Number of memory reads from cache since connection was attached.
getMemoryReads(). Method in class interbase.interclient.ServerStatistics
Number of memory reads from cache since server started..
getMemoryReads(). Method in interface interbase.interclient.Statistics
Number of memory reads from InterBase cache.
getMemoryWrites(). Method in class interbase.interclient.ConnectionStatistics
Number of memory writes to cache since connection was attached.
getMemoryWrites(). Method in class interbase.interclient.ServerStatistics
Number of memory writes to cache since server started..
getMemoryWrites(). Method in interface interbase.interclient.Statistics
Number of memory writes to InterBase cache.
getMetaData(). Method in class interbase.interclient.Connection
A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc.
getMetaData(). Method in class interbase.interclient.ResultSet
The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
getMinorVersion(). Method in class interbase.interclient.Driver
Get the driver's minor version number.
getMonitor(). Method in class interbase.interclient.Driver
Get a monitor for tracing jdbc calls.
getMoreResults(). Method in class interbase.interclient.Statement
getMoreResults moves to a Statement's next result.
getNumericFunctions(). Method in class interbase.interclient.DatabaseMetaData
Get a comma separated list of math functions.
getObject(int). Method in class interbase.interclient.CallableStatement
Get the value of a parameter as a Java object.
getObject(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java object.
getObject(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java object.
getODSMajorVersion(). Method in class interbase.interclient.DatabaseMetaData
Get the On Disk Structure (ODS) major version for the database.
getODSMinorVersion(). Method in class interbase.interclient.DatabaseMetaData
Get the On Disk Structure (ODS) minor version for the database.
getPageAllocation(). Method in class interbase.interclient.DatabaseMetaData
Get the number of pages allocated for this database at the time of connection.
getPageSize(). Method in class interbase.interclient.DatabaseMetaData
Get the page size for this database.
getParameterCount(). Method in class interbase.interclient.ParameterMetaData
How many parameters are there?
getParameterIndex(). Method in class interbase.interclient.ParameterIndexOutOfBoundsException
Get the parameter index which caused this exception to be thrown.
getParameterMetaData(). Method in class interbase.interclient.PreparedStatement
Get meta data describing the parameters to this prepared statement.
getParameterType(int). Method in class interbase.interclient.ParameterMetaData
SQL Type id from java.sql.Types for input parameter.
getParameterTypeName(int). Method in class interbase.interclient.ParameterMetaData
Get the InterBase type name for an input parameter.
getPlan(). Method in class interbase.interclient.PreparedStatement
If this statement was prepared with setPlan enabled then retrieve the plan.
getPrecision(int). Method in class interbase.interclient.ParameterMetaData
Get the number of decimal digits.
getPrecision(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's number of decimal digits.
getPrimaryKeys(String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of a table's primary key columns.
getProcedureColumns(String, String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of a catalog's stored procedure parameters and result columns.
getProcedures(String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of stored procedures available in a catalog.
getProcedureTerm(). Method in class interbase.interclient.DatabaseMetaData
What's the database vendor's preferred term for "procedure"?
getPropertyInfo(String, Properties). Method in class interbase.interclient.Driver
The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database.
getPurgeCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of removals of old versions of fully mature records from table (records committed, resulting in older ancestor versions no longer being needed).
getQueryTimeout(). Method in class interbase.interclient.Statement
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
getRegisteredDatabases(). Method in class interbase.interclient.Server
Returns an array of database files registered in isc4.gdb.
getResultSet(). Method in class interbase.interclient.Statement
getResultSet returns the current result as a ResultSet.
getResultSetMetaData(). Method in class interbase.interclient.PreparedStatement
Get the result set meta data for this prepared statement.
getScale(int). Method in class interbase.interclient.ParameterMetaData
Number of digits to the right of decimal.
getScale(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's number of digits to right of the decimal point.
getSchemaName(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's table's schema name.
getSchemas(). Method in class interbase.interclient.DatabaseMetaData
Get the schema names available in this database.
getSchemaTerm(). Method in class interbase.interclient.DatabaseMetaData
What's the database vendor's preferred term for "schema"?
getSearchStringEscape(). Method in class interbase.interclient.DatabaseMetaData
This is the string that can be used to escape the wildcard characters '_' or '%' in the string pattern style catalog search parameters.
getSecondaryFiles(String). Method in class interbase.interclient.Server
Get the secondary files for a multi-file database.
getSequentialReadCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of sequential table reads, that is, the number of sequential row reads done for this connection.
getServer(String, String, String). Method in class interbase.interclient.Driver
Attach to the InterBase administration service.
getServerBuildNumber(). Method in class interbase.interclient.DatabaseMetaData
What's the build number for this version of the server side JDBC middleware server (InterServer)?
getServerCompanyName(). Method in class interbase.interclient.DatabaseMetaData
Who developed the JDBC/Net middleware server (InterServer).
getServerExpirationDate(). Method in class interbase.interclient.DatabaseMetaData
Get the expiration date for the server side JDBC middleware server (InterServer).
getServerJDBCNetProtocolVersion(). Method in class interbase.interclient.DatabaseMetaData
Get the JDBC/Net protocol used by InterServer.
getServerName(). Method in class interbase.interclient.CommunicationException
Get the name of the server to which communication has failed.
getServerName(). Method in class interbase.interclient.DatabaseMetaData
What's the name of the server side JDBC middleware server?
getServerName(). Method in class interbase.interclient.LoginTimeoutException
Get the name of server to which login was unsuccessful.
getServerPort(). Method in class interbase.interclient.DatabaseMetaData
Get the JDBC/Net middleware server (InterServer) port.
getServerVersion(). Method in class interbase.interclient.DatabaseMetaData
What's the version of the server side JDBC middleware server (InterServer)?
getShort(int). Method in class interbase.interclient.CallableStatement
Get the value of a SMALLINT parameter as a Java short.
getShort(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java short.
getShort(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java short.
getSourceType(). Method in class interbase.interclient.ColumnConversionException
Get the source type for the invalid conversion.
getSourceType(). Method in class interbase.interclient.ParameterConversionException
Get the source type for the invalid conversion.
getSQLKeywords(). Method in class interbase.interclient.DatabaseMetaData
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
getStatistics(). Method in class interbase.interclient.Connection
Get statistics for this connection.
getStatistics(). Method in class interbase.interclient.Server
Get server-wide statistics accumulated since the InterBase service started.
getString(int). Method in class interbase.interclient.CallableStatement
Get the value of a CHAR, VARCHAR, or LONGVARCHAR parameter as a Java String.
getString(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java String.
getString(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a Java String.
getStringFunctions(). Method in class interbase.interclient.DatabaseMetaData
Get a comma separated list of string functions.
getSweepInterval(). Method in class interbase.interclient.DatabaseMetaData
Get the sweep interval for automatic housekeeping.
getSystemFunctions(). Method in class interbase.interclient.DatabaseMetaData
Get a comma separated list of system functions.
getTableLock(String). Method in class interbase.interclient.Connection
Get the current table lock mode on a table.
getTableName(int). Method in class interbase.interclient.ResultSetMetaData
Get the column's table name.
getTablePrivileges(String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of the access rights for each table available in a catalog.
getTables(String, String, String, String[]). Method in class interbase.interclient.DatabaseMetaData
Get a description of tables available in a catalog.
getTableTypes(). Method in class interbase.interclient.DatabaseMetaData
Get the table types available in this database.
getTargetType(). Method in class interbase.interclient.ColumnConversionException
Get the target type for the invalid conversion.
getTargetType(). Method in class interbase.interclient.ParameterConversionException
Get the target type for the invalid conversion.
getTime(int). Method in class interbase.interclient.CallableStatement
Get the value of a SQL TIME parameter as a java.sql.Time object.
getTime(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTime(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTimeDateFunctions(). Method in class interbase.interclient.DatabaseMetaData
Get a comma separated list of time and date functions.
getTimestamp(int). Method in class interbase.interclient.CallableStatement
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
getTimestamp(int). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTimestamp(String). Method in class interbase.interclient.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTraceStream(). Method in class interbase.interclient.Monitor
Get the logging/tracing PrintStream that is used by the monitor for a driver instance.
getTransactionId(). Method in class interbase.interclient.Connection
Get the InterBase transaction id for the current transaction.
getTransactionIsolation(). Method in class interbase.interclient.Connection
Get this Connection's current transaction isolation mode.
getTypeInfo(). Method in class interbase.interclient.DatabaseMetaData
Get a description of all the standard SQL types supported by this database.
getUDFs(). Method in class interbase.interclient.DatabaseMetaData
Return a list of the User-Defined Functions on this database.
getUnicodeStream(int). Method in class interbase.interclient.ResultSet
A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
getUnicodeStream(String). Method in class interbase.interclient.ResultSet
A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.
getUpdateCount(). Method in class interbase.interclient.Statement
getUpdateCount returns the current result as an update count; if the result is a ResultSet or there are no more results, -1 is returned.
getUpdateCount(String). Method in class interbase.interclient.ConnectionStatistics
Number of table updates for this connection.
getURL(). Method in class interbase.interclient.DatabaseMetaData
What's the url for this database?
getURL(). Method in class interbase.interclient.URLSyntaxException
Get the bad URL which caused this exception to be thrown.
getUserName(). Method in class interbase.interclient.DatabaseMetaData
What's our user name as known to the database?
getUsers(). Method in class interbase.interclient.Server
Returns an array of users registered in isc4.gdb.
getUsersConnected(). Method in class interbase.interclient.Server
Returns an array of users currently connected to server.
getUsersConnected(String). Method in class interbase.interclient.Server
Returns an array of users currently connected to database.
getVersionColumns(String, String, String). Method in class interbase.interclient.DatabaseMetaData
Get a description of a table's columns that are automatically updated when any value in a row is updated.
getWarnings(). Method in class interbase.interclient.Connection
The first warning reported by calls on this Connection is returned.
getWarnings(). Method in class interbase.interclient.ResultSet
The first warning reported by calls on this ResultSet is returned.
getWarnings(). Method in class interbase.interclient.Statement
The first warning reported by calls on this Statement is returned.

I

importedKeyCascade. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - for update, change imported key to agree with primary key update; for delete, delete rows that import a deleted key.
importedKeyInitiallyDeferred. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY DEFERRABILITY - see SQL92 for definition
importedKeyInitiallyImmediate. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY DEFERRABILITY - see SQL92 for definition
importedKeyNoAction. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - do not allow update or delete of primary key if it has been imported.
importedKeyNotDeferrable. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY DEFERRABILITY - see SQL92 for definition
importedKeyRestrict. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - do not allow update or delete of primary key if it has been imported.
importedKeySetDefault. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - change imported key to default values if its primary key has been updated or deleted.
importedKeySetNull. Static variable in class interbase.interclient.DatabaseMetaData
IMPORT KEY UPDATE_RULE and DELETE_RULE - change imported key to NULL if its primary key has been updated or deleted.
INTERBASE. Static variable in interface interbase.interclient.ComponentException
INTERCLIENT. Static variable in interface interbase.interclient.ComponentException
INTERSERVER. Static variable in interface interbase.interclient.ComponentException
inTransaction(). Method in class interbase.interclient.Connection
Is a transaction currently active on this connection?
isAutoIncrement(int). Method in class interbase.interclient.ResultSetMetaData
Is the column automatically numbered, thus read-only?
isCaseSensitive(int). Method in class interbase.interclient.ResultSetMetaData
Does a column's case matters?
isCatalogAtStart(). Method in class interbase.interclient.DatabaseMetaData
Does a catalog appear at the start of a qualified table name?
isClosed(). Method in class interbase.interclient.Connection
Is the connection closed?
isCurrency(int). Method in class interbase.interclient.ResultSetMetaData
Can the column can be used to represent a cash value?
isDefinitelyWritable(int). Method in class interbase.interclient.ResultSetMetaData
Will a write on the column definitely succeed?
isNull(int). Method in class interbase.interclient.ResultSet
Is the column value a SQL NULL?
isNullable(int). Method in class interbase.interclient.ParameterMetaData
Can you put a null for this parameter?
isNullable(int). Method in class interbase.interclient.ResultSetMetaData
Can you can put a NULL in this column?
isReadOnly(). Method in class interbase.interclient.Connection
Is the connection in read-only mode?
isReadOnly(). Method in class interbase.interclient.DatabaseMetaData
Is the database in read-only mode?
isReadOnly(int). Method in class interbase.interclient.ResultSetMetaData
Is a column definitely not writable?
isSearchable(int). Method in class interbase.interclient.ResultSetMetaData
Can a column be used in a where clause?
isSigned(int). Method in class interbase.interclient.ResultSetMetaData
Can the column can contain signed numbers?
isSpaceReservedForVersioning(). Method in class interbase.interclient.DatabaseMetaData
Is space being reserved on each newly created database page for anticipated record versions?
isSynchronous(). Method in class interbase.interclient.DatabaseMetaData
Are disk writes synchronous for this connection.
isWritable(int). Method in class interbase.interclient.ResultSetMetaData
Is it possible for a write on the column to succeed?

J

jdbcCompliant(). Method in class interbase.interclient.Driver
Report whether the Driver is a genuine JDBC COMPLIANT (tm) driver.

L

limitNumberOfConnections(String, int). Method in class interbase.interclient.Server
Limit the number of connections to a database.
LOCK_RESOLUTION_NOWAIT. Static variable in class interbase.interclient.Connection
The InterBase lock resolution protocol in which a transaction will not wait for locks to be released, but instead, a LockConflictException is thrown.
LOCK_RESOLUTION_WAIT. Static variable in class interbase.interclient.Connection
The default lock resolution mode for InterBase.

M

markAsDamaged(String). Method in class interbase.interclient.Server
Mark the database as damaged.
move(String, String). Method in class interbase.interclient.Server
Change the name or physical location of a database.

N

nativeSQL(String). Method in class interbase.interclient.Connection
A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; nativeSQL returns the native form of the statement that the driver would have sent.
next(). Method in class interbase.interclient.ResultSet
A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
nullPlusNonNullIsNull(). Method in class interbase.interclient.DatabaseMetaData
Is concatenation between a NULL and a non-NULL value NULL?
nullsAreSortedAtEnd(). Method in class interbase.interclient.DatabaseMetaData
Are NULL values sorted at the end regardless of sort order?
nullsAreSortedAtStart(). Method in class interbase.interclient.DatabaseMetaData
Are NULL values sorted at the start regardless of sort order?
nullsAreSortedHigh(). Method in class interbase.interclient.DatabaseMetaData
Are NULL values sorted high?
nullsAreSortedLow(). Method in class interbase.interclient.DatabaseMetaData
Are NULL values sorted low?

P

prepareCall(String). Method in class interbase.interclient.Connection
A SQL stored procedure call statement is handled by creating a CallableStatement for it.
prepareStatement(boolean, String). Method in class interbase.interclient.Connection
Prepares a statement with InterBase SET_PLAN enabled or disabled.
prepareStatement(String). Method in class interbase.interclient.Connection
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object.
println(String). Method in class interbase.interclient.Monitor
Print a message to the monitor's trace stream.
procedureColumnIn. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN_TYPE - IN parameter.
procedureColumnInOut. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN_TYPE - INOUT parameter.
procedureColumnOut. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN_TYPE - OUT parameter.
procedureColumnResult. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN_TYPE - result column in ResultSet.
procedureColumnReturn. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN_TYPE - procedure return value.
procedureColumnUnknown. Static variable in class interbase.interclient.DatabaseMetaData
COLUMN_TYPE - nobody knows.
procedureNoNulls. Static variable in class interbase.interclient.DatabaseMetaData
TYPE NULLABLE - does not allow NULL values.
procedureNoResult. Static variable in class interbase.interclient.DatabaseMetaData
PROCEDURE_TYPE - Does not return a result.
procedureNullable. Static variable in class interbase.interclient.DatabaseMetaData
TYPE NULLABLE - allows NULL values.
procedureNullableUnknown. Static variable in class interbase.interclient.DatabaseMetaData
TYPE NULLABLE - nullability unknown.
procedureResultUnknown. Static variable in class interbase.interclient.DatabaseMetaData
PROCEDURE_TYPE - May return a result.
procedureReturnsResult. Static variable in class interbase.interclient.DatabaseMetaData
PROCEDURE_TYPE - Returns a result.

R

register(String). Method in class interbase.interclient.Server
Register a database in isc4.gdb
registerOutParameter(int, int). Method in class interbase.interclient.CallableStatement
Before executing a stored procedure call, you must explicitly call registerOutParameter to register the java.sql.Type of each out parameter.
registerOutParameter(int, int, int). Method in class interbase.interclient.CallableStatement
Use this version of registerOutParameter for registering Numeric or Decimal out parameters.
repair(String). Method in class interbase.interclient.Server
Release unassigned pages and record fragments.
reserveNoSpaceForVersioning(boolean). Method in class interbase.interclient.ConnectionProperties
Specify whether or not space is reserved on each newly created database page for anticipated record versions.
restore(String, String). Method in class interbase.interclient.Server
Restore a database from a backup file.
restore(String, String, int, String[], int[]). Method in class interbase.interclient.Server
Restore a database from a backup file.
restore(String, String, int, String[], int[], boolean, boolean, boolean, boolean, String[]). Method in class interbase.interclient.Server
Restore a database from a backup file.
revert(int). Method in interface interbase.interclient.Adaptor
Revert back to the default JDBC behavior for the object previously adapted for the modification described by the given modifier.
revert(int). Method in class interbase.interclient.ResultSet
Revert back to the default JDBC behavior for the object adapted for the modification described by the given modifier.
RIGHT_TRIM_STRINGS. Static variable in interface interbase.interclient.Adaptor
This modifier instructs an adaptable JDBC object to create String instances with white space already trimmed from the end of the String on calls to ResultSet.getString ().
rollback(). Method in class interbase.interclient.Connection
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection.
rollbackLimboTransaction(String, int). Method in class interbase.interclient.Server
Rollback a limbo transaction.

S

ServerProperties(). Constructor for class interbase.interclient.ServerProperties
Construct a default InterBase service configuration.
setAsciiStream(int, InputStream). Method in class interbase.interclient.PreparedStatement
Send a large ASCII value as input to a LONGVARCHAR via a java.io.InputStream.
setAsciiStream(int, InputStream, int). Method in class interbase.interclient.PreparedStatement
Send a large ASCII value as input to a LONGVARCHAR via a length delimited java.io.InputStream.
setAutoCommit(boolean). Method in class interbase.interclient.Connection
If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions.
setBigDecimal(int, BigDecimal). Method in class interbase.interclient.PreparedStatement
Set a parameter to a java.lang.BigDecimal value.
setBinaryStream(int, InputStream). Method in class interbase.interclient.PreparedStatement
Send a large binary value as input to a LONGVARBINARY via a java.io.InputStream.
setBinaryStream(int, InputStream, int). Method in class interbase.interclient.PreparedStatement
Send a large binary value as input to a LONGVARBINARY via a length delimited java.io.InputStream.
setBoolean(int, boolean). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java boolean value.
setByte(int, byte). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java byte value.
setBytes(int, byte[]). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java array of bytes.
setCacheBuffers(int). Method in class interbase.interclient.ConnectionProperties
Set the suggested number of cache page buffers to use for this connection.
setCacheBuffers(String, int). Method in class interbase.interclient.Server
Set the suggested number of cache page buffers to use for a database.
setCatalog(String). Method in class interbase.interclient.Connection
A sub-space of this Connection's database may be selected by setting a catalog name.
setCursorName(String). Method in class interbase.interclient.Statement
setCursorname defines the SQL cursor name that will be used by subsequent Statement execute methods.
setDate(int, Date). Method in class interbase.interclient.PreparedStatement
Set a parameter to a java.sql.Date value.
setDefaultCacheBuffers(int). Method in class interbase.interclient.ServerProperties
Set the default suggested number of cache buffers the server will use for database attachments.
setDefaultPageSize(int). Method in class interbase.interclient.ServerProperties
Set the default page size that will be used by the Server.createDatabase() method.
setDouble(int, double). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java double value.
setEscapeProcessing(boolean). Method in class interbase.interclient.Statement
If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database.
setExclusiveAccess(boolean). Method in class interbase.interclient.ConnectionProperties
Once a connection is established with this configuration, do not allow subsequent connections to the database.
setFloat(int, float). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java float value.
setInt(int, int). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java int value.
setLockResolution(int). Method in class interbase.interclient.Connection
Set the InterBase transaction lock resolution protocol.
setLong(int, long). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java long value.
setMaxFieldSize(int). Method in class interbase.interclient.Statement
The maxFieldSize limit (in bytes) is set to limit the size of data that can be returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR fields.
setMaxRows(int). Method in class interbase.interclient.Statement
The maxRows limit is set to limit the number of rows that any ResultSet can contain.
setNull(int, int). Method in class interbase.interclient.PreparedStatement
Set a parameter to SQL NULL.
setObject(int, Object). Method in class interbase.interclient.PreparedStatement
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
setObject(int, Object, int). Method in class interbase.interclient.PreparedStatement
This method is like setObject above, but assumes a scale of zero.
setObject(int, Object, int, int). Method in class interbase.interclient.PreparedStatement
Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
setQueryTimeout(int). Method in class interbase.interclient.Statement
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
setReadOnly(boolean). Method in class interbase.interclient.Connection
You can put a connection in read-only mode as a hint to enable database optimizations.
setShort(int, short). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java short value.
setString(int, String). Method in class interbase.interclient.PreparedStatement
Set a parameter to a Java String value.
setSweepInterval(String, int). Method in class interbase.interclient.Server
Set the sweep interval for automatic sweeping.
setTableLock(String, int). Method in class interbase.interclient.Connection
Specify an InterBase table lock mode for a table.
setTime(int, Time). Method in class interbase.interclient.PreparedStatement
Set a parameter to a java.sql.Time value.
setTimestamp(int, Timestamp). Method in class interbase.interclient.PreparedStatement
Set a parameter to a java.sql.Timestamp value.
setTraceStream(PrintStream). Method in class interbase.interclient.Monitor
Set the logging/tracing PrintStream that is used by the monitor for a driver instance.
setTransactionIsolation(int). Method in class interbase.interclient.Connection
You can call this method to try to change the transaction isolation level using one of the TRANSACTION_* values.
setUnicodeStream(int, InputStream). Method in class interbase.interclient.PreparedStatement
Send a large UNICODE value as input to a LONGVARCHAR via a java.io.InputStream.
setUnicodeStream(int, InputStream, int). Method in class interbase.interclient.PreparedStatement
Send a large UNICODE value as input to a LONGVARCHAR via a length delimited java.io.InputStream.
setUser(String, String). Method in class interbase.interclient.ConnectionProperties
Set the user and password for the pending connection.
shutdown(). Method in class interbase.interclient.Server
Shut down the InterBase service.
shutdown(String, boolean, boolean, boolean, int). Method in class interbase.interclient.Server
Prevent further database connections or transactions, or force the shutdown of existing ones.
SINGLE_INSTANCE_TIME. Static variable in interface interbase.interclient.Adaptor
This modifier instructs an adaptable JDBC object to reuse a single instance of a Java Time/Date/Timestamp object on calls to ResultSet.getDate(), ResultSet.getTime() and ResultSet.getTimestamp ().
startup(ServerProperties). Method in class interbase.interclient.Server
Start the InterBase service to allow for database connections.
storesLowerCaseIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
storesLowerCaseQuotedIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
storesMixedCaseIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
storesMixedCaseQuotedIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
storesUpperCaseIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
storesUpperCaseQuotedIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
supportsAlterTableWithAddColumn(). Method in class interbase.interclient.DatabaseMetaData
Is "ALTER TABLE" with add column supported?
supportsAlterTableWithDropColumn(). Method in class interbase.interclient.DatabaseMetaData
Is "ALTER TABLE" with drop column supported?
supportsANSI92EntryLevelSQL(). Method in class interbase.interclient.DatabaseMetaData
Is the ANSI92 entry level SQL grammar supported?
supportsANSI92FullSQL(). Method in class interbase.interclient.DatabaseMetaData
Is the ANSI92 full SQL grammar supported?
supportsANSI92IntermediateSQL(). Method in class interbase.interclient.DatabaseMetaData
Is the ANSI92 intermediate SQL grammar supported?
supportsCatalogsInDataManipulation(). Method in class interbase.interclient.DatabaseMetaData
Can a catalog name be used in a data manipulation statement?
supportsCatalogsInIndexDefinitions(). Method in class interbase.interclient.DatabaseMetaData
Can a catalog name be used in an index definition statement?
supportsCatalogsInPrivilegeDefinitions(). Method in class interbase.interclient.DatabaseMetaData
Can a catalog name be used in a privilege definition statement?
supportsCatalogsInProcedureCalls(). Method in class interbase.interclient.DatabaseMetaData
Can a catalog name be used in a procedure call statement?
supportsCatalogsInTableDefinitions(). Method in class interbase.interclient.DatabaseMetaData
Can a catalog name be used in a table definition statement?
supportsColumnAliasing(). Method in class interbase.interclient.DatabaseMetaData
Is column aliasing supported?
supportsConvert(). Method in class interbase.interclient.DatabaseMetaData
Is the CONVERT function between SQL types supported?
supportsConvert(int, int). Method in class interbase.interclient.DatabaseMetaData
Is CONVERT between the given SQL types supported?
supportsCoreSQLGrammar(). Method in class interbase.interclient.DatabaseMetaData
Is the ODBC Core SQL grammar supported?
supportsCorrelatedSubqueries(). Method in class interbase.interclient.DatabaseMetaData
Are correlated subqueries supported?
supportsDataDefinitionAndDataManipulationTransactions(). Method in class interbase.interclient.DatabaseMetaData
Are both data definition and data manipulation statements within a transaction supported?
supportsDataManipulationTransactionsOnly(). Method in class interbase.interclient.DatabaseMetaData
Are only data manipulation statements within a transaction supported?
supportsDifferentTableCorrelationNames(). Method in class interbase.interclient.DatabaseMetaData
If table correlation names are supported, are they restricted to be different from the names of the tables?
supportsExpressionsInOrderBy(). Method in class interbase.interclient.DatabaseMetaData
Are expressions in "ORDER BY" lists supported?
supportsExtendedSQLGrammar(). Method in class interbase.interclient.DatabaseMetaData
Is the ODBC Extended SQL grammar supported?
supportsFullOuterJoins(). Method in class interbase.interclient.DatabaseMetaData
Are full nested outer joins supported?
supportsGroupBy(). Method in class interbase.interclient.DatabaseMetaData
Is some form of "GROUP BY" clause supported?
supportsGroupByBeyondSelect(). Method in class interbase.interclient.DatabaseMetaData
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
supportsGroupByUnrelated(). Method in class interbase.interclient.DatabaseMetaData
Can a "GROUP BY" clause use columns not in the SELECT?
supportsIntegrityEnhancementFacility(). Method in class interbase.interclient.DatabaseMetaData
Is the SQL Integrity Enhancement Facility supported?
supportsLikeEscapeClause(). Method in class interbase.interclient.DatabaseMetaData
Is the escape character in "LIKE" clauses supported?
supportsLimitedOuterJoins(). Method in class interbase.interclient.DatabaseMetaData
Is there limited support for outer joins?
supportsMinimumSQLGrammar(). Method in class interbase.interclient.DatabaseMetaData
Is the ODBC Minimum SQL grammar supported?
supportsMixedCaseIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Check if the database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
supportsMixedCaseQuotedIdentifiers(). Method in class interbase.interclient.DatabaseMetaData
Check if the database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
supportsMultipleResultSets(). Method in class interbase.interclient.DatabaseMetaData
Are multiple ResultSets from a single execute supported?
supportsMultipleTransactions(). Method in class interbase.interclient.DatabaseMetaData
Can we have multiple transactions open at once (on different connections)?
supportsNonNullableColumns(). Method in class interbase.interclient.DatabaseMetaData
Can columns be defined as non-nullable?
supportsOpenCursorsAcrossCommit(). Method in class interbase.interclient.DatabaseMetaData
Can cursors remain open across commits?
supportsOpenCursorsAcrossRollback(). Method in class interbase.interclient.DatabaseMetaData
Can cursors remain open across rollbacks?
supportsOpenStatementsAcrossCommit(). Method in class interbase.interclient.DatabaseMetaData
Can statements remain open across commits?
supportsOpenStatementsAcrossRollback(). Method in class interbase.interclient.DatabaseMetaData
Can statements remain open across rollbacks?
supportsOrderByUnrelated(). Method in class interbase.interclient.DatabaseMetaData
Can an "ORDER BY" clause use columns not in the SELECT?
supportsOuterJoins(). Method in class interbase.interclient.DatabaseMetaData
Is some form of outer join supported?
supportsPositionedDelete(). Method in class interbase.interclient.DatabaseMetaData
Is positioned DELETE supported?
supportsPositionedUpdate(). Method in class interbase.interclient.DatabaseMetaData
Is positioned UPDATE supported?
supportsSchemasInDataManipulation(). Method in class interbase.interclient.DatabaseMetaData
Can a schema name be used in a data manipulation statement?
supportsSchemasInIndexDefinitions(). Method in class interbase.interclient.DatabaseMetaData
Can a schema name be used in an index definition statement?
supportsSchemasInPrivilegeDefinitions(). Method in class interbase.interclient.DatabaseMetaData
Can a schema name be used in a privilege definition statement?
supportsSchemasInProcedureCalls(). Method in class interbase.interclient.DatabaseMetaData
Can a schema name be used in a procedure call statement?
supportsSchemasInTableDefinitions(). Method in class interbase.interclient.DatabaseMetaData
Can a schema name be used in a table definition statement?
supportsSelectForUpdate(). Method in class interbase.interclient.DatabaseMetaData
Is SELECT for UPDATE supported?
supportsStoredProcedures(). Method in class interbase.interclient.DatabaseMetaData
Are stored procedure calls using the stored procedure escape syntax supported?
supportsSubqueriesInComparisons(). Method in class interbase.interclient.DatabaseMetaData
Are subqueries in comparison expressions supported?
supportsSubqueriesInExists(). Method in class interbase.interclient.DatabaseMetaData
Are subqueries in 'exists' expressions supported?
supportsSubqueriesInIns(). Method in class interbase.interclient.DatabaseMetaData
Are subqueries in 'in' statements supported?
supportsSubqueriesInQuantifieds(). Method in class interbase.interclient.DatabaseMetaData
Are subqueries in quantified expressions supported?
supportsTableCorrelationNames(). Method in class interbase.interclient.DatabaseMetaData
Are table correlation names supported?
supportsTransactionIsolationLevel(int). Method in class interbase.interclient.DatabaseMetaData
Does the database support the given transaction isolation level?
supportsTransactions(). Method in class interbase.interclient.DatabaseMetaData
Are transactions supported?
supportsUnion(). Method in class interbase.interclient.DatabaseMetaData
Is SQL UNION supported?
supportsUnionAll(). Method in class interbase.interclient.DatabaseMetaData
Is SQL UNION ALL supported?
sweep(String). Method in class interbase.interclient.Server
Manually sweep the database of old record versions.

T

TABLELOCK_PROTECTED_READ. Static variable in class interbase.interclient.Connection
Disallow all table writes; Permit table reads by all transactions.
TABLELOCK_PROTECTED_WRITE. Static variable in class interbase.interclient.Connection
Permit exclusive table writes only; Permit table reads by concurrency and read-committed mode transactions with read access.
TABLELOCK_SHARED_READ. Static variable in class interbase.interclient.Connection
Permit table writes by any transaction with write access; Permit table reads by any transaction.
TABLELOCK_SHARED_WRITE. Static variable in class interbase.interclient.Connection
Permit table writes by concurrency and read-committed mode transactions with write access; Permit table reads by concurrency and read-committed mode transactions with read access.
TRANSACTION_NONE. Static variable in class interbase.interclient.Connection
JDBC Isolation level in which transactions are not supported.
TRANSACTION_READ_COMMITTED. Static variable in class interbase.interclient.Connection
JDBC Isolation level in which dirty reads are prevented; non-repeatable reads and phantom reads can occur.
TRANSACTION_READ_LATEST_COMMITTED_VERSION. Static variable in class interbase.interclient.Connection
An InterBase isolation in which transactions read the last committed update but not if an uncommitted update is pending.
TRANSACTION_READ_MOST_RECENT_COMMITTED_VERSION. Static variable in class interbase.interclient.Connection
An InterBase isolation in which transactions read the most recent committed updates of simultaneous transactions (synonym for TRANSACTION_READ_COMMITTED).
TRANSACTION_READ_UNCOMMITTED. Static variable in class interbase.interclient.Connection
JDBC Isolation level in which dirty reads, non-repeatable reads and phantom reads can occur.
TRANSACTION_REPEATABLE_READ. Static variable in class interbase.interclient.Connection
JDBC Isolation level in which dirty reads and non-repeatable reads are prevented; phantom reads can occur.
TRANSACTION_SERIALIZABLE. Static variable in class interbase.interclient.Connection
JDBC Isolation level in which dirty reads, non-repeatable reads and phantom reads are prevented.
TRANSACTION_SNAPSHOT. Static variable in class interbase.interclient.Connection
The native isolation mode for InterBase, also known as concurrency mode (synonym for TRANSACTION_SERIALIZABLE).
TRANSACTION_SNAPSHOT_TABLE_STABILITY. Static variable in class interbase.interclient.Connection
An InterBase isolation which ensures exclusive write-access to tables which are being modified.
twoPhaseCommitLimboTransactions(String). Method in class interbase.interclient.Server
Attempt to resolve all limbo transactions using two-phase commit.
typeNoNulls. Static variable in class interbase.interclient.DatabaseMetaData
TYPE NULLABLE - does not allow NULL values.
typeNullable. Static variable in class interbase.interclient.DatabaseMetaData
TYPE NULLABLE - allows NULL values.
typeNullableUnknown. Static variable in class interbase.interclient.DatabaseMetaData
TYPE NULLABLE - nullability unknown.
typePredBasic. Static variable in class interbase.interclient.DatabaseMetaData
TYPE INFO SEARCHABLE - Supported except for WHERE ..
typePredChar. Static variable in class interbase.interclient.DatabaseMetaData
TYPE INFO SEARCHABLE - Only supported with WHERE ..
typePredNone. Static variable in class interbase.interclient.DatabaseMetaData
TYPE INFO SEARCHABLE - No support.
typeSearchable. Static variable in class interbase.interclient.DatabaseMetaData
TYPE INFO SEARCHABLE - Supported for all WHERE ...

U

usesLocalFilePerTable(). Method in class interbase.interclient.DatabaseMetaData
Does the database use a file for each table?
usesLocalFiles(). Method in class interbase.interclient.DatabaseMetaData
Does the database store tables in a local file?

V

verify(String). Method in class interbase.interclient.Server
Check the database for checksum errors, and unassigned or corrupt pages.
versionColumnNotPseudo. Static variable in class interbase.interclient.DatabaseMetaData
VERSION COLUMNS PSEUDO_COLUMN - is NOT a pseudo column.
versionColumnPseudo. Static variable in class interbase.interclient.DatabaseMetaData
VERSION COLUMNS PSEUDO_COLUMN - is a pseudo column.
versionColumnUnknown. Static variable in class interbase.interclient.DatabaseMetaData
VERSION COLUMNS PSEUDO_COLUMN - may or may not be pseudo column.

W

wasNull(). Method in class interbase.interclient.CallableStatement
An OUT parameter may have the value of SQL NULL; wasNull reports whether the last value read has this special value.
wasNull(). Method in class interbase.interclient.ResultSet
A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.