Class FBDatabaseMetaData
- java.lang.Object
- 
- org.firebirdsql.jdbc.FBDatabaseMetaData
 
- 
- All Implemented Interfaces:
- java.sql.DatabaseMetaData,- java.sql.Wrapper,- FirebirdDatabaseMetaData
 
 public class FBDatabaseMetaData extends java.lang.Object implements FirebirdDatabaseMetaData Comprehensive information about the database as a whole.- Author:
- David Jencks, Mark Rotteveel
 
- 
- 
Field SummaryFields Modifier and Type Field Description protected static DatatypeCoderdatatypeCoderstatic java.lang.StringGET_COLUMNS_ENDstatic java.lang.StringGLOBAL_TEMPORARYstatic java.lang.StringSYSTEM_TABLEstatic java.lang.StringTABLEstatic java.lang.StringVIEW- 
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
 
- 
 - 
Constructor SummaryConstructors Modifier Constructor Description protectedFBDatabaseMetaData(FBConnection c)
 - 
Method SummaryAll Methods Static Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description booleanallProceduresAreCallable()booleanallTablesAreSelectable()booleanautoCommitFailureClosesAllResultSets()protected RowDescriptorbuildTablePrivilegeRSMetaData()voidclose()Closes any cached metadata statements held by this database metadata implementation.booleandataDefinitionCausesTransactionCommit()booleandataDefinitionIgnoredInTransactions()booleandeletesAreDetected(int type)booleandoesMaxRowSizeIncludeBlobs()protected java.sql.ResultSetdoQuery(java.lang.String sql, java.util.List<java.lang.String> params)Execute an sql query with a given set of parameters.protected java.sql.ResultSetdoQuery(java.lang.String sql, java.util.List<java.lang.String> params, boolean standalone)Execute an sql query with a given set of parameters.static java.lang.StringescapeWildcards(java.lang.String objectName)Escapes the like wildcards and escape (\_%in the provided search string with a\.booleangeneratedKeyAlwaysReturned()java.sql.ResultSetgetAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)java.sql.ResultSetgetBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)protected static byte[]getBytes(java.lang.String value)java.sql.ResultSetgetCatalogs()java.lang.StringgetCatalogSeparator()java.lang.StringgetCatalogTerm()java.sql.ResultSetgetClientInfoProperties()java.sql.ResultSetgetColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern)java.sql.ResultSetgetColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)java.sql.ConnectiongetConnection()intgetConnectionDialect()Get the dialect of the connection.java.sql.ResultSetgetCrossReference(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)intgetDatabaseDialect()Get the dialect of the database.intgetDatabaseMajorVersion()intgetDatabaseMinorVersion()java.lang.StringgetDatabaseProductName()java.lang.StringgetDatabaseProductVersion()protected DbMetadataMediatorgetDbMetadataMediator()intgetDefaultTransactionIsolation()intgetDriverMajorVersion()intgetDriverMinorVersion()java.lang.StringgetDriverName()java.lang.StringgetDriverVersion()java.sql.ResultSetgetExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)java.lang.StringgetExtraNameCharacters()java.sql.ResultSetgetFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern)java.sql.ResultSetgetFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern)java.lang.StringgetIdentifierQuoteString()java.sql.ResultSetgetImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)java.sql.ResultSetgetIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)intgetJDBCMajorVersion()intgetJDBCMinorVersion()intgetMaxBinaryLiteralLength()intgetMaxCatalogNameLength()intgetMaxCharLiteralLength()intgetMaxColumnNameLength()intgetMaxColumnsInGroupBy()intgetMaxColumnsInIndex()intgetMaxColumnsInOrderBy()intgetMaxColumnsInSelect()intgetMaxColumnsInTable()intgetMaxConnections()intgetMaxCursorNameLength()intgetMaxIndexLength()intgetMaxProcedureNameLength()intgetMaxRowSize()intgetMaxSchemaNameLength()intgetMaxStatementLength()intgetMaxStatements()intgetMaxTableNameLength()intgetMaxTablesInSelect()intgetMaxUserNameLength()java.lang.StringgetNumericFunctions()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.sql.ResultSetgetPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)java.sql.ResultSetgetProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern)java.sql.ResultSetgetProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern)java.lang.StringgetProcedureSourceCode(java.lang.String procedureName)Get the source of a stored procedure.java.lang.StringgetProcedureTerm()java.sql.ResultSetgetPseudoColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)intgetResultSetHoldability()java.sql.RowIdLifetimegetRowIdLifetime()java.sql.ResultSetgetSchemas()java.sql.ResultSetgetSchemas(java.lang.String catalog, java.lang.String schemaPattern)java.lang.StringgetSchemaTerm()java.lang.StringgetSearchStringEscape()java.lang.StringgetSQLKeywords()intgetSQLStateType()java.lang.StringgetStringFunctions()java.sql.ResultSetgetSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)java.sql.ResultSetgetSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)java.lang.StringgetSystemFunctions()java.sql.ResultSetgetTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)java.sql.ResultSetgetTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types)java.lang.String[]getTableTypeNames()Supported table type names.java.sql.ResultSetgetTableTypes()java.lang.StringgetTimeDateFunctions()java.lang.StringgetTriggerSourceCode(java.lang.String triggerName)Get the source of a trigger.java.sql.ResultSetgetTypeInfo()java.sql.ResultSetgetUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types)java.lang.StringgetURL()java.lang.StringgetUserName()java.sql.ResultSetgetVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)java.lang.StringgetViewSourceCode(java.lang.String viewName)Get the source of a view.protected java.lang.StringgetWantsSystemTables(java.lang.String[] types)protected java.lang.StringgetWantsTables(java.lang.String[] types)protected java.lang.StringgetWantsViews(java.lang.String[] types)static booleanhasNoWildcards(java.lang.String pattern)Deprecated.Will be removed in Jaybird 5booleaninsertsAreDetected(int type)booleanisCatalogAtStart()booleanisReadOnly()booleanisWrapperFor(java.lang.Class<?> iface)booleanlocatorsUpdateCopy()booleannullPlusNonNullIsNull()booleannullsAreSortedAtEnd()booleannullsAreSortedAtStart()booleannullsAreSortedHigh()booleannullsAreSortedLow()booleanothersDeletesAreVisible(int type)booleanothersInsertsAreVisible(int type)booleanothersUpdatesAreVisible(int type)booleanownDeletesAreVisible(int type)booleanownInsertsAreVisible(int type)booleanownUpdatesAreVisible(int type)protected FBResultSetprocessTablePrivileges(RowDescriptor rowDescriptor, java.sql.ResultSet fbTablePrivileges)booleanstoresLowerCaseIdentifiers()booleanstoresLowerCaseQuotedIdentifiers()booleanstoresMixedCaseIdentifiers()booleanstoresMixedCaseQuotedIdentifiers()booleanstoresUpperCaseIdentifiers()booleanstoresUpperCaseQuotedIdentifiers()static java.lang.StringstripEscape(java.lang.String pattern)Deprecated.Will be removed in Jaybird 5booleansupportsAlterTableWithAddColumn()booleansupportsAlterTableWithDropColumn()booleansupportsANSI92EntryLevelSQL()booleansupportsANSI92FullSQL()booleansupportsANSI92IntermediateSQL()booleansupportsBatchUpdates()booleansupportsCatalogsInDataManipulation()booleansupportsCatalogsInIndexDefinitions()booleansupportsCatalogsInPrivilegeDefinitions()booleansupportsCatalogsInProcedureCalls()booleansupportsCatalogsInTableDefinitions()booleansupportsColumnAliasing()booleansupportsConvert()booleansupportsConvert(int fromType, int toType)booleansupportsCoreSQLGrammar()booleansupportsCorrelatedSubqueries()booleansupportsDataDefinitionAndDataManipulationTransactions()booleansupportsDataManipulationTransactionsOnly()booleansupportsDifferentTableCorrelationNames()booleansupportsExpressionsInOrderBy()booleansupportsExtendedSQLGrammar()booleansupportsFullOuterJoins()booleansupportsGetGeneratedKeys()booleansupportsGroupBy()booleansupportsGroupByBeyondSelect()booleansupportsGroupByUnrelated()booleansupportsIntegrityEnhancementFacility()booleansupportsLikeEscapeClause()booleansupportsLimitedOuterJoins()booleansupportsMinimumSQLGrammar()booleansupportsMixedCaseIdentifiers()booleansupportsMixedCaseQuotedIdentifiers()booleansupportsMultipleOpenResults()booleansupportsMultipleResultSets()booleansupportsMultipleTransactions()booleansupportsNamedParameters()booleansupportsNonNullableColumns()booleansupportsOpenCursorsAcrossCommit()booleansupportsOpenCursorsAcrossRollback()booleansupportsOpenStatementsAcrossCommit()booleansupportsOpenStatementsAcrossRollback()booleansupportsOrderByUnrelated()booleansupportsOuterJoins()booleansupportsPositionedDelete()booleansupportsPositionedUpdate()booleansupportsResultSetConcurrency(int type, int concurrency)booleansupportsResultSetHoldability(int holdability)booleansupportsResultSetType(int type)booleansupportsSavepoints()booleansupportsSchemasInDataManipulation()booleansupportsSchemasInIndexDefinitions()booleansupportsSchemasInPrivilegeDefinitions()booleansupportsSchemasInProcedureCalls()booleansupportsSchemasInTableDefinitions()booleansupportsSelectForUpdate()booleansupportsStatementPooling()booleansupportsStoredFunctionsUsingCallSyntax()booleansupportsStoredProcedures()booleansupportsSubqueriesInComparisons()booleansupportsSubqueriesInExists()booleansupportsSubqueriesInIns()booleansupportsSubqueriesInQuantifieds()booleansupportsTableCorrelationNames()booleansupportsTransactionIsolationLevel(int level)booleansupportsTransactions()booleansupportsUnion()booleansupportsUnionAll()<T> Tunwrap(java.lang.Class<T> iface)booleanupdatesAreDetected(int type)booleanusesLocalFilePerTable()booleanusesLocalFiles()
 
