Class DatabaseMetaLocal

java.lang.Object

org.h2.jdbc.meta.DatabaseMeta

org.h2.jdbc.meta.DatabaseMetaLocalBase

org.h2.jdbc.meta.DatabaseMetaLocal

public final class DatabaseMetaLocal
extends DatabaseMetaLocalBase

Local implementation of database meta information.

Field Summary

Fields

Modifier and Type	Field	Description
private static final ValueSmallint	BEST_ROW_NOT_PSEUDO
private static final ValueSmallint	BEST_ROW_SESSION
private static final ValueInteger	COLUMN_NO_NULLS
private static final ValueSmallint	COLUMN_NO_NULLS_SMALL
private static final ValueInteger	COLUMN_NULLABLE
private static final ValueSmallint	COLUMN_NULLABLE_UNKNOWN_SMALL
private static final ValueSmallint	IMPORTED_KEY_CASCADE
private static final ValueSmallint	IMPORTED_KEY_DEFAULT
private static final ValueSmallint	IMPORTED_KEY_NOT_DEFERRABLE
private static final ValueSmallint	IMPORTED_KEY_RESTRICT
private static final ValueSmallint	IMPORTED_KEY_SET_NULL
private static final Value	NO
private static final Value	NO_USAGE_RESTRICTIONS
private static final ValueSmallint	PROCEDURE_COLUMN_IN
private static final ValueSmallint	PROCEDURE_COLUMN_RETURN
private static final ValueSmallint	PROCEDURE_NO_RESULT
private static final ValueSmallint	PROCEDURE_RETURNS_RESULT
private final SessionLocal	session
private static final ValueSmallint	TABLE_INDEX_HASHED
private static final ValueSmallint	TABLE_INDEX_OTHER
private static final String[]	TABLE_TYPES
private static final ValueSmallint	TYPE_NULLABLE
private static final ValueSmallint	TYPE_SEARCHABLE
private static final Value	YES

Constructor Summary

Constructors

Constructor	Description
DatabaseMetaLocal(SessionLocal session)

Method Summary

Modifier and Type	Method	Description
private void	addCrossReferenceResult(SimpleResult result, Value catalog, String pkSchema, Table pkTable, String fkSchema, Table fkTable, ConstraintReferential fk)
private void	addPrivilege(SimpleResult result, Value catalogValue, Value schemaValue, Value tableValue, Value granteeValue, String right, boolean isAdmin, CompareLike columnLike, Column[] columns)
private void	addPrivileges(SimpleResult result, Value catalogValue, String schemaName, String tableName, DbObject grantee, int rightMask, CompareLike columnLike, Column[] columns)
private boolean	checkCatalogName(String catalog)
(package private) void	checkClosed()
private boolean	checkSchema(String schemaName, Schema schema)
final DefaultNullOrdering	defaultNullOrdering()	INTERNAL
ResultInterface	getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)	INTERNAL
ResultInterface	getCatalogs()	INTERNAL
ResultInterface	getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)	INTERNAL
ResultInterface	getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)	INTERNAL
private void	getColumnsAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, Table t, CompareLike columnLike)
ResultInterface	getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)	INTERNAL
private Value	getDataTypeName(TypeInfo typeInfo)
ResultInterface	getExportedKeys(String catalog, String schema, String table)	INTERNAL
private String	getFunctions(String section)
ResultInterface	getImportedKeys(String catalog, String schema, String table)	INTERNAL
ResultInterface	getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)	INTERNAL
private void	getIndexInfo(Value catalogValue, Value schemaValue, Table table, boolean unique, boolean approximate, SimpleResult result, Database db)
private CompareLike	getLike(String pattern)
String	getNumericFunctions()	INTERNAL
ResultInterface	getPrimaryKeys(String catalog, String schema, String table)	INTERNAL
private void	getProcedureColumnAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value procedureNameValue, Value specificNameValue, TypeInfo type, boolean notNull, int ordinal)
ResultInterface	getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)	INTERNAL
ResultInterface	getProcedures(String catalog, String schemaPattern, String procedureNamePattern)	INTERNAL
private void	getProceduresAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value procedureNameValue, String comment, ValueSmallint procedureType, Value specificNameValue)
ResultInterface	getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)	INTERNAL
private void	getPseudoColumnsAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, CompareLike columnLike, Column c)
private void	getPseudoColumnsAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, Table t, CompareLike columnLike)
private static Value	getRadix(int valueType, boolean small)
private static ValueSmallint	getRefAction(ConstraintActionType action)
ResultInterface	getSchemas()	INTERNAL
private Collection<Schema>	getSchemas(String schema)
ResultInterface	getSchemas(String catalog, String schemaPattern)	INTERNAL
private Collection<Schema>	getSchemasForPattern(String schemaPattern)
String	getSearchStringEscape()	INTERNAL
String	getSQLKeywords()	INTERNAL
(package private) Value	getString(String string)
String	getStringFunctions()	INTERNAL
String	getSystemFunctions()	INTERNAL
ResultInterface	getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)	INTERNAL
ResultInterface	getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)	INTERNAL
private void	getTablesAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, Table t, boolean synonym, HashSet<String> typesSet)
private Collection<? extends SchemaObject>	getTablesForPattern(Schema schema, String tablePattern)
ResultInterface	getTableTypes()	INTERNAL
String	getTimeDateFunctions()	INTERNAL
ResultInterface	getTypeInfo()	INTERNAL
private SimpleResult	initCrossReferenceResult()

