Package org.firebirdsql.jdbc
Interface FirebirdDatabaseMetaData
- 
- All Superinterfaces:
- java.sql.DatabaseMetaData,- java.sql.Wrapper
 - All Known Implementing Classes:
- FBDatabaseMetaData
 
 public interface FirebirdDatabaseMetaData extends java.sql.DatabaseMetaDataExtension ofDatabaseMetaDatainterface providing access to Firebird specific features.- Author:
- Michael Romankiewicz
 
- 
- 
Field Summary- 
Fields inherited from interface java.sql.DatabaseMetaDataattributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown
 
- 
 - 
Method SummaryAll Methods Instance Methods Abstract Methods Modifier and Type Method Description voidclose()Closes any cached metadata statements held by this database metadata implementation.intgetConnectionDialect()Get the dialect of the connection.intgetDatabaseDialect()Get the dialect of the database.intgetOdsMajorVersion()Get the major version of the ODS (On-Disk Structure) of the database.intgetOdsMinorVersion()Get the minor version of the ODS (On-Disk Structure) of the database.java.lang.StringgetProcedureSourceCode(java.lang.String procedureName)Get the source of a stored procedure.java.lang.String[]getTableTypeNames()Supported table type names.java.lang.StringgetTriggerSourceCode(java.lang.String triggerName)Get the source of a trigger.java.lang.StringgetViewSourceCode(java.lang.String viewName)Get the source of a view.- 
Methods inherited from interface java.sql.DatabaseMetaDataallProceduresAreCallable, allTablesAreSelectable, autoCommitFailureClosesAllResultSets, dataDefinitionCausesTransactionCommit, dataDefinitionIgnoredInTransactions, deletesAreDetected, doesMaxRowSizeIncludeBlobs, generatedKeyAlwaysReturned, getAttributes, getBestRowIdentifier, getCatalogs, getCatalogSeparator, getCatalogTerm, getClientInfoProperties, getColumnPrivileges, getColumns, getConnection, getCrossReference, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDefaultTransactionIsolation, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExportedKeys, getExtraNameCharacters, getFunctionColumns, getFunctions, getIdentifierQuoteString, getImportedKeys, getIndexInfo, getJDBCMajorVersion, getJDBCMinorVersion, getMaxBinaryLiteralLength, getMaxCatalogNameLength, getMaxCharLiteralLength, getMaxColumnNameLength, getMaxColumnsInGroupBy, getMaxColumnsInIndex, getMaxColumnsInOrderBy, getMaxColumnsInSelect, getMaxColumnsInTable, getMaxConnections, getMaxCursorNameLength, getMaxIndexLength, getMaxLogicalLobSize, getMaxProcedureNameLength, getMaxRowSize, getMaxSchemaNameLength, getMaxStatementLength, getMaxStatements, getMaxTableNameLength, getMaxTablesInSelect, getMaxUserNameLength, getNumericFunctions, getPrimaryKeys, getProcedureColumns, getProcedures, getProcedureTerm, getPseudoColumns, getResultSetHoldability, getRowIdLifetime, getSchemas, getSchemas, getSchemaTerm, getSearchStringEscape, getSQLKeywords, getSQLStateType, getStringFunctions, getSuperTables, getSuperTypes, getSystemFunctions, getTablePrivileges, getTables, getTableTypes, getTimeDateFunctions, getTypeInfo, getUDTs, getURL, getUserName, getVersionColumns, insertsAreDetected, isCatalogAtStart, isReadOnly, locatorsUpdateCopy, nullPlusNonNullIsNull, nullsAreSortedAtEnd, nullsAreSortedAtStart, nullsAreSortedHigh, nullsAreSortedLow, othersDeletesAreVisible, othersInsertsAreVisible, othersUpdatesAreVisible, ownDeletesAreVisible, ownInsertsAreVisible, ownUpdatesAreVisible, storesLowerCaseIdentifiers, storesLowerCaseQuotedIdentifiers, storesMixedCaseIdentifiers, storesMixedCaseQuotedIdentifiers, storesUpperCaseIdentifiers, storesUpperCaseQuotedIdentifiers, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsANSI92EntryLevelSQL, supportsANSI92FullSQL, supportsANSI92IntermediateSQL, supportsBatchUpdates, supportsCatalogsInDataManipulation, supportsCatalogsInIndexDefinitions, supportsCatalogsInPrivilegeDefinitions, supportsCatalogsInProcedureCalls, supportsCatalogsInTableDefinitions, supportsColumnAliasing, supportsConvert, supportsConvert, supportsCoreSQLGrammar, supportsCorrelatedSubqueries, supportsDataDefinitionAndDataManipulationTransactions, supportsDataManipulationTransactionsOnly, supportsDifferentTableCorrelationNames, supportsExpressionsInOrderBy, supportsExtendedSQLGrammar, supportsFullOuterJoins, supportsGetGeneratedKeys, supportsGroupBy, supportsGroupByBeyondSelect, supportsGroupByUnrelated, supportsIntegrityEnhancementFacility, supportsLikeEscapeClause, supportsLimitedOuterJoins, supportsMinimumSQLGrammar, supportsMixedCaseIdentifiers, supportsMixedCaseQuotedIdentifiers, supportsMultipleOpenResults, supportsMultipleResultSets, supportsMultipleTransactions, supportsNamedParameters, supportsNonNullableColumns, supportsOpenCursorsAcrossCommit, supportsOpenCursorsAcrossRollback, supportsOpenStatementsAcrossCommit, supportsOpenStatementsAcrossRollback, supportsOrderByUnrelated, supportsOuterJoins, supportsPositionedDelete, supportsPositionedUpdate, supportsRefCursors, supportsResultSetConcurrency, supportsResultSetHoldability, supportsResultSetType, supportsSavepoints, supportsSchemasInDataManipulation, supportsSchemasInIndexDefinitions, supportsSchemasInPrivilegeDefinitions, supportsSchemasInProcedureCalls, supportsSchemasInTableDefinitions, supportsSelectForUpdate, supportsSharding, supportsStatementPooling, supportsStoredFunctionsUsingCallSyntax, supportsStoredProcedures, supportsSubqueriesInComparisons, supportsSubqueriesInExists, supportsSubqueriesInIns, supportsSubqueriesInQuantifieds, supportsTableCorrelationNames, supportsTransactionIsolationLevel, supportsTransactions, supportsUnion, supportsUnionAll, updatesAreDetected, usesLocalFilePerTable, usesLocalFiles
 