- 
- 
- 
Field Detail- 
datatypeCoderprotected static final DatatypeCoder datatypeCoder 
 - 
TABLEpublic static final java.lang.String TABLE - See Also:
- Constant Field Values
 
 - 
SYSTEM_TABLEpublic static final java.lang.String SYSTEM_TABLE - See Also:
- Constant Field Values
 
 - 
VIEWpublic static final java.lang.String VIEW - See Also:
- Constant Field Values
 
 - 
GLOBAL_TEMPORARYpublic static final java.lang.String GLOBAL_TEMPORARY - See Also:
- Constant Field Values
 
 - 
GET_COLUMNS_ENDpublic static final java.lang.String GET_COLUMNS_END - See Also:
- Constant Field Values
 
 
- 
 - 
Constructor Detail- 
FBDatabaseMetaDataprotected FBDatabaseMetaData(FBConnection c) throws java.sql.SQLException - Throws:
- java.sql.SQLException
 
 
- 
 - 
Method Detail- 
closepublic void close() Description copied from interface:FirebirdDatabaseMetaDataCloses 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. - Specified by:
- closein interface- FirebirdDatabaseMetaData
 
 - 
allProceduresAreCallablepublic boolean allProceduresAreCallable() throws java.sql.SQLException- Specified by:
- allProceduresAreCallablein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
allTablesAreSelectablepublic boolean allTablesAreSelectable() throws java.sql.SQLException- Specified by:
- allTablesAreSelectablein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getURLpublic java.lang.String getURL() throws java.sql.SQLException- Specified by:
- getURLin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getUserNamepublic java.lang.String getUserName() throws java.sql.SQLException- Specified by:
- getUserNamein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
isReadOnlypublic boolean isReadOnly() throws java.sql.SQLException- Specified by:
- isReadOnlyin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
nullsAreSortedHighpublic boolean nullsAreSortedHigh() throws java.sql.SQLException- Specified by:
- nullsAreSortedHighin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
nullsAreSortedLowpublic boolean nullsAreSortedLow() throws java.sql.SQLException- Specified by:
- nullsAreSortedLowin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
nullsAreSortedAtStartpublic boolean nullsAreSortedAtStart() throws java.sql.SQLException- Specified by:
- nullsAreSortedAtStartin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
nullsAreSortedAtEndpublic boolean nullsAreSortedAtEnd() throws java.sql.SQLException- Specified by:
- nullsAreSortedAtEndin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDatabaseProductNamepublic java.lang.String getDatabaseProductName() throws java.sql.SQLException- Specified by:
- getDatabaseProductNamein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDatabaseProductVersionpublic java.lang.String getDatabaseProductVersion() throws java.sql.SQLException- Specified by:
- getDatabaseProductVersionin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDriverNamepublic java.lang.String getDriverName() throws java.sql.SQLException- Specified by:
- getDriverNamein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDriverVersionpublic java.lang.String getDriverVersion() throws java.sql.SQLException- Specified by:
- getDriverVersionin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDriverMajorVersionpublic int getDriverMajorVersion() - Specified by:
- getDriverMajorVersionin interface- java.sql.DatabaseMetaData
 
 - 
