java.sql.DatabaseMetaData, java.sql.WrapperNetDatabaseMetaDatapublic 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 ResultSets 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.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean allTablesAreSelectable()
throws java.sql.SQLException
allTablesAreSelectable in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean nullsAreSortedHigh()
throws java.sql.SQLException
nullsAreSortedHigh in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean nullsAreSortedLow()
throws java.sql.SQLException
nullsAreSortedLow in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean nullsAreSortedAtStart()
throws java.sql.SQLException
nullsAreSortedAtStart in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean nullsAreSortedAtEnd()
throws java.sql.SQLException
nullsAreSortedAtEnd in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean usesLocalFiles()
throws java.sql.SQLException
usesLocalFiles in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean usesLocalFilePerTable()
throws java.sql.SQLException
usesLocalFilePerTable in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean storesUpperCaseIdentifiers()
throws java.sql.SQLException
storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean storesLowerCaseIdentifiers()
throws java.sql.SQLException
storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean storesMixedCaseIdentifiers()
throws java.sql.SQLException
storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean storesUpperCaseQuotedIdentifiers()
throws java.sql.SQLException
storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean storesLowerCaseQuotedIdentifiers()
throws java.sql.SQLException
storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean storesMixedCaseQuotedIdentifiers()
throws java.sql.SQLException
storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getSQLKeywords()
throws java.sql.SQLException
getSQLKeywords in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getNumericFunctions()
throws java.sql.SQLException
getNumericFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getStringFunctions()
throws java.sql.SQLException
getStringFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getSystemFunctions()
throws java.sql.SQLException
getSystemFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getTimeDateFunctions()
throws java.sql.SQLException
getTimeDateFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getSearchStringEscape()
throws java.sql.SQLException
getSearchStringEscape in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getExtraNameCharacters()
throws java.sql.SQLException
getExtraNameCharacters in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsAlterTableWithAddColumn()
throws java.sql.SQLException
supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsAlterTableWithDropColumn()
throws java.sql.SQLException
supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsConvert()
throws java.sql.SQLException
supportsConvert in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsConvert(int fromType,
int toType)
throws java.sql.SQLException
supportsConvert in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsDifferentTableCorrelationNames()
throws java.sql.SQLException
supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsExpressionsInOrderBy()
throws java.sql.SQLException
supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsOrderByUnrelated()
throws java.sql.SQLException
supportsOrderByUnrelated in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsGroupBy()
throws java.sql.SQLException
supportsGroupBy in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsGroupByUnrelated()
throws java.sql.SQLException
supportsGroupByUnrelated in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsGroupByBeyondSelect()
throws java.sql.SQLException
supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsMultipleResultSets()
throws java.sql.SQLException
supportsMultipleResultSets in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsMultipleTransactions()
throws java.sql.SQLException
supportsMultipleTransactions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCoreSQLGrammar()
throws java.sql.SQLException
supportsCoreSQLGrammar in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsExtendedSQLGrammar()
throws java.sql.SQLException
supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsANSI92IntermediateSQL()
throws java.sql.SQLException
supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsANSI92FullSQL()
throws java.sql.SQLException
supportsANSI92FullSQL in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsIntegrityEnhancementFacility()
throws java.sql.SQLException
supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsOuterJoins()
throws java.sql.SQLException
supportsOuterJoins in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsFullOuterJoins()
throws java.sql.SQLException
supportsFullOuterJoins in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsLimitedOuterJoins()
throws java.sql.SQLException
supportsLimitedOuterJoins in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getSchemaTerm()
throws java.sql.SQLException
getSchemaTerm in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getProcedureTerm()
throws java.sql.SQLException
getProcedureTerm in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getCatalogTerm()
throws java.sql.SQLException
getCatalogTerm in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean isCatalogAtStart()
throws java.sql.SQLException
isCatalogAtStart in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getCatalogSeparator()
throws java.sql.SQLException
getCatalogSeparator in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSchemasInDataManipulation()
throws java.sql.SQLException
supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSchemasInProcedureCalls()
throws java.sql.SQLException
supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSchemasInTableDefinitions()
throws java.sql.SQLException
supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSchemasInIndexDefinitions()
throws java.sql.SQLException
supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSchemasInPrivilegeDefinitions()
throws java.sql.SQLException
supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCatalogsInDataManipulation()
throws java.sql.SQLException
supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCatalogsInProcedureCalls()
throws java.sql.SQLException
supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCatalogsInTableDefinitions()
throws java.sql.SQLException
supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCatalogsInIndexDefinitions()
throws java.sql.SQLException
supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCatalogsInPrivilegeDefinitions()
throws java.sql.SQLException
supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsPositionedDelete()
throws java.sql.SQLException
supportsPositionedDelete in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsPositionedUpdate()
throws java.sql.SQLException
supportsPositionedUpdate in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSelectForUpdate()
throws java.sql.SQLException
supportsSelectForUpdate in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsStoredProcedures()
throws java.sql.SQLException
supportsStoredProcedures in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSubqueriesInComparisons()
throws java.sql.SQLException
supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsUnion()
throws java.sql.SQLException
supportsUnion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsUnionAll()
throws java.sql.SQLException
supportsUnionAll in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsOpenCursorsAcrossCommit()
throws java.sql.SQLException
supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsOpenCursorsAcrossRollback()
throws java.sql.SQLException
supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsOpenStatementsAcrossCommit()
throws java.sql.SQLException
supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsOpenStatementsAcrossRollback()
throws java.sql.SQLException
supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxBinaryLiteralLength()
throws java.sql.SQLException
getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxCharLiteralLength()
throws java.sql.SQLException
getMaxCharLiteralLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxColumnNameLength()
throws java.sql.SQLException
getMaxColumnNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxColumnsInGroupBy()
throws java.sql.SQLException
getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxColumnsInIndex()
throws java.sql.SQLException
getMaxColumnsInIndex in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxColumnsInOrderBy()
throws java.sql.SQLException
getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxColumnsInSelect()
throws java.sql.SQLException
getMaxColumnsInSelect in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxColumnsInTable()
throws java.sql.SQLException
getMaxColumnsInTable in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxConnections()
throws java.sql.SQLException
getMaxConnections in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxCursorNameLength()
throws java.sql.SQLException
getMaxCursorNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxIndexLength()
throws java.sql.SQLException
getMaxIndexLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxSchemaNameLength()
throws java.sql.SQLException
getMaxSchemaNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxProcedureNameLength()
throws java.sql.SQLException
getMaxProcedureNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxCatalogNameLength()
throws java.sql.SQLException
getMaxCatalogNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxRowSize()
throws java.sql.SQLException
getMaxRowSize in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean doesMaxRowSizeIncludeBlobs()
throws java.sql.SQLException
doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxStatementLength()
throws java.sql.SQLException
getMaxStatementLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxStatements()
throws java.sql.SQLException
getMaxStatements in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxTableNameLength()
throws java.sql.SQLException
getMaxTableNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxTablesInSelect()
throws java.sql.SQLException
getMaxTablesInSelect in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getMaxUserNameLength()
throws java.sql.SQLException
getMaxUserNameLength in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getDefaultTransactionIsolation()
throws java.sql.SQLException
getDefaultTransactionIsolation in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsTransactions()
throws java.sql.SQLException
supportsTransactions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsTransactionIsolationLevel(int level)
throws java.sql.SQLException
supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsDataDefinitionAndDataManipulationTransactions()
throws java.sql.SQLException
supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsDataManipulationTransactionsOnly()
throws java.sql.SQLException
supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean dataDefinitionCausesTransactionCommit()
throws java.sql.SQLException
dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean dataDefinitionIgnoredInTransactions()
throws java.sql.SQLException
dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsResultSetType(int type)
throws java.sql.SQLException
supportsResultSetType in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsResultSetConcurrency(int type,
int concurrency)
throws java.sql.SQLException
supportsResultSetConcurrency in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean ownUpdatesAreVisible(int type)
throws java.sql.SQLException
ownUpdatesAreVisible in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean ownDeletesAreVisible(int type)
throws java.sql.SQLException
ownDeletesAreVisible in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean ownInsertsAreVisible(int type)
throws java.sql.SQLException
ownInsertsAreVisible in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean othersUpdatesAreVisible(int type)
throws java.sql.SQLException
othersUpdatesAreVisible in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean othersDeletesAreVisible(int type)
throws java.sql.SQLException
othersDeletesAreVisible in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean othersInsertsAreVisible(int type)
throws java.sql.SQLException
othersInsertsAreVisible in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean updatesAreDetected(int type)
throws java.sql.SQLException
updatesAreDetected in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean deletesAreDetected(int type)
throws java.sql.SQLException
deletesAreDetected in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean insertsAreDetected(int type)
throws java.sql.SQLException
insertsAreDetected in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsBatchUpdates()
throws java.sql.SQLException
supportsBatchUpdates in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSavepoints()
throws java.sql.SQLException
supportsSavepoints in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic abstract java.lang.String getURL_()
throws SqlException
SqlExceptionpublic java.lang.String getURL()
throws java.sql.SQLException
getURL in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getUserName()
throws java.sql.SQLException
getUserName in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean isReadOnly()
throws java.sql.SQLException
isReadOnly in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getDatabaseProductName()
throws java.sql.SQLException
getDatabaseProductName in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getDatabaseProductVersion()
throws java.sql.SQLException
getDatabaseProductVersion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getDriverName()
throws java.sql.SQLException
getDriverName in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getDriverVersion()
throws java.sql.SQLException
getDriverVersion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getDriverMajorVersion()
getDriverMajorVersion in interface java.sql.DatabaseMetaDatapublic int getDriverMinorVersion()
getDriverMinorVersion in interface java.sql.DatabaseMetaDatapublic boolean supportsMixedCaseIdentifiers()
throws java.sql.SQLException
supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsMixedCaseQuotedIdentifiers()
throws java.sql.SQLException
supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getIdentifierQuoteString()
throws java.sql.SQLException
getIdentifierQuoteString in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsColumnAliasing()
throws java.sql.SQLException
supportsColumnAliasing in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean nullPlusNonNullIsNull()
throws java.sql.SQLException
nullPlusNonNullIsNull in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsTableCorrelationNames()
throws java.sql.SQLException
supportsTableCorrelationNames in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsLikeEscapeClause()
throws java.sql.SQLException
supportsLikeEscapeClause in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsNonNullableColumns()
throws java.sql.SQLException
supportsNonNullableColumns in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsMinimumSQLGrammar()
throws java.sql.SQLException
supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsANSI92EntryLevelSQL()
throws java.sql.SQLException
supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSubqueriesInExists()
throws java.sql.SQLException
supportsSubqueriesInExists in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSubqueriesInIns()
throws java.sql.SQLException
supportsSubqueriesInIns in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSubqueriesInQuantifieds()
throws java.sql.SQLException
supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsCorrelatedSubqueries()
throws java.sql.SQLException
supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getProceduresX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getProcedureColumnsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatacatalog - 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.DatabaseMetaDatacatalog - 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getTablesX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types) throws SqlException
SqlExceptionpublic java.sql.ResultSet getSchemas()
throws java.sql.SQLException
getSchemas in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getSchemasX() throws SqlException
SqlExceptionpublic java.sql.ResultSet getCatalogs()
throws java.sql.SQLException
getCatalogs in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getCatalogsX() throws SqlException
SqlExceptionpublic java.sql.ResultSet getTableTypes()
throws java.sql.SQLException
getTableTypes in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getTableTypesX() throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getColumnsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getColumnPrivilegesX(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getTablePrivilegesX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getBestRowIdentifierX(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getVersionColumnsX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getPrimaryKeysX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getImportedKeysX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getExportedKeysX(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate 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
SqlExceptionpublic java.sql.ResultSet getTypeInfo()
throws java.sql.SQLException
getTypeInfo in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getTypeInfoX() throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getIndexInfoX(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate) throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getUDTsX(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws SqlException
SqlExceptionprivate java.lang.String getOptions()
private ClientResultSet executeCatalogQuery(ClientPreparedStatement cs) throws SqlException
SqlExceptionpublic java.sql.Connection getConnection()
throws java.sql.SQLException
getConnection in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsNamedParameters()
throws java.sql.SQLException
supportsNamedParameters in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsMultipleOpenResults()
throws java.sql.SQLException
supportsMultipleOpenResults in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsGetGeneratedKeys()
throws java.sql.SQLException
supportsGetGeneratedKeys in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getSuperTypesX() throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getSuperTablesX() throws SqlException
SqlExceptionpublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getAttributesX() throws SqlException
SqlExceptionpublic boolean supportsResultSetHoldability(int holdability)
throws java.sql.SQLException
supportsResultSetHoldability in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getResultSetHoldability()
throws java.sql.SQLException
getResultSetHoldability in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getDatabaseMajorVersion()
throws java.sql.SQLException
getDatabaseMajorVersion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getDatabaseMinorVersion()
throws java.sql.SQLException
getDatabaseMinorVersion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getJDBCMajorVersion()
throws java.sql.SQLException
getJDBCMajorVersion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getJDBCMinorVersion()
throws java.sql.SQLException
getJDBCMinorVersion in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic int getSQLStateType()
throws java.sql.SQLException
getSQLStateType in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean locatorsUpdateCopy()
throws java.sql.SQLException
locatorsUpdateCopy in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsStatementPooling()
throws java.sql.SQLException
supportsStatementPooling in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionprivate 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.SQLExceptionprivate int getMetaDataInfoInt(int infoCallIndex)
throws java.sql.SQLException
java.sql.SQLExceptionprivate java.lang.String getMetaDataInfoString(int infoCallIndex)
throws java.sql.SQLException
java.sql.SQLExceptionprivate boolean getMetaDataInfoBooleanWithType(int infoCallIndex,
int type)
throws java.sql.SQLException
java.sql.SQLExceptionprivate boolean getMetaDataInfoBooleanWithTypeClient(int infoCallIndex,
int type)
throws java.sql.SQLException
java.sql.SQLExceptionprivate boolean getMetaDataInfoBooleanWithTypeServer(int infoCallIndex,
int type)
throws java.sql.SQLException
java.sql.SQLExceptionprivate boolean getMetaDataInfoInt_SupportsResultSetConcurrency(int infoCallIndex,
int type,
int concurrency)
throws java.sql.SQLException
java.sql.SQLExceptionprivate boolean getMetaDataInfoBoolean_supportsConvert(int infoCallIndex,
int fromType,
int toType)
throws java.sql.SQLException
java.sql.SQLExceptionprivate void metaDataInfoCall()
throws SqlException
SqlExceptionpublic final boolean supportsStoredFunctionsUsingCallSyntax()
throws java.sql.SQLException
supportsStoredFunctionsUsingCallSyntax in interface java.sql.DatabaseMetaDatatrue, 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 ResultSets to be closed when auto-commit is
true.autoCommitFailureClosesAllResultSets in interface java.sql.DatabaseMetaDatafalse, 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.DatabaseMetaDatacatalog - 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.DatabaseMetaDataResultSet 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.DatabaseMetaDataROWID_UNSUPPORTEDjava.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.Wrapperinterfaces - 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.Wrapperinterfaces - a Class defining an interfacejava.sql.SQLException - if no object if found that implements the
interfacepublic boolean generatedKeyAlwaysReturned()
generatedKeyAlwaysReturned in interface java.sql.DatabaseMetaDatapublic 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.DatabaseMetaDatajava.sql.SQLExceptionprivate ClientResultSet getPseudoColumnsX() throws SqlException
SqlExceptionpublic long getMaxLogicalLobSize()
getMaxLogicalLobSize in interface java.sql.DatabaseMetaDatapublic boolean supportsRefCursors()
supportsRefCursors in interface java.sql.DatabaseMetaDataprivate ClientPreparedStatement prepareMetaDataQuery(java.lang.String cmd) throws SqlException
SqlExceptionprotected void checkForClosedConnection()
throws java.sql.SQLException
java.sql.SQLExceptionprivate void checkForClosedConnectionX()
throws SqlException
SqlExceptionprivate 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.