com.sas.rio
Class MVADatabaseMetaData
java.lang.Object
|
+--com.sas.rio.MVADatabaseMetaData
- Direct Known Subclasses:
- LDAPDatabaseMetaData
- public class MVADatabaseMetaData
- extends java.lang.Object
- implements java.sql.DatabaseMetaData
This class provides information about the database as a whole.
Many of the methods here return lists of information in ResultSets.
You can use the normal ResultSet methods such as getString and getInt
to retrieve the data from these ResultSets. If a given form of
metadata is not available, these methods should throw a SQLException.
Some of these methods take arguments that are String patterns. These
arguments all have names such as fooPattern. Within a pattern String, "%"
means match any substring of 0 or more characters, and "_" means match
any one character. Only metadata entries matching the search pattern
are returned. If a search pattern argument is set to a null ref, it means
that argument's criteria should be dropped from the search.
A SQLException will be thrown if a driver does not support a meta
data method. In the case of methods that return a ResultSet,
either a ResultSet (which may be empty) is returned or a
SQLException is thrown.
Fields inherited from interface java.sql.DatabaseMetaData |
bestRowNotPseudo,
bestRowPseudo,
bestRowSession,
bestRowTemporary,
bestRowTransaction,
bestRowUnknown,
columnNoNulls,
columnNullable,
columnNullableUnknown,
importedKeyCascade,
importedKeyInitiallyDeferred,
importedKeyInitiallyImmediate,
importedKeyNoAction,
importedKeyNotDeferrable,
importedKeyRestrict,
importedKeySetDefault,
importedKeySetNull,
procedureColumnIn,
procedureColumnInOut,
procedureColumnOut,
procedureColumnResult,
procedureColumnReturn,
procedureColumnUnknown,
procedureNoNulls,
procedureNoResult,
procedureNullable,
procedureNullableUnknown,
procedureResultUnknown,
procedureReturnsResult,
tableIndexClustered,
tableIndexHashed,
tableIndexOther,
tableIndexStatistic,
typeNoNulls,
typeNullable,
typeNullableUnknown,
typePredBasic,
typePredChar,
typePredNone,
typeSearchable,
versionColumnNotPseudo,
versionColumnPseudo,
versionColumnUnknown |
Method Summary |
boolean |
allProceduresAreCallable()
Determines whether all stored procedures are callable. |
boolean |
allTablesAreSelectable()
Determines whether all accessible tables are selectable. |
boolean |
dataDefinitionCausesTransactionCommit()
Determines whether a data definition statement within a transaction forces the
transaction to commit. |
boolean |
dataDefinitionIgnoredInTransactions()
Determines whether a data definition statement within a transaction is ignored. |
boolean |
deletesAreDetected(int type)
JDBC 2.0
Determines whether or not a visible row delete can be detected by
calling ResultSet.rowDeleted(). |
boolean |
doesMaxRowSizeIncludeBlobs()
Determines whether getMaxRowSize() includes LONGVARCHAR and LONGVARBINARY
blobs. |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
Gets a description of a table's optimal set of columns that
uniquely identifies a row. |
java.sql.ResultSet |
getCatalogs()
Gets the catalog names that are available in this database. |
java.lang.String |
getCatalogSeparator()
Gets the separator that is being used between the catalog name and the table name. |
java.lang.String |
getCatalogTerm()
Gets the preferred term for "catalog". |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
Gets a description of the access rights for a table's columns. |
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
Gets a description of table columns available in a catalog. |
java.sql.Connection |
getConnection()
JDBC 2.0
Gets the connection that produced this metadata object. |
java.sql.ResultSet |
getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
Gets a description of the foreign key columns in the foreign key
table that reference the primary key columns of the primary key table. |
java.lang.String |
getDatabaseProductName()
Gets the database product name. |
java.lang.String |
getDatabaseProductVersion()
TODO:
Returns the version of the MVA server. |
int |
getDefaultTransactionIsolation()
Gets the default transaction isolation level for the database. |
int |
getDriverMajorVersion()
Gets the driver major version number as a string. |
int |
getDriverMinorVersion()
Gets the driver minor version number as a string. |
java.lang.String |
getDriverName()
Gets the driver name. |
java.lang.String |
getDriverVersion()
Gets the driver version number as a string. |
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Gets a description of a foreign key columns that reference a
table's primary key columns. |
java.lang.String |
getExtraNameCharacters()
Gets a string that contains all the "extra" characters that identier names can contain. |
java.lang.String |
getIdentifierQuoteString()
Gets the quote string that is used to surround quoted SQL identifiers. |
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Gets a description of the primary key columns that are
referenced by a table's foreign key columns. |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
Gets a description of a table's indices and statistics. |
int |
getMaxBinaryLiteralLength()
Returns the number of hex characters that are allowed in an inline binary literal. |
int |
getMaxCatalogNameLength()
Indicates the maximum length of a catalog name. |
int |
getMaxCharLiteralLength()
Returns the maximum length of a character literal. |
int |
getMaxColumnNameLength()
Returns the maximum length of a column name. |
int |
getMaxColumnsInGroupBy()
Indicates the maximum number of columns that are allowed in a GROUP BY clause. |
int |
getMaxColumnsInIndex()
Indicates the maximum number of columns that are allowed in an index. |
int |
getMaxColumnsInOrderBy()
Indicates the maximum number of columns that are allowed in an ORDER BY clause. |
int |
getMaxColumnsInSelect()
Determines the maximum number of columns that are allowed in a SELECT list. |
int |
getMaxColumnsInTable()
Indicates the maximum number of columns that are allowed in a table. |
int |
getMaxConnections()
Indicates the maximum number of database connections that can be active concurrently. |
int |
getMaxCursorNameLength()
Indicates the maximum length of a cursor name. |
int |
getMaxIndexLength()
Indicates the maximum size of an index (in bytes). |
int |
getMaxProcedureNameLength()
Indicates the maximum length of a procedure name. |
int |
getMaxRowSize()
Indicates the maximum length of a single row. |
int |
getMaxSchemaNameLength()
Indicates the maximum length of a schema name. |
int |
getMaxStatementLength()
Indicates the maximum length of an SQL statement. |
int |
getMaxStatements()
Indicates the maximum number of active statements that can be open to this database
concurrently. |
int |
getMaxTableNameLength()
Indicates the maximum length of a table name. |
int |
getMaxTablesInSelect()
Indicates the maximum number of tables in a SELECT list. |
int |
getMaxUserNameLength()
Indicates the maximum length of a user name. |
java.lang.String |
getNumericFunctions()
Gets a comma-delimited list of math functions. |
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Gets a description of a table's primary key columns. |
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
Gets a description of a catalog's stored procedure parameters
and result columns. |
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
Get a description of stored procedures available in a catalog. |
java.lang.String |
getProcedureTerm()
Gets the preferred term for "procedure". |
java.sql.ResultSet |
getSchemas()
Gets the schema names available in this database. |
java.lang.String |
getSchemaTerm()
Gets the preferred term for "schema". |
java.lang.String |
getSearchStringEscape()
Gets the string that can be used to escape an underscore (_) or a percentage sign (%) in
string based searches such as getTables(). |
java.lang.String |
getSQLKeywords()
Gets a comma-delimited list of all database-specific SQL keywords
that are not SQL92 keywords. |
java.lang.String |
getStringFunctions()
Gets a comma-delimited list of string functions. |
java.lang.String |
getSystemFunctions()
Gets a comma-delimited list of system functions. |
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Gets a description of the access rights each table available
in a catalog. |
java.sql.ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
Gets a description of the tables that are available in a catalog. |
java.sql.ResultSet |
getTableTypes()
Gets the table types available in this database. |
java.lang.String |
getTimeDateFunctions()
Gets a comma-delimited list of time and date functions. |
java.sql.ResultSet |
getTypeInfo()
Gets a description of all the standard SQL types supported by
this database. |
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
JDBC 2.0
Gets a description of the user-defined types defined in a particular
schema. |
java.lang.String |
getURL()
Gets the URL from the MVAConnection object. |
java.lang.String |
getUserName()
Gets the user name from the MVAConnection object. |
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Gets a description of the table columns that are automatically
updated when any value in a row is updated. |
boolean |
insertsAreDetected(int type)
JDBC 2.0
Determines whether or not a visible row insert can be detected
by calling ResultSet.rowInserted(). |
boolean |
isCatalogAtStart()
Determines whether a catalog appears at the start of a qualified table name. |
boolean |
isReadOnly()
TODO: is this right ???
Determines whether the connection is read-only. |
boolean |
nullPlusNonNullIsNull()
Determines whether the concatenations between NULL and non-NULL values are NULL. |
boolean |
nullsAreSortedAtEnd()
Determines whether NULLs are sorted at end. |
boolean |
nullsAreSortedAtStart()
Determines whether NULLs are sorted at start. |
boolean |
nullsAreSortedHigh()
Determines whether NULLs are sorted high. |
boolean |
nullsAreSortedLow()
Determines whether NULLs are sorted low. |
boolean |
othersDeletesAreVisible(int type)
JDBC 2.0
Determines whether changes made by others are visible. |
boolean |
othersInsertsAreVisible(int type)
JDBC 2.0
Determines whether changes made by others are visible. |
boolean |
othersUpdatesAreVisible(int type)
JDBC 2.0
Determines whether changes made by others are visible. |
boolean |
ownDeletesAreVisible(int type)
JDBC 2.0
Determines whether a result set's own changes are visible. |
boolean |
ownInsertsAreVisible(int type)
JDBC 2.0
Determines whether a result set's own changes are visible. |
boolean |
ownUpdatesAreVisible(int type)
JDBC 2.0
Determines whether a result set's own changes are visible. |
boolean |
storesLowerCaseIdentifiers()
Determines whether the database stores lowercase identifiers. |
boolean |
storesLowerCaseQuotedIdentifiers()
Determines whether the database stores lowercase quoted SQL identifiers. |
boolean |
storesMixedCaseIdentifiers()
Determines whether the database stores mixed-case identifiers. |
boolean |
storesMixedCaseQuotedIdentifiers()
Determines whether the database stores mixed-case quoted SQL identifiers. |
boolean |
storesUpperCaseIdentifiers()
Determines whether the database stores uppercase identifiers. |
boolean |
storesUpperCaseQuotedIdentifiers()
Determines whether the database stores uppercase quoted SQL identifiers. |
boolean |
supportsAlterTableWithAddColumn()
Determines whether ALTER TABLE with an add column is supported. |
boolean |
supportsAlterTableWithDropColumn()
Determines whether ALTER TABLE with a drop column is supported. |
boolean |
supportsANSI92EntryLevelSQL()
Determines whether ANSI92 entry level SQL grammar is supported. |
boolean |
supportsANSI92FullSQL()
Determines whether ANSI92 full SQL grammar is supported. |
boolean |
supportsANSI92IntermediateSQL()
Determines whether ANSI92 intermediate SQL grammar is supported. |
boolean |
supportsBatchUpdates()
JDBC 2.0
Determines if the database supports batch updates. |
boolean |
supportsCatalogsInDataManipulation()
Determines whether a data manipulation statement can contain a catalog name. |
boolean |
supportsCatalogsInIndexDefinitions()
Determines whether an index definition statement can contain a catalog name. |
boolean |
supportsCatalogsInPrivilegeDefinitions()
Determines whether a privilege definition statement can contain a catalog name. |
boolean |
supportsCatalogsInProcedureCalls()
Determines whether a procedure call statement can contain a catalog name. |
boolean |
supportsCatalogsInTableDefinitions()
Determines whether a table definition statement can contain a catalog name. |
boolean |
supportsColumnAliasing()
Determines whether column aliasing is supported. |
boolean |
supportsConvert()
Determines whether the CONVERT function for conversions between SQL types is supported. |
boolean |
supportsConvert(int fromType,
int toType)
Determines whether the CONVERT function for conversions between the given SQL types from
java.sql.Types is supported. |
boolean |
supportsCoreSQLGrammar()
Determines whether the ODBC Core SQL grammar is supported. |
boolean |
supportsCorrelatedSubqueries()
Determines whether correlated subqueries are supported. |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Determines whether both data definition and data manipulation statements
within a transaction are supported. |
boolean |
supportsDataManipulationTransactionsOnly()
Determines whether data manipulation statements within a transaction are
supported. |
boolean |
supportsDifferentTableCorrelationNames()
When table correlation names are supported, determines whether table correlation names must
be different from the table names. |
boolean |
supportsExpressionsInOrderBy()
Determines whether expressions are supported in "ORDER BY" lists. |
boolean |
supportsExtendedSQLGrammar()
Determines whether the ODBC Extended SQL grammar is supported. |
boolean |
supportsFullOuterJoins()
Determines whether full, nested outer joins are supported. |
boolean |
supportsGroupBy()
Determines whether some form of the GROUP BY clause is supported. |
boolean |
supportsGroupByBeyondSelect()
Determines whether a GROUP BY clause can add columns that are not in the SELECT list. |
boolean |
supportsGroupByUnrelated()
Detrmines whether GROUP BY clause can use columns that are not in the SELECT list. |
boolean |
supportsIntegrityEnhancementFacility()
Determines whether the SQL Integrity Enhancement Facility is supported. |
boolean |
supportsLikeEscapeClause()
Determines whether the escape character in LIKE clauses is supported. |
boolean |
supportsLimitedOuterJoins()
Determines whether there is limited support for outer joins. |
boolean |
supportsMinimumSQLGrammar()
Determines whether the ODBC Minimum SQL grammar is supported. |
boolean |
supportsMixedCaseIdentifiers()
Determines whether the database supports mixed-case, unquoted SQL identifiers. |
boolean |
supportsMixedCaseQuotedIdentifiers()
Determines whether the database supports mixed-case quoted SQL identifiers. |
boolean |
supportsMultipleResultSets()
Determines whether mulitple ResultSets from a single execute are supported. |
boolean |
supportsMultipleTransactions()
Determines whether multiple transactions can be open concurrently. |
boolean |
supportsNonNullableColumns()
Determines whether columns can support NULLs. |
boolean |
supportsOpenCursorsAcrossCommit()
Determines whether cursors can remain open across commits. |
boolean |
supportsOpenCursorsAcrossRollback()
Determines whether cursors can remain open across rollback. |
boolean |
supportsOpenStatementsAcrossCommit()
Determines whether statements can remain open across commits. |
boolean |
supportsOpenStatementsAcrossRollback()
Determines whether statements can remain open across rollbacks. |
boolean |
supportsOrderByUnrelated()
Determines whether an ORDER BY clause can use columns that are not in the SELECT list. |
boolean |
supportsOuterJoins()
Determines whether some form of outer join is supported. |
boolean |
supportsPositionedDelete()
Determines whether positioned DELETE is supported. |
boolean |
supportsPositionedUpdate()
Determines whether positioned UPDATE is supported. |
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
JDBC 2.0
Determines if the database supports the concurrency type in combination
with the given result set type. |
boolean |
supportsResultSetType(int type)
JDBC 2.0
Determines if the database supports the given result set type. |
boolean |
supportsSchemasInDataManipulation()
Determines whether a data manipulation statementcaon contain a schema name. |
boolean |
supportsSchemasInIndexDefinitions()
Determines whether an index definition statement can contain a schema name. |
boolean |
supportsSchemasInPrivilegeDefinitions()
Determines whether a privilege definition statement can contain a schema name. |
boolean |
supportsSchemasInProcedureCalls()
Determines whether a procedure call statement can contain a schema name. |
boolean |
supportsSchemasInTableDefinitions()
Determines whether a table definition statement can contain a schema name. |
boolean |
supportsSelectForUpdate()
Determines whether SELECT for UPDATE is supported. |
boolean |
supportsStoredProcedures()
Determines whether stored procedure calls that use the stored procedure escape
syntax are supported. |
boolean |
supportsSubqueriesInComparisons()
Determines whether subqueries in comparison expressions are supported. |
boolean |
supportsSubqueriesInExists()
Determines whether subqueries in exists expressions are supported. |
boolean |
supportsSubqueriesInIns()
Determines whether subqueries in "in" statements are supported. |
boolean |
supportsSubqueriesInQuantifieds()
Determines whether subqueries in quantified expressions are supported. |
boolean |
supportsTableCorrelationNames()
Determines whether table correlation names are supported. |
boolean |
supportsTransactionIsolationLevel(int level)
Determines whether the database supports the transaction isolation level. |
boolean |
supportsTransactions()
Determines whether transactions are supported. |
boolean |
supportsUnion()
Determines whether an SQL UNION is supported. |
boolean |
supportsUnionAll()
Determines whether an SQL UNION ALL is supported. |
boolean |
updatesAreDetected(int type)
JDBC 2.0
Determines whether or not a visible row update can be detected by
calling ResultSet.rowUpdated(). |
boolean |
usesLocalFilePerTable()
Determines whether the database uses a file for each table. |
boolean |
usesLocalFiles()
Determines whether the database stores each table in a local file. |
Methods inherited from class java.lang.Object |
equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
bookmarkLength
public long bookmarkLength
status
public long status
bookmarkLengthHolder
public org.omg.CORBA.IntHolder bookmarkLengthHolder
sasDataSet
public com.sas.iom.SAS.IDataSet sasDataSet
MVADatabaseMetaData
public MVADatabaseMetaData(MVAConnection connection)
throws java.sql.SQLException
- Constructs MVADatabaseMetaData object.
- Parameters:
connection
- MVAConnection object- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
allProceduresAreCallable
public boolean allProceduresAreCallable()
throws java.sql.SQLException
- Determines whether all stored procedures are callable.
- Specified by:
- allProceduresAreCallable in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support stored procedures.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
allTablesAreSelectable
public boolean allTablesAreSelectable()
throws java.sql.SQLException
- Determines whether all accessible tables are selectable.
- Specified by:
- allTablesAreSelectable in interface java.sql.DatabaseMetaData
- Returns:
- True. All accessable tables are selectable.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getURL
public java.lang.String getURL()
throws java.sql.SQLException
- Gets the URL from the MVAConnection object.
- Specified by:
- getURL in interface java.sql.DatabaseMetaData
- Returns:
- The URL that is obtained from the MVAConnection object.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getUserName
public java.lang.String getUserName()
throws java.sql.SQLException
- Gets the user name from the MVAConnection object.
- Specified by:
- getUserName in interface java.sql.DatabaseMetaData
- Returns:
- The user name that is obtained from the MVAConnection object.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
isReadOnly
public boolean isReadOnly()
throws java.sql.SQLException
- TODO: is this right ???
Determines whether the connection is read-only.
- Specified by:
- isReadOnly in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support read-only connections.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
nullsAreSortedHigh
public boolean nullsAreSortedHigh()
throws java.sql.SQLException
- Determines whether NULLs are sorted high.
- Specified by:
- nullsAreSortedHigh in interface java.sql.DatabaseMetaData
- Returns:
- False. NULLs are sorted low.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
nullsAreSortedLow
public boolean nullsAreSortedLow()
throws java.sql.SQLException
- Determines whether NULLs are sorted low.
- Specified by:
- nullsAreSortedLow in interface java.sql.DatabaseMetaData
- Returns:
- True. NULLs are sorted low.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart()
throws java.sql.SQLException
- Determines whether NULLs are sorted at start.
- Specified by:
- nullsAreSortedAtStart in interface java.sql.DatabaseMetaData
- Returns:
- False. NULLs are sorted low
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd()
throws java.sql.SQLException
- Determines whether NULLs are sorted at end.
- Specified by:
- nullsAreSortedAtEnd in interface java.sql.DatabaseMetaData
- Returns:
- False. NULLs are sorted low
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getDatabaseProductName
public java.lang.String getDatabaseProductName()
throws java.sql.SQLException
- Gets the database product name.
- Specified by:
- getDatabaseProductName in interface java.sql.DatabaseMetaData
- Returns:
- The string "SAS".
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getDatabaseProductVersion
public java.lang.String getDatabaseProductVersion()
throws java.sql.SQLException
- TODO:
Returns the version of the MVA server.
- Specified by:
- getDatabaseProductVersion in interface java.sql.DatabaseMetaData
- Returns:
- A string that contains the version number from the MVA server.
- Throws:
- java.sql.SQLException - This exception is thrown if an error condition is detected or if the
server does not respond.
getDriverName
public java.lang.String getDriverName()
throws java.sql.SQLException
- Gets the driver name.
- Specified by:
- getDriverName in interface java.sql.DatabaseMetaData
- Returns:
- the the driver name.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getDriverVersion
public java.lang.String getDriverVersion()
throws java.sql.SQLException
- Gets the driver version number as a string.
- Specified by:
- getDriverVersion in interface java.sql.DatabaseMetaData
- Returns:
- String "1.0".
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getDriverMajorVersion
public int getDriverMajorVersion()
- Gets the driver major version number as a string.
- Specified by:
- getDriverMajorVersion in interface java.sql.DatabaseMetaData
- Returns:
- 1.
getDriverMinorVersion
public int getDriverMinorVersion()
- Gets the driver minor version number as a string.
- Specified by:
- getDriverMinorVersion in interface java.sql.DatabaseMetaData
- Returns:
- 0.
usesLocalFiles
public boolean usesLocalFiles()
throws java.sql.SQLException
- Determines whether the database stores each table in a local file.
- Specified by:
- usesLocalFiles in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
usesLocalFilePerTable
public boolean usesLocalFilePerTable()
throws java.sql.SQLException
- Determines whether the database uses a file for each table.
- Specified by:
- usesLocalFilePerTable in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers()
throws java.sql.SQLException
- Determines whether the database supports mixed-case, unquoted SQL identifiers.
- Specified by:
- supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers()
throws java.sql.SQLException
- Determines whether the database stores uppercase identifiers.
- Specified by:
- storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers()
throws java.sql.SQLException
- Determines whether the database stores lowercase identifiers.
- Specified by:
- storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers()
throws java.sql.SQLException
- Determines whether the database stores mixed-case identifiers.
- Specified by:
- storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers()
throws java.sql.SQLException
- Determines whether the database supports mixed-case quoted SQL identifiers.
- Specified by:
- supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers()
throws java.sql.SQLException
- Determines whether the database stores uppercase quoted SQL identifiers.
- Specified by:
- storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers()
throws java.sql.SQLException
- Determines whether the database stores lowercase quoted SQL identifiers.
- Specified by:
- storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers()
throws java.sql.SQLException
- Determines whether the database stores mixed-case quoted SQL identifiers.
- Specified by:
- storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getIdentifierQuoteString
public java.lang.String getIdentifierQuoteString()
throws java.sql.SQLException
- Gets the quote string that is used to surround quoted SQL identifiers.
SAS software does not support quoted identifiers, so a blank is
returned.
- Specified by:
- getIdentifierQuoteString in interface java.sql.DatabaseMetaData
- Returns:
- A blank string (" ").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getSQLKeywords
public java.lang.String getSQLKeywords()
throws java.sql.SQLException
- Gets a comma-delimited list of all database-specific SQL keywords
that are not SQL92 keywords.
- Specified by:
- getSQLKeywords in interface java.sql.DatabaseMetaData
- Returns:
- An empty string (""). No additional keywords are reserved.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getNumericFunctions
public java.lang.String getNumericFunctions()
throws java.sql.SQLException
- Gets a comma-delimited list of math functions.
- Specified by:
- getNumericFunctions in interface java.sql.DatabaseMetaData
- Returns:
- The string "ABS, ACOS, ASIN, ATAN, CEILING, COS, EXP, FLOOR, LOG, LOG10, MOD, POWER, RAND, ROUND, SIGN, SIN, SQRT, TAN"
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getStringFunctions
public java.lang.String getStringFunctions()
throws java.sql.SQLException
- Gets a comma-delimited list of string functions.
- Specified by:
- getStringFunctions in interface java.sql.DatabaseMetaData
- Returns:
- The string "ASCII, CHAR, CONCAT, LCASE, LEFT, LTRIM, REPEAT, REPLACE, RTRIM, SOUNDEX, SPACE, SUBSTRING, UCASE"
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getSystemFunctions
public java.lang.String getSystemFunctions()
throws java.sql.SQLException
- Gets a comma-delimited list of system functions.
SAS software does not support any system functions, so an
empty string is returned.
- Specified by:
- getSystemFunctions in interface java.sql.DatabaseMetaData
- Returns:
- An empty string ("").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getTimeDateFunctions
public java.lang.String getTimeDateFunctions()
throws java.sql.SQLException
- Gets a comma-delimited list of time and date functions.
- Specified by:
- getTimeDateFunctions in interface java.sql.DatabaseMetaData
- Returns:
- The string "CURDATE, CURTIME, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, MONTHNAME, NOW, QUARTER, SECOND, YEAR"
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getSearchStringEscape
public java.lang.String getSearchStringEscape()
throws java.sql.SQLException
- Gets the string that can be used to escape an underscore (_) or a percentage sign (%) in
string based searches such as getTables(). SAS software does not support any escape
characters for schema or table names, so an empty string is returned.
- Specified by:
- getSearchStringEscape in interface java.sql.DatabaseMetaData
- Returns:
- An empty string ("").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getExtraNameCharacters
public java.lang.String getExtraNameCharacters()
throws java.sql.SQLException
- Gets a string that contains all the "extra" characters that identier names can contain.
SAS software does not support any additional characters for names, so an
empty string is returned.
- Specified by:
- getExtraNameCharacters in interface java.sql.DatabaseMetaData
- Returns:
- An empty string ("").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn()
throws java.sql.SQLException
- Determines whether ALTER TABLE with an add column is supported.
- Specified by:
- supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn()
throws java.sql.SQLException
- Determines whether ALTER TABLE with a drop column is supported.
- Specified by:
- supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsColumnAliasing
public boolean supportsColumnAliasing()
throws java.sql.SQLException
- Determines whether column aliasing is supported.
- Specified by:
- supportsColumnAliasing in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull()
throws java.sql.SQLException
- Determines whether the concatenations between NULL and non-NULL values are NULL.
- Specified by:
- nullPlusNonNullIsNull in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsConvert
public boolean supportsConvert()
throws java.sql.SQLException
- Determines whether the CONVERT function for conversions between SQL types is supported.
- Specified by:
- supportsConvert in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsConvert
public boolean supportsConvert(int fromType,
int toType)
throws java.sql.SQLException
- Determines whether the CONVERT function for conversions between the given SQL types from
java.sql.Types is supported.
- Specified by:
- supportsConvert in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames()
throws java.sql.SQLException
- Determines whether table correlation names are supported.
- Specified by:
- supportsTableCorrelationNames in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames()
throws java.sql.SQLException
- When table correlation names are supported, determines whether table correlation names must
be different from the table names.
- Specified by:
- supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy()
throws java.sql.SQLException
- Determines whether expressions are supported in "ORDER BY" lists.
- Specified by:
- supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated()
throws java.sql.SQLException
- Determines whether an ORDER BY clause can use columns that are not in the SELECT list.
- Specified by:
- supportsOrderByUnrelated in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsGroupBy
public boolean supportsGroupBy()
throws java.sql.SQLException
- Determines whether some form of the GROUP BY clause is supported.
- Specified by:
- supportsGroupBy in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated()
throws java.sql.SQLException
- Detrmines whether GROUP BY clause can use columns that are not in the SELECT list.
- Specified by:
- supportsGroupByUnrelated in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect()
throws java.sql.SQLException
- Determines whether a GROUP BY clause can add columns that are not in the SELECT list.
- Specified by:
- supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause()
throws java.sql.SQLException
- Determines whether the escape character in LIKE clauses is supported.
- Specified by:
- supportsLikeEscapeClause in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsMultipleResultSets
public boolean supportsMultipleResultSets()
throws java.sql.SQLException
- Determines whether mulitple ResultSets from a single execute are supported.
- Specified by:
- supportsMultipleResultSets in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsMultipleTransactions
public boolean supportsMultipleTransactions()
throws java.sql.SQLException
- Determines whether multiple transactions can be open concurrently.
- Specified by:
- supportsMultipleTransactions in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsNonNullableColumns
public boolean supportsNonNullableColumns()
throws java.sql.SQLException
- Determines whether columns can support NULLs.
- Specified by:
- supportsNonNullableColumns in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar()
throws java.sql.SQLException
- Determines whether the ODBC Minimum SQL grammar is supported.
- Specified by:
- supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar()
throws java.sql.SQLException
- Determines whether the ODBC Core SQL grammar is supported.
- Specified by:
- supportsCoreSQLGrammar in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar()
throws java.sql.SQLException
- Determines whether the ODBC Extended SQL grammar is supported.
- Specified by:
- supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL()
throws java.sql.SQLException
- Determines whether ANSI92 entry level SQL grammar is supported.
- Specified by:
- supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL()
throws java.sql.SQLException
- Determines whether ANSI92 intermediate SQL grammar is supported.
- Specified by:
- supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL()
throws java.sql.SQLException
- Determines whether ANSI92 full SQL grammar is supported.
- Specified by:
- supportsANSI92FullSQL in interface java.sql.DatabaseMetaData
- Returns:
- False
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility()
throws java.sql.SQLException
- Determines whether the SQL Integrity Enhancement Facility is supported.
- Specified by:
- supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsOuterJoins
public boolean supportsOuterJoins()
throws java.sql.SQLException
- Determines whether some form of outer join is supported.
- Specified by:
- supportsOuterJoins in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsFullOuterJoins
public boolean supportsFullOuterJoins()
throws java.sql.SQLException
- Determines whether full, nested outer joins are supported.
- Specified by:
- supportsFullOuterJoins in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins()
throws java.sql.SQLException
- Determines whether there is limited support for outer joins.
- Specified by:
- supportsLimitedOuterJoins in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getSchemaTerm
public java.lang.String getSchemaTerm()
throws java.sql.SQLException
- Gets the preferred term for "schema".
- Specified by:
- getSchemaTerm in interface java.sql.DatabaseMetaData
- Returns:
- The string "library".
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getProcedureTerm
public java.lang.String getProcedureTerm()
throws java.sql.SQLException
- Gets the preferred term for "procedure".
- Specified by:
- getProcedureTerm in interface java.sql.DatabaseMetaData
- Returns:
- An empty string ("").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getCatalogTerm
public java.lang.String getCatalogTerm()
throws java.sql.SQLException
- Gets the preferred term for "catalog".
- Specified by:
- getCatalogTerm in interface java.sql.DatabaseMetaData
- Returns:
- An empty string ("").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
isCatalogAtStart
public boolean isCatalogAtStart()
throws java.sql.SQLException
- Determines whether a catalog appears at the start of a qualified table name.
- Specified by:
- isCatalogAtStart in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getCatalogSeparator
public java.lang.String getCatalogSeparator()
throws java.sql.SQLException
- Gets the separator that is being used between the catalog name and the table name.
- Specified by:
- getCatalogSeparator in interface java.sql.DatabaseMetaData
- Returns:
- An empty string ("").
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation()
throws java.sql.SQLException
- Determines whether a data manipulation statementcaon contain a schema name.
- Specified by:
- supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls()
throws java.sql.SQLException
- Determines whether a procedure call statement can contain a schema name.
- Specified by:
- supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support stored procedures.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions()
throws java.sql.SQLException
- Determines whether a table definition statement can contain a schema name.
- Specified by:
- supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions()
throws java.sql.SQLException
- Determines whether an index definition statement can contain a schema name.
- Specified by:
- supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions()
throws java.sql.SQLException
- Determines whether a privilege definition statement can contain a schema name.
- Specified by:
- supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support privileges.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation()
throws java.sql.SQLException
- Determines whether a data manipulation statement can contain a catalog name.
- Specified by:
- supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support SQL catalogs.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls()
throws java.sql.SQLException
- Determines whether a procedure call statement can contain a catalog name.
- Specified by:
- supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support SQL catalogs.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions()
throws java.sql.SQLException
- Determines whether a table definition statement can contain a catalog name.
- Specified by:
- supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support SQL catalogs.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions()
throws java.sql.SQLException
- Determines whether an index definition statement can contain a catalog name.
- Specified by:
- supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support SQL catalogs.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions()
throws java.sql.SQLException
- Determines whether a privilege definition statement can contain a catalog name.
- Specified by:
- supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support SQL catalogs.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsPositionedDelete
public boolean supportsPositionedDelete()
throws java.sql.SQLException
- Determines whether positioned DELETE is supported.
- Specified by:
- supportsPositionedDelete in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsPositionedUpdate
public boolean supportsPositionedUpdate()
throws java.sql.SQLException
- Determines whether positioned UPDATE is supported.
- Specified by:
- supportsPositionedUpdate in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSelectForUpdate
public boolean supportsSelectForUpdate()
throws java.sql.SQLException
- Determines whether SELECT for UPDATE is supported.
- Specified by:
- supportsSelectForUpdate in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsStoredProcedures
public boolean supportsStoredProcedures()
throws java.sql.SQLException
- Determines whether stored procedure calls that use the stored procedure escape
syntax are supported.
- Specified by:
- supportsStoredProcedures in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons()
throws java.sql.SQLException
- Determines whether subqueries in comparison expressions are supported.
- Specified by:
- supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists()
throws java.sql.SQLException
- Determines whether subqueries in exists expressions are supported.
- Specified by:
- supportsSubqueriesInExists in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns()
throws java.sql.SQLException
- Determines whether subqueries in "in" statements are supported.
- Specified by:
- supportsSubqueriesInIns in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds()
throws java.sql.SQLException
- Determines whether subqueries in quantified expressions are supported.
- Specified by:
- supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries()
throws java.sql.SQLException
- Determines whether correlated subqueries are supported.
- Specified by:
- supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsUnion
public boolean supportsUnion()
throws java.sql.SQLException
- Determines whether an SQL UNION is supported.
- Specified by:
- supportsUnion in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsUnionAll
public boolean supportsUnionAll()
throws java.sql.SQLException
- Determines whether an SQL UNION ALL is supported.
- Specified by:
- supportsUnionAll in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit()
throws java.sql.SQLException
- Determines whether cursors can remain open across commits.
- Specified by:
- supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback()
throws java.sql.SQLException
- Determines whether cursors can remain open across rollback.
- Specified by:
- supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit()
throws java.sql.SQLException
- Determines whether statements can remain open across commits.
- Specified by:
- supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback()
throws java.sql.SQLException
- Determines whether statements can remain open across rollbacks.
- Specified by:
- supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaData
- Returns:
- True. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength()
throws java.sql.SQLException
- Returns the number of hex characters that are allowed in an inline binary literal.
- Specified by:
- getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxCharLiteralLength
public int getMaxCharLiteralLength()
throws java.sql.SQLException
- Returns the maximum length of a character literal.
- Specified by:
- getMaxCharLiteralLength in interface java.sql.DatabaseMetaData
- Returns:
- 32767.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxColumnNameLength
public int getMaxColumnNameLength()
throws java.sql.SQLException
- Returns the maximum length of a column name.
- Specified by:
- getMaxColumnNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 32.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy()
throws java.sql.SQLException
- Indicates the maximum number of columns that are allowed in a GROUP BY clause.
- Specified by:
- getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxColumnsInIndex
public int getMaxColumnsInIndex()
throws java.sql.SQLException
- Indicates the maximum number of columns that are allowed in an index.
- Specified by:
- getMaxColumnsInIndex in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy()
throws java.sql.SQLException
- Indicates the maximum number of columns that are allowed in an ORDER BY clause.
- Specified by:
- getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxColumnsInSelect
public int getMaxColumnsInSelect()
throws java.sql.SQLException
- Determines the maximum number of columns that are allowed in a SELECT list.
- Specified by:
- getMaxColumnsInSelect in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxColumnsInTable
public int getMaxColumnsInTable()
throws java.sql.SQLException
- Indicates the maximum number of columns that are allowed in a table.
- Specified by:
- getMaxColumnsInTable in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxConnections
public int getMaxConnections()
throws java.sql.SQLException
- Indicates the maximum number of database connections that can be active concurrently.
- Specified by:
- getMaxConnections in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxCursorNameLength
public int getMaxCursorNameLength()
throws java.sql.SQLException
- Indicates the maximum length of a cursor name.
- Specified by:
- getMaxCursorNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 0. SAS software does not support cursors.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxIndexLength
public int getMaxIndexLength()
throws java.sql.SQLException
- Indicates the maximum size of an index (in bytes).
- Specified by:
- getMaxIndexLength in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxSchemaNameLength
public int getMaxSchemaNameLength()
throws java.sql.SQLException
- Indicates the maximum length of a schema name.
- Specified by:
- getMaxSchemaNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 8.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxProcedureNameLength
public int getMaxProcedureNameLength()
throws java.sql.SQLException
- Indicates the maximum length of a procedure name.
- Specified by:
- getMaxProcedureNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 0. SAS software does not support stored procedures.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxCatalogNameLength
public int getMaxCatalogNameLength()
throws java.sql.SQLException
- Indicates the maximum length of a catalog name.
- Specified by:
- getMaxCatalogNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 0. SAS software does not support SQL catalogs.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxRowSize
public int getMaxRowSize()
throws java.sql.SQLException
- Indicates the maximum length of a single row.
- Specified by:
- getMaxRowSize in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs()
throws java.sql.SQLException
- Determines whether getMaxRowSize() includes LONGVARCHAR and LONGVARBINARY
blobs.
- Specified by:
- doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaData
- Returns:
- True.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxStatementLength
public int getMaxStatementLength()
throws java.sql.SQLException
- Indicates the maximum length of an SQL statement.
- Specified by:
- getMaxStatementLength in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxStatements
public int getMaxStatements()
throws java.sql.SQLException
- Indicates the maximum number of active statements that can be open to this database
concurrently.
- Specified by:
- getMaxStatements in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxTableNameLength
public int getMaxTableNameLength()
throws java.sql.SQLException
- Indicates the maximum length of a table name.
- Specified by:
- getMaxTableNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 32.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxTablesInSelect
public int getMaxTablesInSelect()
throws java.sql.SQLException
- Indicates the maximum number of tables in a SELECT list.
- Specified by:
- getMaxTablesInSelect in interface java.sql.DatabaseMetaData
- Returns:
- 0. There is no limit.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getMaxUserNameLength
public int getMaxUserNameLength()
throws java.sql.SQLException
- Indicates the maximum length of a user name.
- Specified by:
- getMaxUserNameLength in interface java.sql.DatabaseMetaData
- Returns:
- 8.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation()
throws java.sql.SQLException
- Gets the default transaction isolation level for the database.
- Specified by:
- getDefaultTransactionIsolation in interface java.sql.DatabaseMetaData
- Returns:
- java.sql.Connection.TRANSACTION_NONE
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsTransactions
public boolean supportsTransactions()
throws java.sql.SQLException
- Determines whether transactions are supported.
- Specified by:
- supportsTransactions in interface java.sql.DatabaseMetaData
- Returns:
- False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level)
throws java.sql.SQLException
- Determines whether the database supports the transaction isolation level.
- Specified by:
- supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaData
- Returns:
- True if the transaction isolation level is set to java.sql.Connection.TRANSACTION_NONE, else False.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions()
throws java.sql.SQLException
- Determines whether both data definition and data manipulation statements
within a transaction are supported.
- Specified by:
- supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly()
throws java.sql.SQLException
- Determines whether data manipulation statements within a transaction are
supported.
- Specified by:
- supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit()
throws java.sql.SQLException
- Determines whether a data definition statement within a transaction forces the
transaction to commit.
- Specified by:
- dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions()
throws java.sql.SQLException
- Determines whether a data definition statement within a transaction is ignored.
- Specified by:
- dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaData
- Returns:
- False. SAS software does not support transactions.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getProcedures
public java.sql.ResultSet getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
throws java.sql.SQLException
- Get a description of stored procedures available in a catalog. This method is not
supported.
- Specified by:
- getProcedures in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getProcedureColumns
public java.sql.ResultSet getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
- Gets a description of a catalog's stored procedure parameters
and result columns. This method is not supported.
- Specified by:
- getProcedureColumns in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getTables
public java.sql.ResultSet getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
throws java.sql.SQLException
- Gets a description of the tables that are available in a catalog.
Only table descriptions that match the catalog, schema, table
name, and type criteria are returned. The rows are ordered by
TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description contains the following columns:
Column name | Data type | Description |
CATALOG | String | The table catalog (can be NULL) |
SCHEMA | String | The table schema (can be NULL) |
TABLE | String | The table name |
TYPE | String | The table type |
COMMENT | String | An explanatory comment regarding the table |
TABLE_PASS | String | A non-standard column returning the password
protection of the table. The returned column values would be one of NULL, READ, WRITE, ALTER
values. A NULL is returned if no passwords are defined for the table. Since this is a
non-standard result, this column must be referenced by name. |
- Specified by:
- getTables in interface java.sql.DatabaseMetaData
- Parameters:
catalog
- A catalog name. An empty string ("") retrieves the rows that do not have a catalog.schemaPattern
- A schema name pattern. An empty string ("") retrieves the rows that do not
have a schema.tableNamePattern
- A table name pattern.types
- A list of table types to include. A value of NULL returns all types.- Returns:
- ResultSet in which each row is a table description.
- Throws:
- java.sql.SQLException - This exception is thrown if there is no connection to server or if an
IO exception is detected.
getSchemas
public java.sql.ResultSet getSchemas()
throws java.sql.SQLException
- Gets the schema names available in this database. The results
are ordered by schema name.
Each row of the result set contains the following columns:
Column name | Data type | Description |
SCHEMA | String | The schema name |
- Specified by:
- getSchemas in interface java.sql.DatabaseMetaData
- Returns:
- ResultSet in which each row has a single String column that is a schema name.
- Throws:
- java.sql.SQLException - This exception may be thrown.
getCatalogs
public java.sql.ResultSet getCatalogs()
throws java.sql.SQLException
- Gets the catalog names that are available in this database. This method is not supported.
- Specified by:
- getCatalogs in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown because SAS software does not
support SQL catalogs.
getTableTypes
public java.sql.ResultSet getTableTypes()
throws java.sql.SQLException
- Gets the table types available in this database. The results
are ordered by table type.
The table type is:
Column name | Data type | Description |
TYPE | String | The table type |
- Specified by:
- getTableTypes in interface java.sql.DatabaseMetaData
- Returns:
- ResultSet in which each row has a single String column that is a table type.
- Throws:
- java.sql.SQLException - This exception may be thrown.
getColumns
public java.sql.ResultSet getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
- Gets a description of table columns available in a catalog.
Only column descriptions matching the catalog, schema, table and column name criteria are returned.
The descriptions are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
Each column description contains the following columns:
Column name | Data type | Description |
CATALOG | String | A table catalog (can be NULL) |
SCHEMA | String | A table schema (can be NULL) |
TABLE | String | A table name |
NAME | String | A column name |
SQLTYPE | short | An SQL type from java.sql.Types |
TYPE | String | A data-source-dependent format name including format width and decimal |
SIZE | int | The column size (For char or date
types, this is the maximum number of characters; for numeric or decimal types, this is precision.) |
EMPTY | NULL | Not used |
SCALE | int | The number of fractional digits |
RADIX | int | The radix (typically either 10 or 2) |
NULLABLE |
int | Constants that state whether NULL is allowed:
- columnNoNulls - NULL values can possibly not be allowed
- columnNullable - NULL values are allowed
- columnNullableUnknown - Nullability is unknown
|
COMMENT | String | A comment describing the column (can be NULL) |
DEFAULT | String | The default value (can be NULL) |
EMPTY2 | int | Not used |
EMPTY3 | int | Not used |
MAX | int | For char types, this is the
maximum number of bytes in the column |
POSITION | int | The index of the column in the table
(starting at 1) |
NOTKNOWN | String | Strings that state whether NULL is allowed:
- "NO" means that the column definitely
does not allow NULL values
- "YES" means that the column might
allow NULL values
- An empty string ("") means unknown
|
- Specified by:
- getColumns in interface java.sql.DatabaseMetaData
- Parameters:
catalog
- A catalog name. An empty string ("") retrieves the rows that do
not have a catalog.schemaPattern
- A schema name pattern. An empty string ("") retrieves the
rows that do not have a schema.tableNamePattern
- A table name pattern. For password protected tables the parameter will be
of the form myTable(pw=XXXX).columnNamePattern
- A column name pattern.- Throws:
- java.sql.SQLException - This exception may be thrown.
getColumnPrivileges
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
throws java.sql.SQLException
- Gets a description of the access rights for a table's columns. This method is not supported.
- Specified by:
- getColumnPrivileges in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getTablePrivileges
public java.sql.ResultSet getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
throws java.sql.SQLException
- Gets a description of the access rights each table available
in a catalog. This method is not supported.
- Specified by:
- getTablePrivileges in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getBestRowIdentifier
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
throws java.sql.SQLException
- Gets a description of a table's optimal set of columns that
uniquely identifies a row. Each column description contains the following columns:
Column name | Data type | Description |
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
|
NAME | String | Column name |
SQLTYPE | short | SQL data type from java.sql.Types |
TYPE | String | Data source dependent type name |
SIZE | int | Precision |
EMPTY | int | Not used |
SCALE | short | Scale |
EMPTY2 | short | 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
|
Note: This method has some performance problems when using multiple queries.
- Specified by:
- getBestRowIdentifier in interface java.sql.DatabaseMetaData
- Parameters:
catalog
- A catalog name. An empty string ("") retrieves the rows that do not
have a catalog.schema
- A schema name pattern. An empty string ("") retrieves the rows that
do not have a schema.table
- A table name pattern.nullable
- Whether NULL values are allowed.- Returns:
- A ResultSet.
- Throws:
- java.sql.SQLException - This exception is thrown if a database error is detected.
getVersionColumns
public java.sql.ResultSet getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Gets a description of the table columns that are automatically
updated when any value in a row is updated. This method is not supported.
- Specified by:
- getVersionColumns in interface java.sql.DatabaseMetaData
- Returns:
- An exception is always thrown. No columns are automatically updated.
- Throws:
- java.sql.SQLException - This exception is always thrown.
getPrimaryKeys
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Gets a description of a table's primary key columns. They
are ordered by COLUMN_NAME. This method has some performance problems
due to multiple queries.
Each primary key column description has the following columns:
Column name | Data type | Description |
CATALOG | String | A table catalog (can be NULL) |
SCHEMA | String | A table schema (can be NULL) |
TABLE | String | A table name |
NAME | String | A column name |
SEQ | short | A sequence number within primary key |
INDEX | String | A primary key name (can be NULL) |
- Specified by:
- getPrimaryKeys in interface java.sql.DatabaseMetaData
- Parameters:
catalog
- A catalog name. An empty string ("") retrieves rows that do not
have a catalog.schema
- A schema name pattern. An empty string ("") retrieves rows that
do not have a schema.table
- A table name pattern.- Returns:
- A ResultSet.
- Throws:
- java.sql.SQLException - This exception is thrown if a database-access error is detected.
getImportedKeys
public java.sql.ResultSet getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Gets a description of the primary key columns that are
referenced by a table's foreign key columns. This method is not supported.
- Specified by:
- getImportedKeys in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getExportedKeys
public java.sql.ResultSet getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Gets a description of a foreign key columns that reference a
table's primary key columns. This method is not supported.
- Specified by:
- getExportedKeys in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getCrossReference
public java.sql.ResultSet getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
throws java.sql.SQLException
- Gets a description of the foreign key columns in the foreign key
table that reference the primary key columns of the primary key table. This method is not supported.
- Specified by:
- getCrossReference in interface java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException - This exception is always thrown.
getTypeInfo
public java.sql.ResultSet getTypeInfo()
throws java.sql.SQLException
- Gets 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:
Column name | Data type | Description |
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 ?
- 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 |
- Specified by:
- getTypeInfo in interface java.sql.DatabaseMetaData
- Returns:
- ResultSet in which each row is an SQL type definition.
- Throws:
- java.sql.SQLException - This exception is required by the interface, but it is never thrown.
getIndexInfo
public java.sql.ResultSet getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
throws java.sql.SQLException
- Gets a description of a table's indices and statistics. Each index column description contains the following columns:
Column name | Data type | Description |
CATALOG | String | A table catalog (can be NULL) |
SCHEMA | String | A table schema (can be NULL) |
TABLE | String | A table name |
NONUNIQ | boolean | Whether index values can be non-unique |
QUAL | String | An index catalog (can be NULL) |
INDEX | String | An index name |
TYPE | short | An index type:
- tableIndexStatistic - Table statistics returned in conjuction with a table's index descriptions
- tableIndexClustered - A clustered index
- tableIndexHashed - A hashed index
- tableIndexOther - Some other style of index
|
POS | short | Column sequence number within a index |
NAME | String | Column name (can be NULL) |
SEQ | String | Column sort sequence (can be NULL):
- "A" - Ascending
- "D" - Descending
|
CARDINAL | int | Number of rows in a table or unique values in the index |
PAGES | int | Number of pages used for the table or for the current index |
FILTER | String | Filter condition, if any (can be NULL) |
- Specified by:
- getIndexInfo in interface java.sql.DatabaseMetaData
- Parameters:
catalog
- A catalog name. An empty string ("") retrieves rows that do not
have a catalog.schema
- A schema name pattern. An empty string ("") retrieves rows that do
not have a schema name.table
- A table name.unique
- When True, return only indices for unique values;
when False, return indices regardless of whether unique or not.approximate
- When True, result is allowed to reflect approximate
or out of data values; when False, results are requested to be
accurate.- Returns:
- A ResultSet.
- Throws:
- java.sql.SQLException - This exception is thrown if a database-access error is detected.
supportsResultSetType
public boolean supportsResultSetType(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines if the database supports the given result set type.
- Specified by:
- supportsResultSetType in interface java.sql.DatabaseMetaData
- Parameters:
type
- The type defined in java.sql.ResultSet- Returns:
- True if the type is TYPE_SCROLL_INSENSITIVE or TYPE_FORWARD_ONLY, else, returns False.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
- See Also:
MVAConnection
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int type,
int concurrency)
throws java.sql.SQLException
- JDBC 2.0
Determines if the database supports the concurrency type in combination
with the given result set type.
- Specified by:
- supportsResultSetConcurrency in interface java.sql.DatabaseMetaData
- Parameters:
type
- The type defined in java.sql.ResultSet.concurrency
- type The concurrency type defined in java.sql.ResultSet.- Returns:
- True if the resultset type is TYPE_SCROLL_INSENSITIVE or TYPE_FORWARD_ONLY and if the
concurrency type is CONCUR_UPDATABLE or CONCUR_READ_ONLY, else returns False.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
- See Also:
MVAConnection
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether a result set's own changes are visible.
- Specified by:
- ownUpdatesAreVisible in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- True. Own changes are visible.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether a result set's own changes are visible.
- Specified by:
- ownDeletesAreVisible in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- True. Own changes are visible.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether a result set's own changes are visible.
- Specified by:
- ownInsertsAreVisible in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- True. Own changes are visible.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether changes made by others are visible.
- Specified by:
- othersUpdatesAreVisible in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- False. Changes made by others are not visible.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
othersDeletesAreVisible
public boolean othersDeletesAreVisible(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether changes made by others are visible.
- Specified by:
- othersDeletesAreVisible in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- False. Changes made by others are not visible.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether changes made by others are visible.
- Specified by:
- othersInsertsAreVisible in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- False. Changes made by others are not visible.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
updatesAreDetected
public boolean updatesAreDetected(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether or not a visible row update can be detected by
calling ResultSet.rowUpdated().
- Specified by:
- updatesAreDetected in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- False. Updates are not detected.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
deletesAreDetected
public boolean deletesAreDetected(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines 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.
- Specified by:
- deletesAreDetected in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- False. Deletes are not detected.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
insertsAreDetected
public boolean insertsAreDetected(int type)
throws java.sql.SQLException
- JDBC 2.0
Determines whether or not a visible row insert can be detected
by calling ResultSet.rowInserted().
- Specified by:
- insertsAreDetected in interface java.sql.DatabaseMetaData
- Parameters:
result
- set type. The type defined in java.sql.ResultSet.- Returns:
- False. Inserts are not detected.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
supportsBatchUpdates
public boolean supportsBatchUpdates()
throws java.sql.SQLException
- JDBC 2.0
Determines if the database supports batch updates.
- Specified by:
- supportsBatchUpdates in interface java.sql.DatabaseMetaData
- Returns:
- True. Batch updates are supported as sequential queuing up of update calls.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
getUDTs
public java.sql.ResultSet getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
throws java.sql.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.
- Specified by:
- getUDTs in interface java.sql.DatabaseMetaData
- Parameters:
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 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- Returns:
- An empty ResultSet object.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.
getConnection
public java.sql.Connection getConnection()
throws java.sql.SQLException
- JDBC 2.0
Gets the connection that produced this metadata object.
- Specified by:
- getConnection in interface java.sql.DatabaseMetaData
- Returns:
- An MVAConnection object.
- Throws:
- java.sql.SQLException - This exception is required by the interface but it is never thrown.