Methods inherited from class DatabaseMetaLocalBase

getAttributes, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductVersion, getFunctionColumns, getFunctions, getPseudoColumnsResult, getSuperTables, getSuperTypes, getUDTs, getVersionColumns

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

YES

private static final Value YES

NO

private static final Value NO

BEST_ROW_SESSION

private static final ValueSmallint BEST_ROW_SESSION

BEST_ROW_NOT_PSEUDO

private static final ValueSmallint BEST_ROW_NOT_PSEUDO

COLUMN_NO_NULLS

private static final ValueInteger COLUMN_NO_NULLS

COLUMN_NO_NULLS_SMALL

private static final ValueSmallint COLUMN_NO_NULLS_SMALL

COLUMN_NULLABLE

private static final ValueInteger COLUMN_NULLABLE

COLUMN_NULLABLE_UNKNOWN_SMALL

private static final ValueSmallint COLUMN_NULLABLE_UNKNOWN_SMALL

IMPORTED_KEY_CASCADE

private static final ValueSmallint IMPORTED_KEY_CASCADE

IMPORTED_KEY_RESTRICT

private static final ValueSmallint IMPORTED_KEY_RESTRICT

IMPORTED_KEY_DEFAULT

private static final ValueSmallint IMPORTED_KEY_DEFAULT

IMPORTED_KEY_SET_NULL

private static final ValueSmallint IMPORTED_KEY_SET_NULL

IMPORTED_KEY_NOT_DEFERRABLE

private static final ValueSmallint IMPORTED_KEY_NOT_DEFERRABLE

PROCEDURE_COLUMN_IN

private static final ValueSmallint PROCEDURE_COLUMN_IN

PROCEDURE_COLUMN_RETURN

private static final ValueSmallint PROCEDURE_COLUMN_RETURN

PROCEDURE_NO_RESULT

private static final ValueSmallint PROCEDURE_NO_RESULT

PROCEDURE_RETURNS_RESULT

private static final ValueSmallint PROCEDURE_RETURNS_RESULT

TABLE_INDEX_HASHED

private static final ValueSmallint TABLE_INDEX_HASHED

TABLE_INDEX_OTHER

private static final ValueSmallint TABLE_INDEX_OTHER

TABLE_TYPES

private static final String[] TABLE_TYPES

TYPE_NULLABLE

private static final ValueSmallint TYPE_NULLABLE

TYPE_SEARCHABLE

private static final ValueSmallint TYPE_SEARCHABLE

NO_USAGE_RESTRICTIONS

private static final Value NO_USAGE_RESTRICTIONS

session

private final SessionLocal session

Constructor Details

DatabaseMetaLocal

public DatabaseMetaLocal(SessionLocal session)

Method Details

defaultNullOrdering

public final DefaultNullOrdering defaultNullOrdering()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

defaultNullOrdering in class DatabaseMeta

Returns:

DefaultNullOrdering

See Also:

• DatabaseMetaData.nullsAreSortedHigh()
• DatabaseMetaData.nullsAreSortedLow()
• DatabaseMetaData.nullsAreSortedAtStart()
• DatabaseMetaData.nullsAreSortedAtEnd()

getSQLKeywords

