Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.objectweb.cjdbc.driver
Class DatabaseMetaData

java.lang.Object
  extended byorg.objectweb.cjdbc.driver.DatabaseMetaData
All Implemented Interfaces:
java.sql.DatabaseMetaData
public class DatabaseMetaData
extends java.lang.Object
implements java.sql.DatabaseMetaData

DatabaseMetaData retrieves most of the values from the C-JDBC controller. If you are using an heterogeneous cluster, the values returned are the one of the first database that was enabled on the controller.

Version:
1.0
Author:
Emmanuel Cecchet , Jean-Bernard van Zuylen

Field Summary
private  Connection connection
          The connection association
private  java.util.HashMap metadataContainer
          ("getXXX(Y,Z,
 
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()
           
 boolean allTablesAreSelectable()
           
 boolean dataDefinitionCausesTransactionCommit()
           
 boolean dataDefinitionIgnoredInTransactions()
           
 boolean deletesAreDetected(int type)
           
 boolean doesMaxRowSizeIncludeBlobs()
           
 java.sql.ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)
           
 java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)
           
 java.sql.ResultSet getCatalogs()
           
 java.lang.String getCatalogSeparator()
           
 java.lang.String getCatalogTerm()
           
 java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)
           
 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)
           
 int getDatabaseMajorVersion()
           
 int getDatabaseMinorVersion()
           
 java.lang.String getDatabaseProductName()
          We return a comma separated list of database engine names connected to the controller.
 java.lang.String getDatabaseProductVersion()
          What is the version of this database product.
 int getDefaultTransactionIsolation()
           
 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)
           
 java.lang.String getExtraNameCharacters()
           
 java.lang.String getIdentifierQuoteString()
           
 java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)
           
 java.sql.ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)
           
 int getJDBCMajorVersion()
          Retrieves the major JDBC version number for this driver.
 int getJDBCMinorVersion()
          Retrieves the minor JDBC version number for this driver.
 int getMaxBinaryLiteralLength()
           
 int getMaxCatalogNameLength()
           
 int getMaxCharLiteralLength()
           
 int getMaxColumnNameLength()
           
 int getMaxColumnsInGroupBy()
           
 int getMaxColumnsInIndex()
           
 int getMaxColumnsInOrderBy()
           
 int getMaxColumnsInSelect()
           
 int getMaxColumnsInTable()
           
 int getMaxConnections()
          Maximum number of connections to the database (virtually no limit since these are virtual connections to the Controller).
 int getMaxCursorNameLength()
           
 int getMaxIndexLength()
           
 int getMaxProcedureNameLength()
           
 int getMaxRowSize()
           
 int getMaxSchemaNameLength()
           
 int getMaxStatementLength()
           
 int getMaxStatements()
           
 int getMaxTableNameLength()
           
 int getMaxTablesInSelect()
           
 int getMaxUserNameLength()
           