getDriverMinorVersionpublic int getDriverMinorVersion() - Specified by:
- getDriverMinorVersionin interface- java.sql.DatabaseMetaData
 
 - 
usesLocalFilespublic boolean usesLocalFiles() throws java.sql.SQLException- Specified by:
- usesLocalFilesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
usesLocalFilePerTablepublic boolean usesLocalFilePerTable() throws java.sql.SQLException- Specified by:
- usesLocalFilePerTablein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsMixedCaseIdentifierspublic boolean supportsMixedCaseIdentifiers() throws java.sql.SQLException- Specified by:
- supportsMixedCaseIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsStatementPoolingpublic boolean supportsStatementPooling() throws java.sql.SQLException- Specified by:
- supportsStatementPoolingin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
locatorsUpdateCopypublic boolean locatorsUpdateCopy() throws java.sql.SQLException- Specified by:
- locatorsUpdateCopyin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
storesUpperCaseIdentifierspublic boolean storesUpperCaseIdentifiers() throws java.sql.SQLException- Specified by:
- storesUpperCaseIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
storesLowerCaseIdentifierspublic boolean storesLowerCaseIdentifiers() throws java.sql.SQLException- Specified by:
- storesLowerCaseIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
storesMixedCaseIdentifierspublic boolean storesMixedCaseIdentifiers() throws java.sql.SQLException- Specified by:
- storesMixedCaseIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsMixedCaseQuotedIdentifierspublic boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLException- Specified by:
- supportsMixedCaseQuotedIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
storesUpperCaseQuotedIdentifierspublic boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLException- Specified by:
- storesUpperCaseQuotedIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
storesLowerCaseQuotedIdentifierspublic boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLException- Specified by:
- storesLowerCaseQuotedIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
storesMixedCaseQuotedIdentifierspublic boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLException- Specified by:
- storesMixedCaseQuotedIdentifiersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getIdentifierQuoteStringpublic java.lang.String getIdentifierQuoteString() throws java.sql.SQLException- Specified by:
- getIdentifierQuoteStringin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSQLKeywordspublic java.lang.String getSQLKeywords() throws java.sql.SQLException- Specified by:
- getSQLKeywordsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getNumericFunctionspublic java.lang.String getNumericFunctions() throws java.sql.SQLExceptionNOTE: Some of the functions listed may only work on Firebird 2.1 or higher, or when equivalent UDFs are installed. - Specified by:
- getNumericFunctionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getStringFunctionspublic java.lang.String getStringFunctions() throws java.sql.SQLExceptionNOTE: Some of the functions listed may only work on Firebird 2.1 or higher, or when equivalent UDFs are installed. - Specified by:
- getStringFunctionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSystemFunctionspublic java.lang.String getSystemFunctions() throws java.sql.SQLExceptionNOTE: Some of the functions listed may only work on Firebird 2.1 or higher, or when equivalent UDFs are installed. - Specified by:
- getSystemFunctionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getTimeDateFunctionspublic java.lang.String getTimeDateFunctions() throws java.sql.SQLExceptionNOTE: Some of the functions listed may only work on Firebird 2.1 or higher, or when equivalent UDFs are installed. - Specified by:
- getTimeDateFunctionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSearchStringEscapepublic java.lang.String getSearchStringEscape() throws java.sql.SQLException- Specified by:
- getSearchStringEscapein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getExtraNameCharacterspublic java.lang.String getExtraNameCharacters() throws java.sql.SQLException- Specified by:
- getExtraNameCharactersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsAlterTableWithAddColumnpublic boolean supportsAlterTableWithAddColumn() throws java.sql.SQLException- Specified by:
- supportsAlterTableWithAddColumnin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsAlterTableWithDropColumnpublic boolean supportsAlterTableWithDropColumn() throws java.sql.SQLException- Specified by:
- supportsAlterTableWithDropColumnin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsColumnAliasingpublic boolean supportsColumnAliasing() throws java.sql.SQLException- Specified by:
- supportsColumnAliasingin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
nullPlusNonNullIsNullpublic boolean nullPlusNonNullIsNull() throws java.sql.SQLException- Specified by:
- nullPlusNonNullIsNullin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsConvertpublic boolean supportsConvert() throws java.sql.SQLException- Specified by:
- supportsConvertin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsConvertpublic boolean supportsConvert(int fromType, int toType) throws java.sql.SQLExceptionSee also org.firebirdsql.jdbc.escape.ConvertFunctionfor caveats.- Specified by:
- supportsConvertin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsTableCorrelationNamespublic boolean supportsTableCorrelationNames() throws java.sql.SQLException- Specified by:
- supportsTableCorrelationNamesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsDifferentTableCorrelationNamespublic boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLException- Specified by:
- supportsDifferentTableCorrelationNamesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsExpressionsInOrderBypublic boolean supportsExpressionsInOrderBy() throws java.sql.SQLException- Specified by:
- supportsExpressionsInOrderByin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsOrderByUnrelatedpublic boolean supportsOrderByUnrelated() throws java.sql.SQLException- Specified by:
- supportsOrderByUnrelatedin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsGroupBypublic boolean supportsGroupBy() throws java.sql.SQLException- Specified by:
- supportsGroupByin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsGroupByUnrelatedpublic boolean supportsGroupByUnrelated() throws java.sql.SQLException- Specified by:
- supportsGroupByUnrelatedin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsGroupByBeyondSelectpublic boolean supportsGroupByBeyondSelect() throws java.sql.SQLException- Specified by:
- supportsGroupByBeyondSelectin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsLikeEscapeClausepublic boolean supportsLikeEscapeClause() throws java.sql.SQLException- Specified by:
- supportsLikeEscapeClausein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsMultipleResultSetspublic boolean supportsMultipleResultSets() throws java.sql.SQLException- Specified by:
- supportsMultipleResultSetsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsMultipleTransactionspublic boolean supportsMultipleTransactions() throws java.sql.SQLException- Specified by:
- supportsMultipleTransactionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsNonNullableColumnspublic boolean supportsNonNullableColumns() throws java.sql.SQLException- Specified by:
- supportsNonNullableColumnsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsMinimumSQLGrammarpublic boolean supportsMinimumSQLGrammar() throws java.sql.SQLException- Specified by:
- supportsMinimumSQLGrammarin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCoreSQLGrammarpublic boolean supportsCoreSQLGrammar() throws java.sql.SQLException- Specified by:
- supportsCoreSQLGrammarin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsExtendedSQLGrammarpublic boolean supportsExtendedSQLGrammar() throws java.sql.SQLException- Specified by:
- supportsExtendedSQLGrammarin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsANSI92EntryLevelSQLpublic boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLException- Specified by:
- supportsANSI92EntryLevelSQLin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsANSI92IntermediateSQLpublic boolean supportsANSI92IntermediateSQL() throws java.sql.SQLException- Specified by:
- supportsANSI92IntermediateSQLin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsANSI92FullSQLpublic boolean supportsANSI92FullSQL() throws java.sql.SQLException- Specified by:
- supportsANSI92FullSQLin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsIntegrityEnhancementFacilitypublic boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLException- Specified by:
- supportsIntegrityEnhancementFacilityin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsOuterJoinspublic boolean supportsOuterJoins() throws java.sql.SQLException- Specified by:
- supportsOuterJoinsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsFullOuterJoinspublic boolean supportsFullOuterJoins() throws java.sql.SQLException- Specified by:
- supportsFullOuterJoinsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsLimitedOuterJoinspublic boolean supportsLimitedOuterJoins() throws java.sql.SQLException- Specified by:
- supportsLimitedOuterJoinsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSchemaTermpublic java.lang.String getSchemaTerm() throws java.sql.SQLException- Specified by:
- getSchemaTermin interface- java.sql.DatabaseMetaData
- Returns:
- the vendor term, always nullbecause schemas are not supported by database server (see JDBC CTS for details).
- Throws:
- java.sql.SQLException
 
 - 