public String getSQLKeywords()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getSQLKeywords in class DatabaseMeta

Returns:

list of supported SQL keywords

See Also:

• DatabaseMetaData.getSQLKeywords()

getNumericFunctions

public String getNumericFunctions()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getNumericFunctions in class DatabaseMeta

Returns:

list of supported numeric functions

See Also:

• DatabaseMetaData.getNumericFunctions()

getStringFunctions

public String getStringFunctions()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getStringFunctions in class DatabaseMeta

Returns:

list of supported string functions

See Also:

• DatabaseMetaData.getStringFunctions()

getSystemFunctions

public String getSystemFunctions()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getSystemFunctions in class DatabaseMeta

Returns:

list of supported system functions

See Also:

• DatabaseMetaData.getSystemFunctions()

getTimeDateFunctions

public String getTimeDateFunctions()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getTimeDateFunctions in class DatabaseMeta

Returns:

list of supported time/date functions

See Also:

• DatabaseMetaData.getTimeDateFunctions()

getFunctions

private String getFunctions(String section)

getSearchStringEscape

public String getSearchStringEscape()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getSearchStringEscape in class DatabaseMeta

Returns:

search string escape sequence

See Also:

• DatabaseMetaData.getSearchStringEscape()

getProcedures

public ResultInterface getProcedures(String catalog,
 String schemaPattern,
 String procedureNamePattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getProcedures in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

procedureNamePattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getProcedures(String, String, String)

getProceduresAdd

private void getProceduresAdd(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value procedureNameValue,
 String comment,
 ValueSmallint procedureType,
 Value specificNameValue)

getProcedureColumns

public ResultInterface getProcedureColumns(String catalog,
 String schemaPattern,
 String procedureNamePattern,
 String columnNamePattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getProcedureColumns in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

procedureNamePattern - "LIKE" style pattern to filter result

columnNamePattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getProcedureColumns(String, String, String, String)

getProcedureColumnAdd

private void getProcedureColumnAdd(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value procedureNameValue,
 Value specificNameValue,
 TypeInfo type,
 boolean notNull,
 int ordinal)

getTables

public ResultInterface getTables(String catalog,
 String schemaPattern,
 String tableNamePattern,
 String[] types)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getTables in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

tableNamePattern - "LIKE" style pattern to filter result

types - String[]

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getTables(String, String, String, String[])

getTablesAdd

private void getTablesAdd(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value tableName,
 Table t,
 boolean synonym,
 HashSet<String> typesSet)

getSchemas

public ResultInterface getSchemas()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getSchemas in class DatabaseMeta

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getSchemas()

getCatalogs

public ResultInterface getCatalogs()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getCatalogs in class DatabaseMeta

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getCatalogs()

getTableTypes

public ResultInterface getTableTypes()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getTableTypes in class DatabaseMeta

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getTableTypes()

getColumns

public ResultInterface getColumns(String catalog,
 String schemaPattern,
 String tableNamePattern,
 String columnNamePattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getColumns in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

tableNamePattern - "LIKE" style pattern to filter result

columnNamePattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getColumns(String, String, String, String)

getColumnsAdd

private void getColumnsAdd(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value tableName,
 Table t,
 CompareLike columnLike)

getColumnPrivileges

public ResultInterface getColumnPrivileges(String catalog,
 String schema,
 String table,
 String columnNamePattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getColumnPrivileges in class DatabaseMeta

Parameters:

catalog - to inspect

schema - to inspect

table - to inspect

columnNamePattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getColumnPrivileges(String, String, String, String)

getTablePrivileges

public ResultInterface getTablePrivileges(String catalog,
 String schemaPattern,
 String tableNamePattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getTablePrivileges in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

tableNamePattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getTablePrivileges(String, String, String)

addPrivileges

private void addPrivileges(SimpleResult result,
 Value catalogValue,
 String schemaName,
 String tableName,
 DbObject grantee,
 int rightMask,
 CompareLike columnLike,
 Column[] columns)

addPrivilege

private void addPrivilege(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value tableValue,
 Value granteeValue,
 String right,
 boolean isAdmin,
 CompareLike columnLike,
 Column[] columns)

getBestRowIdentifier

public ResultInterface getBestRowIdentifier(String catalog,
 String schema,
 String table,
 int scope,
 boolean nullable)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getBestRowIdentifier in class DatabaseMeta

Parameters:

catalog - "LIKE" style pattern to filter result

schema - "LIKE" style pattern to filter result

table - table of interest

scope - of interest

nullable - include nullable columns

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getBestRowIdentifier(String, String, String, int, boolean)

getDataTypeName

private Value getDataTypeName(TypeInfo typeInfo)

getPrimaryKeys

public ResultInterface getPrimaryKeys(String catalog,
 String schema,
 String table)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getPrimaryKeys in class DatabaseMeta

Parameters:

catalog - to inspect

schema - to inspect

table - to inspect

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getPrimaryKeys(String, String, String)

getImportedKeys

public ResultInterface getImportedKeys(String catalog,
 String schema,
 String table)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getImportedKeys in class DatabaseMeta

Parameters:

catalog - to inspect

schema - to inspect

table - to inspect

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getImportedKeys(String, String, String)

getExportedKeys

public ResultInterface getExportedKeys(String catalog,
 String schema,
 String table)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getExportedKeys in class DatabaseMeta

Parameters:

catalog - to inspect

schema - to inspect

table - to inspect

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getExportedKeys(String, String, String)

getCrossReference

public ResultInterface getCrossReference(String primaryCatalog,
 String primarySchema,
 String primaryTable,
 String foreignCatalog,
 String foreignSchema,
 String foreignTable)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getCrossReference in class DatabaseMeta

Parameters:

primaryCatalog - to inspect

primarySchema - to inspect

primaryTable - to inspect

foreignCatalog - to inspect

foreignSchema - to inspect

foreignTable - to inspect

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getCrossReference(String, String, String, String, String, String)

initCrossReferenceResult

private SimpleResult initCrossReferenceResult()

addCrossReferenceResult

private void addCrossReferenceResult(SimpleResult result,
 Value catalog,
 String pkSchema,
 Table pkTable,
 String fkSchema,
 Table fkTable,
 ConstraintReferential fk)

getRefAction

private static ValueSmallint getRefAction(ConstraintActionType action)

getTypeInfo

public ResultInterface getTypeInfo()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getTypeInfo in class DatabaseMeta

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getTypeInfo()

getRadix

private static Value getRadix(int valueType,
 boolean small)

getIndexInfo

public ResultInterface getIndexInfo(String catalog,
 String schema,
 String table,
 boolean unique,
 boolean approximate)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getIndexInfo in class DatabaseMeta

Parameters:

catalog - to inspect

schema - to inspect

table - to inspect

unique - only

approximate - allowed

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getIndexInfo(String, String, String, boolean, boolean)

getIndexInfo

private void getIndexInfo(Value catalogValue,
 Value schemaValue,
 Table table,
 boolean unique,
 boolean approximate,
 SimpleResult result,
 Database db)

getSchemas

public ResultInterface getSchemas(String catalog,
 String schemaPattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getSchemas in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getSchemas(String, String)

getPseudoColumns

public ResultInterface getPseudoColumns(String catalog,
 String schemaPattern,
 String tableNamePattern,
 String columnNamePattern)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getPseudoColumns in class DatabaseMeta

Parameters:

catalog - to inspect

schemaPattern - "LIKE" style pattern to filter result

tableNamePattern - "LIKE" style pattern to filter result

columnNamePattern - "LIKE" style pattern to filter result

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getPseudoColumns(String, String, String, String)

getPseudoColumnsAdd

private void getPseudoColumnsAdd(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value tableName,
 Table t,
 CompareLike columnLike)

getPseudoColumnsAdd

private void getPseudoColumnsAdd(SimpleResult result,
 Value catalogValue,
 Value schemaValue,
 Value tableName,
 CompareLike columnLike,
 Column c)

checkClosed

void checkClosed()

Specified by:

checkClosed in class DatabaseMetaLocalBase

getString

Value getString(String string)

checkCatalogName

private boolean checkCatalogName(String catalog)

getSchemas

private Collection<Schema> getSchemas(String schema)

getSchemasForPattern

private Collection<Schema> getSchemasForPattern(String schemaPattern)

getTablesForPattern

private Collection<? extends SchemaObject> getTablesForPattern(Schema schema,
 String tablePattern)

checkSchema

private boolean checkSchema(String schemaName,
 Schema schema)

getLike

private CompareLike getLike(String pattern)