private  java.lang.Object getMetadata(java.lang.String methodName, java.lang.Class[] parametersType, java.lang.Object[] arguments, boolean allowsNull)
          Lazy evaluation of a static metadata value.
 java.lang.String getNumericFunctions()
           
 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()
           
 int getResultSetHoldability()
           
 java.sql.ResultSet getSchemas()
           
 java.lang.String getSchemaTerm()
           
 java.lang.String getSearchStringEscape()
           
 java.lang.String getSQLKeywords()
           
 int getSQLStateType()
           
 java.lang.String getStringFunctions()
           
 java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
           
 java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)
           
 java.lang.String getSystemFunctions()
           
 java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
          Gets a description of the access rights for 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 available tables.
 java.sql.ResultSet getTableTypes()
          Gets the table types available in this database.
 java.lang.String getTimeDateFunctions()
           
 java.sql.ResultSet getTypeInfo()
           
 java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types)
           
 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)
           
 boolean insertsAreDetected(int type)
           
 boolean isCatalogAtStart()
           
 boolean isReadOnly()
          Is the database in read-only mode?
 boolean locatorsUpdateCopy()
           
 boolean nullPlusNonNullIsNull()
           
 boolean nullsAreSortedAtEnd()
           
 boolean nullsAreSortedAtStart()
           
 boolean nullsAreSortedHigh()
           
 boolean nullsAreSortedLow()
           
 boolean othersDeletesAreVisible(int type)
           
 boolean othersInsertsAreVisible(int type)
           
 boolean othersUpdatesAreVisible(int type)
           
 boolean ownDeletesAreVisible(int type)
           
 boolean ownInsertsAreVisible(int type)
           
 boolean ownUpdatesAreVisible(int type)
           
 boolean storesLowerCaseIdentifiers()
           
 boolean storesLowerCaseQuotedIdentifiers()
           
 boolean storesMixedCaseIdentifiers()
           
 boolean storesMixedCaseQuotedIdentifiers()
           
 boolean storesUpperCaseIdentifiers()
           
 boolean storesUpperCaseQuotedIdentifiers()
           
 boolean supportsAlterTableWithAddColumn()
           
 boolean supportsAlterTableWithDropColumn()
           
 boolean supportsANSI92EntryLevelSQL()
           
 boolean supportsANSI92FullSQL()
           
 boolean supportsANSI92IntermediateSQL()
           
 boolean supportsBatchUpdates()
           
 boolean supportsCatalogsInDataManipulation()
           
 boolean supportsCatalogsInIndexDefinitions()
           
 boolean supportsCatalogsInPrivilegeDefinitions()
           
 boolean supportsCatalogsInProcedureCalls()
           
 boolean supportsCatalogsInTableDefinitions()
           
 boolean supportsColumnAliasing()
           
 boolean supportsConvert()
           
 boolean supportsConvert(int fromType, int toType)
          Not implemented (returns false).
 boolean supportsCoreSQLGrammar()
           
 boolean supportsCorrelatedSubqueries()
           
 boolean supportsDataDefinitionAndDataManipulationTransactions()
           
 boolean supportsDataManipulationTransactionsOnly()
           
 boolean supportsDifferentTableCorrelationNames()
           
 boolean supportsExpressionsInOrderBy()
           
 boolean supportsExtendedSQLGrammar()
           
 boolean supportsFullOuterJoins()
           
 boolean supportsGetGeneratedKeys()
           
 boolean supportsGroupBy()
           
 boolean supportsGroupByBeyondSelect()
           
 boolean supportsGroupByUnrelated()
           
 boolean supportsIntegrityEnhancementFacility()
           
 boolean supportsLikeEscapeClause()
           
 boolean supportsLimitedOuterJoins()
           
 boolean supportsMinimumSQLGrammar()
           
 boolean supportsMixedCaseIdentifiers()
           
 boolean supportsMixedCaseQuotedIdentifiers()
           
 boolean supportsMultipleOpenResults()
           
 boolean supportsMultipleResultSets()
           
 boolean supportsMultipleTransactions()
           
 boolean supportsNamedParameters()
           
 boolean supportsNonNullableColumns()
           
 boolean supportsOpenCursorsAcrossCommit()
           
 boolean supportsOpenCursorsAcrossRollback()
           
 boolean supportsOpenStatementsAcrossCommit()
           
 boolean supportsOpenStatementsAcrossRollback()
           
 boolean supportsOrderByUnrelated()
           
 boolean supportsOuterJoins()
           
 boolean supportsPositionedDelete()
           
 boolean supportsPositionedUpdate()
           
 boolean supportsResultSetConcurrency(int type, int concurrency)
           
 boolean supportsResultSetHoldability(int holdability)
           
 boolean supportsResultSetType(int type)
           
 boolean supportsSavepoints()
           
 boolean supportsSchemasInDataManipulation()
           
 boolean supportsSchemasInIndexDefinitions()
           
 boolean supportsSchemasInPrivilegeDefinitions()
           
 boolean supportsSchemasInProcedureCalls()
           
 boolean supportsSchemasInTableDefinitions()
           
 boolean supportsSelectForUpdate()
           
 boolean supportsStatementPooling()
           
 boolean supportsStoredProcedures()
           
 boolean supportsSubqueriesInComparisons()
           
 boolean supportsSubqueriesInExists()
           
 boolean supportsSubqueriesInIns()
           
 boolean supportsSubqueriesInQuantifieds()
           
 boolean supportsTableCorrelationNames()
           
 boolean supportsTransactionIsolationLevel(int level)
           
 boolean supportsTransactions()
           
 boolean supportsUnion()
           
 boolean supportsUnionAll()
           
 boolean updatesAreDetected(int type)
           
 boolean usesLocalFilePerTable()
           
 boolean usesLocalFiles()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

connection

private Connection connection
The connection association

metadataContainer

private java.util.HashMap metadataContainer
("getXXX(Y,Z,...)", value) hash table of the metadata queries.

Constructor Detail

DatabaseMetaData

public DatabaseMetaData(Connection conn)
Creates a new DatabaseMetaData instance.

Parameters:
conn - a Connection value
Method Detail

getMetadata

private java.lang.Object getMetadata(java.lang.String methodName,
                                     java.lang.Class[] parametersType,
                                     java.lang.Object[] arguments,
                                     boolean allowsNull)
                              throws java.sql.SQLException
Lazy evaluation of a static metadata value. If the value is already in the hash table, we return it. Else we send a network request to the controller and add it to the table.

Parameters:
methodName - metadata method name
parametersType - parameters type of method to invoke
arguments - arguments to invoke the method
allowsNull - true if a null metadata can be returned, if set to false an exception will be thrown if the metadata is null
Returns:
the value returned by the given method
Throws:
java.sql.SQLException - if the connection fails

allProceduresAreCallable

public boolean allProceduresAreCallable()
                                 throws java.sql.SQLException
Specified by:
allProceduresAreCallable in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.allProceduresAreCallable()

allTablesAreSelectable

public boolean allTablesAreSelectable()
                               throws java.sql.SQLException
Specified by:
allTablesAreSelectable in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.allTablesAreSelectable()

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()
                                              throws java.sql.SQLException
Specified by:
dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.dataDefinitionCausesTransactionCommit()

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()
                                            throws java.sql.SQLException
