java.sql.DatabaseMetaData
, java.sql.Wrapper
NetDatabaseMetaData
public abstract class ClientDatabaseMetaData
extends java.lang.Object
implements 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
Modifier | Constructor | Description |
---|---|---|
protected |
ClientDatabaseMetaData(Agent agent,
ClientConnection connection,
ProductLevel productLevel) |
Modifier and Type | Method | Description |
---|---|---|
boolean |
allProceduresAreCallable() |
|
boolean |
allTablesAreSelectable() |
|
boolean |
autoCommitFailureClosesAllResultSets() |
Retrieves whether an
SQLException will cause all
open ResultSet s to be closed when auto-commit is
true . |
protected void |
checkForClosedConnection() |
A "public" version of checkForClosedConnection() that throws
SQLException instead of SqlException.
|
private void |
checkForClosedConnectionX() |
|
private void |
checkServerJdbcVersionX(java.lang.String method,
int major,
int minor) |
Checks whether the server supports a JDBC version.
|
private void |
computeFeatureSet_() |
|
boolean |
dataDefinitionCausesTransactionCommit() |
|
boolean |
dataDefinitionIgnoredInTransactions() |
|
boolean |
deletesAreDetected(int type) |
|
boolean |
doesMaxRowSizeIncludeBlobs() |
|
private ClientResultSet |
executeCatalogQuery(ClientPreparedStatement cs) |
|
boolean |
generatedKeyAlwaysReturned() |
See DatabaseMetaData javadoc
|
java.sql.ResultSet |
getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern) |
|
private ClientResultSet |
getAttributesX() |
|
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable) |
|
private ClientResultSet |
getBestRowIdentifierX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable) |
|
java.sql.ResultSet |
getCatalogs() |
|
java.lang.String |
getCatalogSeparator() |
|
private ClientResultSet |
getCatalogsX() |
|
java.lang.String |
getCatalogTerm() |
|
java.sql.ResultSet |
getClientInfoProperties() |
Returns a list of the client info properties supported by the
driver.
|
private ClientResultSet |
getClientInfoPropertiesX() |
Untraced version of
getClientInfoProperties() . |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern) |
|
private ClientResultSet |
getColumnPrivilegesX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern) |
|
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern) |
|
private ClientResultSet |
getColumnsX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern) |
|
java.sql.Connection |
getConnection() |
|
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) |
|
private ClientResultSet |
getCrossReferenceX(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable) |
|
int |
getDatabaseMajorVersion() |
|
int |
getDatabaseMinorVersion() |
|
java.lang.String |
getDatabaseProductName() |
|
java.lang.String |
getDatabaseProductVersion() |
|
int |
getDefaultTransactionIsolation() |
|
int |
getDriverMajorVersion() |
|
int |
getDriverMinorVersion() |
|
java.lang.String |
getDriverName() |
|
java.lang.String |
getDriverVersion() |
|
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
private ClientResultSet |
getExportedKeysX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
java.lang.String |
getExtraNameCharacters() |
|
java.sql.ResultSet |
getFunctionColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern,
java.lang.String parameterNamePattern) |
Get the function names available in the database.
|
private ClientResultSet |
getFunctionColumnsX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern,
java.lang.String parameterNamePattern) |
Untraced version of
getFunctionColumns(String, String,
String, String) . |
java.sql.ResultSet |
getFunctions(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern) |
Get the function names available in the database.
|
private ClientResultSet |
getFunctionsX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern) |
Untraced version of
getFunctions(String, String, String) . |
java.lang.String |
getIdentifierQuoteString() |
|
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
private ClientResultSet |
getImportedKeysX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate) |
|
private ClientResultSet |
getIndexInfoX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate) |
|
int |
getJDBCMajorVersion() |
|
int |
getJDBCMinorVersion() |
|
int |
getMaxBinaryLiteralLength() |
|
int |
getMaxCatalogNameLength() |
|
int |
getMaxCharLiteralLength() |
|
int |
getMaxColumnNameLength() |
|
int |
getMaxColumnsInGroupBy() |
|
int |
getMaxColumnsInIndex() |
|
int |
getMaxColumnsInOrderBy() |
|
int |
getMaxColumnsInSelect() |
|
int |
getMaxColumnsInTable() |
|
int |
getMaxConnections() |
|
int |
getMaxCursorNameLength() |
|
int |
getMaxIndexLength() |
|
long |
getMaxLogicalLobSize() |
See DatabaseMetaData javadoc
|
int |
getMaxProcedureNameLength() |
|
int |
getMaxRowSize() |
|
int |
getMaxSchemaNameLength() |
|
int |
getMaxStatementLength() |
|
int |
getMaxStatements() |
|
int |
getMaxTableNameLength() |
|
int |
getMaxTablesInSelect() |
|
int |
getMaxUserNameLength() |
|
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 java.lang.String |
getMetaDataInfoString(int infoCallIndex) |
|
java.lang.String |
getNumericFunctions() |
|
private java.lang.String |
getOptions() |
|
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
private ClientResultSet |
getPrimaryKeysX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern) |
|
private ClientResultSet |
getProcedureColumnsX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern) |
|
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern) |
|
private ClientResultSet |
getProceduresX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern) |
|
java.lang.String |
getProcedureTerm() |
|
java.sql.ResultSet |
getPseudoColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern) |
|
private ClientResultSet |
getPseudoColumnsX() |
|
int |
getResultSetHoldability() |
|
java.sql.RowIdLifetime |
getRowIdLifetime() |
Indicates whether or not this data source supports the SQL
ROWID type. |
java.sql.ResultSet |
getSchemas() |
|
java.sql.ResultSet |
getSchemas(java.lang.String catalog,
java.lang.String schemaPattern) |
Get the schema names available in this database.
|
private ClientResultSet |
getSchemasX() |
|
private ClientResultSet |
getSchemasX(java.lang.String catalog,
java.lang.String schemaPattern) |
Untraced version of
getSchemas(String, String) . |
java.lang.String |
getSchemaTerm() |
|
java.lang.String |
getSearchStringEscape() |
|
java.lang.String |
getSQLKeywords() |
|
int |
getSQLStateType() |
|
java.lang.String |
getStringFunctions() |
|
java.sql.ResultSet |
getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern) |
|
private ClientResultSet |
getSuperTablesX() |
|
java.sql.ResultSet |
getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern) |
|
private ClientResultSet |
getSuperTypesX() |
|
java.lang.String |
getSystemFunctions() |
|
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern) |
|
private ClientResultSet |
getTablePrivilegesX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern) |
|
java.sql.ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types) |
|
private ClientResultSet |
getTablesX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types) |
|
java.sql.ResultSet |
getTableTypes() |
|
private ClientResultSet |
getTableTypesX() |
|
java.lang.String |
getTimeDateFunctions() |
|
java.sql.ResultSet |
getTypeInfo() |
|
private ClientResultSet |
getTypeInfoX() |
|
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types) |
|
private ClientResultSet |
getUDTsX(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types) |
|
java.lang.String |
getURL() |
|
abstract java.lang.String |
getURL_() |
|
java.lang.String |
getUserName() |
|
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
private ClientResultSet |
getVersionColumnsX(java.lang.String catalog,
java.lang.String schema,
java.lang.String table) |
|
boolean |
insertsAreDetected(int type) |
|
boolean |
isCatalogAtStart() |
|
boolean |
isReadOnly() |
|
boolean |
isWrapperFor(java.lang.Class<?> interfaces) |
Returns false unless
interfaces is implemented |
boolean |
locatorsUpdateCopy() |
|
private void |
metaDataInfoCall() |
|
boolean |
nullPlusNonNullIsNull() |
|
boolean |
nullsAreSortedAtEnd() |
|
boolean |
nullsAreSortedAtStart() |
|
boolean |
nullsAreSortedHigh() |
|
boolean |
nullsAreSortedLow() |
|
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 |
prepareMetaDataQuery(java.lang.String cmd) |
|
boolean |
serverSupportLongRDBNAM() |
|
boolean |
serverSupportsBooleanParameterTransport() |
Check if the server accepts receiving booleans as parameter values.
|
private boolean |
serverSupportsBooleanValues() |
Check if server supports boolean values
|
boolean |
serverSupportsEXTDTAAbort() |
Check if server supports product specific EXTDTA abort protocol.
|
boolean |
serverSupportsLayerBStreaming() |
|
boolean |
serverSupportsQryclsimp() |
Check whether the server has full support for the QRYCLSIMP
parameter in OPNQRY.
|
boolean |
serverSupportsSessionDataCaching() |
Check if server supports session data caching
|
boolean |
serverSupportsTimestampNanoseconds() |
Check if server supports nanoseconds in timestamps
|
boolean |
serverSupportsUDTs() |
Check if server supports UDTs
|
boolean |
storesLowerCaseIdentifiers() |
|
boolean |
storesLowerCaseQuotedIdentifiers() |
|
boolean |
storesMixedCaseIdentifiers() |
|
boolean |
storesMixedCaseQuotedIdentifiers() |
|
boolean |
storesUpperCaseIdentifiers() |
|
boolean |
storesUpperCaseQuotedIdentifiers() |
|
boolean |
supportsAlterTableWithAddColumn() |
|
boolean |
supportsAlterTableWithDropColumn() |
|
boolean |
supportsANSI92EntryLevelSQL() |
|
boolean |
supportsANSI92FullSQL() |
|
boolean |
supportsANSI92IntermediateSQL() |
|
boolean |
supportsBatchUpdates() |
|
boolean |
supportsCatalogsInDataManipulation() |
|
boolean |
supportsCatalogsInIndexDefinitions() |
|
boolean |
supportsCatalogsInPrivilegeDefinitions() |
|
boolean |
supportsCatalogsInProcedureCalls() |
|
boolean |
supportsCatalogsInTableDefinitions() |
|
boolean |
supportsColumnAliasing() |
|
boolean |
supportsConvert() |
|
boolean |
supportsConvert(int fromType,
int toType) |
|
boolean |
supportsCoreSQLGrammar() |
|
boolean |
supportsCorrelatedSubqueries() |
|
boolean |
supportsDataDefinitionAndDataManipulationTransactions() |
|
boolean |
supportsDataManipulationTransactionsOnly() |
|
boolean |
supportsDifferentTableCorrelationNames() |
|
boolean |
supportsExpressionsInOrderBy() |
|
boolean |
supportsExtendedSQLGrammar() |
|
boolean |
supportsFullOuterJoins() |
|
boolean |
supportsGetGeneratedKeys() |
|
boolean |
supportsGroupBy() |
|
boolean |
supportsGroupByBeyondSelect() |
|
boolean |
supportsGroupByUnrelated() |
|
boolean |
supportsIntegrityEnhancementFacility() |
|
boolean |
supportsLikeEscapeClause() |
|
boolean |
supportsLimitedOuterJoins() |
|
boolean |
supportsMinimumSQLGrammar() |
|
boolean |
supportsMixedCaseIdentifiers() |
|
boolean |
supportsMixedCaseQuotedIdentifiers() |
|
boolean |
supportsMultipleOpenResults() |
|
boolean |
supportsMultipleResultSets() |
|
boolean |
supportsMultipleTransactions() |
|
boolean |
supportsNamedParameters() |
|
boolean |
supportsNonNullableColumns() |
|
boolean |
supportsOpenCursorsAcrossCommit() |
|
boolean |
supportsOpenCursorsAcrossRollback() |
|
boolean |
supportsOpenStatementsAcrossCommit() |
|
boolean |
supportsOpenStatementsAcrossRollback() |
|
boolean |
supportsOrderByUnrelated() |
|
boolean |
supportsOuterJoins() |
|
boolean |
supportsPositionedDelete() |
|
boolean |
supportsPositionedUpdate() |
|
boolean |
supportsRefCursors() |
Derby does not support the Types.REF_CURSOR type.
|
boolean |
supportsResultSetConcurrency(int type,
int concurrency) |
|
boolean |
supportsResultSetHoldability(int holdability) |
|
boolean |
supportsResultSetType(int type) |
|
boolean |
supportsSavepoints() |
|
boolean |
supportsSchemasInDataManipulation() |
|
boolean |
supportsSchemasInIndexDefinitions() |
|
boolean |
supportsSchemasInPrivilegeDefinitions() |
|
boolean |
supportsSchemasInProcedureCalls() |
|
boolean |
supportsSchemasInTableDefinitions() |
|
boolean |
supportsSelectForUpdate() |
|
boolean |
supportsStatementPooling() |
|
boolean |
supportsStoredFunctionsUsingCallSyntax() |
Retrieves whether this database supports invoking user-defined
or vendor functions using the stored procedure escape syntax.
|
boolean |
supportsStoredProcedures() |
|
boolean |
supportsSubqueriesInComparisons() |
|
boolean |
supportsSubqueriesInExists() |
|
boolean |
supportsSubqueriesInIns() |
|
boolean |
supportsSubqueriesInQuantifieds() |
|
boolean |
supportsTableCorrelationNames() |
|
boolean |
supportsTransactionIsolationLevel(int level) |
|
boolean |
supportsTransactions() |
|
boolean |
supportsUnion() |
|
boolean |
supportsUnionAll() |
|
<T> T |
unwrap(java.lang.Class<T> interfaces) |
Returns
this if this class implements the interface |
boolean |
updatesAreDetected(int type) |
|
boolean |
usesLocalFilePerTable() |
|
boolean |
usesLocalFiles() |
private static final short SQL_BEST_ROWID
private static final short SQL_ROWVER
private static final short SQL_INDEX_UNIQUE
private static final short SQL_INDEX_ALL
private Agent agent_
protected ClientConnection connection_
private static final int numberOfMetaDataInfoMethods__
private java.lang.Object[] metaDataInfoCache_
private boolean metaDataInfoIsCached_
ProductLevel productLevel_
private final int serverJdbcMajorVersion
private final int serverJdbcMinorVersion
private boolean supportsQryclsimp_
private boolean supportsLayerBStreaming_
private boolean supportsSessionDataCaching_
private boolean supportsUDTs_
private boolean supportsEXTDTAAbort_
private boolean supportsTimestampNanoseconds_
private boolean supportsBooleanValues_
private boolean supportsLongRDBNAM_
private boolean supportsBooleanParameterTransport_
private static final int allProceduresAreCallable__
private static final int allTablesAreSelectable__
private static final int nullsAreSortedHigh__
private static final int nullsAreSortedLow__
private static final int nullsAreSortedAtStart__
private static final int nullsAreSortedAtEnd__
private static final int usesLocalFiles__
private static final int usesLocalFilePerTable__
private static final int storesUpperCaseIdentifiers__
private static final int storesLowerCaseIdentifiers__
private static final int storesMixedCaseIdentifiers__
private static final int storesUpperCaseQuotedIdentifiers__
private static final int storesLowerCaseQuotedIdentifiers__
private static final int storesMixedCaseQuotedIdentifiers__
private static final int getSQLKeywords__
private static final int getNumericFunctions__
private static final int getStringFunctions__
private static final int getSystemFunctions__
private static final int getTimeDateFunctions__
private static final int getSearchStringEscape__
private static final int getExtraNameCharacters__
private static final int supportsAlterTableWithAddColumn__
private static final int supportsAlterTableWithDropColumn__
private static final int supportsConvert__
private static final int supportsConvertType__
private static final int supportsDifferentTableCorrelationNames__
private static final int supportsExpressionsInOrderBy__
private static final int supportsOrderByUnrelated__
private static final int supportsGroupBy__
private static final int supportsGroupByUnrelated__
private static final int supportsGroupByBeyondSelect__
private static final int supportsMultipleResultSets__
private static final int supportsMultipleTransactions__
private static final int supportsCoreSQLGrammar__
private static final int supportsExtendedSQLGrammar__
private static final int supportsANSI92IntermediateSQL__
private static final int supportsANSI92FullSQL__
private static final int supportsIntegrityEnhancementFacility__
private static final int supportsOuterJoins__
private static final int supportsFullOuterJoins__
private static final int supportsLimitedOuterJoins__
private static final int getSchemaTerm__
private static final int getProcedureTerm__
private static final int getCatalogTerm__
private static final int isCatalogAtStart__
private static final int getCatalogSeparator__
private static final int supportsSchemasInDataManipulation__
private static final int supportsSchemasInProcedureCalls__
private static final int supportsSchemasInTableDefinitions__
private static final int supportsSchemasInIndexDefinitions__
private static final int supportsSchemasInPrivilegeDefinitions__
private static final int supportsCatalogsInDataManipulation__
private static final int supportsCatalogsInProcedureCalls__
private static final int supportsCatalogsInTableDefinitions__
private static final int supportsCatalogsInIndexDefinitions__
private static final int supportsCatalogsInPrivilegeDefinitions__
private static final int supportsPositionedDelete__
private static final int supportsPositionedUpdate__
private static final int supportsSelectForUpdate__
private static final int supportsStoredProcedures__
private static final int supportsSubqueriesInComparisons__
private static final int supportsUnion__
private static final int supportsUnionAll__
private static final int supportsOpenCursorsAcrossCommit__
private static final int supportsOpenCursorsAcrossRollback__
private static final int supportsOpenStatementsAcrossCommit__
private static final int supportsOpenStatementsAcrossRollback__
private static final int getMaxBinaryLiteralLength__
private static final int getMaxCharLiteralLength__
private static final int getMaxColumnNameLength__
private static final int getMaxColumnsInGroupBy__
private static final int getMaxColumnsInIndex__
private static final int getMaxColumnsInOrderBy__
private static final int getMaxColumnsInSelect__
private static final int getMaxColumnsInTable__
private static final int getMaxConnections__
private static final int getMaxCursorNameLength__
private static final int getMaxIndexLength__
private static final int getMaxSchemaNameLength__
private static final int getMaxProcedureNameLength__
private static final int getMaxCatalogNameLength__
private static final int getMaxRowSize__
private static final int doesMaxRowSizeIncludeBlobs__
private static final int getMaxStatementLength__
private static final int getMaxStatements__
private static final int getMaxTableNameLength__
private static final int getMaxTablesInSelect__
private static final int getMaxUserNameLength__
private static final int getDefaultTransactionIsolation__
private static final int supportsTransactions__
private static final int supportsTransactionIsolationLevel__
private static final int supportsDataDefinitionAndDataManipulationTransactions__
private static final int supportsDataManipulationTransactionsOnly__
private static final int dataDefinitionCausesTransactionCommit__
private static final int dataDefinitionIgnoredInTransactions__
private static final int supportsResultSetType__
private static final int supportsResultSetConcurrency__
private static final int ownUpdatesAreVisible__
private static final int ownDeletesAreVisible__
private static final int ownInsertsAreVisible__
private static final int othersUpdatesAreVisible__
private static final int othersDeletesAreVisible__
private static final int othersInsertsAreVisible__
private static final int updatesAreDetected__
private static final int deletesAreDetected__
private static final int insertsAreDetected__
private static final int supportsBatchUpdates__
protected ClientDatabaseMetaData(Agent agent, ClientConnection connection, ProductLevel productLevel)
public boolean allProceduresAreCallable() throws java.sql.SQLException
allProceduresAreCallable
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean allTablesAreSelectable() throws java.sql.SQLException
allTablesAreSelectable
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean nullsAreSortedHigh() throws java.sql.SQLException
nullsAreSortedHigh
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean nullsAreSortedLow() throws java.sql.SQLException
nullsAreSortedLow
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean nullsAreSortedAtStart() throws java.sql.SQLException
nullsAreSortedAtStart
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean nullsAreSortedAtEnd() throws java.sql.SQLException
nullsAreSortedAtEnd
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean usesLocalFiles() throws java.sql.SQLException
usesLocalFiles
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean usesLocalFilePerTable() throws java.sql.SQLException
usesLocalFilePerTable
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean storesUpperCaseIdentifiers() throws java.sql.SQLException
storesUpperCaseIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean storesLowerCaseIdentifiers() throws java.sql.SQLException
storesLowerCaseIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean storesMixedCaseIdentifiers() throws java.sql.SQLException
storesMixedCaseIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLException
storesUpperCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLException
storesLowerCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLException
storesMixedCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getSQLKeywords() throws java.sql.SQLException
getSQLKeywords
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getNumericFunctions() throws java.sql.SQLException
getNumericFunctions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getStringFunctions() throws java.sql.SQLException
getStringFunctions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getSystemFunctions() throws java.sql.SQLException
getSystemFunctions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getTimeDateFunctions() throws java.sql.SQLException
getTimeDateFunctions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getSearchStringEscape() throws java.sql.SQLException
getSearchStringEscape
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getExtraNameCharacters() throws java.sql.SQLException
getExtraNameCharacters
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsAlterTableWithAddColumn() throws java.sql.SQLException
supportsAlterTableWithAddColumn
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsAlterTableWithDropColumn() throws java.sql.SQLException
supportsAlterTableWithDropColumn
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsConvert() throws java.sql.SQLException
supportsConvert
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsConvert(int fromType, int toType) throws java.sql.SQLException
supportsConvert
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLException
supportsDifferentTableCorrelationNames
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsExpressionsInOrderBy() throws java.sql.SQLException
supportsExpressionsInOrderBy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsOrderByUnrelated() throws java.sql.SQLException
supportsOrderByUnrelated
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsGroupBy() throws java.sql.SQLException
supportsGroupBy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsGroupByUnrelated() throws java.sql.SQLException
supportsGroupByUnrelated
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsGroupByBeyondSelect() throws java.sql.SQLException
supportsGroupByBeyondSelect
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsMultipleResultSets() throws java.sql.SQLException
supportsMultipleResultSets
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsMultipleTransactions() throws java.sql.SQLException
supportsMultipleTransactions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCoreSQLGrammar() throws java.sql.SQLException
supportsCoreSQLGrammar
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsExtendedSQLGrammar() throws java.sql.SQLException
supportsExtendedSQLGrammar
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsANSI92IntermediateSQL() throws java.sql.SQLException
supportsANSI92IntermediateSQL
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsANSI92FullSQL() throws java.sql.SQLException
supportsANSI92FullSQL
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLException
supportsIntegrityEnhancementFacility
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsOuterJoins() throws java.sql.SQLException
supportsOuterJoins
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsFullOuterJoins() throws java.sql.SQLException
supportsFullOuterJoins
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsLimitedOuterJoins() throws java.sql.SQLException
supportsLimitedOuterJoins
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getSchemaTerm() throws java.sql.SQLException
getSchemaTerm
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getProcedureTerm() throws java.sql.SQLException
getProcedureTerm
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getCatalogTerm() throws java.sql.SQLException
getCatalogTerm
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean isCatalogAtStart() throws java.sql.SQLException
isCatalogAtStart
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getCatalogSeparator() throws java.sql.SQLException
getCatalogSeparator
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSchemasInDataManipulation() throws java.sql.SQLException
supportsSchemasInDataManipulation
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSchemasInProcedureCalls() throws java.sql.SQLException
supportsSchemasInProcedureCalls
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSchemasInTableDefinitions() throws java.sql.SQLException
supportsSchemasInTableDefinitions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLException
supportsSchemasInIndexDefinitions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLException
supportsSchemasInPrivilegeDefinitions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCatalogsInDataManipulation() throws java.sql.SQLException
supportsCatalogsInDataManipulation
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLException
supportsCatalogsInProcedureCalls
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLException
supportsCatalogsInTableDefinitions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLException
supportsCatalogsInIndexDefinitions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLException
supportsCatalogsInPrivilegeDefinitions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsPositionedDelete() throws java.sql.SQLException
supportsPositionedDelete
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsPositionedUpdate() throws java.sql.SQLException
supportsPositionedUpdate
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSelectForUpdate() throws java.sql.SQLException
supportsSelectForUpdate
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsStoredProcedures() throws java.sql.SQLException
supportsStoredProcedures
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSubqueriesInComparisons() throws java.sql.SQLException
supportsSubqueriesInComparisons
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsUnion() throws java.sql.SQLException
supportsUnion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsUnionAll() throws java.sql.SQLException
supportsUnionAll
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLException
supportsOpenCursorsAcrossCommit
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLException
supportsOpenCursorsAcrossRollback
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLException
supportsOpenStatementsAcrossCommit
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLException
supportsOpenStatementsAcrossRollback
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxBinaryLiteralLength() throws java.sql.SQLException
getMaxBinaryLiteralLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxCharLiteralLength() throws java.sql.SQLException
getMaxCharLiteralLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxColumnNameLength() throws java.sql.SQLException
getMaxColumnNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxColumnsInGroupBy() throws java.sql.SQLException
getMaxColumnsInGroupBy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxColumnsInIndex() throws java.sql.SQLException
getMaxColumnsInIndex
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxColumnsInOrderBy() throws java.sql.SQLException
getMaxColumnsInOrderBy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxColumnsInSelect() throws java.sql.SQLException
getMaxColumnsInSelect
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxColumnsInTable() throws java.sql.SQLException
getMaxColumnsInTable
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxConnections() throws java.sql.SQLException
getMaxConnections
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxCursorNameLength() throws java.sql.SQLException
getMaxCursorNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxIndexLength() throws java.sql.SQLException
getMaxIndexLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxSchemaNameLength() throws java.sql.SQLException
getMaxSchemaNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxProcedureNameLength() throws java.sql.SQLException
getMaxProcedureNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxCatalogNameLength() throws java.sql.SQLException
getMaxCatalogNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxRowSize() throws java.sql.SQLException
getMaxRowSize
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLException
doesMaxRowSizeIncludeBlobs
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxStatementLength() throws java.sql.SQLException
getMaxStatementLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxStatements() throws java.sql.SQLException
getMaxStatements
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxTableNameLength() throws java.sql.SQLException
getMaxTableNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxTablesInSelect() throws java.sql.SQLException
getMaxTablesInSelect
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getMaxUserNameLength() throws java.sql.SQLException
getMaxUserNameLength
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getDefaultTransactionIsolation() throws java.sql.SQLException
getDefaultTransactionIsolation
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsTransactions() throws java.sql.SQLException
supportsTransactions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsTransactionIsolationLevel(int level) throws java.sql.SQLException
supportsTransactionIsolationLevel
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLException
supportsDataDefinitionAndDataManipulationTransactions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLException
supportsDataManipulationTransactionsOnly
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLException
dataDefinitionCausesTransactionCommit
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLException
dataDefinitionIgnoredInTransactions
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsResultSetType(int type) throws java.sql.SQLException
supportsResultSetType
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsResultSetConcurrency(int type, int concurrency) throws java.sql.SQLException
supportsResultSetConcurrency
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean ownUpdatesAreVisible(int type) throws java.sql.SQLException
ownUpdatesAreVisible
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean ownDeletesAreVisible(int type) throws java.sql.SQLException
ownDeletesAreVisible
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean ownInsertsAreVisible(int type) throws java.sql.SQLException
ownInsertsAreVisible
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean othersUpdatesAreVisible(int type) throws java.sql.SQLException
othersUpdatesAreVisible
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean othersDeletesAreVisible(int type) throws java.sql.SQLException
othersDeletesAreVisible
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean othersInsertsAreVisible(int type) throws java.sql.SQLException
othersInsertsAreVisible
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean updatesAreDetected(int type) throws java.sql.SQLException
updatesAreDetected
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean deletesAreDetected(int type) throws java.sql.SQLException
deletesAreDetected
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean insertsAreDetected(int type) throws java.sql.SQLException
insertsAreDetected
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsBatchUpdates() throws java.sql.SQLException
supportsBatchUpdates
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSavepoints() throws java.sql.SQLException
supportsSavepoints
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public abstract java.lang.String getURL_() throws SqlException
SqlException
public java.lang.String getURL() throws java.sql.SQLException
getURL
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getUserName() throws java.sql.SQLException
getUserName
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean isReadOnly() throws java.sql.SQLException
isReadOnly
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getDatabaseProductName() throws java.sql.SQLException
getDatabaseProductName
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getDatabaseProductVersion() throws java.sql.SQLException
getDatabaseProductVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getDriverName() throws java.sql.SQLException
getDriverName
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getDriverVersion() throws java.sql.SQLException
getDriverVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getDriverMajorVersion()
getDriverMajorVersion
in interface java.sql.DatabaseMetaData
public int getDriverMinorVersion()
getDriverMinorVersion
in interface java.sql.DatabaseMetaData
public boolean supportsMixedCaseIdentifiers() throws java.sql.SQLException
supportsMixedCaseIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLException
supportsMixedCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.lang.String getIdentifierQuoteString() throws java.sql.SQLException
getIdentifierQuoteString
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsColumnAliasing() throws java.sql.SQLException
supportsColumnAliasing
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean nullPlusNonNullIsNull() throws java.sql.SQLException
nullPlusNonNullIsNull
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsTableCorrelationNames() throws java.sql.SQLException
supportsTableCorrelationNames
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsLikeEscapeClause() throws java.sql.SQLException
supportsLikeEscapeClause
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsNonNullableColumns() throws java.sql.SQLException
supportsNonNullableColumns
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsMinimumSQLGrammar() throws java.sql.SQLException
supportsMinimumSQLGrammar
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLException
supportsANSI92EntryLevelSQL
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSubqueriesInExists() throws java.sql.SQLException
supportsSubqueriesInExists
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSubqueriesInIns() throws java.sql.SQLException
supportsSubqueriesInIns
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLException
supportsSubqueriesInQuantifieds
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsCorrelatedSubqueries() throws java.sql.SQLException
supportsCorrelatedSubqueries
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern) throws java.sql.SQLException
getProcedures
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getProceduresX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern) throws SqlException
SqlException
public java.sql.ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getProcedureColumns
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getProcedureColumnsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern) throws SqlException
SqlException
public java.sql.ResultSet getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern) throws java.sql.SQLException
SYSIBM.SQLFunctions(CatalogName
varchar(128), SchemaName varchar(128), FuncName varchar(128),
Options varchar(4000))
on the server. This procedure
will in turn call
EmbedDatabaseMetaData.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 in
DataDictionaryImpl.create_10_2_system_procedures
(TransactionController,UUID)
so it will become available
in newly created databases and after hard upgrade.
getFunctions
in interface java.sql.DatabaseMetaData
catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this
patternResultSet
listing the fucntionsjava.sql.SQLException
- if a database error occursgetFunctionsX(String, String, String)
,
DataDictionaryImpl.create_10_2_system_procedures(TransactionController,java.util.HashSet,UUID)
,
EmbedDatabaseMetaData.getFunctions(String,String,String)
private ClientResultSet getFunctionsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern) throws SqlException
getFunctions(String, String, String)
.catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this
patternResultSet
listing the fucntionsSqlException
- if a database error occursgetFunctions(String, String, String)
public java.sql.ResultSet getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String parameterNamePattern) throws java.sql.SQLException
SYSIBM.SQLFunctionParams(CatalogName
varchar(128), SchemaName varchar(128), FuncName varchar(128),
ParamName varchar(128), Options varchar(4000))
on the
server. This procedure will in turn call
EmbedDatabaseMetaData.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 in
DataDictionaryImpl.create_10_2_system_procedures
(TransactionController,UUID)
so it will become available
in newly created databases and after hard upgrade.
getFunctionColumns
in interface java.sql.DatabaseMetaData
catalog
- limit search to this catalogschemaPattern
- limit search to schemas matching this patternfunctionNamePattern
- limit search to functions matching this
patternResultSet
listing the fucntionsjava.sql.SQLException
- if a database error occursgetFunctionColumnsX(String, String, String,String)
,
DataDictionaryImpl.create_10_2_system_procedures(TransactionController,java.util.HashSet,UUID)
,
EmbedDatabaseMetaData.getFunctions(String,String,String)
private ClientResultSet getFunctionColumnsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String parameterNamePattern) throws SqlException
getFunctionColumns(String, String,
String, String)
.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 patternResultSet
listing the fucntionsSqlException
- if a database error occursgetFunctionColumns(String, String, String, String)
public java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types) throws java.sql.SQLException
getTables
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getTablesX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types) throws SqlException
SqlException
public java.sql.ResultSet getSchemas() throws java.sql.SQLException
getSchemas
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getSchemasX() throws SqlException
SqlException
public java.sql.ResultSet getCatalogs() throws java.sql.SQLException
getCatalogs
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getCatalogsX() throws SqlException
SqlException
public java.sql.ResultSet getTableTypes() throws java.sql.SQLException
getTableTypes
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getTableTypesX() throws SqlException
SqlException
public java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getColumns
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getColumnsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws SqlException
SqlException
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern) throws java.sql.SQLException
getColumnPrivileges
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getColumnPrivilegesX(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern) throws SqlException
SqlException
public java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException
getTablePrivileges
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getTablePrivilegesX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws SqlException
SqlException
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws java.sql.SQLException
getBestRowIdentifier
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getBestRowIdentifierX(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws SqlException
SqlException
public java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getVersionColumns
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getVersionColumnsX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlException
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getPrimaryKeys
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getPrimaryKeysX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlException
public java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getImportedKeys
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getImportedKeysX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlException
public java.sql.ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getExportedKeys
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getExportedKeysX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlException
public 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
getCrossReference
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getCrossReferenceX(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 SqlException
SqlException
public java.sql.ResultSet getTypeInfo() throws java.sql.SQLException
getTypeInfo
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getTypeInfoX() throws SqlException
SqlException
public java.sql.ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate) throws java.sql.SQLException
getIndexInfo
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getIndexInfoX(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate) throws SqlException
SqlException
public java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws java.sql.SQLException
getUDTs
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getUDTsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws SqlException
SqlException
private java.lang.String getOptions()
private ClientResultSet executeCatalogQuery(ClientPreparedStatement cs) throws SqlException
SqlException
public java.sql.Connection getConnection() throws java.sql.SQLException
getConnection
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsNamedParameters() throws java.sql.SQLException
supportsNamedParameters
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsMultipleOpenResults() throws java.sql.SQLException
supportsMultipleOpenResults
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsGetGeneratedKeys() throws java.sql.SQLException
supportsGetGeneratedKeys
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern) throws java.sql.SQLException
getSuperTypes
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getSuperTypesX() throws SqlException
SqlException
public java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException
getSuperTables
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getSuperTablesX() throws SqlException
SqlException
public java.sql.ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern) throws java.sql.SQLException
getAttributes
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getAttributesX() throws SqlException
SqlException
public boolean supportsResultSetHoldability(int holdability) throws java.sql.SQLException
supportsResultSetHoldability
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getResultSetHoldability() throws java.sql.SQLException
getResultSetHoldability
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getDatabaseMajorVersion() throws java.sql.SQLException
getDatabaseMajorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getDatabaseMinorVersion() throws java.sql.SQLException
getDatabaseMinorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getJDBCMajorVersion() throws java.sql.SQLException
getJDBCMajorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getJDBCMinorVersion() throws java.sql.SQLException
getJDBCMinorVersion
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public int getSQLStateType() throws java.sql.SQLException
getSQLStateType
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean locatorsUpdateCopy() throws java.sql.SQLException
locatorsUpdateCopy
in interface java.sql.DatabaseMetaData
java.sql.SQLException
public boolean supportsStatementPooling() throws java.sql.SQLException
supportsStatementPooling
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private void computeFeatureSet_()
public final boolean serverSupportsQryclsimp()
public final boolean serverSupportsLayerBStreaming()
public final boolean serverSupportsSessionDataCaching()
public final boolean serverSupportsUDTs()
public final boolean serverSupportsTimestampNanoseconds()
public final boolean serverSupportsEXTDTAAbort()
true
if the server supports this.private boolean serverSupportsBooleanValues()
public final boolean serverSupportsBooleanParameterTransport()
public final boolean serverSupportLongRDBNAM()
private boolean getMetaDataInfoBoolean(int infoCallIndex) throws java.sql.SQLException
java.sql.SQLException
private int getMetaDataInfoInt(int infoCallIndex) throws java.sql.SQLException
java.sql.SQLException
private java.lang.String getMetaDataInfoString(int infoCallIndex) throws java.sql.SQLException
java.sql.SQLException
private boolean getMetaDataInfoBooleanWithType(int infoCallIndex, int type) throws java.sql.SQLException
java.sql.SQLException
private boolean getMetaDataInfoBooleanWithTypeClient(int infoCallIndex, int type) throws java.sql.SQLException
java.sql.SQLException
private boolean getMetaDataInfoBooleanWithTypeServer(int infoCallIndex, int type) throws java.sql.SQLException
java.sql.SQLException
private boolean getMetaDataInfoInt_SupportsResultSetConcurrency(int infoCallIndex, int type, int concurrency) throws java.sql.SQLException
java.sql.SQLException
private boolean getMetaDataInfoBoolean_supportsConvert(int infoCallIndex, int fromType, int toType) throws java.sql.SQLException
java.sql.SQLException
private void metaDataInfoCall() throws SqlException
SqlException
public final boolean supportsStoredFunctionsUsingCallSyntax() throws java.sql.SQLException
supportsStoredFunctionsUsingCallSyntax
in interface java.sql.DatabaseMetaData
true
, since Derby supports the escape syntaxjava.sql.SQLException
- if a database access error occurspublic final boolean autoCommitFailureClosesAllResultSets() throws java.sql.SQLException
SQLException
will cause all
open ResultSet
s to be closed when auto-commit is
true
.autoCommitFailureClosesAllResultSets
in interface java.sql.DatabaseMetaData
false
, since Derby does not close all open
result sets when an error occursjava.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getSchemas(java.lang.String catalog, java.lang.String schemaPattern) throws java.sql.SQLException
The schema columns are:
null
)getSchemas
in interface java.sql.DatabaseMetaData
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 searchResultSet
object in which each row is a
schema descriptionjava.sql.SQLException
- if a database error occursprivate ClientResultSet getSchemasX(java.lang.String catalog, java.lang.String schemaPattern) throws SqlException
getSchemas(String, String)
.catalog
- catalog nameschemaPattern
- pattern for schema nameResultSet
valueSqlException
- if a database error occursgetSchemas(String, String)
public java.sql.ResultSet getClientInfoProperties() throws java.sql.SQLException
The ResultSet
is sorted by the NAME column.
getClientInfoProperties
in interface java.sql.DatabaseMetaData
ResultSet
object; each row is a
supported client info propertyjava.sql.SQLException
- if an error occursprivate ClientResultSet getClientInfoPropertiesX() throws SqlException
getClientInfoProperties()
.
Returns an empty ResultSet
with the correct column
names.ResultSet
valueSqlException
- if a database error occursgetClientInfoProperties()
public java.sql.RowIdLifetime getRowIdLifetime() throws java.sql.SQLException
ROWID
type. Since Derby does not support the
ROWID
type, return ROWID_UNSUPPORTED
.getRowIdLifetime
in interface java.sql.DatabaseMetaData
ROWID_UNSUPPORTED
java.sql.SQLException
- if a database access error occurspublic boolean isWrapperFor(java.lang.Class<?> interfaces) throws java.sql.SQLException
interfaces
is implementedisWrapperFor
in interface java.sql.Wrapper
interfaces
- a Class defining an interface.java.sql.SQLException
- if an error occurs while determining
whether this is a wrapper for an object
with the given interface.public <T> T unwrap(java.lang.Class<T> interfaces) throws java.sql.SQLException
this
if this class implements the interfaceunwrap
in interface java.sql.Wrapper
interfaces
- a Class defining an interfacejava.sql.SQLException
- if no object if found that implements the
interfacepublic boolean generatedKeyAlwaysReturned()
generatedKeyAlwaysReturned
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getPseudoColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getPseudoColumns
in interface java.sql.DatabaseMetaData
java.sql.SQLException
private ClientResultSet getPseudoColumnsX() throws SqlException
SqlException
public long getMaxLogicalLobSize()
getMaxLogicalLobSize
in interface java.sql.DatabaseMetaData
public boolean supportsRefCursors()
supportsRefCursors
in interface java.sql.DatabaseMetaData
private ClientPreparedStatement prepareMetaDataQuery(java.lang.String cmd) throws SqlException
SqlException
protected void checkForClosedConnection() throws java.sql.SQLException
java.sql.SQLException
private void checkForClosedConnectionX() throws SqlException
SqlException
private void checkServerJdbcVersionX(java.lang.String method, int major, int minor) throws SqlException
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 matchesSqlException
- if the server does not support the
specified JDBC versionApache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.