Top Description Fields Constructors Methods
org.h2.jdbc.meta

public final Class DatabaseMetaLegacy

extends DatabaseMetaLocalBase
Class Inheritance
Imports
java.sql.DatabaseMetaData, java.util.ArrayList, .Arrays, org.h2.api.ErrorCode, org.h2.command.CommandInterface, org.h2.engine.Constants, .Session, org.h2.expression.ParameterInterface, org.h2.message.DbException, org.h2.mode.DefaultNullOrdering, org.h2.result.ResultInterface, org.h2.util.StringUtils, org.h2.value.Value, .ValueInteger, .ValueNull, .ValueVarchar
Legacy implementation of database meta information.

Field Summary

Modifier and TypeField and 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

AccessConstructor and Description
public
DatabaseMetaLegacy(Session session)

Method Summary

Modifier and TypeMethod and Description
pack-priv void
checkClosed()

Implements abstract org.h2.jdbc.meta.DatabaseMetaLocalBase.checkClosed.

public final DefaultNullOrdering
defaultNullOrdering()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.defaultNullOrdering.

INTERNAL

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

public ResultInterface
getBestRowIdentifier(String
"LIKE" style pattern to filter result
catalogPattern, String
"LIKE" style pattern to filter result
schemaPattern, String
table of interest
tableName, int
of interest
scope, boolean
include nullable columns
nullable)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getBestRowIdentifier.

INTERNAL

private Value
getCatalogPattern(String catalogPattern)

public ResultInterface
getCatalogs()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getCatalogs.

INTERNAL