Specified by:
dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.dataDefinitionIgnoredInTransactions()

deletesAreDetected

public boolean deletesAreDetected(int type)
                           throws java.sql.SQLException
Specified by:
deletesAreDetected in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.deletesAreDetected(int)

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()
                                   throws java.sql.SQLException
Specified by:
doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.doesMaxRowSizeIncludeBlobs()

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
Specified by:
getBestRowIdentifier in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getBestRowIdentifier(java.lang.String, java.lang.String, java.lang.String, int, boolean)

getCatalogs

public java.sql.ResultSet getCatalogs()
                               throws java.sql.SQLException
Specified by:
getCatalogs in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getCatalogs()

getCatalogSeparator

public java.lang.String getCatalogSeparator()
                                     throws java.sql.SQLException
Specified by:
getCatalogSeparator in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getCatalogSeparator()

getCatalogTerm

public java.lang.String getCatalogTerm()
                                throws java.sql.SQLException
Specified by:
getCatalogTerm in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getCatalogTerm()

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
Specified by:
getColumns in interface java.sql.DatabaseMetaData
Parameters:
catalog - a catalog name; "" retrieves those without a catalog
schemaPattern - a schema name pattern; "" retrieves those without a schema
tableNamePattern - a table name pattern
columnNamePattern - a column name pattern
Returns:
null
Throws:
java.sql.SQLException - if an error occurs
See Also:
getSearchStringEscape()

