CachedDatabaseMetaData (sharding-jdbc-core 4.0.1 API)

java.lang.Object
- org.apache.shardingsphere.shardingjdbc.jdbc.adapter.WrapperAdapter
- - org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.ResultSetReturnedDatabaseMetaData
  - - org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.AdaptedDatabaseMetaData
    - - org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.CachedDatabaseMetaData

All Implemented Interfaces:

DatabaseMetaData, Wrapper
```
public final class CachedDatabaseMetaData
extends AdaptedDatabaseMetaData
```
Cached database meta data.

Author:

zhangliang

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
Constructor and Description
`CachedDatabaseMetaData(DatabaseMetaData databaseMetaData, Map<String,DataSource> dataSourceMap, org.apache.shardingsphere.core.rule.ShardingRule shardingRule)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`allProceduresAreCallable()`
`boolean`	`allTablesAreSelectable()`
`boolean`	`autoCommitFailureClosesAllResultSets()`
`boolean`	`dataDefinitionCausesTransactionCommit()`
`boolean`	`dataDefinitionIgnoredInTransactions()`
`boolean`	`doesMaxRowSizeIncludeBlobs()`
`boolean`	`generatedKeyAlwaysReturned()`
`String`	`getCatalogSeparator()`
`String`	`getCatalogTerm()`
`int`	`getDatabaseMajorVersion()`
`int`	`getDatabaseMinorVersion()`
`String`	`getDatabaseProductName()`
`String`	`getDatabaseProductVersion()`
`int`	`getDefaultTransactionIsolation()`
`int`	`getDriverMajorVersion()`
`int`	`getDriverMinorVersion()`
`String`	`getDriverName()`
`String`	`getDriverVersion()`
`String`	`getExtraNameCharacters()`
`String`	`getIdentifierQuoteString()`
`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()`
`int`	`getMaxProcedureNameLength()`
`int`	`getMaxRowSize()`
`int`	`getMaxSchemaNameLength()`
`int`	`getMaxStatementLength()`
`int`	`getMaxStatements()`
`int`	`getMaxTableNameLength()`
`int`	`getMaxTablesInSelect()`
`int`	`getMaxUserNameLength()`
`String`	`getNumericFunctions()`
`String`	`getProcedureTerm()`
`int`	`getResultSetHoldability()`
`RowIdLifetime`	`getRowIdLifetime()`
`String`	`getSchemaTerm()`
`String`	`getSearchStringEscape()`
`String`	`getSQLKeywords()`
`int`	`getSQLStateType()`
`String`	`getStringFunctions()`
`String`	`getSystemFunctions()`
`String`	`getTimeDateFunctions()`
`String`	`getURL()`
`String`	`getUserName()`
`boolean`	`isCatalogAtStart()`
`boolean`	`isReadOnly()`
`boolean`	`locatorsUpdateCopy()`
`boolean`	`nullPlusNonNullIsNull()`
`boolean`	`nullsAreSortedAtEnd()`
`boolean`	`nullsAreSortedAtStart()`
`boolean`	`nullsAreSortedHigh()`
`boolean`	`nullsAreSortedLow()`
`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`	`supportsSavepoints()`
`boolean`	`supportsSchemasInDataManipulation()`
`boolean`	`supportsSchemasInIndexDefinitions()`
`boolean`	`supportsSchemasInPrivilegeDefinitions()`
`boolean`	`supportsSchemasInProcedureCalls()`
`boolean`	`supportsSchemasInTableDefinitions()`
`boolean`	`supportsSelectForUpdate()`
`boolean`	`supportsStatementPooling()`
`boolean`	`supportsStoredFunctionsUsingCallSyntax()`
`boolean`	`supportsStoredProcedures()`
`boolean`	`supportsSubqueriesInComparisons()`
`boolean`	`supportsSubqueriesInExists()`
`boolean`	`supportsSubqueriesInIns()`
`boolean`	`supportsSubqueriesInQuantifieds()`
`boolean`	`supportsTableCorrelationNames()`
`boolean`	`supportsTransactions()`
`boolean`	`supportsUnion()`
`boolean`	`supportsUnionAll()`
`boolean`	`usesLocalFilePerTable()`
`boolean`	`usesLocalFiles()`

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.AdaptedDatabaseMetaData
deletesAreDetected, insertsAreDetected, othersDeletesAreVisible, othersInsertsAreVisible, othersUpdatesAreVisible, ownDeletesAreVisible, ownInsertsAreVisible, ownUpdatesAreVisible, supportsResultSetConcurrency, supportsResultSetHoldability, supportsResultSetType, supportsTransactionIsolationLevel, updatesAreDetected

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.ResultSetReturnedDatabaseMetaData
getAttributes, getBestRowIdentifier, getCatalogs, getClientInfoProperties, getColumnPrivileges, getColumns, getConnection, getCrossReference, getExportedKeys, getFunctionColumns, getFunctions, getImportedKeys, getIndexInfo, getPrimaryKeys, getProcedureColumns, getProcedures, getPseudoColumns, getSchemas, getSchemas, getSuperTables, getSuperTypes, getTablePrivileges, getTables, getTableTypes, getTypeInfo, getUDTs, getVersionColumns

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.adapter.WrapperAdapter
isWrapperFor, recordMethodInvocation, replayMethodsInvocation, unwrap

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.DatabaseMetaData
getMaxLogicalLobSize, supportsRefCursors

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

Constructor Detail

CachedDatabaseMetaData

public CachedDatabaseMetaData(DatabaseMetaData databaseMetaData,
                              Map<String,DataSource> dataSourceMap,
                              org.apache.shardingsphere.core.rule.ShardingRule shardingRule)
                       throws SQLException

Throws:: SQLException

Method Detail

getURL
```
public String getURL()
```

getUserName
```
public String getUserName()
```

getDatabaseProductName

public String getDatabaseProductName()

getDatabaseProductVersion

public String getDatabaseProductVersion()

getDriverName
```
public String getDriverName()
```

getDriverVersion
```
public String getDriverVersion()
```

getDriverMajorVersion
```
public int getDriverMajorVersion()
```

getDriverMinorVersion
```
public int getDriverMinorVersion()
```

getDatabaseMajorVersion
```
public int getDatabaseMajorVersion()
```

getDatabaseMinorVersion
```
public int getDatabaseMinorVersion()
```

getJDBCMajorVersion
```
public int getJDBCMajorVersion()
```

getJDBCMinorVersion
```
public int getJDBCMinorVersion()
```

isReadOnly
```
public boolean isReadOnly()
```

allProceduresAreCallable

public boolean allProceduresAreCallable()

allTablesAreSelectable

public boolean allTablesAreSelectable()

nullsAreSortedHigh
```
public boolean nullsAreSortedHigh()
```

nullsAreSortedLow
```
public boolean nullsAreSortedLow()
```

nullsAreSortedAtStart

public boolean nullsAreSortedAtStart()

nullsAreSortedAtEnd
```
public boolean nullsAreSortedAtEnd()
```

usesLocalFiles
```
public boolean usesLocalFiles()
```

usesLocalFilePerTable

public boolean usesLocalFilePerTable()

supportsMixedCaseIdentifiers

public boolean supportsMixedCaseIdentifiers()

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()

storesMixedCaseIdentifiers

public boolean storesMixedCaseIdentifiers()

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()

storesLowerCaseQuotedIdentifiers

public boolean storesLowerCaseQuotedIdentifiers()

storesMixedCaseQuotedIdentifiers

public boolean storesMixedCaseQuotedIdentifiers()

getIdentifierQuoteString

public String getIdentifierQuoteString()

getSQLKeywords
```
public String getSQLKeywords()
```

getNumericFunctions
```
public String getNumericFunctions()
```

getStringFunctions
```
public String getStringFunctions()
```

getSystemFunctions
```
public String getSystemFunctions()
```

getTimeDateFunctions
```
public String getTimeDateFunctions()
```

getSearchStringEscape
```
public String getSearchStringEscape()
```

getExtraNameCharacters

public String getExtraNameCharacters()

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()

supportsAlterTableWithDropColumn

public boolean supportsAlterTableWithDropColumn()

supportsColumnAliasing

public boolean supportsColumnAliasing()

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()

supportsConvert
```
public boolean supportsConvert()
```

supportsConvert

public boolean supportsConvert(int fromType,
                               int toType)

supportsTableCorrelationNames

public boolean supportsTableCorrelationNames()

supportsDifferentTableCorrelationNames

public boolean supportsDifferentTableCorrelationNames()

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()

supportsGroupBy
```
public boolean supportsGroupBy()
```

supportsGroupByUnrelated

public boolean supportsGroupByUnrelated()

supportsGroupByBeyondSelect

public boolean supportsGroupByBeyondSelect()

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()

supportsMultipleResultSets

public boolean supportsMultipleResultSets()

supportsMultipleTransactions

public boolean supportsMultipleTransactions()

supportsNonNullableColumns

public boolean supportsNonNullableColumns()

supportsMinimumSQLGrammar

public boolean supportsMinimumSQLGrammar()

supportsCoreSQLGrammar

public boolean supportsCoreSQLGrammar()

supportsExtendedSQLGrammar

public boolean supportsExtendedSQLGrammar()

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()

supportsANSI92IntermediateSQL

public boolean supportsANSI92IntermediateSQL()

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()

supportsOuterJoins
```
public boolean supportsOuterJoins()
```

supportsFullOuterJoins

public boolean supportsFullOuterJoins()

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()

getSchemaTerm
```
public String getSchemaTerm()
```

getProcedureTerm
```
public String getProcedureTerm()
```

getCatalogTerm
```
public String getCatalogTerm()
```

isCatalogAtStart
```
public boolean isCatalogAtStart()
```

getCatalogSeparator
```
public String getCatalogSeparator()
```

supportsSchemasInDataManipulation

public boolean supportsSchemasInDataManipulation()

supportsSchemasInProcedureCalls

public boolean supportsSchemasInProcedureCalls()

supportsSchemasInTableDefinitions

public boolean supportsSchemasInTableDefinitions()

supportsSchemasInIndexDefinitions

public boolean supportsSchemasInIndexDefinitions()

supportsSchemasInPrivilegeDefinitions

public boolean supportsSchemasInPrivilegeDefinitions()

supportsCatalogsInDataManipulation

public boolean supportsCatalogsInDataManipulation()

supportsCatalogsInProcedureCalls

public boolean supportsCatalogsInProcedureCalls()

supportsCatalogsInTableDefinitions

public boolean supportsCatalogsInTableDefinitions()

supportsCatalogsInIndexDefinitions

public boolean supportsCatalogsInIndexDefinitions()

supportsCatalogsInPrivilegeDefinitions

public boolean supportsCatalogsInPrivilegeDefinitions()

supportsPositionedDelete

public boolean supportsPositionedDelete()

supportsPositionedUpdate

public boolean supportsPositionedUpdate()

supportsSelectForUpdate

public boolean supportsSelectForUpdate()

supportsStoredProcedures

public boolean supportsStoredProcedures()

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()

supportsSubqueriesInExists

public boolean supportsSubqueriesInExists()

supportsSubqueriesInIns

public boolean supportsSubqueriesInIns()

supportsSubqueriesInQuantifieds

public boolean supportsSubqueriesInQuantifieds()

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()

supportsUnion
```
public boolean supportsUnion()
```

supportsUnionAll
```
public boolean supportsUnionAll()
```

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()

getMaxCharLiteralLength
```
public int getMaxCharLiteralLength()
```

getMaxColumnNameLength
```
public int getMaxColumnNameLength()
```

getMaxColumnsInGroupBy
```
public int getMaxColumnsInGroupBy()
```

getMaxColumnsInIndex
```
public int getMaxColumnsInIndex()
```

getMaxColumnsInOrderBy
```
public int getMaxColumnsInOrderBy()
```

getMaxColumnsInSelect
```
public int getMaxColumnsInSelect()
```

getMaxColumnsInTable
```
public int getMaxColumnsInTable()
```

getMaxConnections
```
public int getMaxConnections()
```

getMaxCursorNameLength
```
public int getMaxCursorNameLength()
```

getMaxIndexLength
```
public int getMaxIndexLength()
```

getMaxSchemaNameLength
```
public int getMaxSchemaNameLength()
```

getMaxProcedureNameLength

public int getMaxProcedureNameLength()

getMaxCatalogNameLength
```
public int getMaxCatalogNameLength()
```

getMaxRowSize
```
public int getMaxRowSize()
```

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()

getMaxStatementLength
```
public int getMaxStatementLength()
```

getMaxStatements
```
public int getMaxStatements()
```

getMaxTableNameLength
```
public int getMaxTableNameLength()
```

getMaxTablesInSelect
```
public int getMaxTablesInSelect()
```

getMaxUserNameLength
```
public int getMaxUserNameLength()
```

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()

supportsTransactions
```
public boolean supportsTransactions()
```

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()

supportsBatchUpdates
```
public boolean supportsBatchUpdates()
```

supportsSavepoints
```
public boolean supportsSavepoints()
```

supportsNamedParameters

public boolean supportsNamedParameters()

supportsMultipleOpenResults

public boolean supportsMultipleOpenResults()

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()

getResultSetHoldability
```
public int getResultSetHoldability()
```

getSQLStateType
```
public int getSQLStateType()
```

locatorsUpdateCopy
```
public boolean locatorsUpdateCopy()
```

supportsStatementPooling

public boolean supportsStatementPooling()

supportsStoredFunctionsUsingCallSyntax

public boolean supportsStoredFunctionsUsingCallSyntax()

autoCommitFailureClosesAllResultSets

public boolean autoCommitFailureClosesAllResultSets()

getRowIdLifetime

public RowIdLifetime getRowIdLifetime()

generatedKeyAlwaysReturned

public boolean generatedKeyAlwaysReturned()

Class CachedDatabaseMetaData

Field Summary

Fields inherited from interface java.sql.DatabaseMetaData

Constructor Summary

Method Summary

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.AdaptedDatabaseMetaData

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource.metadata.ResultSetReturnedDatabaseMetaData

Methods inherited from class org.apache.shardingsphere.shardingjdbc.jdbc.adapter.WrapperAdapter

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.DatabaseMetaData

Methods inherited from interface java.sql.Wrapper

Constructor Detail

CachedDatabaseMetaData

Method Detail

getURL

getUserName

getDatabaseProductName

getDatabaseProductVersion

getDriverName

getDriverVersion

getDriverMajorVersion

getDriverMinorVersion

getDatabaseMajorVersion

getDatabaseMinorVersion

getJDBCMajorVersion

getJDBCMinorVersion

isReadOnly

allProceduresAreCallable

allTablesAreSelectable

nullsAreSortedHigh

nullsAreSortedLow

nullsAreSortedAtStart

nullsAreSortedAtEnd

usesLocalFiles

usesLocalFilePerTable

supportsMixedCaseIdentifiers

storesUpperCaseIdentifiers

storesLowerCaseIdentifiers

storesMixedCaseIdentifiers

supportsMixedCaseQuotedIdentifiers

storesUpperCaseQuotedIdentifiers

storesLowerCaseQuotedIdentifiers

storesMixedCaseQuotedIdentifiers

getIdentifierQuoteString

getSQLKeywords

getNumericFunctions

getStringFunctions

getSystemFunctions

getTimeDateFunctions

getSearchStringEscape

getExtraNameCharacters

supportsAlterTableWithAddColumn

supportsAlterTableWithDropColumn

supportsColumnAliasing

nullPlusNonNullIsNull

supportsConvert

supportsConvert

supportsTableCorrelationNames

supportsDifferentTableCorrelationNames

supportsExpressionsInOrderBy

supportsOrderByUnrelated

supportsGroupBy

supportsGroupByUnrelated

supportsGroupByBeyondSelect

supportsLikeEscapeClause

supportsMultipleResultSets

supportsMultipleTransactions

supportsNonNullableColumns

supportsMinimumSQLGrammar

supportsCoreSQLGrammar

supportsExtendedSQLGrammar

supportsANSI92EntryLevelSQL

supportsANSI92IntermediateSQL

supportsANSI92FullSQL

supportsIntegrityEnhancementFacility

supportsOuterJoins

supportsFullOuterJoins

supportsLimitedOuterJoins

getSchemaTerm

getProcedureTerm