Package org.h2.jdbc.meta

Class DatabaseMetaLegacy

java.lang.Object

org.h2.jdbc.meta.DatabaseMeta

org.h2.jdbc.meta.DatabaseMetaLocalBase

org.h2.jdbc.meta.DatabaseMetaLegacy

public final class DatabaseMetaLegacy
extends DatabaseMetaLocalBase

Legacy implementation of database meta information.

Field Summary

Fields

Modifier and Type	Field	Description
private static final Value	BACKSLASH
private static final Value	NO
private static final Value	PERCENT
private static final Value	SCHEMA_MAIN
private final Session	session
private static final Value	YES

Constructor Summary

Constructors

Constructor	Description
DatabaseMetaLegacy(Session session)

Method Summary

Modifier and Type	Method	Description
(package private) void	checkClosed()
final DefaultNullOrdering	defaultNullOrdering()	INTERNAL
private ResultInterface	executeQuery(String sql, Value... args)
ResultInterface	getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable)	INTERNAL
private Value	getCatalogPattern(String catalogPattern)
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
ResultInterface	getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)	INTERNAL
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
String	getNumericFunctions()	INTERNAL
private Value	getPattern(String pattern)
ResultInterface	getPrimaryKeys(String catalog, String schema, String table)	INTERNAL
ResultInterface	getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)	INTERNAL
ResultInterface	getProcedures(String catalog, String schemaPattern, String procedureNamePattern)	INTERNAL
ResultInterface	getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)	INTERNAL
private Value	getSchemaPattern(String pattern)
ResultInterface	getSchemas()	INTERNAL
ResultInterface	getSchemas(String catalog, String schemaPattern)	INTERNAL
String	getSearchStringEscape()	INTERNAL
String	getSQLKeywords()	INTERNAL
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
ResultInterface	getTableTypes()	INTERNAL
String	getTimeDateFunctions()	INTERNAL
ResultInterface	getTypeInfo()	INTERNAL

Methods inherited from class org.h2.jdbc.meta.DatabaseMetaLocalBase

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

Methods inherited from class java.lang.Object

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

Field Details

PERCENT

private static final Value PERCENT

BACKSLASH

private static final Value BACKSLASH

YES

private static final Value YES

NO

private static final Value NO

SCHEMA_MAIN

private static final Value SCHEMA_MAIN

session

private final Session session

Constructor Details

DatabaseMetaLegacy

public DatabaseMetaLegacy(Session 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)

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)

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[])

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)

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)

getBestRowIdentifier

public ResultInterface getBestRowIdentifier(String catalogPattern,
 String schemaPattern,
 String tableName,
 int scope,
 boolean nullable)

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getBestRowIdentifier in class DatabaseMeta

Parameters:

catalogPattern - "LIKE" style pattern to filter result

schemaPattern - "LIKE" style pattern to filter result

tableName - table of interest

scope - of interest

nullable - include nullable columns

Returns:

ResultInterface

See Also:

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

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)

getTypeInfo

public ResultInterface getTypeInfo()

Description copied from class: DatabaseMeta

INTERNAL

Specified by:

getTypeInfo in class DatabaseMeta

Returns:

ResultInterface

See Also:

• DatabaseMetaData.getTypeInfo()

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)

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)

executeQuery

private ResultInterface executeQuery(String sql,
 Value... args)

checkClosed

void checkClosed()

Specified by:

checkClosed in class DatabaseMetaLocalBase

getString

private Value getString(String string)

getPattern

private Value getPattern(String pattern)

getSchemaPattern

private Value getSchemaPattern(String pattern)

getCatalogPattern

private Value getCatalogPattern(String catalogPattern)