|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.objectweb.cjdbc.driver.DatabaseMetaData
This Connection
class implements a virtual connection
that is just used to store the needed information when the real
connection will have to be established by the Controller to execute
a query.
This code has been largely inspired from the Postgres JDBC driver by Peter T. Mount.
Field Summary | |
private Connection |
connection
The connection association |
Fields inherited from interface java.sql.DatabaseMetaData |
attributeNoNulls, attributeNullable, attributeNullableUnknown, 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, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown |
Constructor Summary | |
DatabaseMetaData(Connection conn)
Creates a new DatabaseMetaData instance. |
Method Summary | |
boolean |
allProceduresAreCallable()
Can all the procedures returned by getProcedures be
called by the current user? |
boolean |
allTablesAreSelectable()
Can all the tables returned by getTable be SELECTed
by the current user? |
boolean |
dataDefinitionCausesTransactionCommit()
Does a data definition statement within a transaction force the transaction to commit? |
boolean |
dataDefinitionIgnoredInTransactions()
Is a data definition statement within a transaction ignored? |
boolean |
deletesAreDetected(int type)
C-JDBC does NOT support deleted rows. |
boolean |
doesMaxRowSizeIncludeBlobs()
Did getMaxRowSize() include LONGVARCHAR and
LONGVARBINARY blobs? |
java.sql.ResultSet |
getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog. |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
This method is currently not supported and returns null . |
java.sql.ResultSet |
getCatalogs()
C-JDBC does NOT yet support catalogs. |
java.lang.String |
getCatalogSeparator()
Returns the catalog separator. |
java.lang.String |
getCatalogTerm()
What is the database vendor's preferred term for "schema" - well, we do not provide support for schemas, so lets just use that term. |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
Feature not yet supported by C-JDBC. |
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
|
java.sql.Connection |
getConnection()
Retrieves the Connection that produced this
DatabaseMetaData . |
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)
Feature not yet supported by C-JDBC |
int |
getDatabaseMajorVersion()
Retrieves the major version number of the underlying database. |
int |
getDatabaseMinorVersion()
Retrieves the minor version number of the underlying database. |
java.lang.String |
getDatabaseProductName()
What is the name of this database product ? |
java.lang.String |
getDatabaseProductVersion()
What is the version of this database product. |
int |
getDefaultTransactionIsolation()
What is the database's default transaction isolation level? |
int |
getDriverMajorVersion()
What is this JDBC driver's major version number? |
int |
getDriverMinorVersion()
What is this JDBC driver's minor version number? |
java.lang.String |
getDriverName()
What is the name of this JDBC driver? |
java.lang.String |
getDriverVersion()
What is the version string of this JDBC driver? |
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Feature not yet supported by C-JDBC. |
java.lang.String |
getExtraNameCharacters()
Gets all the "extra" characters that can be used in unquoted identifier names (those beyond a-zA-Z0-9 and _). |
java.lang.String |
getIdentifierQuoteString()
What is the string used to quote SQL identifiers? |
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Feature not yet supported by C-JDBC. |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
Feature not yet supported by C-JDBC. |
int |
getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver. |
int |
getJDBCMinorVersion()
Retrieves the minor JDBC version number for this driver. |
int |
getMaxBinaryLiteralLength()
How many hex characters can you have in an inline binary literal. |
int |
getMaxCatalogNameLength()
Maximum number of characters in a catalog name. |
int |
getMaxCharLiteralLength()
Maximum length for a character literal. |
int |
getMaxColumnNameLength()
Maximum length for a column name. |
int |
getMaxColumnsInGroupBy()
Maximum number of columns in a "GROUP BY" clause? |
int |
getMaxColumnsInIndex()
Maximum number of columns allowed in an index? |
int |
getMaxColumnsInOrderBy()
Maximum number of columns in an "ORDER BY clause? |
int |
getMaxColumnsInSelect()
Maximum number of columns in a "SELECT" list? |
int |
getMaxColumnsInTable()
Maximum number of columns in a table? |
int |
getMaxConnections()
Maximum number of connections to the database (virtually no limit since these are virtual connections to the Controller). |
int |
getMaxCursorNameLength()
Maximum cursor name length. |
int |
getMaxIndexLength()
Maximum length of an index (in bytes)? |
int |
getMaxProcedureNameLength()
Maximum length of a procedure name? |
int |
getMaxRowSize()
Maximum length of a single row? |
int |
getMaxSchemaNameLength()
Maximum length of a schema name. |
int |
getMaxStatementLength()
Maximum length of a SQL statement? |
int |
getMaxStatements()
How many active statements can we have open at one time to this database? |
int |
getMaxTableNameLength()
Maximum length of a table name? |
int |
getMaxTablesInSelect()
Maximum number of tables that can be specified in a SELECT. |
int |
getMaxUserNameLength()
Maximum length of a user name. |
java.lang.String |
getNumericFunctions()
Name of Open Group CLI is not supported. |
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
|
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
|
java.lang.String |
getProcedureTerm()
What is the database vendor's preferred term for "procedure" - I kind of like "procedure" myself. |
int |
getResultSetHoldability()
Retrieves the default holdability of this ResultSet
object. |
java.sql.ResultSet |
getSchemas()
Feature not yet supported by C-JDBC. |
java.lang.String |
getSchemaTerm()
What is the database vendor's preferred term for "schema" - well, we do not provide support for schemas, so lets just use that term. |
java.lang.String |
getSearchStringEscape()
This is the string that can be used to escape '_' and '%' in a search string pattern style catalog search parameters. |
java.lang.String |
getSQLKeywords()
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords. |
int |
getSQLStateType()
Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as
Open Group) SQL CLI or SQL99. |
java.lang.String |
getStringFunctions()
Feature not yet supported by C-JDBC. |
java.sql.ResultSet |
getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Retrieves a description of the table hierarchies defined in a particular schema in this database. |
java.sql.ResultSet |
getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database. |
java.lang.String |
getSystemFunctions()
Feature not yet supported by C-JDBC. |
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Feature not yet supported by C-JDBC. |
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 available tables. |
java.sql.ResultSet |
getTableTypes()
Feature not yet supported by C-JDBC. |
java.lang.String |
getTimeDateFunctions()
Feature not yet supported by C-JDBC. |
java.sql.ResultSet |
getTypeInfo()
Feature not yet supported by C-JDBC. |
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
Feature not yet supported by C-JDBC. |
java.lang.String |
getURL()
What is the URL for this database? |
java.lang.String |
getUserName()
What is our user name as known to the database? |
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Feature not yet supported by C-JDBC. |
boolean |
insertsAreDetected(int type)
We do not support row insert in ResultSets . |
boolean |
isCatalogAtStart()
Does a catalog appear at the start of a qualified table name? |
boolean |
isReadOnly()
Is the database in read-only mode? |
boolean |
locatorsUpdateCopy()
Indicates whether updates made to a LOB are made on a copy or directly to the LOB. |
boolean |
nullPlusNonNullIsNull()
Are concatenations between NULL and non-NULL values NULL? |
boolean |
nullsAreSortedAtEnd()
Are NULL values sorted at the end regardless of sort order? |
boolean |
nullsAreSortedAtStart()
Are NULL values sorted at the start regardless of sort order? |
boolean |
nullsAreSortedHigh()
Are NULL values sorted high? |
boolean |
nullsAreSortedLow()
Are NULL values sorted low? |
boolean |
othersDeletesAreVisible(int type)
C-JDBC does not support deletes. |
boolean |
othersInsertsAreVisible(int type)
C-JDBC does not support inserts. |
boolean |
othersUpdatesAreVisible(int type)
C-JDBC does not support updates. |
boolean |
ownDeletesAreVisible(int type)
C-JDBC does not support deletes. |
boolean |
ownInsertsAreVisible(int type)
C-JDBC does not support inserts. |
boolean |
ownUpdatesAreVisible(int type)
C-JDBC does not support updates. |
boolean |
storesLowerCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case? |
boolean |
storesLowerCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case? |
boolean |
storesMixedCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case? |
boolean |
storesMixedCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case? |
boolean |
storesUpperCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case? |
boolean |
storesUpperCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case? |
boolean |
supportsAlterTableWithAddColumn()
Not implemented (returns false ). |
boolean |
supportsAlterTableWithDropColumn()
Not implemented (returns false ). |
boolean |
supportsANSI92EntryLevelSQL()
Does this driver support the ANSI-92 entry level SQL grammar? |
boolean |
supportsANSI92FullSQL()
Does this driver support the ANSI-92 full SQL grammar? |
boolean |
supportsANSI92IntermediateSQL()
Does this driver support the ANSI-92 intermediate level SQL grammar? |
boolean |
supportsBatchUpdates()
Does this driver support batch updates ? |
boolean |
supportsCatalogsInDataManipulation()
Can a catalog name be used in a data manipulation statement? |
boolean |
supportsCatalogsInIndexDefinitions()
Can a catalog name be used in an index definition? |
boolean |
supportsCatalogsInPrivilegeDefinitions()
Can a catalog name be used in a privilege definition statement? |
boolean |
supportsCatalogsInProcedureCalls()
Can a catalog name be used in a procedure call statement? |
boolean |
supportsCatalogsInTableDefinitions()
Can a catalog name be used in a table definition statement? |
boolean |
supportsColumnAliasing()
Is column aliasing supported? |
boolean |
supportsConvert()
Not implemented (returns false ). |
boolean |
supportsConvert(int fromType,
int toType)
Not implemented (returns false ). |
boolean |
supportsCoreSQLGrammar()
Does this driver support the Core ODBC SQL grammar. |
boolean |
supportsCorrelatedSubqueries()
Not implemented (returns false ). |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Are both data definition and data manipulation transactions supported? |
boolean |
supportsDataManipulationTransactionsOnly()
Are only data manipulation statements within a transaction supported? |
boolean |
supportsDifferentTableCorrelationNames()
Not implemented (returns false ). |
boolean |
supportsExpressionsInOrderBy()
Not implemented (returns false ). |
boolean |
supportsExtendedSQLGrammar()
Does this driver support the Extended (Level 2) ODBC SQL grammar. |
boolean |
supportsFullOuterJoins()
Not implemented (returns false ). |
boolean |
supportsGetGeneratedKeys()
Retrieves whether auto-generated keys can be retrieved after a statement has been executed. |
boolean |
supportsGroupBy()
Is some form of "GROUP BY" clause supported? |
boolean |
supportsGroupByBeyondSelect()
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT? |
boolean |
supportsGroupByUnrelated()
Can a "GROUP BY" clause use columns not in the SELECT? |
boolean |
supportsIntegrityEnhancementFacility()
Is the SQL Integrity Enhancement Facility supported? |
boolean |
supportsLikeEscapeClause()
Is the escape character in "LIKE" clauses supported? |
boolean |
supportsLimitedOuterJoins()
Is there limited support for outer joins? |
boolean |
supportsMinimumSQLGrammar()
Does this driver support the minimum ODBC SQL grammar. |
boolean |
supportsMixedCaseIdentifiers()
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case? |
boolean |
supportsMixedCaseQuotedIdentifiers()
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case? |
boolean |
supportsMultipleOpenResults()
Retrieves whether it is possible to have multiple ResultSet objects returned from a
CallableStatement object simultaneously.
|
boolean |
supportsMultipleResultSets()
Are multiple ResultSets from a single execute
supported? |
boolean |
supportsMultipleTransactions()
Can we have multiple transactions open at once (on different connections?). |
boolean |
supportsNamedParameters()
Retrieves whether this database supports named parameters to callable statements. |
boolean |
supportsNonNullableColumns()
Can columns be defined as non-nullable. |
boolean |
supportsOpenCursorsAcrossCommit()
Does this database support having cursors remain open across commits. |
boolean |
supportsOpenCursorsAcrossRollback()
Do we support open cursors across rollback ? |
boolean |
supportsOpenStatementsAcrossCommit()
Can statements remain open across commits? |
boolean |
supportsOpenStatementsAcrossRollback()
Can statements remain open across rollbacks? |
boolean |
supportsOrderByUnrelated()
Can an "ORDER BY" clause use columns not in the SELECT? |
boolean |
supportsOuterJoins()
Is some form of outer join supported? |
boolean |
supportsPositionedDelete()
We support cursors for gets only it seems. |
boolean |
supportsPositionedUpdate()
Is positioned UPDATE supported? |
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
Which combination of concurrency level and ResultSet
type is supported ? |
boolean |
supportsResultSetHoldability(int holdability)
Retrieves whether this database supports the given result set holdability. |
boolean |
supportsResultSetType(int type)
Supported ResultSet types. |
boolean |
supportsSavepoints()
Retrieves whether this database supports savepoints. |
boolean |
supportsSchemasInDataManipulation()
Can a schema name be used in a data manipulation statement? |
boolean |
supportsSchemasInIndexDefinitions()
Can a schema name be used in an index definition statement? |
boolean |
supportsSchemasInPrivilegeDefinitions()
Can a schema name be used in a privilege definition statement? |
boolean |
supportsSchemasInProcedureCalls()
Can a schema name be used in a procedure call statement? |
boolean |
supportsSchemasInTableDefinitions()
Can a schema be used in a table definition statement? |
boolean |
supportsSelectForUpdate()
Not implemented (returns false ). |
boolean |
supportsStatementPooling()
Retrieves whether this database supports statement pooling. |
boolean |
supportsStoredProcedures()
Yes, stored procedures are supported since 1.0b6. |
boolean |
supportsSubqueriesInComparisons()
Not implemented (returns false ). |
boolean |
supportsSubqueriesInExists()
Not implemented (returns false ). |
boolean |
supportsSubqueriesInIns()
Not implemented (returns false ). |
boolean |
supportsSubqueriesInQuantifieds()
Not implemented (returns false ). |
boolean |
supportsTableCorrelationNames()
Not implemented (returns false ). |
boolean |
supportsTransactionIsolationLevel(int level)
Does the database support the given transaction isolation level? |
boolean |
supportsTransactions()
Are transactions supported? |
boolean |
supportsUnion()
Is SQL UNION supported? |
boolean |
supportsUnionAll()
Is SQL UNION ALL supported? |
boolean |
updatesAreDetected(int type)
Not implemented (returns false ). |
boolean |
usesLocalFilePerTable()
Does the database use a file for each table? |
boolean |
usesLocalFiles()
Does the database store tables in a local file? |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
private Connection connection
Constructor Detail |
public DatabaseMetaData(Connection conn)
DatabaseMetaData
instance.
conn
- a Connection
valueMethod Detail |
public boolean allProceduresAreCallable() throws java.sql.SQLException
getProcedures
be
called by the current user?
allProceduresAreCallable
in interface java.sql.DatabaseMetaData
true
but we don't support catalogs ...
java.sql.SQLException
- if a database access error occurspublic boolean allTablesAreSelectable() throws java.sql.SQLException
getTable
be SELECTed
by the current user?
allTablesAreSelectable
in interface java.sql.DatabaseMetaData
true
but we don't support catalogs ...
java.sql.SQLException
- if a database access error occurspublic boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLException
CREATE TABLE T (A INT); INSERT INTO T (A) VALUES (2); BEGIN; UPDATE T SET A = A + 1; CREATE TABLE X (A INT); SELECT A FROM T INTO X; COMMIT;
does the CREATE TABLE call cause a commit? The answer is no.
dataDefinitionCausesTransactionCommit
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLException
dataDefinitionIgnoredInTransactions
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean deletesAreDetected(int type) throws java.sql.SQLException
deletesAreDetected
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- if an error occurspublic boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLException
getMaxRowSize()
include LONGVARCHAR and
LONGVARBINARY blobs? We don't handle blobs yet.
doesMaxRowSizeIncludeBlobs
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws java.sql.SQLException
null
. It could be forwarded to the Controller but it
is not clear that the result would be the same for heterogeneous
databases.
getBestRowIdentifier
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalogschema
- 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
java.sql.SQLException
- if an error occurspublic java.sql.ResultSet getCatalogs() throws java.sql.SQLException
getCatalogs
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if an error occurspublic java.lang.String getCatalogSeparator() throws java.sql.SQLException
getCatalogSeparator
in interface java.sql.DatabaseMetaData
"."
java.sql.SQLException
- if an error occurspublic java.lang.String getCatalogTerm() throws java.sql.SQLException
getCatalogTerm
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if an error occurspublic java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getColumns
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a catalogschemaPattern
- a schema name pattern; "" retrieves those
without a schematableNamePattern
- a table name patterncolumnNamePattern
- a column name pattern
null
java.sql.SQLException
- if an error occursgetSearchStringEscape()
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getColumnPrivileges
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalogschemaPattern
- a schema name pattern; "" retrieves those
without a schematableNamePattern
- a table name patterncolumnNamePattern
- a column name pattern
null
java.sql.SQLException
- if an error occursgetSearchStringEscape()
public java.sql.Connection getConnection() throws java.sql.SQLException
Connection
that produced this
DatabaseMetaData
.
getConnection
in interface java.sql.DatabaseMetaData
Connection
object
java.sql.SQLException
- if an error occurspublic 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
getCrossReference
in interface java.sql.DatabaseMetaData
primaryCatalog
- a String
valueprimarySchema
- a String
valueprimaryTable
- a String
valueforeignCatalog
- a String
valueforeignSchema
- a String
valueforeignTable
- a String
value
null
java.sql.SQLException
- if an error occursgetImportedKeys(java.lang.String, java.lang.String, java.lang.String)
public java.lang.String getDatabaseProductName() throws java.sql.SQLException
getDatabaseProductName
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getDatabaseProductVersion() throws java.sql.SQLException
getDatabaseProductVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if an error occurspublic int getDefaultTransactionIsolation() throws java.sql.SQLException
getDefaultTransactionIsolation
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occursConnection
public int getDriverMajorVersion()
getDriverMajorVersion
in interface java.sql.DatabaseMetaData
public int getDriverMinorVersion()
getDriverMinorVersion
in interface java.sql.DatabaseMetaData
public java.lang.String getDriverName() throws java.sql.SQLException
getDriverName
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- why?public java.lang.String getDriverVersion() throws java.sql.SQLException
getDriverVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- why?public java.sql.ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getExportedKeys
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalogschema
- a schema name pattern; "" retrieves those without a
schematable
- a table name
null
java.sql.SQLException
- why?getExportedKeys(java.lang.String, java.lang.String, java.lang.String)
public java.lang.String getExtraNameCharacters() throws java.sql.SQLException
For portability reasons, we assume that no extra character is allowed.
getExtraNameCharacters
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getIdentifierQuoteString() throws java.sql.SQLException
If an SQL identifier is a table name, column name, etc. then we do not support it.
getIdentifierQuoteString
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getImportedKeys
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a catalogschema
- a schema name pattern; "" retrieves those without a
schematable
- a table name
null
java.sql.SQLException
- if a database access error occursgetExportedKeys(java.lang.String, java.lang.String, java.lang.String)
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
getIndexInfo
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalogschema
- a schema name pattern; "" 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
null
java.sql.SQLException
- if a database access error occurspublic int getMaxBinaryLiteralLength() throws java.sql.SQLException
getMaxBinaryLiteralLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxCatalogNameLength() throws java.sql.SQLException
getMaxCatalogNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxCharLiteralLength() throws java.sql.SQLException
getMaxCharLiteralLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxColumnNameLength() throws java.sql.SQLException
getMaxColumnNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxColumnsInGroupBy() throws java.sql.SQLException
getMaxColumnsInGroupBy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxColumnsInIndex() throws java.sql.SQLException
getMaxColumnsInIndex
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxColumnsInOrderBy() throws java.sql.SQLException
getMaxColumnsInOrderBy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxColumnsInSelect() throws java.sql.SQLException
getMaxColumnsInSelect
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxColumnsInTable() throws java.sql.SQLException
getMaxColumnsInTable
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxConnections() throws java.sql.SQLException
getMaxConnections
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxCursorNameLength() throws java.sql.SQLException
getMaxCursorNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxIndexLength() throws java.sql.SQLException
getMaxIndexLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxProcedureNameLength() throws java.sql.SQLException
getMaxProcedureNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxRowSize() throws java.sql.SQLException
getMaxRowSize
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxSchemaNameLength() throws java.sql.SQLException
getMaxSchemaNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxStatementLength() throws java.sql.SQLException
getMaxStatementLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxStatements() throws java.sql.SQLException
Statement
downloads
the results as the query is executed, we can have many. The spec
says 0 should be returned if no limit or unknown.
getMaxStatements
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxTableNameLength() throws java.sql.SQLException
getMaxTableNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxTablesInSelect() throws java.sql.SQLException
getMaxTablesInSelect
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getMaxUserNameLength() throws java.sql.SQLException
getMaxUserNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getNumericFunctions() throws java.sql.SQLException
getNumericFunctions
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- neverpublic java.sql.ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getPrimaryKeys
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalogschema
- a schema name pattern; "" retrieves those without a
schematable
- a table name
null
java.sql.SQLException
- if a database-access error occurspublic java.sql.ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getProcedureColumns
in interface java.sql.DatabaseMetaData
catalog
- This is ignored in org.postgresql, advise this is
set to nullschemaPattern
- This is ignored in org.postgresql, advise
this is set to nullprocedureNamePattern
- a procedure name patterncolumnNamePattern
- a column name pattern
null
java.sql.SQLException
- if a database-access error occursgetSearchStringEscape()
public java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern) throws java.sql.SQLException
getProcedures
in interface java.sql.DatabaseMetaData
catalog
- - a catalog name; "" retrieves those without a *
catalog; null means drop catalog name from criteriaschemaPattern
- - a schema name pattern; "" retrieves those
* without a schema - we ignore this parameterprocedureNamePattern
- - a procedure name pattern
null
java.sql.SQLException
- if a database access error occurspublic java.lang.String getProcedureTerm() throws java.sql.SQLException
getProcedureTerm
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getSchemas() throws java.sql.SQLException
getSchemas
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if a database access error occurspublic java.lang.String getSchemaTerm() throws java.sql.SQLException
getSchemaTerm
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getSearchStringEscape() throws java.sql.SQLException
getSearchStringEscape
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getSQLKeywords() throws java.sql.SQLException
getSQLKeywords
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getStringFunctions() throws java.sql.SQLException
getStringFunctions
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if a database access error occurspublic java.lang.String getSystemFunctions() throws java.sql.SQLException
getSystemFunctions
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types) throws java.sql.SQLException
getTables
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; this is
ignored, and should be set to null
schemaPattern
- a schema name pattern; this is ignored,
and should be set to null
tableNamePattern
- a table name pattern. For all tables this
should be "%"types
- a list of table types to include; null
returns all types
null
java.sql.SQLException
- if a database-access error occurs.public java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException
getTablePrivileges
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a catalogschemaPattern
- a schema name pattern; "" retrieves those
without a schematableNamePattern
- a table name pattern
null
java.sql.SQLException
- if an error occursgetSearchStringEscape()
public java.sql.ResultSet getTableTypes() throws java.sql.SQLException
getTableTypes
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if a database access error occurspublic java.lang.String getTimeDateFunctions() throws java.sql.SQLException
getTimeDateFunctions
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getTypeInfo() throws java.sql.SQLException
getTypeInfo
in interface java.sql.DatabaseMetaData
null
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws java.sql.SQLException
getUDTs
in interface java.sql.DatabaseMetaData
catalog
- a String
valueschemaPattern
- a String
valuetypeNamePattern
- a String
valuetypes
- an int[]
value
null
java.sql.SQLException
- if an error occurspublic java.lang.String getURL() throws java.sql.SQLException
getURL
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.lang.String getUserName() throws java.sql.SQLException
getUserName
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getVersionColumns
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalogschema
- a schema name; "" retrieves those without a schematable
- a table name
null
java.sql.SQLException
- if a database access error occurspublic boolean insertsAreDetected(int type) throws java.sql.SQLException
ResultSets
.
insertsAreDetected
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean isCatalogAtStart() throws java.sql.SQLException
isCatalogAtStart
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean isReadOnly() throws java.sql.SQLException
isReadOnly
in interface java.sql.DatabaseMetaData
true
if so
java.sql.SQLException
- if a database access error occurspublic boolean nullPlusNonNullIsNull() throws java.sql.SQLException
true
.
nullPlusNonNullIsNull
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean nullsAreSortedAtEnd() throws java.sql.SQLException
nullsAreSortedAtEnd
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean nullsAreSortedAtStart() throws java.sql.SQLException
nullsAreSortedAtStart
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean nullsAreSortedHigh() throws java.sql.SQLException
nullsAreSortedHigh
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean nullsAreSortedLow() throws java.sql.SQLException
nullsAreSortedLow
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean othersDeletesAreVisible(int type) throws java.sql.SQLException
othersDeletesAreVisible
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean othersInsertsAreVisible(int type) throws java.sql.SQLException
othersInsertsAreVisible
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean othersUpdatesAreVisible(int type) throws java.sql.SQLException
othersUpdatesAreVisible
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean ownDeletesAreVisible(int type) throws java.sql.SQLException
ownDeletesAreVisible
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean ownInsertsAreVisible(int type) throws java.sql.SQLException
ownInsertsAreVisible
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean ownUpdatesAreVisible(int type) throws java.sql.SQLException
ownUpdatesAreVisible
in interface java.sql.DatabaseMetaData
type
- ignored
false
java.sql.SQLException
- public boolean storesLowerCaseIdentifiers() throws java.sql.SQLException
storesLowerCaseIdentifiers
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if an error occurspublic boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLException
storesLowerCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if an error occurspublic boolean storesMixedCaseIdentifiers() throws java.sql.SQLException
storesMixedCaseIdentifiers
in interface java.sql.DatabaseMetaData
true
if so
java.sql.SQLException
- if an error occurspublic boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLException
storesMixedCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if an error occurspublic boolean storesUpperCaseIdentifiers() throws java.sql.SQLException
storesUpperCaseIdentifiers
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if an error occurspublic boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLException
storesUpperCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if an error occurspublic boolean supportsAlterTableWithAddColumn() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsAlterTableWithAddColumn
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsAlterTableWithDropColumn() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsAlterTableWithDropColumn
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLException
true
. I think
we have to support outer joins for this to be true
.
supportsANSI92EntryLevelSQL
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsANSI92FullSQL() throws java.sql.SQLException
supportsANSI92FullSQL
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsANSI92IntermediateSQL() throws java.sql.SQLException
supportsANSI92IntermediateSQL
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsBatchUpdates() throws java.sql.SQLException
supportsBatchUpdates
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsCatalogsInDataManipulation() throws java.sql.SQLException
supportsCatalogsInDataManipulation
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLException
supportsCatalogsInIndexDefinitions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLException
supportsCatalogsInPrivilegeDefinitions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLException
supportsCatalogsInProcedureCalls
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLException
supportsCatalogsInTableDefinitions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsColumnAliasing() throws java.sql.SQLException
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
.
e.g.
select count(C) as C_COUNT from T group by C;
supportsColumnAliasing
in interface java.sql.DatabaseMetaData
true
if so
java.sql.SQLException
- if a database access error occurspublic boolean supportsConvert() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsConvert
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsConvert(int fromType, int toType) throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsConvert
in interface java.sql.DatabaseMetaData
fromType
- an int
valuetoType
- an int
value
false
java.sql.SQLException
- public boolean supportsCoreSQLGrammar() throws java.sql.SQLException
supportsCoreSQLGrammar
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsCorrelatedSubqueries() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsCorrelatedSubqueries
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLException
supportsDataDefinitionAndDataManipulationTransactions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLException
supportsDataManipulationTransactionsOnly
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsDifferentTableCorrelationNames
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsExpressionsInOrderBy() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsExpressionsInOrderBy
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsExtendedSQLGrammar() throws java.sql.SQLException
supportsExtendedSQLGrammar
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsFullOuterJoins() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsFullOuterJoins
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsGroupBy() throws java.sql.SQLException
supportsGroupBy
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsGroupByBeyondSelect() throws java.sql.SQLException
supportsGroupByBeyondSelect
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsGroupByUnrelated() throws java.sql.SQLException
supportsGroupByUnrelated
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLException
supportsIntegrityEnhancementFacility
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsLikeEscapeClause() throws java.sql.SQLException
true
.
supportsLikeEscapeClause
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsLimitedOuterJoins() throws java.sql.SQLException
true
if supportFullOuterJoins is true
)
supportsLimitedOuterJoins
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsMinimumSQLGrammar() throws java.sql.SQLException
In Postgres Appendix C. From this description, we seem to support the ODBC minimal (Level 0) grammar.
supportsMinimumSQLGrammar
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsMixedCaseIdentifiers() throws java.sql.SQLException
false
.
Predicament - what do they mean by "SQL identifiers" - if it means the names of the tables and columns, then the answers given below are correct - otherwise I don't know.
supportsMixedCaseIdentifiers
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLException
true
.
Predicament - what do they mean by "SQL identifiers" - if it means the names of the tables and columns, then the answers given below are correct - otherwise I don't know.
supportsMixedCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsMultipleResultSets() throws java.sql.SQLException
ResultSets
from a single execute
supported? Well, it should be implemented, but this is possible
for most of the backends. Should really ask the Controller about
that.
supportsMultipleResultSets
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsMultipleTransactions() throws java.sql.SQLException
supportsMultipleTransactions
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsNonNullableColumns() throws java.sql.SQLException
true
.
supportsNonNullableColumns
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLException
supportsOpenCursorsAcrossCommit
in interface java.sql.DatabaseMetaData
true
if so
java.sql.SQLException
- if a database access error occurspublic boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLException
supportsOpenCursorsAcrossRollback
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLException
Statement
object jere, so the answer is
yes, since the Statement
is only a vehicle to
ExecSQL()
.
supportsOpenStatementsAcrossCommit
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLException
Statement
object here, so the answer is
yes, since the Statement is only a vehicle to
ExecSQL()
in Connection
.
supportsOpenStatementsAcrossRollback
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsOrderByUnrelated() throws java.sql.SQLException
supportsOrderByUnrelated
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsOuterJoins() throws java.sql.SQLException
supportsOuterJoins
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsPositionedDelete() throws java.sql.SQLException
supportsPositionedDelete
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsPositionedUpdate() throws java.sql.SQLException
supportsPositionedUpdate
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsResultSetConcurrency(int type, int concurrency) throws java.sql.SQLException
ResultSet
type is supported ?
supportsResultSetConcurrency
in interface java.sql.DatabaseMetaData
type
- ResultSet typeconcurrency
- concurrency level
false
for TYPE_SCROLL_SENSITIVE and
CONCUR_UPDATABLE
java.sql.SQLException
- if an error occurspublic boolean supportsResultSetType(int type) throws java.sql.SQLException
ResultSet
types.
supportsResultSetType
in interface java.sql.DatabaseMetaData
type
- ResultSet type
false
for TYPE_SCROLL_SENSITIVE
java.sql.SQLException
- if an error occurspublic boolean supportsSchemasInDataManipulation() throws java.sql.SQLException
supportsSchemasInDataManipulation
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLException
supportsSchemasInIndexDefinitions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLException
supportsSchemasInPrivilegeDefinitions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsSchemasInProcedureCalls() throws java.sql.SQLException
supportsSchemasInProcedureCalls
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsSchemasInTableDefinitions() throws java.sql.SQLException
supportsSchemasInTableDefinitions
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsSelectForUpdate() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsSelectForUpdate
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsStoredProcedures() throws java.sql.SQLException
supportsStoredProcedures
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- public boolean supportsSubqueriesInComparisons() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsSubqueriesInComparisons
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsSubqueriesInExists() throws java.sql.SQLException
false
). We should ask the
Controller to know
supportsSubqueriesInExists
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsSubqueriesInIns() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsSubqueriesInIns
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsSubqueriesInQuantifieds
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsTableCorrelationNames() throws java.sql.SQLException
false
). We should ask the
Controller to know.
supportsTableCorrelationNames
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- public boolean supportsTransactionIsolationLevel(int level) throws java.sql.SQLException
supportsTransactionIsolationLevel
in interface java.sql.DatabaseMetaData
level
- the values are defined in
java.sql.Connection
true
java.sql.SQLException
- if a database access error occursConnection
public boolean supportsTransactions() throws java.sql.SQLException
supportsTransactions
in interface java.sql.DatabaseMetaData
true
if transactions are supported
java.sql.SQLException
- if a database access error occurspublic boolean supportsUnion() throws java.sql.SQLException
supportsUnion
in interface java.sql.DatabaseMetaData
true
java.sql.SQLException
- if a database access error occurspublic boolean supportsUnionAll() throws java.sql.SQLException
supportsUnionAll
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean updatesAreDetected(int type) throws java.sql.SQLException
false
). We should ask the
Controller to know.
updatesAreDetected
in interface java.sql.DatabaseMetaData
type
- an int
value
false
java.sql.SQLException
- public boolean usesLocalFilePerTable() throws java.sql.SQLException
usesLocalFilePerTable
in interface java.sql.DatabaseMetaData
true
if so
java.sql.SQLException
- if a database access error occurspublic boolean usesLocalFiles() throws java.sql.SQLException
usesLocalFiles
in interface java.sql.DatabaseMetaData
false
java.sql.SQLException
- if a database access error occurspublic boolean supportsSavepoints() throws java.sql.SQLException
This is not yet supported by C-JDBC.
supportsSavepoints
in interface java.sql.DatabaseMetaData
true
if savepoints are supported;
false
otherwise
java.sql.SQLException
- if a database access error occurspublic boolean supportsNamedParameters() throws java.sql.SQLException
This is not yet supported by C-JDBC.
supportsNamedParameters
in interface java.sql.DatabaseMetaData
true
if named parameters are supported;
false
otherwise
java.sql.SQLException
- if a database access error occurspublic boolean supportsMultipleOpenResults() throws java.sql.SQLException
ResultSet
objects returned from a
CallableStatement
object simultaneously.
This is not yet supported by C-JDBC.
supportsMultipleOpenResults
in interface java.sql.DatabaseMetaData
true
if a CallableStatement
object can return multiple ResultSet
objects
simultaneously; false
otherwise
java.sql.SQLException
- if a datanase access error occurspublic boolean supportsGetGeneratedKeys() throws java.sql.SQLException
supportsGetGeneratedKeys
in interface java.sql.DatabaseMetaData
true
if auto-generated keys can be retrieved
after a statement has executed; false
otherwise
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern) throws java.sql.SQLException
Only supertype information for UDTs matching the catalog, schema, and type name is returned. The type name parameter may be a fully-qualified name. When the UDT name supplied is a fully-qualified name, the catalog and schemaPattern parameters are ignored.
If a UDT does not have a direct super type, it is not listed
here. A row of the ResultSet
object returned by
this method describes the designated UDT and a direct
supertype. A row has the following columns:
null
)
null
)
null
)
null
)
Note: If the driver does not support type hierarchies, an empty result set is returned.
getSuperTypes
in interface java.sql.DatabaseMetaData
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 UDT name pattern; may be a
fully-qualified name
ResultSet
object in which a row gives
information about the designated UDT
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException
Only supertable information for tables matching the catalog, schema and table name are returned. The table name parameter may be a fully- qualified name, in which case, the catalog and schemaPattern parameters are ignored. If a table does not have a super table, it is not listed here. Supertables have to be defined in the same catalog and schema as the sub tables. Therefore, the type description does not need to include this information for the supertable.
Each type description has the following columns:
null
)null
)Note: If the driver does not support type hierarchies, an empty result set is returned.
getSuperTables
in interface java.sql.DatabaseMetaData
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 pattern; may be a
fully-qualified name
ResultSet
object in which each row is a
type description
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern) throws java.sql.SQLException
Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria. They are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description does not contain inherited attributes.
The ResultSet
object that is returned has the
following columns:
null
)
null
)
null
)
null
)
null
if DATA_TYPE isn't REF)
null
if DATA_TYPE isn't REF)
null
if the DATA_TYPE isn't REF)
null
if DATA_TYPE
isn't DISTINCT or user-generated REF)
getAttributes
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used
to narrow the searchschemaPattern
- a schema name pattern; must match the schema
name as it is stored in the database; "" retrieves those without
a schema; null
means that the schema name should not
be used to narrow the searchtypeNamePattern
- a type name pattern; must match the type
name as it is stored in the databaseattributeNamePattern
- an attribute name pattern; must match
the attribute name as it is declared in the database
ResultSet
object in which each row is an
attribute description
java.sql.SQLException
- if a database access error occurspublic boolean supportsResultSetHoldability(int holdability) throws java.sql.SQLException
This is not yet supported by C-JDBC.
supportsResultSetHoldability
in interface java.sql.DatabaseMetaData
holdability
- one of the following constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT
or
ResultSet.CLOSE_CURSORS_AT_COMMIT
- Returns:
true
if so; false
otherwise
- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- JDK 1.4
- See Also:
Connection
public int getResultSetHoldability() throws java.sql.SQLException
ResultSet
object.
getResultSetHoldability
in interface java.sql.DatabaseMetaData
ResultSet.HOLD_CURSORS_OVER_COMMIT
or
ResultSet.CLOSE_CURSORS_AT_COMMIT
java.sql.SQLException
- if a database access error occurspublic int getDatabaseMajorVersion() throws java.sql.SQLException
This is not yet supported by C-JDBC.
getDatabaseMajorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getDatabaseMinorVersion() throws java.sql.SQLException
This is not yet supported by C-JDBC.
getDatabaseMinorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getJDBCMajorVersion() throws java.sql.SQLException
getJDBCMajorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getJDBCMinorVersion() throws java.sql.SQLException
getJDBCMinorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic int getSQLStateType() throws java.sql.SQLException
SQLException.getSQLState
is X/Open (now known as
Open Group) SQL CLI or SQL99.
getSQLStateType
in interface java.sql.DatabaseMetaData
java.sql.SQLException
- if a database access error occurspublic boolean locatorsUpdateCopy() throws java.sql.SQLException
locatorsUpdateCopy
in interface java.sql.DatabaseMetaData
true
if updates are made to a copy of the
LOB; false
if updates are made directly to the LOB
java.sql.SQLException
- if a database access error occurspublic boolean supportsStatementPooling() throws java.sql.SQLException
This is not yet supported in C-JDBC.
supportsStatementPooling
in interface java.sql.DatabaseMetaData
true
if so; false
otherwise
java.sql.SQLException
- if a database access error occurs
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |