DatabaseMetaData

Interface Type

JDBC Interface

Supported

Not Supported

DatabaseMetaData

allProceduresAreCallable()

x

 

allTablesAreSelectable()

x

 

dataDefinitionCausesTransactionCommit

x

 

dataDefinitionIgnoredinTransactions()

x

 

deletesAreDetected(int arg0)

 

x

doesMaxRowSizeIncludeBlobs()

x

 

getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)

x

 

getCatalogs()

x

 

getCatalogSeperator()

x

 

getCatalogTerm()

x

 

getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern())

x

 

getColumns(STring catalog, STring schemaPatter, STring tableNamePattern, String columnNamePattern)

x

 

getConnection()

x

 

getCrossReference(String PrimaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)

x

 

getDatabaseProductName()

x

 

getDatabaseProductVersion()

x

 

getDefaultTransactionIsolation()

x

 

getDriverMajorVersion()

x

 

getDriverMinorVersion()

x

 

getDriverName()

x

 

getDriverVersion()

x

 

getExportedKeys(String catalog, String schema, String table)

x

 

getExtraNameCharacters()

x

 

getIdentifierQuoteString()

x

 

getImportedKeys(String catalog, String schema, String table)

x

 

getIndexInfo(String catalog, STring schema, String table)

x

 

getMaxBinaryLiteralLength()

x

 

getMaxCatalogNameLength()

x

 

getMaxCharLiteralLength()

x

 

getMaxColumnNameLength()

x

 

getMaxColumnsInGroupBy()

x

 

getMaxColumnsInIndex()

x

 

getMaxColumninOrderBy()

x

 

getMaxColumnsInSelect()

x

 

getMaxColumnsInTable()

x

 

getMaxConnections()

x

 

getMaxCursorNameLength()

x

 

getMaxIndexLength()

x

 

getMaxProcedureNameLength()

x

 

getMaxRowSize()

x

 

getMaxSchemaNameLength()

x

 

getMaxStatementLength()

x

 

getMaxStatements()

x

 

getMaxTableNameLength()

x

 

getMaxTablesInSelect

x

 

getMaxUserNameLength()

x

 

getNumericFunctions()

x

 

getPrimaryKeys(String catalog, String schema, String table)

x

 

getProcedureColumns(Strintg cataslog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

x

 

getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

x

 

getProcedureTerm()

x

 

getSchemas()

x

 

getSchemaTerm()

x

 

getSearchStringEscape()

x

 

getSQLKeywords()

x

 

getStringFunctions()

x

 

getSystemFunctions()

x

 

getTablePrivileges(String catalog, String schemaPattern, String table)

 

x

getTables(STring catalog, STring schemaPattern, STring tablePattern, String Types[])

x

 

getTableTypes()

x

 

getTimeDataFunctions()

x

 

getTypeInfo()

x

 

getUDTS(String arg0, String arg1, String arg2, int[]arg3)

 

x

getURL()

x

 

getUserName()

x

 

getVersionColumns(String catalog, String schema, String table)

x

 

insertsAreDetected()

 

x

isCatalogAtStart()

x

 

isReadOnly()

x

 

nullPlusNonNullsIsNull()

x

 

nullsAreSortedAtEnd()

x

 

nullsAreSortedAtStart

x

 

nullsAreSortedHigh()

x

 

nullsAreSortedLow()

x

 

othersDeletesAreVisible(int arg0)

 

x

othersInsertsAReVisible(int arg0)

 

x

othersUpdatesAreVisible(int arg0)

 

x

ownDeletesAreVisible(int arg0)

 

x

ownInsertsAreVisible(int arg0)

 

x

ownUpdatesAreVisible(int arg0)

 

x

storesLowerCaseIdentifiers(

x

 

storesLowerCaseQuotedIdentifiers()

x

 

storesMixedCaseIdentifiers()

x

 

storesMixedCaseQuotedIdentifiers()

x

 

storesUpperCaseIdentifiers()

x

 

storesUpperCaseQuotedIdentifiers()

x

 

supportsAlterTableWithAddColumn()

x

 

supportsAlterTableWithDropColumn()

x

 

supportsANSI92EntryLevelSQL()

x

 

supportsANSI92FullSQL()

x

 

supportsANSI92IntermediateSQL()

x

 

supportsBatchUpdates()

 

x

supportsCatalogsInDataManipulations

x

 

supportsCatalogsInIndexDefinitions

x

 

supportsCatalogsInPrivilegeDefinitions()

x

 

supportsCatalogsInProcedureCalls()

x

 

supportsCatalogsInTableDefinitions()

x

 

supportsColumnAliasing()

x

 

supportsConvert()

x

 

supportsconver(int fromType, int to Type)

x

 

supportsCoreSQLGrammar()

x

 

supportsCorrelatedSubQueries()

x

 

supportsDataDefinitionsAndDataManipuilationTransactions()

x

 

supportsDataManipulationTransactionsOnly()

x

 

supportsDifferentTAbleCorrelationNames()

x

 

supportsExpressionsInOrderBy()

x

 

supportsExtendedSQLGrammar()

x

 

supportsFullOuterJoins()

x

 

supportsGroupBy()

x

 

supportsGroupByBeyondSelect()

x

 

supportsGroupByUnrelated()

x

 

supportsIntegrityEnhancementFacility()

x

 

supportsLikeEscapeClause()

x

 

supportsLimitedOuterJoins

x

 

supportsMinimumSQLGrammar()

x

 

supportsMixedCaseIdentifiers()

x

 

supportsMixedCaseQuotedIdentifiers()

x

 

supportsMultipleResultSets()

x

 

supportsMultipleTransactions()

x

 

supportsNonNullableColumns()

x

 

supportsOpenCursorsAcrossCommit()

x

 

supportsOpenCursorsAcrossRollback()

x

 

supportsOrderByUnrelated()

x

 

supportsOuterJoins()

x

 

supportsPositionedDelete()

x

 

supportsPositionedUpdate()

x

 

supportsResultSetConcurrency(int arg0, int arg1)

 

x

supportsResultSetType(int arg0)

x

 

supportsSchemasInDataManipulation()

x

 

supportsSchemasInIndexDefinitions()

x

 

supportsSchemasInPrivilegeDefinitions()

x

 

supportsSchemasInProcedureCalls()

x

 

supportsInTableDefinitions()

x

 

supportsSelectForUpdate()

x

 

supportsStoredProcedures()

x

 

supportsSubQueriesInComparisons()

x

 

supportsSubqueriesInExists()

x

 

supportsSubqueriesInIns()

x

 

supportsSubqueriesInQualified()

x

 

supportsTAbleCorrelationNames()

x

 

supportsTransactionIsolationLevel(int level)

x

 

supportsTransactions()

x

 

supportsUnions()

x

 

supportsUnionAll()

x

 

updatesAreDetected(int arg0)

 

x

useLocalFilePerTable()

x

 

useLocalFiles()

x