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
- 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.
- 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.
- 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.
- 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
- 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?
- 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.
- 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.
- 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?
- jdbcCompliant().
Method in class interbase.interclient.Driver
- Report whether the Driver is a genuine JDBC COMPLIANT (tm) driver.
- 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.
- 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.
- 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?
- 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.
- 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.
- 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.
- 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 ...
- 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?
- 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.
- 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.