Class ClientDatabaseMetaData
- All Implemented Interfaces:
DatabaseMetaData
,Wrapper
- Direct Known Subclasses:
NetDatabaseMetaData
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate Agent
private static final int
private static final int
protected ClientConnection
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private Object[]
private boolean
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
(package private) ProductLevel
private final int
The JDBC major version supported by the server.private final int
The JDBC minor version supported by the server.private static final short
private static final short
private static final short
private static final short
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private boolean
True if the server supports transport of boolean parameter values as booleans.private boolean
True if the server supports boolean valuesprivate static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private boolean
True if the server supports aborting a statement whilst transferring EXTDTA objects.private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private boolean
private static final int
private boolean
DERBY-4805(Increase the length of the RDBNAM field in the DRDA implementation) True if the server supports RDBNAM longer than 255 characterprivate static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private boolean
True if the server supports QRYCLSIMP.private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private boolean
True if the server supports session data cachingprivate static final int
private static final int
private boolean
True if the server supports nanoseconds in timestampsprivate static final int
private static final int
private boolean
True if the server supports UDTsprivate static final int
private static final int
private static final int
private static final int
private static final int
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
-
Constructor Summary
ConstructorsModifierConstructorDescriptionprotected
ClientDatabaseMetaData
(Agent agent, ClientConnection connection, ProductLevel productLevel) -
Method Summary
Modifier and TypeMethodDescriptionboolean
boolean
final boolean
Retrieves whether anSQLException
will cause all openResultSet
s to be closed when auto-commit istrue
.protected void
A "public" version of checkForClosedConnection() that throws SQLException instead of SqlException.private void
private void
checkServerJdbcVersionX
(String method, int major, int minor) Checks whether the server supports a JDBC version.private void
boolean
boolean
boolean
deletesAreDetected
(int type) boolean
private ClientResultSet
boolean
See DatabaseMetaData javadocgetAttributes
(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) private ClientResultSet
getBestRowIdentifier
(String catalog, String schema, String table, int scope, boolean nullable) private ClientResultSet
getBestRowIdentifierX
(String catalog, String schema, String table, int scope, boolean nullable) private ClientResultSet
Returns a list of the client info properties supported by the driver.private ClientResultSet
Untraced version ofgetClientInfoProperties()
.getColumnPrivileges
(String catalog, String schema, String table, String columnNamePattern) private ClientResultSet
getColumnPrivilegesX
(String catalog, String schema, String table, String columnNamePattern) getColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) private ClientResultSet
getColumnsX
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) getCrossReference
(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) private ClientResultSet
getCrossReferenceX
(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) int
int
int
int
int
getExportedKeys
(String catalog, String schema, String table) private ClientResultSet
getExportedKeysX
(String catalog, String schema, String table) getFunctionColumns
(String catalog, String schemaPattern, String functionNamePattern, String parameterNamePattern) Get the function names available in the database.private ClientResultSet
getFunctionColumnsX
(String catalog, String schemaPattern, String functionNamePattern, String parameterNamePattern) Untraced version ofgetFunctionColumns(String, String, String, String)
.getFunctions
(String catalog, String schemaPattern, String functionNamePattern) Get the function names available in the database.private ClientResultSet
getFunctionsX
(String catalog, String schemaPattern, String functionNamePattern) Untraced version ofgetFunctions(String, String, String)
.getImportedKeys
(String catalog, String schema, String table) private ClientResultSet
getImportedKeysX
(String catalog, String schema, String table) getIndexInfo
(String catalog, String schema, String table, boolean unique, boolean approximate) private ClientResultSet
getIndexInfoX
(String catalog, String schema, String table, boolean unique, boolean approximate) int
int
int
int
int
int
int
int
int
int
int
int
int
int
long
See DatabaseMetaData javadocint
int
int
int
int
int
int
int
private boolean
getMetaDataInfoBoolean
(int infoCallIndex) private boolean
getMetaDataInfoBoolean_supportsConvert
(int infoCallIndex, int fromType, int toType) private boolean
getMetaDataInfoBooleanWithType
(int infoCallIndex, int type) private boolean
getMetaDataInfoBooleanWithTypeClient
(int infoCallIndex, int type) private boolean
getMetaDataInfoBooleanWithTypeServer
(int infoCallIndex, int type) private int
getMetaDataInfoInt
(int infoCallIndex) private boolean
getMetaDataInfoInt_SupportsResultSetConcurrency
(int infoCallIndex, int type, int concurrency) private String
getMetaDataInfoString
(int infoCallIndex) private String
getPrimaryKeys
(String catalog, String schema, String table) private ClientResultSet
getPrimaryKeysX
(String catalog, String schema, String table) getProcedureColumns
(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) private ClientResultSet
getProcedureColumnsX
(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) getProcedures
(String catalog, String schemaPattern, String procedureNamePattern) private ClientResultSet
getProceduresX
(String catalog, String schemaPattern, String procedureNamePattern) getPseudoColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) private ClientResultSet
int
Indicates whether or not this data source supports the SQLROWID
type.getSchemas
(String catalog, String schemaPattern) Get the schema names available in this database.private ClientResultSet
private ClientResultSet
getSchemasX
(String catalog, String schemaPattern) Untraced version ofgetSchemas(String, String)
.int
getSuperTables
(String catalog, String schemaPattern, String tableNamePattern) private ClientResultSet
getSuperTypes
(String catalog, String schemaPattern, String typeNamePattern) private ClientResultSet
getTablePrivileges
(String catalog, String schemaPattern, String tableNamePattern) private ClientResultSet
getTablePrivilegesX
(String catalog, String schemaPattern, String tableNamePattern) private ClientResultSet
getTablesX
(String catalog, String schemaPattern, String tableNamePattern, String[] types) private ClientResultSet
private ClientResultSet
private ClientResultSet
getURL()
abstract String
getURL_()
getVersionColumns
(String catalog, String schema, String table) private ClientResultSet
getVersionColumnsX
(String catalog, String schema, String table) boolean
insertsAreDetected
(int type) boolean
boolean
boolean
isWrapperFor
(Class<?> interfaces) Returns false unlessinterfaces
is implementedboolean
private void
boolean
boolean
boolean
boolean
boolean
boolean
othersDeletesAreVisible
(int type) boolean
othersInsertsAreVisible
(int type) boolean
othersUpdatesAreVisible
(int type) boolean
ownDeletesAreVisible
(int type) boolean
ownInsertsAreVisible
(int type) boolean
ownUpdatesAreVisible
(int type) private ClientPreparedStatement
final boolean
final boolean
Check if the server accepts receiving booleans as parameter values.private boolean
Check if server supports boolean valuesfinal boolean
Check if server supports product specific EXTDTA abort protocol.final boolean
final boolean
Check whether the server has full support for the QRYCLSIMP parameter in OPNQRY.final boolean
Check if server supports session data cachingfinal boolean
Check if server supports nanoseconds in timestampsfinal boolean
Check if server supports UDTsboolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsConvert
(int fromType, int toType) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
Derby does not support the Types.REF_CURSOR type.boolean
supportsResultSetConcurrency
(int type, int concurrency) boolean
supportsResultSetHoldability
(int holdability) boolean
supportsResultSetType
(int type) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
final boolean
Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsTransactionIsolationLevel
(int level) boolean
boolean
boolean
<T> T
Returnsthis
if this class implements the interfaceboolean
updatesAreDetected
(int type) boolean
boolean
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.sql.DatabaseMetaData
supportsSharding
-
Field Details
-
SQL_BEST_ROWID
private static final short SQL_BEST_ROWID- See Also:
-
SQL_ROWVER
private static final short SQL_ROWVER- See Also:
-
SQL_INDEX_UNIQUE
private static final short SQL_INDEX_UNIQUE- See Also:
-
SQL_INDEX_ALL
private static final short SQL_INDEX_ALL- See Also:
-
agent_
-
connection_
-
numberOfMetaDataInfoMethods__
private static final int numberOfMetaDataInfoMethods__- See Also:
-
metaDataInfoCache_
-
metaDataInfoIsCached_
private boolean metaDataInfoIsCached_ -
productLevel_
ProductLevel productLevel_ -
serverJdbcMajorVersion
private final int serverJdbcMajorVersionThe JDBC major version supported by the server. -
serverJdbcMinorVersion
private final int serverJdbcMinorVersionThe JDBC minor version supported by the server. -
supportsQryclsimp_
private boolean supportsQryclsimp_True if the server supports QRYCLSIMP. -
supportsLayerBStreaming_
private boolean supportsLayerBStreaming_ -
supportsSessionDataCaching_
private boolean supportsSessionDataCaching_True if the server supports session data caching -
supportsUDTs_
private boolean supportsUDTs_True if the server supports UDTs -
supportsEXTDTAAbort_
private boolean supportsEXTDTAAbort_True if the server supports aborting a statement whilst transferring EXTDTA objects. Note that there are two types of aborts, depending on whether an object is being transferred to the server using DDM layer B streaming or not. -
supportsTimestampNanoseconds_
private boolean supportsTimestampNanoseconds_True if the server supports nanoseconds in timestamps -
supportsBooleanValues_
private boolean supportsBooleanValues_True if the server supports boolean values -
supportsLongRDBNAM_
private boolean supportsLongRDBNAM_DERBY-4805(Increase the length of the RDBNAM field in the DRDA implementation) True if the server supports RDBNAM longer than 255 character -
supportsBooleanParameterTransport_
private boolean supportsBooleanParameterTransport_True if the server supports transport of boolean parameter values as booleans. If false, boolean values used as parameters in prepared statements will be transported as smallints to preserve backwards compatibility. See DERBY-4965. -
allProceduresAreCallable__
private static final int allProceduresAreCallable__- See Also:
-
allTablesAreSelectable__
private static final int allTablesAreSelectable__- See Also:
-
nullsAreSortedHigh__
private static final int nullsAreSortedHigh__- See Also:
-
nullsAreSortedLow__
private static final int nullsAreSortedLow__- See Also:
-
nullsAreSortedAtStart__
private static final int nullsAreSortedAtStart__- See Also:
-
nullsAreSortedAtEnd__
private static final int nullsAreSortedAtEnd__- See Also:
-
usesLocalFiles__
private static final int usesLocalFiles__- See Also:
-
usesLocalFilePerTable__
private static final int usesLocalFilePerTable__- See Also:
-
storesUpperCaseIdentifiers__
private static final int storesUpperCaseIdentifiers__- See Also:
-
storesLowerCaseIdentifiers__
private static final int storesLowerCaseIdentifiers__- See Also:
-
storesMixedCaseIdentifiers__
private static final int storesMixedCaseIdentifiers__- See Also:
-
storesUpperCaseQuotedIdentifiers__
private static final int storesUpperCaseQuotedIdentifiers__- See Also:
-
storesLowerCaseQuotedIdentifiers__
private static final int storesLowerCaseQuotedIdentifiers__- See Also:
-
storesMixedCaseQuotedIdentifiers__
private static final int storesMixedCaseQuotedIdentifiers__- See Also:
-
getSQLKeywords__
private static final int getSQLKeywords__- See Also:
-
getNumericFunctions__
private static final int getNumericFunctions__- See Also:
-
getStringFunctions__
private static final int getStringFunctions__- See Also:
-
getSystemFunctions__
private static final int getSystemFunctions__- See Also:
-
getTimeDateFunctions__
private static final int getTimeDateFunctions__- See Also:
-
getSearchStringEscape__
private static final int getSearchStringEscape__- See Also:
-
getExtraNameCharacters__
private static final int getExtraNameCharacters__- See Also:
-
supportsAlterTableWithAddColumn__
private static final int supportsAlterTableWithAddColumn__- See Also:
-
supportsAlterTableWithDropColumn__
private static final int supportsAlterTableWithDropColumn__- See Also:
-
supportsConvert__
private static final int supportsConvert__- See Also:
-
supportsConvertType__
private static final int supportsConvertType__- See Also:
-
supportsDifferentTableCorrelationNames__
private static final int supportsDifferentTableCorrelationNames__- See Also:
-
supportsExpressionsInOrderBy__
private static final int supportsExpressionsInOrderBy__- See Also:
-
supportsGroupBy__
private static final int supportsGroupBy__- See Also:
-
supportsGroupByBeyondSelect__
private static final int supportsGroupByBeyondSelect__- See Also:
-
supportsMultipleResultSets__
private static final int supportsMultipleResultSets__- See Also:
-
supportsMultipleTransactions__
private static final int supportsMultipleTransactions__- See Also:
-
supportsCoreSQLGrammar__
private static final int supportsCoreSQLGrammar__- See Also:
-
supportsExtendedSQLGrammar__
private static final int supportsExtendedSQLGrammar__- See Also:
-
supportsANSI92IntermediateSQL__
private static final int supportsANSI92IntermediateSQL__- See Also:
-
supportsANSI92FullSQL__
private static final int supportsANSI92FullSQL__- See Also:
-
supportsIntegrityEnhancementFacility__
private static final int supportsIntegrityEnhancementFacility__- See Also:
-
supportsOuterJoins__
private static final int supportsOuterJoins__- See Also:
-
supportsFullOuterJoins__
private static final int supportsFullOuterJoins__- See Also:
-
supportsLimitedOuterJoins__
private static final int supportsLimitedOuterJoins__- See Also:
-
getSchemaTerm__
private static final int getSchemaTerm__- See Also:
-
getProcedureTerm__
private static final int getProcedureTerm__- See Also:
-
getCatalogTerm__
private static final int getCatalogTerm__- See Also:
-
isCatalogAtStart__
private static final int isCatalogAtStart__- See Also:
-
getCatalogSeparator__
private static final int getCatalogSeparator__- See Also:
-
supportsSchemasInDataManipulation__
private static final int supportsSchemasInDataManipulation__- See Also:
-
supportsSchemasInProcedureCalls__
private static final int supportsSchemasInProcedureCalls__- See Also:
-
supportsSchemasInTableDefinitions__
private static final int supportsSchemasInTableDefinitions__- See Also:
-
supportsSchemasInIndexDefinitions__
private static final int supportsSchemasInIndexDefinitions__- See Also:
-
supportsSchemasInPrivilegeDefinitions__
private static final int supportsSchemasInPrivilegeDefinitions__- See Also:
-
supportsCatalogsInDataManipulation__
private static final int supportsCatalogsInDataManipulation__- See Also:
-
supportsCatalogsInProcedureCalls__
private static final int supportsCatalogsInProcedureCalls__- See Also:
-
supportsCatalogsInTableDefinitions__
private static final int supportsCatalogsInTableDefinitions__- See Also:
-
supportsCatalogsInIndexDefinitions__
private static final int supportsCatalogsInIndexDefinitions__- See Also:
-
supportsCatalogsInPrivilegeDefinitions__
private static final int supportsCatalogsInPrivilegeDefinitions__- See Also:
-
supportsPositionedDelete__
private static final int supportsPositionedDelete__- See Also:
-
supportsPositionedUpdate__
private static final int supportsPositionedUpdate__- See Also:
-
supportsSelectForUpdate__
private static final int supportsSelectForUpdate__- See Also:
-
supportsStoredProcedures__
private static final int supportsStoredProcedures__- See Also:
-
supportsSubqueriesInComparisons__
private static final int supportsSubqueriesInComparisons__- See Also:
-
supportsUnion__
private static final int supportsUnion__- See Also:
-
supportsUnionAll__
private static final int supportsUnionAll__- See Also:
-
supportsOpenCursorsAcrossCommit__
private static final int supportsOpenCursorsAcrossCommit__- See Also:
-
supportsOpenCursorsAcrossRollback__
private static final int supportsOpenCursorsAcrossRollback__- See Also:
-
supportsOpenStatementsAcrossCommit__
private static final int supportsOpenStatementsAcrossCommit__- See Also:
-
supportsOpenStatementsAcrossRollback__
private static final int supportsOpenStatementsAcrossRollback__- See Also:
-
getMaxBinaryLiteralLength__
private static final int getMaxBinaryLiteralLength__- See Also:
-
getMaxCharLiteralLength__
private static final int getMaxCharLiteralLength__- See Also:
-
getMaxColumnNameLength__
private static final int getMaxColumnNameLength__- See Also:
-
getMaxColumnsInGroupBy__
private static final int getMaxColumnsInGroupBy__- See Also:
-
getMaxColumnsInIndex__
private static final int getMaxColumnsInIndex__- See Also:
-
getMaxColumnsInOrderBy__
private static final int getMaxColumnsInOrderBy__- See Also:
-
getMaxColumnsInSelect__
private static final int getMaxColumnsInSelect__- See Also:
-
getMaxColumnsInTable__
private static final int getMaxColumnsInTable__- See Also:
-
getMaxConnections__
private static final int getMaxConnections__- See Also:
-
getMaxCursorNameLength__
private static final int getMaxCursorNameLength__- See Also:
-
getMaxIndexLength__
private static final int getMaxIndexLength__- See Also:
-
getMaxSchemaNameLength__
private static final int getMaxSchemaNameLength__- See Also:
-
getMaxProcedureNameLength__
private static final int getMaxProcedureNameLength__- See Also:
-
getMaxCatalogNameLength__
private static final int getMaxCatalogNameLength__- See Also:
-
getMaxRowSize__
private static final int getMaxRowSize__- See Also:
-
doesMaxRowSizeIncludeBlobs__
private static final int doesMaxRowSizeIncludeBlobs__- See Also:
-
getMaxStatementLength__
private static final int getMaxStatementLength__- See Also:
-
getMaxStatements__
private static final int getMaxStatements__- See Also:
-
getMaxTableNameLength__
private static final int getMaxTableNameLength__- See Also:
-
getMaxTablesInSelect__
private static final int getMaxTablesInSelect__- See Also:
-
getMaxUserNameLength__
private static final int getMaxUserNameLength__- See Also:
-
getDefaultTransactionIsolation__
private static final int getDefaultTransactionIsolation__- See Also:
-
supportsTransactions__
private static final int supportsTransactions__- See Also:
-
supportsTransactionIsolationLevel__
private static final int supportsTransactionIsolationLevel__- See Also:
-
supportsDataDefinitionAndDataManipulationTransactions__
private static final int supportsDataDefinitionAndDataManipulationTransactions__- See Also:
-
supportsDataManipulationTransactionsOnly__
private static final int supportsDataManipulationTransactionsOnly__- See Also:
-
dataDefinitionCausesTransactionCommit__
private static final int dataDefinitionCausesTransactionCommit__- See Also:
-
dataDefinitionIgnoredInTransactions__
private static final int dataDefinitionIgnoredInTransactions__- See Also:
-
supportsResultSetType__
private static final int supportsResultSetType__- See Also:
-
supportsResultSetConcurrency__
private static final int supportsResultSetConcurrency__- See Also:
-
ownUpdatesAreVisible__
private static final int ownUpdatesAreVisible__- See Also:
-
ownDeletesAreVisible__
private static final int ownDeletesAreVisible__- See Also:
-
ownInsertsAreVisible__
private static final int ownInsertsAreVisible__- See Also:
-
othersUpdatesAreVisible__
private static final int othersUpdatesAreVisible__- See Also:
-
othersDeletesAreVisible__
private static final int othersDeletesAreVisible__- See Also:
-
othersInsertsAreVisible__
private static final int othersInsertsAreVisible__- See Also:
-
updatesAreDetected__
private static final int updatesAreDetected__- See Also:
-
deletesAreDetected__
private static final int deletesAreDetected__- See Also:
-
insertsAreDetected__
private static final int insertsAreDetected__- See Also:
-
supportsBatchUpdates__
private static final int supportsBatchUpdates__- See Also:
-
-
Constructor Details
-
ClientDatabaseMetaData
protected ClientDatabaseMetaData(Agent agent, ClientConnection connection, ProductLevel productLevel)
-
-
Method Details
-
allProceduresAreCallable
- Specified by:
allProceduresAreCallable
in interfaceDatabaseMetaData
- Throws:
SQLException
-
allTablesAreSelectable
- Specified by:
allTablesAreSelectable
in interfaceDatabaseMetaData
- Throws:
SQLException
-
nullsAreSortedHigh
- Specified by:
nullsAreSortedHigh
in interfaceDatabaseMetaData
- Throws:
SQLException
-
nullsAreSortedLow
- Specified by:
nullsAreSortedLow
in interfaceDatabaseMetaData
- Throws:
SQLException
-
nullsAreSortedAtStart
- Specified by:
nullsAreSortedAtStart
in interfaceDatabaseMetaData
- Throws:
SQLException
-
nullsAreSortedAtEnd
- Specified by:
nullsAreSortedAtEnd
in interfaceDatabaseMetaData
- Throws:
SQLException
-
usesLocalFiles
- Specified by:
usesLocalFiles
in interfaceDatabaseMetaData
- Throws:
SQLException
-
usesLocalFilePerTable
- Specified by:
usesLocalFilePerTable
in interfaceDatabaseMetaData
- Throws:
SQLException
-
storesUpperCaseIdentifiers
- Specified by:
storesUpperCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
storesLowerCaseIdentifiers
- Specified by:
storesLowerCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
storesMixedCaseIdentifiers
- Specified by:
storesMixedCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
storesUpperCaseQuotedIdentifiers
- Specified by:
storesUpperCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
storesLowerCaseQuotedIdentifiers
- Specified by:
storesLowerCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
storesMixedCaseQuotedIdentifiers
- Specified by:
storesMixedCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSQLKeywords
- Specified by:
getSQLKeywords
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getNumericFunctions
- Specified by:
getNumericFunctions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getStringFunctions
- Specified by:
getStringFunctions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSystemFunctions
- Specified by:
getSystemFunctions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getTimeDateFunctions
- Specified by:
getTimeDateFunctions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSearchStringEscape
- Specified by:
getSearchStringEscape
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getExtraNameCharacters
- Specified by:
getExtraNameCharacters
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsAlterTableWithAddColumn
- Specified by:
supportsAlterTableWithAddColumn
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsAlterTableWithDropColumn
- Specified by:
supportsAlterTableWithDropColumn
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsConvert
- Specified by:
supportsConvert
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsConvert
- Specified by:
supportsConvert
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsDifferentTableCorrelationNames
- Specified by:
supportsDifferentTableCorrelationNames
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsExpressionsInOrderBy
- Specified by:
supportsExpressionsInOrderBy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsGroupBy
- Specified by:
supportsGroupBy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsGroupByBeyondSelect
- Specified by:
supportsGroupByBeyondSelect
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsMultipleResultSets
- Specified by:
supportsMultipleResultSets
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsMultipleTransactions
- Specified by:
supportsMultipleTransactions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsCoreSQLGrammar
- Specified by:
supportsCoreSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsExtendedSQLGrammar
- Specified by:
supportsExtendedSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsANSI92IntermediateSQL
- Specified by:
supportsANSI92IntermediateSQL
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsANSI92FullSQL
- Specified by:
supportsANSI92FullSQL
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsIntegrityEnhancementFacility
- Specified by:
supportsIntegrityEnhancementFacility
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsOuterJoins
- Specified by:
supportsOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsFullOuterJoins
- Specified by:
supportsFullOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsLimitedOuterJoins
- Specified by:
supportsLimitedOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSchemaTerm
- Specified by:
getSchemaTerm
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getProcedureTerm
- Specified by:
getProcedureTerm
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCatalogTerm
- Specified by:
getCatalogTerm
in interfaceDatabaseMetaData
- Throws:
SQLException
-
isCatalogAtStart
- Specified by:
isCatalogAtStart
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCatalogSeparator
- Specified by:
getCatalogSeparator
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSchemasInDataManipulation
- Specified by:
supportsSchemasInDataManipulation
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSchemasInProcedureCalls
- Specified by:
supportsSchemasInProcedureCalls
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSchemasInTableDefinitions
- Specified by:
supportsSchemasInTableDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSchemasInIndexDefinitions
- Specified by:
supportsSchemasInIndexDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSchemasInPrivilegeDefinitions
- Specified by:
supportsSchemasInPrivilegeDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsCatalogsInDataManipulation
- Specified by:
supportsCatalogsInDataManipulation
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsCatalogsInProcedureCalls
- Specified by:
supportsCatalogsInProcedureCalls
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsCatalogsInTableDefinitions
- Specified by:
supportsCatalogsInTableDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsCatalogsInIndexDefinitions
- Specified by:
supportsCatalogsInIndexDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsCatalogsInPrivilegeDefinitions
- Specified by:
supportsCatalogsInPrivilegeDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsPositionedDelete
- Specified by:
supportsPositionedDelete
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsPositionedUpdate
- Specified by:
supportsPositionedUpdate
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSelectForUpdate
- Specified by:
supportsSelectForUpdate
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsStoredProcedures
- Specified by:
supportsStoredProcedures
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSubqueriesInComparisons
- Specified by:
supportsSubqueriesInComparisons
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsUnion
- Specified by:
supportsUnion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsUnionAll
- Specified by:
supportsUnionAll
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsOpenCursorsAcrossCommit
- Specified by:
supportsOpenCursorsAcrossCommit
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsOpenCursorsAcrossRollback
- Specified by:
supportsOpenCursorsAcrossRollback
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsOpenStatementsAcrossCommit
- Specified by:
supportsOpenStatementsAcrossCommit
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsOpenStatementsAcrossRollback
- Specified by:
supportsOpenStatementsAcrossRollback
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxBinaryLiteralLength
- Specified by:
getMaxBinaryLiteralLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxCharLiteralLength
- Specified by:
getMaxCharLiteralLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxColumnNameLength
- Specified by:
getMaxColumnNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxColumnsInGroupBy
- Specified by:
getMaxColumnsInGroupBy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxColumnsInIndex
- Specified by:
getMaxColumnsInIndex
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxColumnsInOrderBy
- Specified by:
getMaxColumnsInOrderBy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxColumnsInSelect
- Specified by:
getMaxColumnsInSelect
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxColumnsInTable
- Specified by:
getMaxColumnsInTable
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxConnections
- Specified by:
getMaxConnections
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxCursorNameLength
- Specified by:
getMaxCursorNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxIndexLength
- Specified by:
getMaxIndexLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxSchemaNameLength
- Specified by:
getMaxSchemaNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxProcedureNameLength
- Specified by:
getMaxProcedureNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxCatalogNameLength
- Specified by:
getMaxCatalogNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxRowSize
- Specified by:
getMaxRowSize
in interfaceDatabaseMetaData
- Throws:
SQLException
-
doesMaxRowSizeIncludeBlobs
- Specified by:
doesMaxRowSizeIncludeBlobs
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxStatementLength
- Specified by:
getMaxStatementLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxStatements
- Specified by:
getMaxStatements
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxTableNameLength
- Specified by:
getMaxTableNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxTablesInSelect
- Specified by:
getMaxTablesInSelect
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxUserNameLength
- Specified by:
getMaxUserNameLength
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDefaultTransactionIsolation
- Specified by:
getDefaultTransactionIsolation
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsTransactions
- Specified by:
supportsTransactions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsTransactionIsolationLevel
- Specified by:
supportsTransactionIsolationLevel
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsDataDefinitionAndDataManipulationTransactions
- Specified by:
supportsDataDefinitionAndDataManipulationTransactions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsDataManipulationTransactionsOnly
- Specified by:
supportsDataManipulationTransactionsOnly
in interfaceDatabaseMetaData
- Throws:
SQLException
-
dataDefinitionCausesTransactionCommit
- Specified by:
dataDefinitionCausesTransactionCommit
in interfaceDatabaseMetaData
- Throws:
SQLException
-
dataDefinitionIgnoredInTransactions
- Specified by:
dataDefinitionIgnoredInTransactions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsResultSetType
- Specified by:
supportsResultSetType
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsResultSetConcurrency
- Specified by:
supportsResultSetConcurrency
in interfaceDatabaseMetaData
- Throws:
SQLException
-
ownUpdatesAreVisible
- Specified by:
ownUpdatesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLException
-
ownDeletesAreVisible
- Specified by:
ownDeletesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLException
-
ownInsertsAreVisible
- Specified by:
ownInsertsAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLException
-
othersUpdatesAreVisible
- Specified by:
othersUpdatesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLException
-
othersDeletesAreVisible
- Specified by:
othersDeletesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLException
-
othersInsertsAreVisible
- Specified by:
othersInsertsAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLException
-
updatesAreDetected
- Specified by:
updatesAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLException
-
deletesAreDetected
- Specified by:
deletesAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLException
-
insertsAreDetected
- Specified by:
insertsAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsBatchUpdates
- Specified by:
supportsBatchUpdates
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSavepoints
- Specified by:
supportsSavepoints
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getURL_
- Throws:
SqlException
-
getURL
- Specified by:
getURL
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getUserName
- Specified by:
getUserName
in interfaceDatabaseMetaData
- Throws:
SQLException
-
isReadOnly
- Specified by:
isReadOnly
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseProductName
- Specified by:
getDatabaseProductName
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseProductVersion
- Specified by:
getDatabaseProductVersion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDriverName
- Specified by:
getDriverName
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDriverVersion
- Specified by:
getDriverVersion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDriverMajorVersion
public int getDriverMajorVersion()- Specified by:
getDriverMajorVersion
in interfaceDatabaseMetaData
-
getDriverMinorVersion
public int getDriverMinorVersion()- Specified by:
getDriverMinorVersion
in interfaceDatabaseMetaData
-
supportsMixedCaseIdentifiers
- Specified by:
supportsMixedCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsMixedCaseQuotedIdentifiers
- Specified by:
supportsMixedCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getIdentifierQuoteString
- Specified by:
getIdentifierQuoteString
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsColumnAliasing
- Specified by:
supportsColumnAliasing
in interfaceDatabaseMetaData
- Throws:
SQLException
-
nullPlusNonNullIsNull
- Specified by:
nullPlusNonNullIsNull
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsTableCorrelationNames
- Specified by:
supportsTableCorrelationNames
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsLikeEscapeClause
- Specified by:
supportsLikeEscapeClause
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsNonNullableColumns
- Specified by:
supportsNonNullableColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsMinimumSQLGrammar
- Specified by:
supportsMinimumSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsANSI92EntryLevelSQL
- Specified by:
supportsANSI92EntryLevelSQL
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSubqueriesInExists
- Specified by:
supportsSubqueriesInExists
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSubqueriesInIns
- Specified by:
supportsSubqueriesInIns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSubqueriesInQuantifieds
- Specified by:
supportsSubqueriesInQuantifieds
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getProcedures
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException - Specified by:
getProcedures
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getProceduresX
private ClientResultSet getProceduresX(String catalog, String schemaPattern, String procedureNamePattern) throws SqlException - Throws:
SqlException
-
getProcedureColumns
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException - Specified by:
getProcedureColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getProcedureColumnsX
private ClientResultSet getProcedureColumnsX(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SqlException - Throws:
SqlException
-
getFunctions
public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException Get the function names available in the database. Calls stored procedureSYSIBM.SQLFunctions(CatalogName varchar(128), SchemaName varchar(128), FuncName varchar(128), Options varchar(4000))
on the server. This procedure will in turn callEmbedDatabaseMetaData.getFunctions(String,String,String)
Compatibility: Only available if both server and client version < 10.1, and JDK version >= 1.6. Older clients will not have this method available. Newer clients will be able to call this method when connected to an older server, but this will be trigger an exception in
checkServerJdbcVersionX()
.Upgrade:
SYSIBM.SQLFunctions
is added inDataDictionaryImpl.create_10_2_system_procedures (TransactionController,UUID)
so it will become available in newly created databases and after hard upgrade.- Specified by:
getFunctions
in interfaceDatabaseMetaData
- Parameters:
catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this pattern- Returns:
- a
ResultSet
listing the fucntions - Throws:
SQLException
- if a database error occurs- See Also:
-
getFunctionsX
private ClientResultSet getFunctionsX(String catalog, String schemaPattern, String functionNamePattern) throws SqlException Untraced version ofgetFunctions(String, String, String)
.- Parameters:
catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this pattern- Returns:
- a
ResultSet
listing the fucntions - Throws:
SqlException
- if a database error occurs- See Also:
-
getFunctionColumns
public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String parameterNamePattern) throws SQLException Get the function names available in the database. Calls stored procedureSYSIBM.SQLFunctionParams(CatalogName varchar(128), SchemaName varchar(128), FuncName varchar(128), ParamName varchar(128), Options varchar(4000))
on the server. This procedure will in turn callEmbedDatabaseMetaData.getFunctionColumns(String,String, String,String)
Compatibility: Only available if both server and client version > 10.1, and JDK version >= 1.6. Older clients will not have this method available. Newer clients will be able to call this method when connected to an older server, but this will be trigger an exception in
checkServerJdbcVersionX()
.Upgrade:
SYSIBM.SQLFunctionParams
is added inDataDictionaryImpl.create_10_2_system_procedures (TransactionController,UUID)
so it will become available in newly created databases and after hard upgrade.- Specified by:
getFunctionColumns
in interfaceDatabaseMetaData
- Parameters:
catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this pattern- Returns:
- a
ResultSet
listing the fucntions - Throws:
SQLException
- if a database error occurs- See Also:
-
getFunctionColumnsX
private ClientResultSet getFunctionColumnsX(String catalog, String schemaPattern, String functionNamePattern, String parameterNamePattern) throws SqlException Untraced version ofgetFunctionColumns(String, String, String, String)
.- Parameters:
catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this patternparameterNamePattern
- limit search to parameters mathing this pattern- Returns:
- a
ResultSet
listing the fucntions - Throws:
SqlException
- if a database error occurs- See Also:
-
getTables
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException - Specified by:
getTables
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getTablesX
private ClientResultSet getTablesX(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SqlException - Throws:
SqlException
-
getSchemas
- Specified by:
getSchemas
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSchemasX
- Throws:
SqlException
-
getCatalogs
- Specified by:
getCatalogs
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCatalogsX
- Throws:
SqlException
-
getTableTypes
- Specified by:
getTableTypes
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getTableTypesX
- Throws:
SqlException
-
getColumns
public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException - Specified by:
getColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getColumnsX
private ClientResultSet getColumnsX(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SqlException - Throws:
SqlException
-
getColumnPrivileges
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException - Specified by:
getColumnPrivileges
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getColumnPrivilegesX
private ClientResultSet getColumnPrivilegesX(String catalog, String schema, String table, String columnNamePattern) throws SqlException - Throws:
SqlException
-
getTablePrivileges
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException - Specified by:
getTablePrivileges
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getTablePrivilegesX
private ClientResultSet getTablePrivilegesX(String catalog, String schemaPattern, String tableNamePattern) throws SqlException - Throws:
SqlException
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException - Specified by:
getBestRowIdentifier
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getBestRowIdentifierX
private ClientResultSet getBestRowIdentifierX(String catalog, String schema, String table, int scope, boolean nullable) throws SqlException - Throws:
SqlException
-
getVersionColumns
- Specified by:
getVersionColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getVersionColumnsX
private ClientResultSet getVersionColumnsX(String catalog, String schema, String table) throws SqlException - Throws:
SqlException
-
getPrimaryKeys
- Specified by:
getPrimaryKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getPrimaryKeysX
private ClientResultSet getPrimaryKeysX(String catalog, String schema, String table) throws SqlException - Throws:
SqlException
-
getImportedKeys
- Specified by:
getImportedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getImportedKeysX
private ClientResultSet getImportedKeysX(String catalog, String schema, String table) throws SqlException - Throws:
SqlException
-
getExportedKeys
- Specified by:
getExportedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getExportedKeysX
private ClientResultSet getExportedKeysX(String catalog, String schema, String table) throws SqlException - Throws:
SqlException
-
getCrossReference
public ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException - Specified by:
getCrossReference
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCrossReferenceX
private ClientResultSet getCrossReferenceX(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SqlException - Throws:
SqlException
-
getTypeInfo
- Specified by:
getTypeInfo
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getTypeInfoX
- Throws:
SqlException
-
getIndexInfo
public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException - Specified by:
getIndexInfo
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getIndexInfoX
private ClientResultSet getIndexInfoX(String catalog, String schema, String table, boolean unique, boolean approximate) throws SqlException - Throws:
SqlException
-
getUDTs
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException - Specified by:
getUDTs
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getUDTsX
private ClientResultSet getUDTsX(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SqlException - Throws:
SqlException
-
getOptions
-
executeCatalogQuery
- Throws:
SqlException
-
getConnection
- Specified by:
getConnection
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsNamedParameters
- Specified by:
supportsNamedParameters
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsMultipleOpenResults
- Specified by:
supportsMultipleOpenResults
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsGetGeneratedKeys
- Specified by:
supportsGetGeneratedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSuperTypes
public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException - Specified by:
getSuperTypes
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSuperTypesX
- Throws:
SqlException
-
getSuperTables
public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException - Specified by:
getSuperTables
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSuperTablesX
- Throws:
SqlException
-
getAttributes
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException - Specified by:
getAttributes
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getAttributesX
- Throws:
SqlException
-
supportsResultSetHoldability
- Specified by:
supportsResultSetHoldability
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getResultSetHoldability
- Specified by:
getResultSetHoldability
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseMajorVersion
- Specified by:
getDatabaseMajorVersion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseMinorVersion
- Specified by:
getDatabaseMinorVersion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getJDBCMajorVersion
- Specified by:
getJDBCMajorVersion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getJDBCMinorVersion
- Specified by:
getJDBCMinorVersion
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSQLStateType
- Specified by:
getSQLStateType
in interfaceDatabaseMetaData
- Throws:
SQLException
-
locatorsUpdateCopy
- Specified by:
locatorsUpdateCopy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsStatementPooling
- Specified by:
supportsStatementPooling
in interfaceDatabaseMetaData
- Throws:
SQLException
-
computeFeatureSet_
private void computeFeatureSet_() -
serverSupportsQryclsimp
public final boolean serverSupportsQryclsimp()Check whether the server has full support for the QRYCLSIMP parameter in OPNQRY.- Returns:
- true if QRYCLSIMP is fully supported
-
serverSupportsLayerBStreaming
public final boolean serverSupportsLayerBStreaming() -
serverSupportsSessionDataCaching
public final boolean serverSupportsSessionDataCaching()Check if server supports session data caching- Returns:
- true if the server supports this
-
serverSupportsUDTs
public final boolean serverSupportsUDTs()Check if server supports UDTs- Returns:
- true if the server supports this
-
serverSupportsTimestampNanoseconds
public final boolean serverSupportsTimestampNanoseconds()Check if server supports nanoseconds in timestamps- Returns:
- true if the server supports this
-
serverSupportsEXTDTAAbort
public final boolean serverSupportsEXTDTAAbort()Check if server supports product specific EXTDTA abort protocol.- Returns:
true
if the server supports this.
-
serverSupportsBooleanValues
private boolean serverSupportsBooleanValues()Check if server supports boolean values- Returns:
- true if the server supports this
-
serverSupportsBooleanParameterTransport
public final boolean serverSupportsBooleanParameterTransport()Check if the server accepts receiving booleans as parameter values.- Returns:
- true if the server supports this
-
serverSupportLongRDBNAM
public final boolean serverSupportLongRDBNAM() -
getMetaDataInfoBoolean
- Throws:
SQLException
-
getMetaDataInfoInt
- Throws:
SQLException
-
getMetaDataInfoString
- Throws:
SQLException
-
getMetaDataInfoBooleanWithType
- Throws:
SQLException
-
getMetaDataInfoBooleanWithTypeClient
private boolean getMetaDataInfoBooleanWithTypeClient(int infoCallIndex, int type) throws SQLException - Throws:
SQLException
-
getMetaDataInfoBooleanWithTypeServer
private boolean getMetaDataInfoBooleanWithTypeServer(int infoCallIndex, int type) throws SQLException - Throws:
SQLException
-
getMetaDataInfoInt_SupportsResultSetConcurrency
private boolean getMetaDataInfoInt_SupportsResultSetConcurrency(int infoCallIndex, int type, int concurrency) throws SQLException - Throws:
SQLException
-
getMetaDataInfoBoolean_supportsConvert
private boolean getMetaDataInfoBoolean_supportsConvert(int infoCallIndex, int fromType, int toType) throws SQLException - Throws:
SQLException
-
metaDataInfoCall
- Throws:
SqlException
-
supportsStoredFunctionsUsingCallSyntax
Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.- Specified by:
supportsStoredFunctionsUsingCallSyntax
in interfaceDatabaseMetaData
- Returns:
true
, since Derby supports the escape syntax- Throws:
SQLException
- if a database access error occurs
-
autoCommitFailureClosesAllResultSets
Retrieves whether anSQLException
will cause all openResultSet
s to be closed when auto-commit istrue
.- Specified by:
autoCommitFailureClosesAllResultSets
in interfaceDatabaseMetaData
- Returns:
false
, since Derby does not close all open result sets when an error occurs- Throws:
SQLException
- if a database access error occurs
-
getSchemas
Get the schema names available in this database. The results are ordered by schema name.The schema columns are:
- TABLE_SCHEM String => schema name
- TABLE_CATALOG String => catalog name
(may be
null
)
- Specified by:
getSchemas
in interfaceDatabaseMetaData
- Parameters:
catalog
- catalog name used to narrow down the search; "" means no catalog,null
means any catalogschemaPattern
- schema name used to narrow down the search,null
means schema name should not be used to narrow down search- Returns:
- a
ResultSet
object in which each row is a schema description - Throws:
SQLException
- if a database error occurs
-
getSchemasX
Untraced version ofgetSchemas(String, String)
.- Parameters:
catalog
- catalog nameschemaPattern
- pattern for schema name- Returns:
- a
ResultSet
value - Throws:
SqlException
- if a database error occurs- See Also:
-
getClientInfoProperties
Returns a list of the client info properties supported by the driver. The result set contains the following columns:- NAME String=> The name of the client info property.
- MAX_LEN int=> The maximum length of the value for the property.
- DEFAULT_VALUE String=> The default value of the property.
- DESCRIPTION String=> A description of the property.
The
ResultSet
is sorted by the NAME column.- Specified by:
getClientInfoProperties
in interfaceDatabaseMetaData
- Returns:
- A
ResultSet
object; each row is a supported client info property - Throws:
SQLException
- if an error occurs
-
getClientInfoPropertiesX
Untraced version ofgetClientInfoProperties()
. Returns an emptyResultSet
with the correct column names.- Returns:
- a
ResultSet
value - Throws:
SqlException
- if a database error occurs- See Also:
-
getRowIdLifetime
Indicates whether or not this data source supports the SQLROWID
type. Since Derby does not support theROWID
type, returnROWID_UNSUPPORTED
.- Specified by:
getRowIdLifetime
in interfaceDatabaseMetaData
- Returns:
ROWID_UNSUPPORTED
- Throws:
SQLException
- if a database access error occurs
-
isWrapperFor
Returns false unlessinterfaces
is implemented- Specified by:
isWrapperFor
in interfaceWrapper
- Parameters:
interfaces
- a Class defining an interface.- Returns:
- true if this implements the interface or directly or indirectly wraps an object that does.
- Throws:
SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface.
-
unwrap
Returnsthis
if this class implements the interface- Specified by:
unwrap
in interfaceWrapper
- Parameters:
interfaces
- a Class defining an interface- Returns:
- an object that implements the interface
- Throws:
SQLException
- if no object if found that implements the interface
-
generatedKeyAlwaysReturned
public boolean generatedKeyAlwaysReturned()See DatabaseMetaData javadoc- Specified by:
generatedKeyAlwaysReturned
in interfaceDatabaseMetaData
-
getPseudoColumns
public ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException - Specified by:
getPseudoColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getPseudoColumnsX
- Throws:
SqlException
-
getMaxLogicalLobSize
public long getMaxLogicalLobSize()See DatabaseMetaData javadoc- Specified by:
getMaxLogicalLobSize
in interfaceDatabaseMetaData
-
supportsRefCursors
public boolean supportsRefCursors()Derby does not support the Types.REF_CURSOR type.- Specified by:
supportsRefCursors
in interfaceDatabaseMetaData
-
prepareMetaDataQuery
- Throws:
SqlException
-
checkForClosedConnection
A "public" version of checkForClosedConnection() that throws SQLException instead of SqlException. In particular this is used by all the DatabaseMetadata methods- Throws:
SQLException
-
checkForClosedConnectionX
- Throws:
SqlException
-
checkServerJdbcVersionX
Checks whether the server supports a JDBC version. If the server does not support the JDBC version, an exception is thrown.- Parameters:
method
- name of the method for which support is needed on the server (used in exception message)major
- minimum JDBC major versionminor
- minimum JDBC minor version if major version matches- Throws:
SqlException
- if the server does not support the specified JDBC version
-