getProcedureTermpublic java.lang.String getProcedureTerm() throws java.sql.SQLException- Specified by:
- getProcedureTermin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getCatalogTermpublic java.lang.String getCatalogTerm() throws java.sql.SQLException- Specified by:
- getCatalogTermin interface- java.sql.DatabaseMetaData
- Returns:
- the vendor term, always nullbecause catalogs are not supported by database server (see JDBC CTS for details).
- Throws:
- java.sql.SQLException
 
 - 
isCatalogAtStartpublic boolean isCatalogAtStart() throws java.sql.SQLException- Specified by:
- isCatalogAtStartin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getCatalogSeparatorpublic java.lang.String getCatalogSeparator() throws java.sql.SQLException- Specified by:
- getCatalogSeparatorin interface- java.sql.DatabaseMetaData
- Returns:
- the separator string, always nullbecause catalogs are not supported by database server (see JDBC CTS for details).
- Throws:
- java.sql.SQLException
 
 - 
supportsSchemasInDataManipulationpublic boolean supportsSchemasInDataManipulation() throws java.sql.SQLException- Specified by:
- supportsSchemasInDataManipulationin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSchemasInProcedureCallspublic boolean supportsSchemasInProcedureCalls() throws java.sql.SQLException- Specified by:
- supportsSchemasInProcedureCallsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSchemasInTableDefinitionspublic boolean supportsSchemasInTableDefinitions() throws java.sql.SQLException- Specified by:
- supportsSchemasInTableDefinitionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSchemasInIndexDefinitionspublic boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLException- Specified by:
- supportsSchemasInIndexDefinitionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSchemasInPrivilegeDefinitionspublic boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLException- Specified by:
- supportsSchemasInPrivilegeDefinitionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCatalogsInDataManipulationpublic boolean supportsCatalogsInDataManipulation() throws java.sql.SQLException- Specified by:
- supportsCatalogsInDataManipulationin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCatalogsInProcedureCallspublic boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLException- Specified by:
- supportsCatalogsInProcedureCallsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCatalogsInTableDefinitionspublic boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLException- Specified by:
- supportsCatalogsInTableDefinitionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCatalogsInIndexDefinitionspublic boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLException- Specified by:
- supportsCatalogsInIndexDefinitionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCatalogsInPrivilegeDefinitionspublic boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLException- Specified by:
- supportsCatalogsInPrivilegeDefinitionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsPositionedDeletepublic boolean supportsPositionedDelete() throws java.sql.SQLException- Specified by:
- supportsPositionedDeletein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsPositionedUpdatepublic boolean supportsPositionedUpdate() throws java.sql.SQLException- Specified by:
- supportsPositionedUpdatein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSelectForUpdatepublic boolean supportsSelectForUpdate() throws java.sql.SQLException- Specified by:
- supportsSelectForUpdatein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsStoredProcedurespublic boolean supportsStoredProcedures() throws java.sql.SQLException- Specified by:
- supportsStoredProceduresin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSubqueriesInComparisonspublic boolean supportsSubqueriesInComparisons() throws java.sql.SQLException- Specified by:
- supportsSubqueriesInComparisonsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSubqueriesInExistspublic boolean supportsSubqueriesInExists() throws java.sql.SQLException- Specified by:
- supportsSubqueriesInExistsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSubqueriesInInspublic boolean supportsSubqueriesInIns() throws java.sql.SQLException- Specified by:
- supportsSubqueriesInInsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSubqueriesInQuantifiedspublic boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLException- Specified by:
- supportsSubqueriesInQuantifiedsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsCorrelatedSubqueriespublic boolean supportsCorrelatedSubqueries() throws java.sql.SQLException- Specified by:
- supportsCorrelatedSubqueriesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsUnionpublic boolean supportsUnion() throws java.sql.SQLException- Specified by:
- supportsUnionin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsUnionAllpublic boolean supportsUnionAll() throws java.sql.SQLException- Specified by:
- supportsUnionAllin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsOpenCursorsAcrossCommitpublic boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLException- Specified by:
- supportsOpenCursorsAcrossCommitin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsOpenCursorsAcrossRollbackpublic boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLException- Specified by:
- supportsOpenCursorsAcrossRollbackin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsOpenStatementsAcrossCommitpublic boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLException- Specified by:
- supportsOpenStatementsAcrossCommitin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsOpenStatementsAcrossRollbackpublic boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLException- Specified by:
- supportsOpenStatementsAcrossRollbackin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxBinaryLiteralLengthpublic int getMaxBinaryLiteralLength() throws java.sql.SQLException- Specified by:
- getMaxBinaryLiteralLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxCharLiteralLengthpublic int getMaxCharLiteralLength() throws java.sql.SQLException- Specified by:
- getMaxCharLiteralLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxColumnNameLengthpublic int getMaxColumnNameLength() throws java.sql.SQLException- Specified by:
- getMaxColumnNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxColumnsInGroupBypublic int getMaxColumnsInGroupBy() throws java.sql.SQLException- Specified by:
- getMaxColumnsInGroupByin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxColumnsInIndexpublic int getMaxColumnsInIndex() throws java.sql.SQLException- Specified by:
- getMaxColumnsInIndexin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxColumnsInOrderBypublic int getMaxColumnsInOrderBy() throws java.sql.SQLException- Specified by:
- getMaxColumnsInOrderByin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxColumnsInSelectpublic int getMaxColumnsInSelect() throws java.sql.SQLException- Specified by:
- getMaxColumnsInSelectin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxColumnsInTablepublic int getMaxColumnsInTable() throws java.sql.SQLException- Specified by:
- getMaxColumnsInTablein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxConnectionspublic int getMaxConnections() throws java.sql.SQLException- Specified by:
- getMaxConnectionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxCursorNameLengthpublic int getMaxCursorNameLength() throws java.sql.SQLException- Specified by:
- getMaxCursorNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxIndexLengthpublic int getMaxIndexLength() throws java.sql.SQLException- Specified by:
- getMaxIndexLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxSchemaNameLengthpublic int getMaxSchemaNameLength() throws java.sql.SQLException- Specified by:
- getMaxSchemaNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxProcedureNameLengthpublic int getMaxProcedureNameLength() throws java.sql.SQLException- Specified by:
- getMaxProcedureNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxCatalogNameLengthpublic int getMaxCatalogNameLength() throws java.sql.SQLException- Specified by:
- getMaxCatalogNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxRowSizepublic int getMaxRowSize() throws java.sql.SQLException- Specified by:
- getMaxRowSizein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
doesMaxRowSizeIncludeBlobspublic boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLException- Specified by:
- doesMaxRowSizeIncludeBlobsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxStatementLengthpublic int getMaxStatementLength() throws java.sql.SQLException- Specified by:
- getMaxStatementLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxStatementspublic int getMaxStatements() throws java.sql.SQLException- Specified by:
- getMaxStatementsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxTableNameLengthpublic int getMaxTableNameLength() throws java.sql.SQLException- Specified by:
- getMaxTableNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxTablesInSelectpublic int getMaxTablesInSelect() throws java.sql.SQLException- Specified by:
- getMaxTablesInSelectin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getMaxUserNameLengthpublic int getMaxUserNameLength() throws java.sql.SQLException- Specified by:
- getMaxUserNameLengthin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDefaultTransactionIsolationpublic int getDefaultTransactionIsolation() throws java.sql.SQLException- Specified by:
- getDefaultTransactionIsolationin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsTransactionspublic boolean supportsTransactions() throws java.sql.SQLException- Specified by:
- supportsTransactionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsTransactionIsolationLevelpublic boolean supportsTransactionIsolationLevel(int level) throws java.sql.SQLException- Specified by:
- supportsTransactionIsolationLevelin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsDataDefinitionAndDataManipulationTransactionspublic boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLExceptionAlthough Firebird supports both DML and DDL in transactions, it is not possible to use objects in the same transaction that defines them. For example, it is not possible to insert into a table in the same transaction that created it. - Specified by:
- supportsDataDefinitionAndDataManipulationTransactionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsDataManipulationTransactionsOnlypublic boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLException- Specified by:
- supportsDataManipulationTransactionsOnlyin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
dataDefinitionCausesTransactionCommitpublic boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLExceptionRead the note on supportsDataDefinitionAndDataManipulationTransactions().- Specified by:
- dataDefinitionCausesTransactionCommitin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
dataDefinitionIgnoredInTransactionspublic boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLExceptionRead the note on supportsDataDefinitionAndDataManipulationTransactions().- Specified by:
- dataDefinitionIgnoredInTransactionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getProcedurespublic java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern) throws java.sql.SQLException- Specified by:
- getProceduresin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getProcedureColumnspublic 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:
- getProcedureColumnsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getTablespublic java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types) throws java.sql.SQLException- Specified by:
- getTablesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSchemaspublic java.sql.ResultSet getSchemas() throws java.sql.SQLException- Specified by:
- getSchemasin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getCatalogspublic java.sql.ResultSet getCatalogs() throws java.sql.SQLException- Specified by:
- getCatalogsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getTableTypespublic java.sql.ResultSet getTableTypes() throws java.sql.SQLException- Specified by:
- getTableTypesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getTableTypeNamespublic java.lang.String[] getTableTypeNames() throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataSupported table type names.- Specified by:
- getTableTypeNamesin interface- FirebirdDatabaseMetaData
- 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
- See Also:
- DatabaseMetaData.getTableTypes()
 
 - 
