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.DatabaseMetaData
attributeNoNulls, 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 Summary
All 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.DatabaseMetaData
allProceduresAreCallable, 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
-
getProcedureSourceCode
java.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.
-
getTriggerSourceCode
java.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.
-
getViewSourceCode
java.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.
-
getOdsMajorVersion
int 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
-
getOdsMinorVersion
int 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
-
getDatabaseDialect
int 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()
-
getConnectionDialect
int 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()
-
close
void 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.
-
getTableTypeNames
java.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()
-
-