allProceduresAreCallable
public boolean allProceduresAreCallable()
throws SQLException
Can all the procedures returned by getProcedures be called by the
current user?
allTablesAreSelectable
public boolean allTablesAreSelectable()
throws SQLException
Can all the tables returned by getTable be SELECTed by the
current user?
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit()
throws SQLException
Does a data definition statement within a transaction force the
transaction to commit?
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions()
throws SQLException
Is a data definition statement within a transaction ignored?
deletesAreDetected
public boolean deletesAreDetected(int type)
throws SQLException
JDBC 2.0 Indicates whether or not a visible row delete can be detected
by calling ResultSet.rowDeleted(). If deletesAreDetected() returns
false, then deleted rows are removed from the result set.
true
if changes are detected by the result set type
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs()
throws SQLException
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
getAttributes
public java.sql.ResultSet getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
throws SQLException
getBestRowIdentifier
public java.sql.ResultSet getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
throws SQLException
Get a description of a table's optimal set of columns that
uniquely identifies a row. They are ordered by SCOPE.
Each column description has the following columns:
- SCOPE short =>actual scope of result
- bestRowTemporary - very temporary, while using row
- bestRowTransaction - valid for remainder of current transaction
- bestRowSession - valid for remainder of current session
- COLUMN_NAME String =>column name
- DATA_TYPE short =>SQL data type from java.sql.Types
- TYPE_NAME String =>Data source dependent type name
- COLUMN_SIZE int =>precision
- BUFFER_LENGTH int =>not used
- DECIMAL_DIGITS short =>scale
- PSEUDO_COLUMN short =>is this a pseudo column like an
Oracle ROWID
- bestRowUnknown - may or may not be pseudo column
- bestRowNotPseudo - is NOT a pseudo column
- bestRowPseudo - is a pseudo column
catalog
- a catalog name; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schematable
- a table namescope
- the scope of interest; use same values as SCOPEnullable
- include columns that are nullable?
- ResultSet - each row is a column description
getCatalogSeparator
public String getCatalogSeparator()
throws SQLException
What's the separator between catalog and table name?
getCatalogTerm
public String getCatalogTerm()
throws SQLException
What's the database vendor's preferred term for "catalog"?
getCatalogs
public java.sql.ResultSet getCatalogs()
throws SQLException
Get the catalog names available in this database. The results are
ordered by catalog name.
The catalog column is:
- TABLE_CAT String =>catalog name
- ResultSet - each row has a single String column
that is a catalog name
getColumnPrivileges
public java.sql.ResultSet getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
throws SQLException
Get a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are
ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
- TABLE_CAT String =>table catalog (may be null)
- TABLE_SCHEM String =>table schema (may be null)
- TABLE_NAME String =>table name
- COLUMN_NAME String =>column name
- GRANTOR =>grantor of access (may be null)
- GRANTEE String =>grantee of access
- PRIVILEGE String =>name of access (SELECT, INSERT, UPDATE,
REFRENCES, ...)
- IS_GRANTABLE String =>"YES" if grantee is permitted to
grant to others; "NO" if not; null if unknown
catalog
- a catalog name; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schema
schematable
- a table namecolumnNamePattern
- a column name pattern
- ResultSet - each row is a column privilege description
getColumns
public java.sql.ResultSet getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
throws SQLException
Get a description of table columns available in a catalog.
Only column descriptions matching the catalog, schema, table and column
name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME
and ORDINAL_POSITION.
Each column description has the following columns:
- TABLE_CAT String =>table catalog (may be null)
- TABLE_SCHEM String =>table schema (may be null)
- TABLE_NAME String =>table name
- COLUMN_NAME String =>column name
- DATA_TYPE short =>SQL type from java.sql.Types
- TYPE_NAME String =>Data source dependent type name
- COLUMN_SIZE int =>column size. For char or date types this
is the maximum number of characters, for numeric or decimal types this
is precision.
- BUFFER_LENGTH is not used.
- DECIMAL_DIGITS int =>the number of fractional digits
- NUM_PREC_RADIX int =>Radix (typically either 10 or 2)
- NULLABLE int =>is NULL allowed?
- columnNoNulls - might not allow NULL values
- columnNullable - definitely allows NULL values
- columnNullableUnknown - nullability unknown
- REMARKS String =>comment describing column (may be null)
- COLUMN_DEF String =>default value (may be null)
- SQL_DATA_TYPE int =>unused
- SQL_DATETIME_SUB int =>unused
- CHAR_OCTET_LENGTH int =>for char types the maximum number
of bytes in the column
- ORDINAL_POSITION int =>index of column in table (starting
at 1)
- IS_NULLABLE String =>"NO" means column definitely does not
allow NULL values; "YES" means the column might allow NULL values. An
empty string means nobody knows.
catalog
- a catalog name; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those without a schematableNamePattern
- a table name patterncolumnNamePattern
- a column name pattern
- ResultSet - each row is a column description
getConnection
public java.sql.Connection getConnection()
throws SQLException
JDBC 2.0 Retrieves the connection that produced this metadata object.
- the connection that produced this metadata object
getCrossReference
public java.sql.ResultSet getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
throws SQLException
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.
Each foreign key column description has the following columns:
- PKTABLE_CAT String =>primary key table catalog (may be
null)
- PKTABLE_SCHEM String =>primary key table schema (may be
null)
- PKTABLE_NAME String =>primary key table name
- PKCOLUMN_NAME String =>primary key column name
- FKTABLE_CAT String =>foreign key table catalog (may be
null) being exported (may be null)
- FKTABLE_SCHEM String =>foreign key table schema (may be
null) being exported (may be null)
- FKTABLE_NAME String =>foreign key table name being
exported
- FKCOLUMN_NAME String =>foreign key column name being
exported
- KEY_SEQ short =>sequence number within foreign key
- UPDATE_RULE short =>What happens to foreign key when
primary is updated:
- importedNoAction - do not allow update of primary key if it has
been imported
- importedKeyCascade - change imported key to agree with primary
key update
- importedKeySetNull - change imported key to NULL if its primary
key has been updated
- importedKeySetDefault - change imported key to default values
if its primary key has been updated
- importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x
compatibility)
- DELETE_RULE short =>What happens to the foreign key when
primary is deleted.
- importedKeyNoAction - do not allow delete of primary key if it
has been imported
- importedKeyCascade - delete rows that import a deleted key
- importedKeySetNull - change imported key to NULL if its primary
key has been deleted
- importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x
compatibility)
- importedKeySetDefault - change imported key to default if its
primary key has been deleted
- FK_NAME String =>foreign key name (may be null)
- PK_NAME String =>primary key name (may be null)
- DEFERRABILITY short =>can the evaluation of foreign key
constraints be deferred until commit
- importedKeyInitiallyDeferred - see SQL92 for definition
- importedKeyInitiallyImmediate - see SQL92 for definition
- importedKeyNotDeferrable - see SQL92 for definition
primaryCatalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaprimarySchema
- a schema name pattern; "" retrieves those without a schemaprimaryTable
- the table name that exports the keyforeignCatalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaforeignSchema
- a schema name pattern; "" retrieves those without a schemaforeignTable
- the table name that imports the key
- ResultSet - each row is a foreign key column description
getDatabaseMajorVersion
public int getDatabaseMajorVersion()
throws SQLException
Returns the database major version.
getDatabaseMinorVersion
public int getDatabaseMinorVersion()
throws SQLException
Returns the database minor version.
getDatabaseProductName
public String getDatabaseProductName()
throws SQLException
Returns the name of this database product.
getDatabaseProductVersion
public String getDatabaseProductVersion()
throws SQLException
Returns the version of this database product.
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation()
throws SQLException
Returns the database's default transaction isolation level. The values
are defined in java.sql.Connection.
- the default isolation level
getDriverMajorVersion
public int getDriverMajorVersion()
Returns this JDBC driver's major version number.
- JDBC driver major version
getDriverMinorVersion
public int getDriverMinorVersion()
Returns this JDBC driver's minor version number.
- JDBC driver minor version number
getDriverName
public String getDriverName()
throws SQLException
Returns the name of this JDBC driver.
getDriverVersion
public String getDriverVersion()
throws SQLException
Returns the version of this JDBC driver.
getExportedKeys
public java.sql.ResultSet getExportedKeys(String catalog,
String schema,
String table)
throws SQLException
Get a description of the foreign key columns that reference a table's
primary key columns (the foreign keys exported by a table). They are
ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
- PKTABLE_CAT String =>primary key table catalog (may be
null)
- PKTABLE_SCHEM String =>primary key table schema (may be
null)
- PKTABLE_NAME String =>primary key table name
- PKCOLUMN_NAME String =>primary key column name
- FKTABLE_CAT String =>foreign key table catalog (may be
null) being exported (may be null)
- FKTABLE_SCHEM String =>foreign key table schema (may be
null) being exported (may be null)
- FKTABLE_NAME String =>foreign key table name being
exported
- FKCOLUMN_NAME String =>foreign key column name being
exported
- KEY_SEQ short =>sequence number within foreign key
- UPDATE_RULE short =>What happens to foreign key when
primary is updated:
- importedNoAction - do not allow update of primary key if it has
been imported
- importedKeyCascade - change imported key to agree with primary
key update
- importedKeySetNull - change imported key to NULL if its primary
key has been updated
- importedKeySetDefault - change imported key to default values
if its primary key has been updated
- importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x
compatibility)
- DELETE_RULE short =>What happens to the foreign key when
primary is deleted.
- importedKeyNoAction - do not allow delete of primary key if it
has been imported
- importedKeyCascade - delete rows that import a deleted key
- importedKeySetNull - change imported key to NULL if its primary
key has been deleted
- importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x
compatibility)
- importedKeySetDefault - change imported key to default if its
primary key has been deleted
- FK_NAME String =>foreign key name (may be null)
- PK_NAME String =>primary key name (may be null)
- DEFERRABILITY short =>can the evaluation of foreign key
constraints be deferred until commit
- importedKeyInitiallyDeferred - see SQL92 for definition
- importedKeyInitiallyImmediate - see SQL92 for definition
- importedKeyNotDeferrable - see SQL92 for definition
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schematable
- a table name
- ResultSet - each row is a foreign key column description
getExtraNameCharacters
public String getExtraNameCharacters()
throws SQLException
Get all the "extra" characters that can be used in unquoted identifier
names (those beyond a-z, A-Z, 0-9 and _).
- the string containing the extra characters
getIdentifierQuoteString
public String getIdentifierQuoteString()
throws SQLException
Returns the string used to quote SQL identifiers. This returns a space "
" if identifier quoting isn't supported. A JDBC-Compliant driver always
uses a double quote character.
getImportedKeys
public java.sql.ResultSet getImportedKeys(String catalog,
String schema,
String table)
throws SQLException
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). They
are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
- PKTABLE_CAT String =>primary key table catalog being
imported (may be null)
- PKTABLE_SCHEM String =>primary key table schema being
imported (may be null)
- PKTABLE_NAME String =>primary key table name being
imported
- PKCOLUMN_NAME String =>primary key column name being
imported
- FKTABLE_CAT String =>foreign key table catalog (may be
null)
- FKTABLE_SCHEM String =>foreign key table schema (may be
null)
- FKTABLE_NAME String =>foreign key table name
- FKCOLUMN_NAME String =>foreign key column name
- KEY_SEQ short =>sequence number within foreign key
- UPDATE_RULE short =>What happens to foreign key when
primary is updated:
- importedNoAction - do not allow update of primary key if it has
been imported
- importedKeyCascade - change imported key to agree with primary
key update
- importedKeySetNull - change imported key to NULL if its primary
key has been updated
- importedKeySetDefault - change imported key to default values
if its primary key has been updated
- importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x
compatibility)
- DELETE_RULE short =>What happens to the foreign key when
primary is deleted.
- importedKeyNoAction - do not allow delete of primary key if it
has been imported
- importedKeyCascade - delete rows that import a deleted key
- importedKeySetNull - change imported key to NULL if its primary
key has been deleted
- importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x
compatibility)
- importedKeySetDefault - change imported key to default if its
primary key has been deleted
- FK_NAME String =>foreign key name (may be null)
- PK_NAME String =>primary key name (may be null)
- DEFERRABILITY short =>can the evaluation of foreign key
constraints be deferred until commit
- importedKeyInitiallyDeferred - see SQL92 for definition
- importedKeyInitiallyImmediate - see SQL92 for definition
- importedKeyNotDeferrable - see SQL92 for definition
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schematable
- a table name
- ResultSet - each row is a primary key column description
getIndexInfo
public java.sql.ResultSet getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
throws SQLException
Get a description of a table's indices and statistics. They are ordered
by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
- TABLE_CAT String =>table catalog (may be null)
- TABLE_SCHEM String =>table schema (may be null)
- TABLE_NAME String =>table name
- NON_UNIQUE boolean =>Can index values be non-unique? false
when TYPE is tableIndexStatistic
- INDEX_QUALIFIER String =>index catalog (may be null); null
when TYPE is tableIndexStatistic
- INDEX_NAME String =>index name; null when TYPE is
tableIndexStatistic
- TYPE short =>index type:
- tableIndexStatistic - this identifies table statistics that are
returned in conjuction with a table's index descriptions
- tableIndexClustered - this is a clustered index
- tableIndexHashed - this is a hashed index
- tableIndexOther - this is some other style of index
- ORDINAL_POSITION short =>column sequence number within
index; zero when TYPE is tableIndexStatistic
- COLUMN_NAME String =>column name; null when TYPE is
tableIndexStatistic
- ASC_OR_DESC String =>column sort sequence, "A" =>
ascending, "D" =>descending, may be null if sort sequence is not
supported; null when TYPE is tableIndexStatistic
- CARDINALITY int =>When TYPE is tableIndexStatistic, then
this is the number of rows in the table; otherwise, it is the number
of unique values in the index.
- PAGES int =>When TYPE is tableIndexStatisic then this is
the number of pages used for the table, otherwise it is the number of
pages used for the current index.
- FILTER_CONDITION String =>Filter condition, if any. (may
be null)
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schematable
- a table nameunique
- when true
, return only indices for unique
values; when false
, return indices regardless of
whether unique or notapproximate
- when true
, result is allowed to reflect
approximate or out of data values; when false
, results
are requested to be accurate
- ResultSet - each row is an index column description
getJDBCMajorVersion
public int getJDBCMajorVersion()
throws SQLException
Returns the JDBC major version.
getJDBCMinorVersion
public int getJDBCMinorVersion()
throws SQLException
Returns the JDBC minor version.
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength()
throws SQLException
How many hex characters can you have in an inline binary literal?
getMaxCatalogNameLength
public int getMaxCatalogNameLength()
throws SQLException
What's the maximum length of a catalog name?
getMaxCharLiteralLength
public int getMaxCharLiteralLength()
throws SQLException
What's the max length for a character literal?
getMaxColumnNameLength
public int getMaxColumnNameLength()
throws SQLException
What's the limit on column name length?
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy()
throws SQLException
What's the maximum number of columns in a "GROUP BY" clause?
getMaxColumnsInIndex
public int getMaxColumnsInIndex()
throws SQLException
What's the maximum number of columns allowed in an index?
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy()
throws SQLException
What's the maximum number of columns in an "ORDER BY" clause?
getMaxColumnsInSelect
public int getMaxColumnsInSelect()
throws SQLException
What's the maximum number of columns in a "SELECT" list?
getMaxColumnsInTable
public int getMaxColumnsInTable()
throws SQLException
What's the maximum number of columns in a table?
getMaxConnections
public int getMaxConnections()
throws SQLException
How many active connections can we have at a time to this database?
getMaxCursorNameLength
public int getMaxCursorNameLength()
throws SQLException
What's the maximum cursor name length?
- max cursor name length in bytes
getMaxIndexLength
public int getMaxIndexLength()
throws SQLException
What's the maximum length of an index (in bytes)?
- max index length in bytes
getMaxProcedureNameLength
public int getMaxProcedureNameLength()
throws SQLException
What's the maximum length of a procedure name?
getMaxRowSize
public int getMaxRowSize()
throws SQLException
What's the maximum length of a single row?
getMaxSchemaNameLength
public int getMaxSchemaNameLength()
throws SQLException
What's the maximum length allowed for a schema name?
getMaxStatementLength
public int getMaxStatementLength()
throws SQLException
What's the maximum length of a SQL statement?
getMaxStatements
public int getMaxStatements()
throws SQLException
How many active statements can we have open at one time to this
database?
getMaxTableNameLength
public int getMaxTableNameLength()
throws SQLException
What's the maximum length of a table name?
getMaxTablesInSelect
public int getMaxTablesInSelect()
throws SQLException
What's the maximum number of tables in a SELECT?
getMaxUserNameLength
public int getMaxUserNameLength()
throws SQLException
What's the maximum length of a user name?
getNumericFunctions
public String getNumericFunctions()
throws SQLException
Get a comma separated list of math functions.
getPrimaryKeys
public java.sql.ResultSet getPrimaryKeys(String catalog,
String schema,
String table)
throws SQLException
Get a description of a table's primary key columns. They are ordered by
COLUMN_NAME.
Each primary key column description has the following columns:
- TABLE_CAT String =>table catalog (may be null)
- TABLE_SCHEM String =>table schema (may be null)
- TABLE_NAME String =>table name
- COLUMN_NAME String =>column name
- KEY_SEQ short =>sequence number within primary key
- PK_NAME String =>primary key name (may be null)
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schematable
- a table name
- ResultSet - each row is a primary key column description
getProcedureColumns
public java.sql.ResultSet getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
throws SQLException
Get a description of a catalog's stored procedure parameters and result
columns.
Only descriptions matching the schema, procedure and parameter name
criteria are returned. They are ordered by PROCEDURE_SCHEM and
PROCEDURE_NAME. Within this, the return value, if any, is first. Next
are the parameter descriptions in call order. The column descriptions
follow in column number order.
Each row in the ResultSet is a parameter description or column
description with the following fields:
- PROCEDURE_CAT String =>procedure catalog (may be null)
- PROCEDURE_SCHEM String =>procedure schema (may be null)
- PROCEDURE_NAME String =>procedure name
- COLUMN_NAME String =>column/parameter name
- COLUMN_TYPE Short =>kind of column/parameter:
- procedureColumnUnknown - nobody knows
- procedureColumnIn - IN parameter
- procedureColumnInOut - INOUT parameter
- procedureColumnOut - OUT parameter
- procedureColumnReturn - procedure return value
- procedureColumnResult - result column in ResultSet
- DATA_TYPE short =>SQL type from java.sql.Types
- TYPE_NAME String =>SQL type name
- PRECISION int =>precision
- LENGTH int =>length in bytes of data
- SCALE short =>scale
- RADIX short =>radix
- NULLABLE short =>can it contain NULL?
- procedureNoNulls - does not allow NULL values
- procedureNullable - allows NULL values
- procedureNullableUnknown - nullability unknown
- REMARKS String =>comment describing parameter/column
Note: Some databases may not return the column descriptions for a
procedure. Additional columns beyond REMARKS can be defined by the
database.
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schemaprocedureNamePattern
- a procedure name patterncolumnNamePattern
- a column name pattern
- ResultSet - each row is a stored procedure parameter or column description
getProcedureTerm
public String getProcedureTerm()
throws SQLException
What's the database vendor's preferred term for "procedure"?
getProcedures
public java.sql.ResultSet getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern)
throws SQLException
Get a description of stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name
criteria are returned. They are ordered by PROCEDURE_SCHEM, and
PROCEDURE_NAME.
Each procedure description has the the following columns:
- PROCEDURE_CAT String =>procedure catalog (may be null)
- PROCEDURE_SCHEM String =>procedure schema (may be null)
- PROCEDURE_NAME String =>procedure name
- reserved for future use
- reserved for future use
- reserved for future use
- REMARKS String =>explanatory comment on the procedure
- PROCEDURE_TYPE short =>kind of procedure:
- procedureResultUnknown - May return a result
- procedureNoResult - Does not return a result
- procedureReturnsResult - Returns a result
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schemaprocedureNamePattern
- a procedure name pattern
- ResultSet - each row is a procedure description
getResultSetHoldability
public int getResultSetHoldability()
throws SQLException
getSQLKeywords
public String getSQLKeywords()
throws SQLException
Get a comma separated list of all a database's SQL keywords that are NOT
also SQL92 keywords.
getSQLStateType
public int getSQLStateType()
throws SQLException
getSchemaTerm
public String getSchemaTerm()
throws SQLException
What's the database vendor's preferred term for "schema"?
getSchemas
public java.sql.ResultSet getSchemas()
throws SQLException
Get the schema names available in this database. The results are ordered
by schema name.
The schema column is:
- TABLE_SCHEM String => schema name
- TABLE_CATALOG String => catalog name (may be
null
, JDBC 3.0)
- a
ResultSet
object in which each row is a schema decription
getSearchStringEscape
public String getSearchStringEscape()
throws SQLException
This is the string that can be used to escape '_' or '%' in the string
pattern style catalog search parameters.
The '_' character represents any single character.
The '%' character represents any sequence of zero or more characters.
- the string used to escape wildcard characters
getSortedTypes
private static Collection getSortedTypes(ResultSet rs,
boolean useLOBs)
throws SQLException
getStringFunctions
public String getStringFunctions()
throws SQLException
Get a comma separated list of string functions.
getSuperTables
public java.sql.ResultSet getSuperTables(String catalog,
String schemaPattern,
String tableNamePattern)
throws SQLException
getSuperTypes
public java.sql.ResultSet getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
throws SQLException
getSystemFunctions
public String getSystemFunctions()
throws SQLException
Get a comma separated list of system functions.
getTablePrivileges
public java.sql.ResultSet getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern)
throws SQLException
Get a description of the access rights for each table available in a
catalog. Note that a table privilege applies to one or more columns in
the table. It would be wrong to assume that this priviledge applies to
all columns (this may be true for some systems but is not true for all.)
Only privileges matching the schema and table name criteria are
returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
Each privilige description has the following columns:
- TABLE_CAT String =>table catalog (may be null)
- TABLE_SCHEM String =>table schema (may be null)
- TABLE_NAME String =>table name
- GRANTOR =>grantor of access (may be null)
- GRANTEE String =>grantee of access
- PRIVILEGE String =>name of access (SELECT, INSERT, UPDATE,
REFRENCES, ...)
- IS_GRANTABLE String =>"YES" if grantee is permitted to
grant to others; "NO" if not; null if unknown
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schematableNamePattern
- a table name pattern
- ResultSet - each row is a table privilege description
getTableTypes
public java.sql.ResultSet getTableTypes()
throws SQLException
Get the table types available in this database. The results are ordered
by table type.
The table type is:
- TABLE_TYPE String => table type. Typical types are "TABLE",
"VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY",
"ALIAS", "SYNONYM".
- ResultSet - each row has a single String column that is a table type
getTables
public java.sql.ResultSet getTables(String catalog,
String schemaPattern,
String tableNamePattern,
types[] )
throws SQLException
Get a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and
type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM
and TABLE_NAME.
Each table description has the following columns:
- TABLE_CAT String =>table catalog (may be null)
- TABLE_SCHEM String =>table schema (may be null)
- TABLE_NAME String =>table name
- TABLE_TYPE String =>table type. Typical types are "TABLE",
"VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY",
"ALIAS", "SYNONYM".
- REMARKS String =>explanatory comment on the table
- TYPE_CAT String => the types catalog (may be
null
)
- TYPE_SCHEM String => the types schema (may be
null
)
- TYPE_NAME String => type name (may be
null
)
- SELF_REFERENCING_COL_NAME String => name of the designated
"identifier" column of a typed table (may be
null
)
- REF_GENERATION String => specifies how values in
SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER",
"DERIVED". (may be
null
)
Note: Some databases may not return information for all tables.
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schematableNamePattern
- a table name pattern
- ResultSet - each row is a table description
getTimeDateFunctions
public String getTimeDateFunctions()
throws SQLException
Get a comma separated list of time and date functions.
getTypeInfo
public java.sql.ResultSet getTypeInfo()
throws SQLException
Get a description of all the standard SQL types supported by this
database. They are ordered by DATA_TYPE and then by how closely the data
type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
- TYPE_NAME String =>Type name
- DATA_TYPE short =>SQL data type from java.sql.Types
- PRECISION int =>maximum precision
- LITERAL_PREFIX String =>prefix used to quote a literal
(may be null)
- LITERAL_SUFFIX String =>suffix used to quote a literal
(may be null)
- CREATE_PARAMS String =>parameters used in creating the
type (may be null)
- NULLABLE short =>can you use NULL for this type?
- typeNoNulls - does not allow NULL values
- typeNullable - allows NULL values
- typeNullableUnknown - nullability unknown
- CASE_SENSITIVE boolean=>is it case sensitive?
- SEARCHABLE short =>can you use "WHERE" based on this type:
- typePredNone - No support
- typePredChar - Only supported with WHERE .. LIKE
- typePredBasic - Supported except for WHERE .. LIKE
- typeSearchable - Supported for all WHERE ..
- UNSIGNED_ATTRIBUTE boolean =>is it unsigned?
- FIXED_PREC_SCALE boolean =>can it be a money value?
- AUTO_INCREMENT boolean =>can it be used for an
auto-increment value?
- LOCAL_TYPE_NAME String =>localized version of type name
(may be null)
- MINIMUM_SCALE short =>minimum scale supported
- MAXIMUM_SCALE short =>maximum scale supported
- SQL_DATA_TYPE int =>unused
- SQL_DATETIME_SUB int =>unused
- NUM_PREC_RADIX int =>usually 2 or 10
- ResultSet - each row is a SQL type description
getUDTs
public java.sql.ResultSet getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
throws SQLException
JDBC 2.0 Gets a description of the user-defined types defined in a
particular schema. Schema-specific UDTs may have type JAVA_OBJECT,
STRUCT, or DISTINCT.
Only types matching the catalog, schema, type name and type criteria are
returned. They are ordered by DATA_TYPE, TYPE_SCHEM and TYPE_NAME. The
type name parameter may be a fully-qualified name. In this case, the
catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
- TYPE_CAT String =>the type's catalog (may be null)
- TYPE_SCHEM String =>type's schema (may be null)
- TYPE_NAME String =>type name
- CLASS_NAME String =>Java class name
- DATA_TYPE String =>type value defined in java.sql.Types.
One of JAVA_OBJECT, STRUCT, or DISTINCT
- REMARKS String =>explanatory comment on the type
Note: If the driver does not support UDTs, an empty result set is
returned.
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schematypeNamePattern
- a type name pattern; may be a fully-qualified
nametypes
- a list of user-named types to include
(JAVA_OBJECT, STRUCT, or DISTINCT); null returns all types
- ResultSet - each row is a type description
getURL
public String getURL()
throws SQLException
What's the URL for this database?
- the URL or null if it can't be generated
getUserName
public String getUserName()
throws SQLException
What's our user name as known to the database?
getVersionColumns
public java.sql.ResultSet getVersionColumns(String catalog,
String schema,
String table)
throws SQLException
Get a description of a table's columns that are automatically updated
when any value in a row is updated. They are unordered.
Each column description has the following columns:
- SCOPE short =>is not used
- COLUMN_NAME String =>column name
- DATA_TYPE short =>SQL data type from java.sql.Types
- TYPE_NAME String =>Data source dependent type name
- COLUMN_SIZE int =>precision
- BUFFER_LENGTH int =>length of column value in bytes
- DECIMAL_DIGITS short =>scale
- PSEUDO_COLUMN short =>is this a pseudo column like an
Oracle ROWID
- versionColumnUnknown - may or may not be pseudo column
- versionColumnNotPseudo - is NOT a pseudo column
- versionColumnPseudo - is a pseudo column
catalog
- a catalog name; "" retrieves those without a
null
means drop catalog name from the selection criteriaschema
- a schema name; "" retrieves those without a schematable
- a table name
- ResultSet - each row is a column description
insertsAreDetected
public boolean insertsAreDetected(int type)
throws SQLException
JDBC 2.0 Indicates whether or not a visible row insert can be detected
by calling ResultSet.rowInserted().
true
if changes are detected by the result set type
isCatalogAtStart
public boolean isCatalogAtStart()
throws SQLException
Retrieves whether a catalog appears at the start of a fully qualified
table name. If not, the catalog appears at the end.
- true if it appears at the start
isReadOnly
public boolean isReadOnly()
throws SQLException
Is the database in read-only mode?
locatorsUpdateCopy
public boolean locatorsUpdateCopy()
throws SQLException
Returns
true
if updates are made to a copy of the LOB; returns
false
if LOB updates are made directly to the database.
NOTE: Since SQL Server / Sybase do not support LOB locators as Oracle does (AFAIK);
this method always returns
true
.
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull()
throws SQLException
Retrieves whether this database supports concatenations between
NULL
and non-NULL
values being
NULL
.
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd()
throws SQLException
Are NULL values sorted at the end regardless of sort order?
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart()
throws SQLException
Are NULL values sorted at the start regardless of sort order?
nullsAreSortedHigh
public boolean nullsAreSortedHigh()
throws SQLException
Are NULL values sorted high?
nullsAreSortedLow
public boolean nullsAreSortedLow()
throws SQLException
Are NULL values sorted low?
othersDeletesAreVisible
public boolean othersDeletesAreVisible(int type)
throws SQLException
JDBC 2.0 Indicates whether deletes made by others are visible.
true
if deletes made by others are
visible for the result set type; false
otherwise
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type)
throws SQLException
JDBC 2.0 Indicates whether inserts made by others are visible.
true
if inserts made by others are visible
for the result set type; false
otherwise
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type)
throws SQLException
JDBC 2.0 Indicates whether updates made by others are visible.
true
if updates made by others are
visible for the result set type; false
otherwise
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type)
throws SQLException
JDBC 2.0 Indicates whether a result set's own deletes are visible.
true
if deletes are visible for the
result set type; false
otherwise
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type)
throws SQLException
JDBC 2.0 Indicates whether a result set's own inserts are visible.
true
if inserts are visible for the
result set type; false
otherwise
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type)
throws SQLException
JDBC 2.0 Indicates whether a result set's own updates are visible.
true
if updates are visible for the
result set type; false
otherwise
processEscapes
private static String processEscapes(String pattern)
Format the supplied search pattern to transform the escape \x into [x].
pattern
- the pattern to tranform
- the transformed pattern as a
String
setCaseSensitiveFlag
private void setCaseSensitiveFlag()
throws SQLException
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers()
throws SQLException
Does the database treat mixed case unquoted SQL identifiers as case
insensitive and store them in lower case?
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers()
throws SQLException
Does the database treat mixed case quoted SQL identifiers as case
insensitive and store them in lower case?
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers()
throws SQLException
Does the database treat mixed case unquoted SQL identifiers as case
insensitive and store them in mixed case?
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers()
throws SQLException
Does the database treat mixed case quoted SQL identifiers as case
insensitive and store them in mixed case?
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers()
throws SQLException
Does the database treat mixed case unquoted SQL identifiers as case
insensitive and store them in upper case?
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers()
throws SQLException
Does the database treat mixed case quoted SQL identifiers as case
insensitive and store them in upper case?
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL()
throws SQLException
Retrieves whether this database supports the ANSI92 entry level SQL
grammar.
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL()
throws SQLException
Is the ANSI92 full SQL grammar supported?
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL()
throws SQLException
Is the ANSI92 intermediate SQL grammar supported?
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn()
throws SQLException
Is "ALTER TABLE" with add column supported?
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn()
throws SQLException
Is "ALTER TABLE" with drop column supported?
supportsBatchUpdates
public boolean supportsBatchUpdates()
throws SQLException
JDBC 2.0 Indicates whether the driver supports batch updates.
true
if the driver supports batch updates;
false
otherwise
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation()
throws SQLException
Can a catalog name be used in a data manipulation statement?
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions()
throws SQLException
Can a catalog name be used in an index definition statement?
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions()
throws SQLException
Can a catalog name be used in a privilege definition statement?
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls()
throws SQLException
Can a catalog name be used in a procedure call statement?
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions()
throws SQLException
Can a catalog name be used in a table definition statement?
supportsColumnAliasing
public boolean supportsColumnAliasing()
throws SQLException
Retrieves whether this database supports column aliasing.
If so, the SQL AS clause can be used to provide names for computed
columns or to provide alias names for columns as required. A
JDBC-Compliant driver always returns true.
supportsConvert
public boolean supportsConvert()
throws SQLException
Is the CONVERT function between SQL types supported?
supportsConvert
public boolean supportsConvert(int fromType,
int toType)
throws SQLException
Is CONVERT between the given SQL types supported?
fromType
- the type to convert fromtoType
- the type to convert to
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar()
throws SQLException
Is the ODBC Core SQL grammar supported?
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries()
throws SQLException
Retrieves whether this database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions()
throws SQLException
Are both data definition and data manipulation statements within a
transaction supported?
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly()
throws SQLException
Are only data manipulation statements within a transaction supported?
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames()
throws SQLException
If table correlation names are supported, are they restricted to be
different from the names of the tables?
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy()
throws SQLException
Are expressions in "ORDER BY" lists supported?
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar()
throws SQLException
Is the ODBC Extended SQL grammar supported?
supportsFullOuterJoins
public boolean supportsFullOuterJoins()
throws SQLException
Are full nested outer joins supported?
supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys()
throws SQLException
Returns true
if getting auto-generated keys is supported after a
statment is executed; returns false
otherwise
supportsGroupBy
public boolean supportsGroupBy()
throws SQLException
Is some form of "GROUP BY" clause supported?
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect()
throws SQLException
Can a "GROUP BY" clause add columns not in the SELECT provided it
specifies all the columns in the SELECT?
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated()
throws SQLException
Can a "GROUP BY" clause use columns not in the SELECT?
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility()
throws SQLException
Is the SQL Integrity Enhancement Facility supported?
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause()
throws SQLException
Retrieves whether this database supports specifying a LIKE
escape clause.
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins()
throws SQLException
Retrieves whether this database provides limited support for outer
joins. (This will be true
if the method
supportsFullOuterJoins
returns true
).
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar()
throws SQLException
Retrieves whether this database supports the ODBC Minimum SQL grammar.
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers()
throws SQLException
Retrieves whether this database treats mixed case unquoted SQL identifiers as
case sensitive and as a result stores them in mixed case.
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers()
throws SQLException
Retrieves whether this database treats mixed case quoted SQL identifiers as
case sensitive and as a result stores them in mixed case.
supportsMultipleOpenResults
public boolean supportsMultipleOpenResults()
throws SQLException
Returns true
if Callable statements can return multiple result sets;
returns false
if they can only return one result set.
supportsMultipleResultSets
public boolean supportsMultipleResultSets()
throws SQLException
Are multiple ResultSets from a single execute supported?
supportsMultipleTransactions
public boolean supportsMultipleTransactions()
throws SQLException
Can we have multiple transactions open at once (on different
connections)?
supportsNamedParameters
public boolean supportsNamedParameters()
throws SQLException
Returns true
if the database supports named parameters;
returns false
if the database does not support named parameters.
supportsNonNullableColumns
public boolean supportsNonNullableColumns()
throws SQLException
Retrieves whether columns in this database may be defined as non-nullable.
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit()
throws SQLException
Can cursors remain open across commits?
true
if cursors always remain open;
false
if they might not remain open
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback()
throws SQLException
Can cursors remain open across rollbacks?
true
if cursors always remain open;
false
if they might not remain open
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit()
throws SQLException
Can statements remain open across commits?
true
if statements always remain open;
false
if they might not remain open
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback()
throws SQLException
Can statements remain open across rollbacks?
true
if statements always remain open;
false
if they might not remain open
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated()
throws SQLException
Can an "ORDER BY" clause use columns not in the SELECT?
supportsOuterJoins
public boolean supportsOuterJoins()
throws SQLException
Is some form of outer join supported?
supportsPositionedDelete
public boolean supportsPositionedDelete()
throws SQLException
Is positioned DELETE supported?
supportsPositionedUpdate
public boolean supportsPositionedUpdate()
throws SQLException
Is positioned UPDATE supported?
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int type,
int concurrency)
throws SQLException
Does the database support the concurrency type in combination with the
given result set type?
Supported concurrencies for SQL Server:
JDBC concurrency | SQL Server concurrency | Row locks | Description |
CONCUR_READ_ONLY | Read only | No | Read-only. |
CONCUR_UPDATABLE | Optimistic concurrency, updatable | No | Row integrity checked with timestamp comparison or, when not available, value comparison (except text and image fields). |
CONCUR_UPDATABLE+1 | Pessimistic concurrency, updatable | Yes | Row integrity is ensured by locking rows. |
CONCUR_UPDATABLE+2 | Optimistic concurrency, updatable | No | Row integrity checked with value comparison (except text and image fields). |
type
- defined in java.sql.ResultSet
concurrency
- type defined in java.sql.ResultSet
true
if so; false
otherwise
supportsResultSetHoldability
public boolean supportsResultSetHoldability(int param)
throws SQLException
supportsResultSetType
public boolean supportsResultSetType(int type)
throws SQLException
Does the database support the given result set type?
Supported types for SQL Server:
JDBC type | SQL Server cursor type | Server load | Description |
TYPE_FORWARD_ONLY | Forward-only, dynamic (fast forward-only, static with useCursors=true ) | Light | Fast, will read all data (less fast, doesn't read all data with useCursors=true ). Forward only. |
TYPE_SCROLL_INSENSITIVE | Static cursor | Heavy | Only use with CONCUR_READ_ONLY. SQL Server generates a temporary table, so changes made by others are not visible. Scrollable. |
TYPE_SCROLL_SENSITIVE | Keyset cursor | Medium | Others' updates or deletes visible, but not others' inserts. Scrollable. |
TYPE_SCROLL_SENSITIVE + 1 | Dynamic cursor | Heavy | Others' updates, deletes and inserts visible. Scrollable. |
type
- defined in java.sql.ResultSet
true
if so; false
otherwise
supportsSavepoints
public boolean supportsSavepoints()
throws SQLException
Returns true
if savepoints are supported; returns
false
otherwise
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation()
throws SQLException
Can a schema name be used in a data manipulation statement?
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions()
throws SQLException
Can a schema name be used in an index definition statement?
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions()
throws SQLException
Can a schema name be used in a privilege definition statement?
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls()
throws SQLException
Can a schema name be used in a procedure call statement?
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions()
throws SQLException
Can a schema name be used in a table definition statement?
supportsSelectForUpdate
public boolean supportsSelectForUpdate()
throws SQLException
Is SELECT for UPDATE supported?
supportsStatementPooling
public boolean supportsStatementPooling()
throws SQLException
Returns true
if the database supports statement pooling;
returns false
otherwise.
supportsStoredProcedures
public boolean supportsStoredProcedures()
throws SQLException
Are stored procedure calls using the stored procedure escape syntax
supported?
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons()
throws SQLException
Retrieves whether this database supports subqueries in comparison
expressions.
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists()
throws SQLException
Retrieves whether this database supports subqueries in
EXISTS
expressions.
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns()
throws SQLException
Retrieves whether this database supports subqueries in
IN
statements.
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds()
throws SQLException
Retrieves whether this database supports subqueries in quantified
expressions.
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames()
throws SQLException
Retrieves whether this database supports table correlation names.
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level)
throws SQLException
Does the database support the given transaction isolation level?
level
- the values are defined in java.sql.Connection
supportsTransactions
public boolean supportsTransactions()
throws SQLException
Retrieves whether this database supports transactions. If not, invoking the
method commit
is a noop, and the isolation level is
TRANSACTION_NONE
.
true
if transactions are supported
supportsUnion
public boolean supportsUnion()
throws SQLException
Is SQL UNION supported?
supportsUnionAll
public boolean supportsUnionAll()
throws SQLException
Is SQL UNION ALL supported?
syscall
private String syscall(String catalog,
String call)
Format the supplied procedure call as a valid JDBC call escape.
catalog
- the database name or nullcall
- the stored procedure call to format
- the formatted call escape as a
String
updatesAreDetected
public boolean updatesAreDetected(int type)
throws SQLException
JDBC 2.0 Indicates whether or not a visible row update can be detected
by calling the method ResultSet.rowUpdated
.
true
if changes are detected by the
result set type; false
otherwise
upperCaseColumnNames
private static void upperCaseColumnNames(JtdsResultSet results)
throws SQLException
Uppercase all column names.
Sybase returns column names in lowecase while the JDBC standard suggests
they should be uppercase.
results
- the result set to modify
usesLocalFilePerTable
public boolean usesLocalFilePerTable()
throws SQLException
Does the database use a file for each table?
true
if the database uses a local file for each
table
usesLocalFiles
public boolean usesLocalFiles()
throws SQLException
Does the database store tables in a local file?