getColumnPrivileges

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
Specified by:
getColumnPrivileges in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getColumnPrivileges(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException
Retrieves the Connection that produced this DatabaseMetaData.

Specified by:
getConnection in interface java.sql.DatabaseMetaData
Returns:
the Connection object
Throws:
java.sql.SQLException - if an error occurs

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
Specified by:
getCrossReference in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getDatabaseProductName

public java.lang.String getDatabaseProductName()
                                        throws java.sql.SQLException
We return a comma separated list of database engine names connected to the controller. A name appears only once regardless of the number of instances of this particular db engine. If no database product name is provided by the backend drivers, default is to return "C-JDBC Controller".

Specified by:
getDatabaseProductName in interface java.sql.DatabaseMetaData
Returns:
comma separated list of database product names
Throws:
java.sql.SQLException - if a database access error occurs

getDatabaseProductVersion

public java.lang.String getDatabaseProductVersion()
                                           throws java.sql.SQLException
What is the version of this database product.

Specified by:
getDatabaseProductVersion in interface java.sql.DatabaseMetaData
Returns:
the C-JDBC driver version
Throws:
java.sql.SQLException - if an error occurs

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()
                                   throws java.sql.SQLException
Specified by:
getDefaultTransactionIsolation in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getDefaultTransactionIsolation()

getDriverMajorVersion

public int getDriverMajorVersion()
What is this JDBC driver's major version number?

Specified by:
getDriverMajorVersion in interface java.sql.DatabaseMetaData
Returns:
the JDBC driver major version

getDriverMinorVersion

public int getDriverMinorVersion()
What is this JDBC driver's minor version number?

Specified by:
getDriverMinorVersion in interface java.sql.DatabaseMetaData
Returns:
the JDBC driver minor version

getDriverName

public java.lang.String getDriverName()
                               throws java.sql.SQLException
What is the name of this JDBC driver?

Specified by:
getDriverName in interface java.sql.DatabaseMetaData
Returns:
the JDBC driver name
Throws:
java.sql.SQLException - why?

getDriverVersion

public java.lang.String getDriverVersion()
                                  throws java.sql.SQLException
What is the version string of this JDBC driver?

Specified by:
getDriverVersion in interface java.sql.DatabaseMetaData
Returns:
the JDBC driver name.
Throws:
java.sql.SQLException - why?

getExportedKeys

public java.sql.ResultSet getExportedKeys(java.lang.String catalog,
                                          java.lang.String schema,
                                          java.lang.String table)
                                   throws java.sql.SQLException
Specified by:
getExportedKeys in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getExportedKeys(java.lang.String, java.lang.String, java.lang.String)

getExtraNameCharacters

public java.lang.String getExtraNameCharacters()
                                        throws java.sql.SQLException
Specified by:
getExtraNameCharacters in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getExtraNameCharacters()

getIdentifierQuoteString

public java.lang.String getIdentifierQuoteString()
                                          throws java.sql.SQLException
Specified by:
getIdentifierQuoteString in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getIdentifierQuoteString()

getImportedKeys

public java.sql.ResultSet getImportedKeys(java.lang.String catalog,
                                          java.lang.String schema,
                                          java.lang.String table)
                                   throws java.sql.SQLException
Specified by:
getImportedKeys in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getImportedKeys(java.lang.String, java.lang.String, java.lang.String)

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
Specified by:
getIndexInfo in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getIndexInfo(java.lang.String, java.lang.String, java.lang.String, boolean, boolean)

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()
                              throws java.sql.SQLException
Specified by:
getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxBinaryLiteralLength()

getMaxCatalogNameLength

public int getMaxCatalogNameLength()
                            throws java.sql.SQLException
Specified by:
getMaxCatalogNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxCatalogNameLength()

getMaxCharLiteralLength

public int getMaxCharLiteralLength()
                            throws java.sql.SQLException
Specified by:
getMaxCharLiteralLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxCharLiteralLength()

getMaxColumnNameLength

public int getMaxColumnNameLength()
                           throws java.sql.SQLException
Specified by:
getMaxColumnNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxColumnNameLength()

getMaxColumnsInGroupBy

public int getMaxColumnsInGroupBy()
                           throws java.sql.SQLException
Specified by:
getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxColumnsInGroupBy()

getMaxColumnsInIndex

public int getMaxColumnsInIndex()
                         throws java.sql.SQLException
Specified by:
getMaxColumnsInIndex in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxColumnsInIndex()

getMaxColumnsInOrderBy

public int getMaxColumnsInOrderBy()
                           throws java.sql.SQLException
Specified by:
getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxColumnsInOrderBy()

getMaxColumnsInSelect

public int getMaxColumnsInSelect()
                          throws java.sql.SQLException
Specified by:
getMaxColumnsInSelect in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxColumnsInSelect()

getMaxColumnsInTable

public int getMaxColumnsInTable()
                         throws java.sql.SQLException
Specified by:
getMaxColumnsInTable in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxColumnsInTable()

getMaxConnections

public int getMaxConnections()
                      throws java.sql.SQLException
Maximum number of connections to the database (virtually no limit since these are virtual connections to the Controller). The spec says 0 should be returned if unknown.

Specified by:
getMaxConnections in interface java.sql.DatabaseMetaData
Returns:
value retrieved from first enabled backend
Throws:
java.sql.SQLException - if a database access error occurs

getMaxCursorNameLength

public int getMaxCursorNameLength()
                           throws java.sql.SQLException
Specified by:
getMaxCursorNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxCursorNameLength()

getMaxIndexLength

public int getMaxIndexLength()
                      throws java.sql.SQLException
Specified by:
getMaxIndexLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxIndexLength()

getMaxProcedureNameLength

public int getMaxProcedureNameLength()
                              throws java.sql.SQLException
Specified by:
getMaxProcedureNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxProcedureNameLength()

getMaxRowSize

public int getMaxRowSize()
                  throws java.sql.SQLException
Specified by:
getMaxRowSize in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxRowSize()

getMaxSchemaNameLength

public int getMaxSchemaNameLength()
                           throws java.sql.SQLException
Specified by:
getMaxSchemaNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxSchemaNameLength()

getMaxStatementLength

public int getMaxStatementLength()
                          throws java.sql.SQLException
Specified by:
getMaxStatementLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxStatementLength()

getMaxStatements

public int getMaxStatements()
                     throws java.sql.SQLException
Specified by:
getMaxStatements in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxStatements()

getMaxTableNameLength

public int getMaxTableNameLength()
                          throws java.sql.SQLException
Specified by:
getMaxTableNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxTableNameLength()

getMaxTablesInSelect

public int getMaxTablesInSelect()
                         throws java.sql.SQLException
Specified by:
getMaxTablesInSelect in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxTablesInSelect()

getMaxUserNameLength

public int getMaxUserNameLength()
                         throws java.sql.SQLException
Specified by:
getMaxUserNameLength in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getMaxUserNameLength()

getNumericFunctions

public java.lang.String getNumericFunctions()
                                     throws java.sql.SQLException
Specified by:
getNumericFunctions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getNumericFunctions()

getPrimaryKeys

public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog,
                                         java.lang.String schema,
                                         java.lang.String table)
                                  throws java.sql.SQLException
Specified by:
getPrimaryKeys in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getPrimaryKeys(java.lang.String, java.lang.String, java.lang.String)

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
Specified by:
getProcedureColumns in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getProcedureColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getProcedures

public java.sql.ResultSet getProcedures(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String procedureNamePattern)
                                 throws java.sql.SQLException
Specified by:
getProcedures in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getProcedures(java.lang.String, java.lang.String, java.lang.String)

getProcedureTerm

public java.lang.String getProcedureTerm()
                                  throws java.sql.SQLException
Specified by:
getProcedureTerm in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getProcedureTerm()

getSchemas

public java.sql.ResultSet getSchemas()
                              throws java.sql.SQLException
Specified by:
getSchemas in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSchemas()

getSchemaTerm

public java.lang.String getSchemaTerm()
                               throws java.sql.SQLException
Specified by:
getSchemaTerm in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSchemaTerm()

getSearchStringEscape

public java.lang.String getSearchStringEscape()
                                       throws java.sql.SQLException
Specified by:
getSearchStringEscape in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSearchStringEscape()

getSQLKeywords

public java.lang.String getSQLKeywords()
                                throws java.sql.SQLException
Specified by:
getSQLKeywords in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSQLKeywords()

getStringFunctions

public java.lang.String getStringFunctions()
                                    throws java.sql.SQLException
Specified by:
getStringFunctions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getStringFunctions()

getSystemFunctions