public ResultInterface
getColumnPrivileges(String
to inspect
catalog, String
to inspect
schema, String
to inspect
table, String
"LIKE" style pattern to filter result
columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getColumnPrivileges.

INTERNAL

public ResultInterface
getColumns(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern, String
"LIKE" style pattern to filter result
tableNamePattern, String
"LIKE" style pattern to filter result
columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getColumns.

INTERNAL

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

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getCrossReference.

INTERNAL

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

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getExportedKeys.

INTERNAL

private String
getFunctions(String section)

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

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getImportedKeys.

INTERNAL

public ResultInterface
getIndexInfo(String
to inspect
catalog, String
to inspect
schema, String
to inspect
table, boolean
only
unique, boolean
allowed
approximate)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getIndexInfo.

INTERNAL

public String
getNumericFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getNumericFunctions.

INTERNAL

private Value
getPattern(String pattern)

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

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getPrimaryKeys.

INTERNAL

public ResultInterface
getProcedureColumns(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern, String
"LIKE" style pattern to filter result
procedureNamePattern, String
"LIKE" style pattern to filter result
columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getProcedureColumns.

INTERNAL

public ResultInterface
getProcedures(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern, String
"LIKE" style pattern to filter result
procedureNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getProcedures.

INTERNAL

public ResultInterface
getPseudoColumns(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern, String
"LIKE" style pattern to filter result
tableNamePattern, String
"LIKE" style pattern to filter result
columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getPseudoColumns.

INTERNAL

private Value
getSchemaPattern(String pattern)

public ResultInterface
getSchemas()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSchemas.

INTERNAL

public ResultInterface
getSchemas(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSchemas.

INTERNAL

public String
getSearchStringEscape()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSearchStringEscape.

INTERNAL

public String
getSQLKeywords()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSQLKeywords.

INTERNAL

private Value
getString(String string)

public String
getStringFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getStringFunctions.

INTERNAL

public String
getSystemFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSystemFunctions.

INTERNAL

public ResultInterface
getTablePrivileges(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern, String
"LIKE" style pattern to filter result
tableNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTablePrivileges.

INTERNAL

public ResultInterface
getTables(String
to inspect
catalog, String
"LIKE" style pattern to filter result
schemaPattern, String
"LIKE" style pattern to filter result
tableNamePattern, String[]
String[]
types)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTables.

INTERNAL

public ResultInterface
getTableTypes()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTableTypes.

INTERNAL

public String
getTimeDateFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTimeDateFunctions.

INTERNAL

public ResultInterface
getTypeInfo()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTypeInfo.

INTERNAL

Inherited from org.h2.jdbc.meta.DatabaseMetaLocalBase:
getAttributesgetDatabaseMajorVersiongetDatabaseMinorVersiongetDatabaseProductVersiongetFunctionColumnsgetFunctionsgetPseudoColumnsResultgetSuperTablesgetSuperTypesgetUDTsgetVersionColumns

Field Detail

BACKSLASHback to summary
private static final Value BACKSLASH
NOback to summary
private static final Value NO
PERCENTback to summary
private static final Value PERCENT
SCHEMA_MAINback to summary
private static final Value SCHEMA_MAIN
sessionback to summary
private final Session session
YESback to summary
private static final Value YES

Constructor Detail

DatabaseMetaLegacyback to summary
public DatabaseMetaLegacy(Session session)

Method Detail

checkClosedback to summary
pack-priv void checkClosed()

Implements abstract org.h2.jdbc.meta.DatabaseMetaLocalBase.checkClosed.

Annotations
@Override
defaultNullOrderingback to summary
public final DefaultNullOrdering defaultNullOrdering()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.defaultNullOrdering.

Doc from org.h2.jdbc.meta.DatabaseMeta.defaultNullOrdering.

INTERNAL

Returns:DefaultNullOrdering

DefaultNullOrdering

Annotations
@Override
executeQueryback to summary
private ResultInterface executeQuery(String sql, Value... args)
getBestRowIdentifierback to summary
public ResultInterface getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getBestRowIdentifier.

Doc from org.h2.jdbc.meta.DatabaseMeta.getBestRowIdentifier.

INTERNAL

Parameters
catalogPattern:String

"LIKE" style pattern to filter result

schemaPattern:String

"LIKE" style pattern to filter result

tableName:String

table of interest

scope:int

of interest

nullable:boolean

include nullable columns

Returns:ResultInterface

ResultInterface

Annotations
@Override
getCatalogPatternback to summary
private Value getCatalogPattern(String catalogPattern)
getCatalogsback to summary
public ResultInterface getCatalogs()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getCatalogs.

Doc from org.h2.jdbc.meta.DatabaseMeta.getCatalogs.

INTERNAL

Returns:ResultInterface

ResultInterface

Annotations
@Override
getColumnPrivilegesback to summary
public ResultInterface getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getColumnPrivileges.

Doc from org.h2.jdbc.meta.DatabaseMeta.getColumnPrivileges.

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getColumnsback to summary
public ResultInterface getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getColumns.

Doc from org.h2.jdbc.meta.DatabaseMeta.getColumns.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getCrossReferenceback to summary
public ResultInterface getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getCrossReference.

Doc from org.h2.jdbc.meta.DatabaseMeta.getCrossReference.

INTERNAL

Parameters
primaryCatalog:String

to inspect

primarySchema:String

to inspect

primaryTable:String

to inspect

foreignCatalog:String

to inspect

foreignSchema:String

to inspect

foreignTable:String

to inspect

Returns:ResultInterface

ResultInterface

Annotations
@Override
getExportedKeysback to summary
public ResultInterface getExportedKeys(String catalog, String schema, String table)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getExportedKeys.

Doc from org.h2.jdbc.meta.DatabaseMeta.getExportedKeys.

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

Annotations
@Override
getFunctionsback to summary
private String getFunctions(String section)
getImportedKeysback to summary
public ResultInterface getImportedKeys(String catalog, String schema, String table)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getImportedKeys.

Doc from org.h2.jdbc.meta.DatabaseMeta.getImportedKeys.

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

Annotations
@Override
getIndexInfoback to summary
public ResultInterface getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getIndexInfo.

Doc from org.h2.jdbc.meta.DatabaseMeta.getIndexInfo.

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

unique:boolean

only

approximate:boolean

allowed

Returns:ResultInterface

ResultInterface

Annotations
@Override
getNumericFunctionsback to summary
public String getNumericFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getNumericFunctions.

Doc from org.h2.jdbc.meta.DatabaseMeta.getNumericFunctions.

INTERNAL

Returns:String

list of supported numeric functions

Annotations
@Override
getPatternback to summary
private Value getPattern(String pattern)
getPrimaryKeysback to summary
public ResultInterface getPrimaryKeys(String catalog, String schema, String table)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getPrimaryKeys.

Doc from org.h2.jdbc.meta.DatabaseMeta.getPrimaryKeys.

INTERNAL

Parameters
catalog:String

to inspect

schema:String

to inspect

table:String

to inspect

Returns:ResultInterface

ResultInterface

Annotations
@Override
getProcedureColumnsback to summary
public ResultInterface getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getProcedureColumns.

Doc from org.h2.jdbc.meta.DatabaseMeta.getProcedureColumns.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

procedureNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getProceduresback to summary
public ResultInterface getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getProcedures.

Doc from org.h2.jdbc.meta.DatabaseMeta.getProcedures.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

procedureNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getPseudoColumnsback to summary
public ResultInterface getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getPseudoColumns.

Doc from org.h2.jdbc.meta.DatabaseMeta.getPseudoColumns.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

columnNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getSchemaPatternback to summary
private Value getSchemaPattern(String pattern)
getSchemasback to summary
public ResultInterface getSchemas()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSchemas.

Doc from org.h2.jdbc.meta.DatabaseMeta.getSchemas.

INTERNAL

Returns:ResultInterface

ResultInterface

Annotations
@Override
getSchemasback to summary
public ResultInterface getSchemas(String catalog, String schemaPattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSchemas.

Doc from org.h2.jdbc.meta.DatabaseMeta.getSchemas.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getSearchStringEscapeback to summary
public String getSearchStringEscape()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSearchStringEscape.

Doc from org.h2.jdbc.meta.DatabaseMeta.getSearchStringEscape.

INTERNAL

Returns:String

search string escape sequence

Annotations
@Override
getSQLKeywordsback to summary
public String getSQLKeywords()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSQLKeywords.

Doc from org.h2.jdbc.meta.DatabaseMeta.getSQLKeywords.

INTERNAL

Returns:String

list of supported SQL keywords

Annotations
@Override
getStringback to summary
private Value getString(String string)
getStringFunctionsback to summary
public String getStringFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getStringFunctions.

Doc from org.h2.jdbc.meta.DatabaseMeta.getStringFunctions.

INTERNAL

Returns:String

list of supported string functions

Annotations
@Override
getSystemFunctionsback to summary
public String getSystemFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getSystemFunctions.

Doc from org.h2.jdbc.meta.DatabaseMeta.getSystemFunctions.

INTERNAL

Returns:String

list of supported system functions

Annotations
@Override
getTablePrivilegesback to summary
public ResultInterface getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTablePrivileges.

Doc from org.h2.jdbc.meta.DatabaseMeta.getTablePrivileges.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

Returns:ResultInterface

ResultInterface

Annotations
@Override
getTablesback to summary
public ResultInterface getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTables.

Doc from org.h2.jdbc.meta.DatabaseMeta.getTables.

INTERNAL

Parameters
catalog:String

to inspect

schemaPattern:String

"LIKE" style pattern to filter result

tableNamePattern:String

"LIKE" style pattern to filter result

types:String[]

String[]

Returns:ResultInterface

ResultInterface

Annotations
@Override
getTableTypesback to summary
public ResultInterface getTableTypes()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTableTypes.

Doc from org.h2.jdbc.meta.DatabaseMeta.getTableTypes.

INTERNAL

Returns:ResultInterface

ResultInterface

Annotations
@Override
getTimeDateFunctionsback to summary
public String getTimeDateFunctions()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTimeDateFunctions.

Doc from org.h2.jdbc.meta.DatabaseMeta.getTimeDateFunctions.

INTERNAL

Returns:String

list of supported time/date functions

Annotations
@Override
getTypeInfoback to summary
public ResultInterface getTypeInfo()

Implements abstract org.h2.jdbc.meta.DatabaseMeta.getTypeInfo.

Doc from org.h2.jdbc.meta.DatabaseMeta.getTypeInfo.

INTERNAL

Returns:ResultInterface

ResultInterface

Annotations
@Override