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()

supportsAl