public java.lang.String getSystemFunctions()
                                    throws java.sql.SQLException
Specified by:
getSystemFunctions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSystemFunctions()

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 available tables.

Specified by:
getTables in interface java.sql.DatabaseMetaData
Parameters:
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
Returns:
null
Throws:
java.sql.SQLException - if a database-access error occurs.

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 for each table available in a catalog. Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this priviledge applies to all columns (this may be true for some systems but is not true for all.) Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.

Specified by:
getTablePrivileges in interface java.sql.DatabaseMetaData
Parameters:
catalog - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
schemaPattern - a schema name pattern; "" retrieves those without a schema
tableNamePattern - a table name pattern
Returns:
ResultSet each row is a table privilege description
Throws:
java.sql.SQLException - if a database access error occurs

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.

Specified by:
getTableTypes in interface java.sql.DatabaseMetaData
Returns:
ResultSet each row has a single String column that is a catalog name
Throws:
java.sql.SQLException - if a database error occurs

getTimeDateFunctions

public java.lang.String getTimeDateFunctions()
                                      throws java.sql.SQLException
Specified by:
getTimeDateFunctions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getTimeDateFunctions()

getTypeInfo

public java.sql.ResultSet getTypeInfo()
                               throws java.sql.SQLException
Specified by:
getTypeInfo in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getTypeInfo()

getUDTs

public java.sql.ResultSet getUDTs(java.lang.String catalog,
                                  java.lang.String schemaPattern,
                                  java.lang.String typeNamePattern,
                                  int[] types)
                           throws java.sql.SQLException
Specified by:
getUDTs in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getUDTs(java.lang.String, java.lang.String, java.lang.String, int[])

getURL

public java.lang.String getURL()
                        throws java.sql.SQLException
What is the URL for this database?

Specified by:
getURL in interface java.sql.DatabaseMetaData
Returns:
the url or null if it cannott be generated
Throws:
java.sql.SQLException - if a database access error occurs

getUserName

public java.lang.String getUserName()
                             throws java.sql.SQLException
What is our user name as known to the database?

Specified by:
getUserName in interface java.sql.DatabaseMetaData
Returns:
our database user name
Throws:
java.sql.SQLException - if a database access error occurs

getVersionColumns

public java.sql.ResultSet getVersionColumns(java.lang.String catalog,
                                            java.lang.String schema,
                                            java.lang.String table)
                                     throws java.sql.SQLException
Specified by:
getVersionColumns in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getVersionColumns(java.lang.String, java.lang.String, java.lang.String)

insertsAreDetected

public boolean insertsAreDetected(int type)
                           throws java.sql.SQLException
Specified by:
insertsAreDetected in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.insertsAreDetected(int)

isCatalogAtStart

public boolean isCatalogAtStart()
                         throws java.sql.SQLException
Specified by:
isCatalogAtStart in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.isCatalogAtStart()

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException
Is the database in read-only mode?

Specified by:
isReadOnly in interface java.sql.DatabaseMetaData
Returns:
true if so
Throws:
java.sql.SQLException - if a database access error occurs

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()
                              throws java.sql.SQLException
Specified by:
nullPlusNonNullIsNull in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.nullPlusNonNullIsNull()

nullsAreSortedAtEnd

public boolean nullsAreSortedAtEnd()
                            throws java.sql.SQLException
Specified by:
nullsAreSortedAtEnd in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.nullsAreSortedAtEnd()

nullsAreSortedAtStart

public boolean nullsAreSortedAtStart()
                              throws java.sql.SQLException
Specified by:
nullsAreSortedAtStart in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.nullsAreSortedAtStart()

nullsAreSortedHigh

public boolean nullsAreSortedHigh()
                           throws java.sql.SQLException
Specified by:
nullsAreSortedHigh in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.nullsAreSortedHigh()

nullsAreSortedLow

public boolean nullsAreSortedLow()
                          throws java.sql.SQLException
Specified by:
nullsAreSortedLow in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.nullsAreSortedLow()

othersDeletesAreVisible

public boolean othersDeletesAreVisible(int type)
                                throws java.sql.SQLException
Specified by:
othersDeletesAreVisible in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.othersDeletesAreVisible(int)

othersInsertsAreVisible

public boolean othersInsertsAreVisible(int type)
                                throws java.sql.SQLException
Specified by:
othersInsertsAreVisible in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.othersInsertsAreVisible(int)

othersUpdatesAreVisible

public boolean othersUpdatesAreVisible(int type)
                                throws java.sql.SQLException
Specified by:
othersUpdatesAreVisible in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.othersUpdatesAreVisible(int)

ownDeletesAreVisible

public boolean ownDeletesAreVisible(int type)
                             throws java.sql.SQLException
Specified by:
ownDeletesAreVisible in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.ownDeletesAreVisible(int)

ownInsertsAreVisible

public boolean ownInsertsAreVisible(int type)
                             throws java.sql.SQLException
Specified by:
ownInsertsAreVisible in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.ownInsertsAreVisible(int)

ownUpdatesAreVisible

public boolean ownUpdatesAreVisible(int type)
                             throws java.sql.SQLException