- 
 
- 
- 
- 
Method Detail- 
getProcedureSourceCodejava.lang.String getProcedureSourceCode(java.lang.String procedureName) throws java.sql.SQLExceptionGet the source of a stored procedure.- Parameters:
- procedureName- name of the stored procedure.
- Returns:
- source of the stored procedure.
- Throws:
- java.sql.SQLException- if specified procedure cannot be found.
 
 - 
getTriggerSourceCodejava.lang.String getTriggerSourceCode(java.lang.String triggerName) throws java.sql.SQLExceptionGet the source of a trigger.- Parameters:
- triggerName- name of the trigger.
- Returns:
- source of the trigger.
- Throws:
- java.sql.SQLException- if specified trigger cannot be found.
 
 - 
getViewSourceCodejava.lang.String getViewSourceCode(java.lang.String viewName) throws java.sql.SQLExceptionGet the source of a view.- Parameters:
- viewName- name of the view.
- Returns:
- source of the view.
- Throws:
- java.sql.SQLException- if specified view cannot be found.
 
 - 
getOdsMajorVersionint getOdsMajorVersion() throws java.sql.SQLExceptionGet the major version of the ODS (On-Disk Structure) of the database.- Returns:
- The major version number of the database itself
- Throws:
- java.sql.SQLException- if a database access error occurs
 
 - 
getOdsMinorVersionint getOdsMinorVersion() throws java.sql.SQLExceptionGet the minor version of the ODS (On-Disk Structure) of the database.- Returns:
- The minor version number of the database itself
- Throws:
- java.sql.SQLException- if a database access error occurs
 
 - 
getDatabaseDialectint getDatabaseDialect() throws java.sql.SQLExceptionGet the dialect of the database.- Returns:
- The dialect of the database
- Throws:
- java.sql.SQLException- if a database access error occurs
- See Also:
- getConnectionDialect()
 
 - 
getConnectionDialectint getConnectionDialect() throws java.sql.SQLExceptionGet the dialect of the connection.The connection dialect may be different from the database dialect. - Returns:
- The dialect of the connection
- Throws:
- java.sql.SQLException- if a database access error occurs
- See Also:
- getDatabaseDialect()
 
 - 
closevoid close() Closes any cached metadata statements held by this database metadata implementation.The database metadata object itself remains usable. Exceptions during statement close are logged and suppressed. 
 - 
getTableTypeNamesjava.lang.String[] getTableTypeNames() throws java.sql.SQLExceptionSupported table type names.- Returns:
- An array with the supported table types names for DatabaseMetaData.getTables(String, String, String, String[])
- Throws:
- java.sql.SQLException- For problems determining supported table types
- Since:
- 4.0
- See Also:
- DatabaseMetaData.getTableTypes()
 
 
- 
 
-