getColumnspublic java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLExceptionJaybird defines these additional columns: - JB_IS_IDENTITY String  => Indicates whether this column is an identity column (NOTE: Jaybird
 specific column; retrieve by name!).
 There is a subtle difference with the meaning of IS_AUTOINCREMENT. This column indicates if the column is a true identity column.- YES --- if the column is an identity column
- NO --- if the column is not an identity column
 
- JB_IDENTITY_TYPE String  => Type of identity column (NOTE: Jaybird specific column; retrieve by
 name!)
 - ALWAYS --- for a GENERATED ALWAYS AS IDENTITY column (not yet supported in Firebird 3!)
- BY DEFAULT --- for a GENERATED BY DEFAULT AS IDENTITY column
- null --- if the column is not an identity type (or the identity type is unknown)
 
 - Specified by:
- getColumnsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
- JB_IS_IDENTITY String  => Indicates whether this column is an identity column (NOTE: Jaybird
 specific column; retrieve by name!).
 There is a subtle difference with the meaning of 
 - 
getColumnPrivilegespublic java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern) throws java.sql.SQLException- Specified by:
- getColumnPrivilegesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getTablePrivilegespublic java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException- Specified by:
- getTablePrivilegesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
buildTablePrivilegeRSMetaDataprotected final RowDescriptor buildTablePrivilegeRSMetaData() 
 - 
processTablePrivilegesprotected final FBResultSet processTablePrivileges(RowDescriptor rowDescriptor, java.sql.ResultSet fbTablePrivileges) throws java.sql.SQLException - Throws:
- java.sql.SQLException
 
 - 
getBestRowIdentifierpublic java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws java.sql.SQLExceptionJaybird considers the primary key (scoped as bestRowSessionas the best identifier for all scopes. Pseudo columnRDB$DB_KEY(scoped asbestRowTransactionis considered the second-best alternative for scopesbestRowTemporaryandbestRowTransactioniftablehas no primary key.Jaybird currently considers RDB$DB_KEYto beDatabaseMetaData.bestRowTransactioneven if the dbkey_scope is set to 1 (session). This may change in the future. See alsogetRowIdLifetime().- Specified by:
- getBestRowIdentifierin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getVersionColumnspublic java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLExceptionJaybird considers both RDB$DB_KEYandRDB$RECORD_VERSION(Firebird 3 and higher) as version columns.Jaybird only returns pseudo-column as version columns, so 'last updated' columns updated by a trigger, calculated columns, or other forms of change tracking are not reported by this method. - Specified by:
- getVersionColumnsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getPrimaryKeyspublic java.sql.ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException- Specified by:
- getPrimaryKeysin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getImportedKeyspublic java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException- Specified by:
- getImportedKeysin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getExportedKeyspublic java.sql.ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException- Specified by:
- getExportedKeysin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getCrossReferencepublic 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:
- getCrossReferencein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getTypeInfopublic java.sql.ResultSet getTypeInfo() throws java.sql.SQLException- Specified by:
- getTypeInfoin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getIndexInfopublic 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:
- getIndexInfoin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsResultSetTypepublic boolean supportsResultSetType(int type) throws java.sql.SQLException- Specified by:
- supportsResultSetTypein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsResultSetConcurrencypublic boolean supportsResultSetConcurrency(int type, int concurrency) throws java.sql.SQLException- Specified by:
- supportsResultSetConcurrencyin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
ownUpdatesAreVisiblepublic boolean ownUpdatesAreVisible(int type) throws java.sql.SQLException- Specified by:
- ownUpdatesAreVisiblein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
ownDeletesAreVisiblepublic boolean ownDeletesAreVisible(int type) throws java.sql.SQLException- Specified by:
- ownDeletesAreVisiblein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
ownInsertsAreVisiblepublic boolean ownInsertsAreVisible(int type) throws java.sql.SQLException- Specified by:
- ownInsertsAreVisiblein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
othersUpdatesAreVisiblepublic boolean othersUpdatesAreVisible(int type) throws java.sql.SQLException- Specified by:
- othersUpdatesAreVisiblein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
othersDeletesAreVisiblepublic boolean othersDeletesAreVisible(int type) throws java.sql.SQLException- Specified by:
- othersDeletesAreVisiblein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
othersInsertsAreVisiblepublic boolean othersInsertsAreVisible(int type) throws java.sql.SQLException- Specified by:
- othersInsertsAreVisiblein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
updatesAreDetectedpublic boolean updatesAreDetected(int type) throws java.sql.SQLException- Specified by:
- updatesAreDetectedin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
deletesAreDetectedpublic boolean deletesAreDetected(int type) throws java.sql.SQLException- Specified by:
- deletesAreDetectedin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
insertsAreDetectedpublic boolean insertsAreDetected(int type) throws java.sql.SQLException- Specified by:
- insertsAreDetectedin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsBatchUpdatespublic boolean supportsBatchUpdates() throws java.sql.SQLException- Specified by:
- supportsBatchUpdatesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getUDTspublic java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws java.sql.SQLExceptionUDTs are not supported by Firebird. This method will always return an empty ResultSet. - Specified by:
- getUDTsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getConnectionpublic java.sql.Connection getConnection() throws java.sql.SQLException- Specified by:
- getConnectionin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getAttributespublic java.sql.ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern) throws java.sql.SQLExceptionUDTs are not supported by Firebird. This method will always return an empty ResultSet. - Specified by:
- getAttributesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsSavepointspublic boolean supportsSavepoints() throws java.sql.SQLException- Specified by:
- supportsSavepointsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsNamedParameterspublic boolean supportsNamedParameters() throws java.sql.SQLException- Specified by:
- supportsNamedParametersin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsMultipleOpenResultspublic boolean supportsMultipleOpenResults() throws java.sql.SQLException- Specified by:
- supportsMultipleOpenResultsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsGetGeneratedKeyspublic boolean supportsGetGeneratedKeys() throws java.sql.SQLException- Specified by:
- supportsGetGeneratedKeysin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSuperTypespublic java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLExceptionSupertypes are not supported by Firebird. This method will always return an empty ResultSet. - Specified by:
- getSuperTypesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSuperTablespublic java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLExceptionSupertables are not supported by Firebird. This method will always return an empty ResultSet. - Specified by:
- getSuperTablesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsResultSetHoldabilitypublic boolean supportsResultSetHoldability(int holdability) throws java.sql.SQLException- Specified by:
- supportsResultSetHoldabilityin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getResultSetHoldabilitypublic int getResultSetHoldability() throws java.sql.SQLException- Specified by:
- getResultSetHoldabilityin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDatabaseMajorVersionpublic int getDatabaseMajorVersion() throws java.sql.SQLException- Specified by:
- getDatabaseMajorVersionin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getDatabaseMinorVersionpublic int getDatabaseMinorVersion() throws java.sql.SQLException- Specified by:
- getDatabaseMinorVersionin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getOdsMajorVersionpublic int getOdsMajorVersion() throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the major version of the ODS (On-Disk Structure) of the database.- Specified by:
- getOdsMajorVersionin interface- FirebirdDatabaseMetaData
- Returns:
- The major version number of the database itself
- Throws:
- java.sql.SQLException- if a database access error occurs
 
 - 
getOdsMinorVersionpublic int getOdsMinorVersion() throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the minor version of the ODS (On-Disk Structure) of the database.- Specified by:
- getOdsMinorVersionin interface- FirebirdDatabaseMetaData
- Returns:
- The minor version number of the database itself
- Throws:
- java.sql.SQLException- if a database access error occurs
 
 - 
getDatabaseDialectpublic int getDatabaseDialect() throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the dialect of the database.- Specified by:
- getDatabaseDialectin interface- FirebirdDatabaseMetaData
- Returns:
- The dialect of the database
- Throws:
- java.sql.SQLException- if a database access error occurs
- See Also:
- FirebirdDatabaseMetaData.getConnectionDialect()
 
 - 
getConnectionDialectpublic int getConnectionDialect() throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the dialect of the connection.The connection dialect may be different from the database dialect. - Specified by:
- getConnectionDialectin interface- FirebirdDatabaseMetaData
- Returns:
- The dialect of the connection
- Throws:
- java.sql.SQLException- if a database access error occurs
- See Also:
- FirebirdDatabaseMetaData.getDatabaseDialect()
 
 - 
getSQLStateTypepublic int getSQLStateType() throws java.sql.SQLExceptionFirebird primarily uses SQL standard SQL states, but may occasionally use values from X/Open. - Specified by:
- getSQLStateTypein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
supportsStoredFunctionsUsingCallSyntaxpublic boolean supportsStoredFunctionsUsingCallSyntax() throws java.sql.SQLException- Specified by:
- supportsStoredFunctionsUsingCallSyntaxin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
autoCommitFailureClosesAllResultSetspublic boolean autoCommitFailureClosesAllResultSets() throws java.sql.SQLExceptionThe holdable result sets remain open, others are closed, but this happens before the statement is executed. - Specified by:
- autoCommitFailureClosesAllResultSetsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getClientInfoPropertiespublic java.sql.ResultSet getClientInfoProperties() throws java.sql.SQLException- Specified by:
- getClientInfoPropertiesin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getFunctionColumnspublic java.sql.ResultSet getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLExceptionThis method does not return columns of functions defined in packages. - Specified by:
- getFunctionColumnsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getFunctionspublic java.sql.ResultSet getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern) throws java.sql.SQLExceptionJaybird defines a number of additional columns. As these are not defined in JDBC, their position may change with revisions of JDBC. We recommend to retrieve these columns by name. The following additional columns are available: - JB_FUNCTION_SOURCE String => The source of the function (for Firebird 3+ PSQL functions only)).
- JB_FUNCTION_KIND String => The kind of function, one of "UDF", "PSQL" (Firebird 3+) or "UDR" (Firebird 3+)
- JB_MODULE_NAME String => Value of RDB$MODULE_NAME(isnullfor PSQL)
- JB_ENTRYPOINT String => Value of RDB$ENTRYPOINT(isnullfor PSQL)
- JB_ENGINE_NAME String => Value of RDB$ENGINE_NAME(isnullfor UDF and PSQL)
 This method does not return functions defined in packages. - Specified by:
- getFunctionsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getSchemaspublic java.sql.ResultSet getSchemas(java.lang.String catalog, java.lang.String schemaPattern) throws java.sql.SQLException- Specified by:
- getSchemasin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
isWrapperForpublic boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException- Specified by:
- isWrapperForin interface- java.sql.Wrapper
- Throws:
- java.sql.SQLException
 
 - 
unwrappublic <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException- Specified by:
- unwrapin interface- java.sql.Wrapper
- Throws:
- java.sql.SQLException
 
 - 
hasNoWildcards@Deprecated public static boolean hasNoWildcards(java.lang.String pattern) Deprecated.Will be removed in Jaybird 5Determine if there are no SQL wildcard characters ('%' or '_') in the given pattern.- Parameters:
- pattern- The pattern to be checked for wildcards
- Returns:
- trueif there are no wildcards in the pattern,- falseotherwise
 
 - 
stripEscape@Deprecated public static java.lang.String stripEscape(java.lang.String pattern) Deprecated.Will be removed in Jaybird 5Strips all backslash-escapes from a string.- Parameters:
- pattern- The string to be stripped
- Returns:
- pattern with all backslash-escapes removed
 
 - 
escapeWildcardspublic static java.lang.String escapeWildcards(java.lang.String objectName) Escapes the like wildcards and escape (\_%in the provided search string with a\.Primary purpose is to escape object names with wildcards for use in metadata patterns for literal matches, but it can also be used to escape for SQL LIKE.- Parameters:
- objectName- Object name to escape.
- Returns:
- Object name with wildcards escaped.
 
 - 
getWantsSystemTablesprotected java.lang.String getWantsSystemTables(java.lang.String[] types) 
 - 
getWantsTablesprotected java.lang.String getWantsTables(java.lang.String[] types) 
 - 
getWantsViewsprotected java.lang.String getWantsViews(java.lang.String[] types) 
 - 
getPseudoColumnspublic java.sql.ResultSet getPseudoColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException- Specified by:
- getPseudoColumnsin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
generatedKeyAlwaysReturnedpublic boolean generatedKeyAlwaysReturned() throws java.sql.SQLException- Specified by:
- generatedKeyAlwaysReturnedin interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getProcedureSourceCodepublic java.lang.String getProcedureSourceCode(java.lang.String procedureName) throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the source of a stored procedure.- Specified by:
- getProcedureSourceCodein interface- FirebirdDatabaseMetaData
- Parameters:
- procedureName- name of the stored procedure.
- Returns:
- source of the stored procedure.
- Throws:
- java.sql.SQLException- if specified procedure cannot be found.
 
 - 
getTriggerSourceCodepublic java.lang.String getTriggerSourceCode(java.lang.String triggerName) throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the source of a trigger.- Specified by:
- getTriggerSourceCodein interface- FirebirdDatabaseMetaData
- Parameters:
- triggerName- name of the trigger.
- Returns:
- source of the trigger.
- Throws:
- java.sql.SQLException- if specified trigger cannot be found.
 
 - 
getViewSourceCodepublic java.lang.String getViewSourceCode(java.lang.String viewName) throws java.sql.SQLExceptionDescription copied from interface:FirebirdDatabaseMetaDataGet the source of a view.- Specified by:
- getViewSourceCodein interface- FirebirdDatabaseMetaData
- Parameters:
- viewName- name of the view.
- Returns:
- source of the view.
- Throws:
- java.sql.SQLException- if specified view cannot be found.
 
 - 
getBytesprotected static byte[] getBytes(java.lang.String value) 
 - 
doQueryprotected java.sql.ResultSet doQuery(java.lang.String sql, java.util.List<java.lang.String> params) throws java.sql.SQLExceptionExecute an sql query with a given set of parameters.- Parameters:
- sql- The sql statement to be used for the query
- params- The parameters to be used in the query
- Throws:
- java.sql.SQLException- if a database access error occurs
 
 - 
doQueryprotected java.sql.ResultSet doQuery(java.lang.String sql, java.util.List<java.lang.String> params, boolean standalone) throws java.sql.SQLExceptionExecute an sql query with a given set of parameters.- Parameters:
- sql- The sql statement to be used for the query
- params- The parameters to be used in the query
- standalone- The query to be executed is a standalone query (should not be cached and be closed asap)
- Throws:
- java.sql.SQLException- if a database access error occurs
 
 - 
getRowIdLifetimepublic java.sql.RowIdLifetime getRowIdLifetime() throws java.sql.SQLExceptionMinimum lifetime supported by Firebird is transaction-scope, and this can be changed to session-scope with isc_dpb_dbkey_scopeset to1(eg connection propertydbkey_scope=1). This implementation, however, will always reportRowIdLifetime.ROWID_VALID_TRANSACTION.- Specified by:
- getRowIdLifetimein interface- java.sql.DatabaseMetaData
- Throws:
- java.sql.SQLException
 
 - 
getJDBCMajorVersionpublic int getJDBCMajorVersion() - Specified by:
- getJDBCMajorVersionin interface- java.sql.DatabaseMetaData
 
 - 
getJDBCMinorVersionpublic int getJDBCMinorVersion() - Specified by:
- getJDBCMinorVersionin interface- java.sql.DatabaseMetaData
 
 - 
getDbMetadataMediatorprotected DbMetadataMediator getDbMetadataMediator() 
 
- 
 
-