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