Specified by:
ownUpdatesAreVisible in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.ownUpdatesAreVisible(int)

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()
                                   throws java.sql.SQLException
Specified by:
storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.storesLowerCaseIdentifiers()

storesLowerCaseQuotedIdentifiers

public boolean storesLowerCaseQuotedIdentifiers()
                                         throws java.sql.SQLException
Specified by:
storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.storesLowerCaseQuotedIdentifiers()

storesMixedCaseIdentifiers

public boolean storesMixedCaseIdentifiers()
                                   throws java.sql.SQLException
Specified by:
storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.storesMixedCaseIdentifiers()

storesMixedCaseQuotedIdentifiers

public boolean storesMixedCaseQuotedIdentifiers()
                                         throws java.sql.SQLException
Specified by:
storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.storesMixedCaseQuotedIdentifiers()

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()
                                   throws java.sql.SQLException
Specified by:
storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.storesUpperCaseIdentifiers()

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()
                                         throws java.sql.SQLException
Specified by:
storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.storesUpperCaseQuotedIdentifiers()

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()
                                        throws java.sql.SQLException
Specified by:
supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsAlterTableWithAddColumn()

supportsAlterTableWithDropColumn

public boolean supportsAlterTableWithDropColumn()
                                         throws java.sql.SQLException
Specified by:
supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsAlterTableWithDropColumn()

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()
                                    throws java.sql.SQLException
Specified by:
supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsANSI92EntryLevelSQL()

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()
                              throws java.sql.SQLException
Specified by:
supportsANSI92FullSQL in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsANSI92FullSQL()

supportsANSI92IntermediateSQL

public boolean supportsANSI92IntermediateSQL()
                                      throws java.sql.SQLException
Specified by:
supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsANSI92IntermediateSQL()

supportsBatchUpdates

public boolean supportsBatchUpdates()
                             throws java.sql.SQLException
Specified by:
supportsBatchUpdates in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsBatchUpdates()

supportsCatalogsInDataManipulation

public boolean supportsCatalogsInDataManipulation()
                                           throws java.sql.SQLException
Specified by:
supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCatalogsInDataManipulation()

supportsCatalogsInIndexDefinitions

public boolean supportsCatalogsInIndexDefinitions()
                                           throws java.sql.SQLException
Specified by:
supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCatalogsInIndexDefinitions()

supportsCatalogsInPrivilegeDefinitions

public boolean supportsCatalogsInPrivilegeDefinitions()
                                               throws java.sql.SQLException
Specified by:
supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions()

supportsCatalogsInProcedureCalls

public boolean supportsCatalogsInProcedureCalls()
                                         throws java.sql.SQLException
Specified by:
supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCatalogsInProcedureCalls()

supportsCatalogsInTableDefinitions

public boolean supportsCatalogsInTableDefinitions()
                                           throws java.sql.SQLException
Specified by:
supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCatalogsInTableDefinitions()

supportsColumnAliasing

public boolean supportsColumnAliasing()
                               throws java.sql.SQLException
Specified by:
supportsColumnAliasing in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsColumnAliasing()

supportsConvert

public boolean supportsConvert()
                        throws java.sql.SQLException
Specified by:
supportsConvert in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsConvert()

supportsConvert

public boolean supportsConvert(int fromType,
                               int toType)
                        throws java.sql.SQLException
Not implemented (returns false). We should ask the Controller to know.

Specified by:
supportsConvert in interface java.sql.DatabaseMetaData
Parameters:
fromType - an int value
toType - an int value
Returns:
false
Throws:
java.sql.SQLException -

supportsCoreSQLGrammar

public boolean supportsCoreSQLGrammar()
                               throws java.sql.SQLException
Specified by:
supportsCoreSQLGrammar in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCoreSQLGrammar()

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()
                                     throws java.sql.SQLException
Specified by:
supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsCorrelatedSubqueries()

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                              throws java.sql.SQLException
Specified by:
supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions()

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()
                                                 throws java.sql.SQLException
Specified by:
supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsDataManipulationTransactionsOnly()

supportsDifferentTableCorrelationNames

public boolean supportsDifferentTableCorrelationNames()
                                               throws java.sql.SQLException
Specified by:
supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsDifferentTableCorrelationNames()

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()
                                     throws java.sql.SQLException
Specified by:
supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsExpressionsInOrderBy()

supportsExtendedSQLGrammar

public boolean supportsExtendedSQLGrammar()
                                   throws java.sql.SQLException
Specified by:
supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsExtendedSQLGrammar()

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
                               throws java.sql.SQLException
Specified by:
supportsFullOuterJoins in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsFullOuterJoins()

supportsGroupBy

public boolean supportsGroupBy()
                        throws java.sql.SQLException
Specified by:
supportsGroupBy in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsGroupBy()

supportsGroupByBeyondSelect

public boolean supportsGroupByBeyondSelect()
                                    throws java.sql.SQLException
Specified by:
supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsGroupByBeyondSelect()

