JDBC 2.0 Gets the value of a JDBC ARRAY parameter as an Array object in the
Java programming language.
Not supported by VORTEXjdbc.
Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
Not supported by VORTEXjdbc.
Get the value of a column in the current row as a Java AsciiStream.
Very large ascii values in a LONGVARCHAR column can
be read in small chunks from a java.io.InputStream.
Retrieves a description of the given attribute of the given type for a
user-defined type (UDT) that is available in the given schema and catalog.
Get the current auto-close state.
Getting auto-commit mode.
Not supported by VORTEXjdbc
Get a description of a table's optimal set of columns that
uniquely identifies a row.
JDBC 2.0 Gets the value of a JDBC NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the right of the
decimal point as the value contains.
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Get the value of a NUMERIC parameter as a java.sql.Numeric object.
Get the value of a column in the current row as a Java BigDecimal.
Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Retrieve the column value as a numeric based on column name
Get the value of a column in the current row as a Java BinaryStream.
Very large binary values in a LONGVARBINARY column can
be read in small chunks from a java.io.InputStream.
JDBC 2.0 Gets the value of a JDBC BLOB parameter as a Blob object in the
Java programming language.
Not supported by VORTEXjdbc.
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
Not supported by VORTEXjdbc.
Get (receive) BLOB/CLOB data from the RDBMS.
Get the value of a BIT parameter as a Java boolean.
Get the value of a column in the current row as a Java boolean.
Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.
Retrieve the column value as a boolean based on column name
Get the value of a TINYINT parameter as a Java byte.
Get the value of a column in the current row as a Java byte.
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
Get the value of a column in the current row as a Java byte.
Get the next column as a byte array.
Get the value of a SQL BINARY or VARBINARY parameter as a Java byte[]
Get the value of a column in the current row as a Java byte array.
Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
Retrieve the column value as a byte array based on column name
JDBC draft specification method to return the catalog.
Not supported by VORTEXjdbc.
Supported for Oracle, Rdb, Sybase, SQL Server, Informix, and Genesis
Get the catalog names available in this database.
What's the separator between catalog and table name?
What's the database vendor's preferred term for "catalog"?
Not supported by VORTEXjdbc.
Not supported by VORTEXjdbc.
JDBC 2.0 Gets the value of a JDBC CLOB parameter as a Clob object in the
Java programming language.
Not supported by VORTEXjdbc.
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
Not supported by VORTEXjdbc.
Returns the dbDescriptor for an output columns.
Not supported by VORTEXjdbc.
Returns the number of columns in this result set.
Gives the display size for this column.
This returns column_name.
The name of the requested column.
Not supported by VORTEXjdbc
Get a description of the access rights for a table's columns.
Supported for Oracle, Rdb, Sybase, SQL Server, Informix, and Genesis
Get a description of table columns available in a catalog.
Gives the column type using the types in java.sql.Types.
Gives the column type as a string.
Returns the concurrency mode of this result set.
JDBC 2.0 Retrieves the connection that produced this metadata object.
Returns the Connection object that produced this Statement object.
Not supported by VORTEXjdbc
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.) This
should normally return a single foreign key/primary key pair
(most tables only import a foreign key from a table once.) They
are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and
KEY_SEQ.
Return the current record from the table
Retrieves the major database version number.
Retrieves the minor database version number.
What's the name of this database product?
What's the version of this database product?
Only supported on Oracle, Sybase, SQLServer, and Informix.
Get the value of a SQL DATE parameter as a java.sql.Date object
Get the value of a column in the current row as a Java date.
Gets the value of a JDBC DATE parameter as a java.sql.Date object, using
the given Calendar object to construct the date.
Get the value of a column in the current row as a Java date.
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
Retrieve the column value as a date based on column name
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
Get the value of a column in the current row as a Java date.
Get the next column as a Date.
Return VORTEX dbChannel for this record
Returns the actual dbcursor number.
Return VORTEX dbCursor for this record
Return VORTEX dbDescriptor for this column
What's the database's default transaction isolation level? The
values are defined in java.sql.Connection.
Get the value of a DOUBLE parameter as a Java double.
Get the value of a column in the current row as a Java double.
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
Retrieve the column value as a double based on column name
What's this JDBC driver's major version number?
What's this JDBC driver's minor version number?
What's the name of this JDBC driver?
What's the version of this JDBC driver?
Not supported by VORTEXjdbc
Get a description of a foreign key columns that reference a
table's primary key columns (the foreign keys exported by a
table).
Get all the "extra" characters that can be used in unquoted
identifier names (those beyond a-z, 0-9 and _).
Returns the fetch direction for this result set.
Retrieves the direction for fetching rows from database tables that is the
default for result sets generated from this Statement object.
Returns the fetch size for this result set.
Retrieves the number of result set rows that is the default fetch size for
result sets generated from this Statement object.
Get the value of a FLOAT parameter as a Java float.
Get the value of a column in the current row as a Java float.
Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
Retrieve the column value as a float based on column name
getGenerateKeys returns any auto-generated keys created as a result of
executing this Statement.
Retrieves the current holdability of ResultSet objects created using
this Connection object.
What's the string used to quote SQL identifiers?
This returns a space " " if identifier quoting isn't supported.
Not supported by VORTEXjdbc
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).
Supported for GENESIS
Get a description of a table's indices and statistics.
Get the value of a INTEGER parameter as a Java int.
Get the value of a column in the current row as a Java int.
Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
Retreive the column value as a int based on column name
Retrieves the major JDBC version number for this driver.
Retrieves the minor JDBC version number for this driver.
Get the value of a BIGINT parameter as a Java long.
Get the value of a column in the current row as a Java long.
Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
Retrieve the column value as a long based on column name
Get the driver's major version number.
How many hex characters can you have in an inline binary literal?
What's the maximum length of a catalog name?
What's the max length for a character literal?
What's the limit on column name length?
What's the maximum number of columns in a "GROUP BY" clause?
What's the maximum number of columns allowed in an index?
What's the maximum number of columns in an "ORDER BY" clause?
What's the maximum number of columns in a "SELECT" list?
What's maximum number of columns in a table?
How many active connections can we have at a time to this database?
What's the maximum cursor name length?
This does not apply to VORTEXjdbc
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.
What's the maximum length of an index (in bytes)?
What's the maximum length of a procedure name?
This does not apply to VORTEXjdbc
The maxRows limit is the maximum number of rows that a
ResultSet can contain.
What's the maximum length of a single row?
What's the maximum length allowed for a schema name?
What's the maximum length of a SQL statement?
How many active statements can we have open at one time to this
database?
What's the maximum length of a table name?
What's the maximum number of tables in a SELECT?
What's the maximum length of a user name?
Return information about the database.
Gets the number, types and properties of a ResultSet's columns.
return meta-data on a result set.
Get the driver's minor version number.
getMoreResults moves to a Statement's next result.
getMoreResults moves to this Statements next result, deals with any
current ResultSet objects according to the instructions specified by the
given flag, and returns true is the next result is a ResultSet object.
Fetch the field from the table
Get the next column as a dbNumber.
Get a comma separated list of math functions.
Get the value of a parameter as a Java object.
Get the value of a column in the current row as a Java Object.
Get the value of a column in the current row as a Java Object.
Get the value of a column in the current row as a Java Object.
JDBC 2.0 Returns an object representing the value of OUT parameter i and
uses map for the custom mapping of the parameter value.
Not supported by VORTEXjdbc.
Retrieves the value of a parameter as an Object in the Java programming language.
Same as above, except returning the default SQL type
Get the value of a column as an object; an integral value is
returned as its java.lang equivalent object; a LONGVARCHAR or
LONGVARBINARY value is returned as a java.io.InputStream.
Get the value of a column as an object; an integral value is
returned as its java.lang equivalent object; a LONGVARCHAR or
LONGVARBINARY value is returned as a java.io.InputStream.
Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.
Returns the value of a column in the current row as a Java object.
Retrieves the fully-qualified name of the Java class whose instances should
be passed to the method PreparedStatement.setObject.
Retrieves the number of parameters in the PreparedStatement object for
which this ParameterMetaData object contains information.
Retrieves the number, types and properties of this PreparedStatement's
parameters.
Retrieves the designated parameter's mode.
Retrieves the designated parameter's SQL type.
Retrieves the designated parameter's database-specific type name.
Retrieves the designated parameter's number of decimal digits.
Supported for Genesis
Get a description of a table's primary key columns.
Not supported by VORTEXjdbc
Get a description of a catalog's stored procedure parameters
and result columns.
Not supported by VORTEXjdbc
What's the database vendor's preferred term for "procedure"?
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.
The queryTimeout limit is the number of seconds the driver will
wait for a Statement to execute.
Fetch the next record from the table
JDBC 2.0 Gets the value of a JDBC REF() parameter as a
Ref object in the Java programming language.
Not supported by VORTEXjdbc.
Retrieves the value of a JDBC REF() parameter as a Ref object in the Java programming language.
Not supported by VORTEXjdbc.
getResultSet returns the current result as a ResultSet.
Retrieves the result set concurrency.
Retrieves the default holdability of this ResultSet.
getResultSetHoldability returns the result set holdability.
Determine the result set type.
Retrieves the current row number.
Get the number of rows affected by the last execute() call.
Retrieves the designated parameter's number of digits to the right of
the decimal point.
Not supported by VORTEXjdbc.
Supported for Oracle, Rdb, Sybase, SQL Server, Informix, and Genesis
Get the schema names available in this database.
What's the database vendor's preferred term for "schema"?
Returns true if this is a scrollable cursor.
This is the string that can be used to escape '_' or '%' in
the string pattern style catalog search parameters.
Get the value of a SMALLINT parameter as a Java short.
Get the value of a column in the current row as a Java short.
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
Retrieve the column value as a short based on column name
Skip (pass over) columns.
Returns the SQL statement associated with this statement.
Get a comma separated list of all a database's SQL keywords
that are NOT also SQL92 keywords.
Indicates whether the SQLSTATE returned by SQLException.getSQLState is
X/Open aka Open Group SQL CLI or SQL99.
Returns the Statement that produced this ResultSet object.
Get the value of a CHAR, VARCHAR, or LONGVARCHAR parameter as a
Java String.
Get the value of a column in the current row as a Java string.
Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
Get the value of a column in the current row as a Java String.
Get the next column as a string.
Get a comma separated list of string functions.
Retrieves a description of the table hierarchies defined in a
particular schema in this database.
Retrieves a description of the user-defined type (UDT) hierarchies
defined in a particular schema in this database.
Get a comma separated list of system functions.
Gives the name of the table to which this column belongs.
Not supported by VORTEXjdbc
Get a description of the access rights for each table available
in a catalog.
Supported for Oracle, Rdb, Sybase, SQL Server, Informix, and Genesis
Get a description of tables available in a catalog.
Supported for Oracle, Rdb, Sybase, SQL Server, Informix, and Genesis
Get the table types available in this database.
Get the value of a SQL TIME parameter as a java.sql.Time object.
Get the value of a column in the current row as a Java time.
Gets the value of a JDBC TIME parameter as a java.sql.Time object, using
the given Calendar object to construct the time.
Get the value of a column in the current row as a Java time.
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
Retrieve the column value as a time based on column name
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
Get the value of a column in the current row as a Java time.
Get a comma separated list of time and date functions.
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
Get the value of a column in the current row as a Java timestamp.
Gets the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp
object, using the given Calendar object to construct the Timestamp
object.
Get the value of a column in the current row as a Java timestamp.
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
Retrieve the column value as a timestamp based on column name
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
Get the value of a column in the current row as a Java timestamp.
JDBC draft specification method for retrieving the transaction
isolation level for the connection.
Returns the type of this result set.
Not supported by VORTEXjdbc
Get a description of all the standard SQL types supported by
this database.
JDBC 2.0 Gets a description of the user-defined types defined in a
particular schema.
Get the value of a column in the current row as a Java UnicodeStream.
Very large unicode values in a LONGVARCHAR column can
be read in small chunks from a java.io.InputStream.
getUpdateCount returns the current result, which should be an
integer value.
Returns the name of the update table.
Gives the URL used to connect to the database.
What's the url for this database?
Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
Get the value of a column as a URL object.
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
Get the value of a column as a URL object.
Retrieve the user name of the connection.
What's our user name as known to the database?
Not supported by VORTEXjdbc
Get a description of a table's columns that are automatically
updated when any value in a row is updated.
Retrieving a chain of warnings
related to the connection.
The first warning reported by calls on this Statement is
returned.
Scale of a numeric output column.
When a very large ASCII value is input to a LONGVARCHAR
parameter it may be more practical to send it via a
java.io.InputStream.
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
When a Connection is in auto-close mode all its
PreparedStatements, CallableStatements, and ResultSets will be
closed when a transaction is committed or rolled back.
Setting the auto-commit mode.
Set a parameter to a java.sql.Numeric value.
Set a parameter to a java.sql.Numeric value.
When a very large binary value is input to a LONGVARBINARY
parameter it may be more practical to send it via a
java.io.InputStream.
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
Set a parameter to a Java boolean value.
Sets the designated parameter to the given Java boolean value.
Set a parameter to a Java byte value.
Sets the designated parameter to the given Java byte value.
Set a parameter to a Java array of bytes.
Set a parameter to a Java array of bytes.
JDBC draft specification method to select a sub-space of the target
database.
Sets the designated parameter to the given Reader object, which is the
given number of characters long.
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setCursorname defines the SQL cursor name that will be used by
subsequent Statement execute methods.
Set a parameter to a java.sql.Date value.
Sets the designated parameter to a java.sql.Date value, using the given
Calendar object.
Set a parameter to a java.sql.Date value.
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
Set a parameter to a Java double value.
Set a parameter to a Java double value.
This does not apply to VORTEXjdbc
If escape scanning is on (the default) the driver will do
escape substitution before sending the SQL to the database.
Not supported by VORTEXjdbc.
Gives the driver a hint as to the direction in which the rows in a result
set will be processed.
Gives the JDBC driver a hint as to the number of rows that should be
fetched from the database when more rows are needed for this result set.
Gives the JDBC driver a hint as to the number of rows that should be
fetched from the database when more rows are needed.
Set a parameter to a Java float value.
Set a parameter to a Java float value.
Changes the holdability of ResultSet objects created using this
Connection object to the given holdability.
Set a parameter to a Java int value.
Set a parameter to a Java int value.
Set a parameter to a Java long value.
Set a parameter to a Java long value.
This does not apply to VORTEXjdbc
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.
This does not apply to VORTEXjdbc
The maxRows limit is set to limit the number of rows that any
ResultSet can contain.
Set a parameter to SQL NULL.
Sets the designated parameter to SQL NULL.
Sets the designated parameter to SQL NULL.
Sets the designated parameter to SQL NULL.
Set the value of a parameter using an object; use the
java.lang equivalent objects for integral values.
This method is like setObject above, but assumes scale of zero.
Set the value of a parameter using an object; use the
java.lang equivalent objects for integral values.
Sets the value of the designated parameter with the given object.
Sets the value of the designated parameter with the given object.
Sets the value of the designated parameter with the given object.
Set (bind) an BLOB/CLOB length parameter.
Set (bind) a byte parameter.
Set (bind) a byte parameter.
Set (bind) a byte parameter.
Set (bind) a byte parameter.
Set (bind) a Date parameter.
Set (bind) a Date parameter.
Set (bind) a double parameter.
Set (bind) a double parameter.
Set (bind) a float parameter.
Set (bind) a float parameter.
Set (bind) an integer parameter.
Set (bind) an integer parameter.
Set (bind) a String parameter.
Set (bind) a String parameter.
Set (bind) a Timestamp parameter.
Set (bind) a dbNumber parameter.
Set (bind) a dbNumber parameter.
Set (bind) a dbParam parameter.
The queryTimeout limit is the number of seconds the driver will
wait for a Statement to execute.
Setup the connection in read-only mode.
Creates an unnamed savepoint in the current transaction and returns the new
Savepoint object that represents it.
Creates a savepoint with the given name in the current transaction
and returns the new Savepoint object that represents it.
Set a parameter to a Java short value.
Set a parameter to a Java short value.
Set a parameter to a Java String value.
Set a parameter to a Java String value.
Set a parameter to a java.sql.Time value.
Sets the designated parameter to a java.sql.Time value, using the given
Calendar object.
Set a parameter to a java.sql.Time value.
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
Set a parameter to a java.sql.Timestamp value.
Sets the designated parameter to a java.sql.Timestamp value, using the
given Calendar object.
Set a parameter to a java.sql.Timestamp value.
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
This method has no meaning to VORTEX since VORTEX support
isolation level on a newly opened connection, using
TRANSACTION_REPEATABLE_READ only
Note: setTransactionIsolation cannot be called while
in the middle of a transaction.
When a very large UNICODE value is input to a LONGVARCHAR
parameter it may be more practical to send it via a
java.io.InputStream.
Sets the name of the update table.
Sets the designated parameter to the given URL value.
Sets the designated parameter to the given java.net.URL object.
Associate a SQL statement to a dbCursor.
Does the database store mixed case unquoted SQL identifiers in
lower case?
Does the database store mixed case quoted SQL identifiers in
lower case?
Does the database store mixed case unquoted SQL identifiers in
mixed case?
Does the database store mixed case quoted SQL identifiers in
mixed case?
Does the database store mixed case unquoted SQL identifiers in
upper case?
Does the database store mixed case quoted SQL identifiers in
upper case?
Is "ALTER TABLE" with add column supported?
Is "ALTER TABLE" with drop column supported?
Is the ANSI92 entry level SQL grammar supported?
All JDBC compliant drivers must return true.
Is the ANSI92 full SQL grammar supported?
Is the ANSI92 intermediate SQL grammar supported?
JDBC 2.0 Indicates whether the driver supports batch updates.
Can a catalog name be used in a data manipulation statement?
Can a catalog name be used in a index definition statement?
Can a catalog name be used in a privilege definition statement?
Can a catalog name be used in a procedure call statement?
Can a catalog name be used in a table definition statement?
Is column aliasing supported?
If so, the SQL AS clause can be used to provide names for
computed columns or to provide alias names for columns as
required.
Is the CONVERT function between SQL types supported?
Is CONVERT between the given SQL types supported?
Is the ODBC Core SQL grammar supported?
Are correlated subqueries supported?
Are both data definition and data manipulation statements
within a transaction supported?
Are only data manipulation statements within a transaction
supported?
If table correlation names are supported, are they restricted
to be different from the names of the tables?
Are expressions in "ORDER BY" lists supported?
Is the ODBC Extended SQL grammar supported?
Are full nested outer joins supported?
Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
Is some form of "GROUP BY" clause supported?
Can a "GROUP BY" clause add columns not in the SELECT
provided it specifies all the columns in the SELECT?
Can a "GROUP BY" clause use columns not in the SELECT?
Is the SQL Integrity Enhancement Facility supported?
Is the escape character in "LIKE" clauses supported?
Is there limited support for outer joins? (This will be true
if supportFullOuterJoins is true.)
Is the ODBC Minimum SQL grammar supported?
Does the database support mixed case unquoted SQL identifiers?
Does the database support mixed case quoted SQL identifiers?
Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.
Are multiple ResultSets from a single execute supported?
Can we have multiple transactions open at once (on different connections)?
Retrieves whether this database supports named parameters to callable statements.
Can columns be defined as non-nullable?
Can cursors remain open across commits?
Can cursors remain open across rollbacks?
Can statements remain open across commits?
Can statements remain open across rollbacks?
Can an "ORDER BY" clause use columns not in the SELECT?
Is some form of outer join supported?
Is positioned DELETE supported?
Is positioned UPDATE supported?
JDBC 2.0 Does the database support the concurrency type in combination
with the given result set type?
Retrieves whether this database supports the given result set holdability.
JDBC 2.0 Does the database support the given result set type?
Retrieves whether this database supports savepoints.
Can a schema name be used in a data manipulation statement?
Can a schema name be used in an index definition statement?
Can a schema name be used in a privilege definition statement?
Can a schema name be used in a procedure call statement?
Can a schema name be used in a table definition statement?
Is SELECT for UPDATE supported?
Indicates whether the database supports statement pooling.
Are stored procedure calls using the stored procedure escape
syntax supported?
Are subqueries in comparison expressions supported?
Are subqueries in exists expressions supported?
Are subqueries in "in" statements supported?
Are subqueries in quantified expressions supported?
Are table correlation names supported?
Does the database support the given transaction isolation level?
Are transactions supported? If not, commit is a noop and the
isolation level is TRANSACTION_NONE.
Is SQL UNION ALL supported?