supportsGroupByUnrelated

public boolean supportsGroupByUnrelated()
                                 throws java.sql.SQLException
Specified by:
supportsGroupByUnrelated in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsGroupByUnrelated()

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()
                                             throws java.sql.SQLException
Specified by:
supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsIntegrityEnhancementFacility()

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()
                                 throws java.sql.SQLException
Specified by:
supportsLikeEscapeClause in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsLikeEscapeClause()

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()
                                  throws java.sql.SQLException
Specified by:
supportsLimitedOuterJoins in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsLimitedOuterJoins()

supportsMinimumSQLGrammar

public boolean supportsMinimumSQLGrammar()
                                  throws java.sql.SQLException
Specified by:
supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsMinimumSQLGrammar()

supportsMixedCaseIdentifiers

public boolean supportsMixedCaseIdentifiers()
                                     throws java.sql.SQLException
Specified by:
supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsMixedCaseIdentifiers()

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()
                                           throws java.sql.SQLException
Specified by:
supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsMixedCaseQuotedIdentifiers()

supportsMultipleResultSets

public boolean supportsMultipleResultSets()
                                   throws java.sql.SQLException
Specified by:
supportsMultipleResultSets in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsMultipleResultSets()

supportsMultipleTransactions

public boolean supportsMultipleTransactions()
                                     throws java.sql.SQLException
Specified by:
supportsMultipleTransactions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsMultipleTransactions()

supportsNonNullableColumns

public boolean supportsNonNullableColumns()
                                   throws java.sql.SQLException
Specified by:
supportsNonNullableColumns in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsNonNullableColumns()

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()
                                        throws java.sql.SQLException
Specified by:
supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsOpenCursorsAcrossCommit()

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()
                                          throws java.sql.SQLException
Specified by:
supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsOpenCursorsAcrossRollback()

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()
                                           throws java.sql.SQLException
Specified by:
supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsOpenStatementsAcrossCommit()

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()
                                             throws java.sql.SQLException
Specified by:
supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsOpenStatementsAcrossRollback()

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()
                                 throws java.sql.SQLException
Specified by:
supportsOrderByUnrelated in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsOrderByUnrelated()

supportsOuterJoins

public boolean supportsOuterJoins()
                           throws java.sql.SQLException
Specified by:
supportsOuterJoins in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsOuterJoins()

supportsPositionedDelete

public boolean supportsPositionedDelete()
                                 throws java.sql.SQLException
Specified by:
supportsPositionedDelete in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsPositionedDelete()

supportsPositionedUpdate

public boolean supportsPositionedUpdate()
                                 throws java.sql.SQLException
Specified by:
supportsPositionedUpdate in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsPositionedUpdate()

supportsResultSetConcurrency

public boolean supportsResultSetConcurrency(int type,
                                            int concurrency)
                                     throws java.sql.SQLException
Specified by:
supportsResultSetConcurrency in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsResultSetConcurrency(int, int)

supportsResultSetHoldability

public boolean supportsResultSetHoldability(int holdability)
                                     throws java.sql.SQLException
Specified by:
supportsResultSetHoldability in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsResultSetHoldability(int)

supportsResultSetType

public boolean supportsResultSetType(int type)
                              throws java.sql.SQLException
Specified by:
supportsResultSetType in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsResultSetType(int)

supportsSchemasInDataManipulation

public boolean supportsSchemasInDataManipulation()
                                          throws java.sql.SQLException
Specified by:
supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSchemasInDataManipulation()

supportsSchemasInIndexDefinitions

public boolean supportsSchemasInIndexDefinitions()
                                          throws java.sql.SQLException
Specified by:
supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSchemasInIndexDefinitions()

supportsSchemasInPrivilegeDefinitions

public boolean supportsSchemasInPrivilegeDefinitions()
                                              throws java.sql.SQLException
Specified by:
supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSchemasInPrivilegeDefinitions()

supportsSchemasInProcedureCalls

public boolean supportsSchemasInProcedureCalls()
                                        throws java.sql.SQLException
Specified by:
supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSchemasInProcedureCalls()

supportsSchemasInTableDefinitions

public boolean supportsSchemasInTableDefinitions()
                                          throws java.sql.SQLException
Specified by:
supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSchemasInTableDefinitions()

supportsSelectForUpdate

public boolean supportsSelectForUpdate()
                                throws java.sql.SQLException
Specified by:
supportsSelectForUpdate in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSelectForUpdate()

supportsStoredProcedures

public boolean supportsStoredProcedures()
                                 throws java.sql.SQLException
Specified by:
supportsStoredProcedures in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsStoredProcedures()

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()
                                        throws java.sql.SQLException
Specified by:
supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSubqueriesInComparisons()

supportsSubqueriesInExists

public boolean supportsSubqueriesInExists()
                                   throws java.sql.SQLException
Specified by:
supportsSubqueriesInExists in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSubqueriesInExists()

supportsSubqueriesInIns

public boolean supportsSubqueriesInIns()
                                throws java.sql.SQLException
Specified by:
supportsSubqueriesInIns in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSubqueriesInIns()

supportsSubqueriesInQuantifieds

public boolean supportsSubqueriesInQuantifieds()
                                        throws java.sql.SQLException
Specified by:
supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSubqueriesInQuantifieds()

supportsTableCorrelationNames

public boolean supportsTableCorrelationNames()
                                      throws java.sql.SQLException
Specified by:
supportsTableCorrelationNames in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsTableCorrelationNames()

supportsTransactionIsolationLevel

public boolean supportsTransactionIsolationLevel(int level)
                                          throws java.sql.SQLException
Specified by:
supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsTransactionIsolationLevel(int)

supportsTransactions

public boolean supportsTransactions()
                             throws java.sql.SQLException
Specified by:
supportsTransactions in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsTransactions()

supportsUnion

public boolean supportsUnion()
                      throws java.sql.SQLException
Specified by:
supportsUnion in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsUnion()

supportsUnionAll

public boolean supportsUnionAll()
                         throws java.sql.SQLException
Specified by:
supportsUnionAll in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsUnionAll()

updatesAreDetected

public boolean updatesAreDetected(int type)
                           throws java.sql.SQLException
Specified by:
updatesAreDetected in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.updatesAreDetected(int)

usesLocalFilePerTable

public boolean usesLocalFilePerTable()
                              throws java.sql.SQLException
Specified by:
usesLocalFilePerTable in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.usesLocalFilePerTable()

usesLocalFiles

public boolean usesLocalFiles()
                       throws java.sql.SQLException
Specified by:
usesLocalFiles in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.usesLocalFiles()

supportsSavepoints

public boolean supportsSavepoints()
                           throws java.sql.SQLException
Specified by:
supportsSavepoints in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsSavepoints()

supportsNamedParameters

public boolean supportsNamedParameters()
                                throws java.sql.SQLException
Specified by:
supportsNamedParameters in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsNamedParameters()

supportsMultipleOpenResults

public boolean supportsMultipleOpenResults()
                                    throws java.sql.SQLException
Specified by:
supportsMultipleOpenResults in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsMultipleOpenResults()

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()
                                 throws java.sql.SQLException
Specified by:
supportsGetGeneratedKeys in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsGetGeneratedKeys()

getSuperTypes

public java.sql.ResultSet getSuperTypes(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String typeNamePattern)
                                 throws java.sql.SQLException
Specified by:
getSuperTypes in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSuperTypes(java.lang.String, java.lang.String, java.lang.String)

getSuperTables

public java.sql.ResultSet getSuperTables(java.lang.String catalog,
                                         java.lang.String schemaPattern,
                                         java.lang.String tableNamePattern)
                                  throws java.sql.SQLException
Specified by:
getSuperTables in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSuperTables(java.lang.String, java.lang.String, java.lang.String)

getAttributes

public java.sql.ResultSet getAttributes(java.lang.String catalog,
                                        java.lang.String schemaPattern,
                                        java.lang.String typeNamePattern,
                                        java.lang.String attributeNamePattern)
                                 throws java.sql.SQLException
Specified by:
getAttributes in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getAttributes(java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getResultSetHoldability

public int getResultSetHoldability()
                            throws java.sql.SQLException
Specified by:
getResultSetHoldability in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getResultSetHoldability()

getDatabaseMajorVersion

public int getDatabaseMajorVersion()
                            throws java.sql.SQLException
Specified by:
getDatabaseMajorVersion in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getDatabaseMajorVersion()

getDatabaseMinorVersion

public int getDatabaseMinorVersion()
                            throws java.sql.SQLException
Specified by:
getDatabaseMinorVersion in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getDatabaseMinorVersion()

getJDBCMajorVersion

public int getJDBCMajorVersion()
                        throws java.sql.SQLException
Retrieves the major JDBC version number for this driver.

Specified by:
getJDBCMajorVersion in interface java.sql.DatabaseMetaData
Returns:
JDBC version major number
Throws:
java.sql.SQLException - if a database access error occurs
Since:
JDK 1.4

getJDBCMinorVersion

public int getJDBCMinorVersion()
                        throws java.sql.SQLException
Retrieves the minor JDBC version number for this driver.

Specified by:
getJDBCMinorVersion in interface java.sql.DatabaseMetaData
Returns:
JDBC version minor number
Throws:
java.sql.SQLException - if a database access error occurs
Since:
JDK 1.4

getSQLStateType

public int getSQLStateType()
                    throws java.sql.SQLException
Specified by:
getSQLStateType in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.getSQLStateType()

locatorsUpdateCopy

public boolean locatorsUpdateCopy()
                           throws java.sql.SQLException
Specified by:
locatorsUpdateCopy in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.locatorsUpdateCopy()

supportsStatementPooling

public boolean supportsStatementPooling()
                                 throws java.sql.SQLException
Specified by:
supportsStatementPooling in interface java.sql.DatabaseMetaData
Throws:
java.sql.SQLException
See Also:
DatabaseMetaData.supportsStatementPooling()
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright © 2002, 2005 - ObjectWeb Consortium - All Rights Reserved.