Top Description Inners Fields Constructors Methods
com.mysql.cj.jdbc

public Class DatabaseMetaData

extends Object
implements DatabaseMetaData
Class Inheritance
All Implemented Interfaces
java.sql.DatabaseMetaData, java.sql.Wrapper
Known Direct Subclasses
com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema
Static Imports
com.mysql.cj.jdbc.DatabaseMetaData.ProcedureType.FUNCTION, .DatabaseMetaData.ProcedureType.PROCEDURE

JDBC Interface to Mysql functions

This class provides information about the database as a whole.

Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods show throw a SQLException.

Some of these methods take arguments that are String patterns. These methods all have names such as fooPattern. Within a pattern String "%" means match any substring of 0 or more characters and "_" means match any one character.

Nested and Inner Type Summary

Modifier and TypeClass and Description
protected class
DatabaseMetaData.ComparableWrapper<
key type
K extends Comparable<? super K>
,
value type
V
>

Helper/wrapper class to provide means of sorting objects by using a sorting key.

protected class
DatabaseMetaData.IndexMetaDataKey

Helper class to provide means of comparing indexes by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.

protected abstract class
protected static enum
DatabaseMetaData.ProcedureType

Enumeration for Procedure Types

pack-priv class
protected class
protected class
protected class
DatabaseMetaData.TableDbObjectKey

Helper class to provide means of comparing fully qualified DB objects.

protected class
DatabaseMetaData.TableMetaDataKey

Helper class to provide means of comparing tables by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM and TABLE_NAME.

protected static enum
DatabaseMetaData.TableType

Enumeration for Table Types

pack-priv class
DatabaseMetaData.TypeDescriptor

Parses and represents common data type information used by various column/parameter methods.

Field Summary

Modifier and TypeField and Description
protected JdbcConnection
conn

The connection to the database

protected String
database

The 'current' database name being used

protected RuntimeProperty<PropertyDefinitions.DatabaseTerm>
private ExceptionInterceptor
private static final Lock
protected static final int
protected static int
maxBufferSize

Default max buffer size.

private int
private String
private static final String[]
private static volatile String
protected RuntimeProperty<Boolean>
protected boolean
protected final String
quotedId

What character to use when quoting identifiers

protected ResultSetFactory
protected NativeSession
pack-priv static final List<String>
private static final String
SUPPORTS_FK

The table type for generic tables that support foreign keys.

protected static final byte[]
protected static final byte[]
protected boolean
protected boolean
protected boolean
protected static final byte[]
protected boolean

Constructor Summary

AccessConstructor and Description
protected
DatabaseMetaData(JdbcConnection
Connection object
connToSet
,
String
database name
databaseToSet
,
ResultSetFactory resultSetFactory)

Creates a new DatabaseMetaData object.

Method Summary

Modifier and TypeMethod and Description
public boolean
allProceduresAreCallable()

Implements java.sql.DatabaseMetaData.allProceduresAreCallable.

Retrieves whether the current user can call all the procedures returned by the method getProcedures.

public boolean
allTablesAreSelectable()

Implements java.sql.DatabaseMetaData.allTablesAreSelectable.

Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.

public boolean
autoCommitFailureClosesAllResultSets()

Implements java.sql.DatabaseMetaData.autoCommitFailureClosesAllResultSets.

Retrieves whether a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable.

protected void
protected void
convertToJdbcProcedureList(boolean fromSelect, ResultSet proceduresRs, List<DatabaseMetaData.ComparableWrapper<String, Row>> procedureRows)

private Row
convertTypeDescriptorToProcedureRow(byte[] procNameAsBytes, byte[] procCatAsBytes, String paramName, boolean isOutParam, boolean isInParam, boolean isReturnParam, DatabaseMetaData.TypeDescriptor typeDesc, boolean forGetFunctionColumns, int ordinal)

protected Field[]
protected Field[]
protected Field[]
protected Field[]
protected Field[]
protected Field[]
protected ColumnDefinition
public boolean
dataDefinitionCausesTransactionCommit()

Implements java.sql.DatabaseMetaData.dataDefinitionCausesTransactionCommit.

Retrieves whether a data definition statement within a transaction forces the transaction to commit.

public boolean
dataDefinitionIgnoredInTransactions()

Implements java.sql.DatabaseMetaData.dataDefinitionIgnoredInTransactions.

Retrieves whether this database ignores a data definition statement within a transaction.

public boolean
deletesAreDetected(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.deletesAreDetected.

Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.

public boolean
doesMaxRowSizeIncludeBlobs()

Implements java.sql.DatabaseMetaData.doesMaxRowSizeIncludeBlobs.

Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

private int

Returns:

the ending index of the parameter declaration, not including the closing ")"
endPositionOfParameterDeclaration
(int
should be the index of the procedure body that contains the first "(".
beginIndex
,
String
the procedure body
procedureDef
,
String
the identifier quote character in use
quoteChar
)

Finds the end of the parameter declaration from the output of "SHOW CREATE PROCEDURE".

private List<Row>

Returns:

the list of rows with new rows added
extractForeignKeyForTable
(ArrayList<Row>
the list of rows to add to
rows
,
ResultSet
the result set from 'SHOW CREATE TABLE'
rs
,
String
the database name
dbName
)

Extracts foreign key info for one table.

public ResultSet

Returns:

A result set that has the structure of 'show table status'
extractForeignKeyFromCreateTable
(String
the database name to extract foreign key info for
dbName
,
String
the table to extract foreign key info for
tableName
)

Creates a result set similar enough to 'SHOW TABLE STATUS' to allow the same code to work on extracting the foreign key data

private int

Returns:

the end of the returns clause
findEndOfReturnsClause
(String
the function body containing the definition of the function
procedureDefn
,
int
the position of "RETURNS" in the definition
positionOfReturnKeyword
)

Finds the end of the RETURNS clause for SQL Functions by using any of the keywords allowed after the RETURNS clause, or a label.

public boolean
generatedKeyAlwaysReturned()

Implements java.sql.DatabaseMetaData.generatedKeyAlwaysReturned.

Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.

public ResultSet
getAttributes(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a type name pattern; must match the type name as it is stored in the database
typeNamePattern
,
String
an attribute name pattern; must match the attribute name as it is declared in the database
attributeNamePattern
)

Implements java.sql.DatabaseMetaData.getAttributes.

Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.

public ResultSet
getBestRowIdentifier(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
final String
a table name; must match the table name as it is stored in the database
table
,
int
the scope of interest; use same values as SCOPE
scope
,
boolean
include columns that are nullable.
nullable
)

Implements java.sql.DatabaseMetaData.getBestRowIdentifier.

Retrieves a description of a table's optimal set of columns that uniquely identifies a row.

private int

Returns:

the DBMD constant that represents the cascade option
getCascadeDeleteOption
(String
the comment from 'SHOW TABLE STATUS'
cascadeOptions
)

Parses the cascade option string and returns the DBMD constant that represents it (for deletes) Please note that in MySQL, NO ACTION is the equivalent to RESTRICT.

private int

Returns:

the DBMD constant that represents the cascade option
getCascadeUpdateOption
(String
the comment from 'SHOW TABLE STATUS'
cascadeOptions
)

Parses the cascade option string and returns the DBMD constant that represents it (for Updates).

public ResultSet
getCatalogs()

Implements java.sql.DatabaseMetaData.getCatalogs.

Retrieves the catalog names available in this database.

public String
getCatalogSeparator()

Implements java.sql.DatabaseMetaData.getCatalogSeparator.

Retrieves the String that this database uses as the separator between a catalog and table name.

public String
getCatalogTerm()

Implements java.sql.DatabaseMetaData.getCatalogTerm.

Retrieves the database vendor's preferred term for "catalog".

public ResultSet
getClientInfoProperties()

Implements java.sql.DatabaseMetaData.getClientInfoProperties.

Retrieves a list of the client info properties that the driver supports.

public ResultSet
getColumnPrivileges(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
String
a table name; must match the table name as it is stored in the database
table
,
String
a column name pattern; must match the column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getColumnPrivileges.

Retrieves a description of the access rights for a table's columns.

protected Field[]
public ResultSet
getColumns(final String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
final String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
final String
a table name pattern; must match the table name as it is stored in the database
tableNamePattern
,
String
a column name pattern; must match the column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getColumns.

Retrieves a description of table columns available in the specified catalog.

protected int

Returns:

The corresponding COLUMN_TYPE as in java.sql.DatabaseMetaData.getProcedureColumns API.
getColumnType
(boolean
Indicates whether it's an output parameter.
isOutParam
,
boolean
Indicates whether it's an input parameter.
isInParam
,
boolean
Indicates whether it's a function return parameter.
isReturnParam
,
boolean
Indicates whether the column belong to a function. This argument is required for JDBC4, in which case this method must be overridden to provide the correct functionality.
forGetFunctionColumns
)

Determines the COLUMN_TYPE information based on parameter type (IN, OUT or INOUT) or function return parameter.

public Connection
getConnection()

Implements java.sql.DatabaseMetaData.getConnection.

Retrieves the connection that produced this metadata object.

public ResultSet
getCrossReference(final String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
parentCatalog
,
final String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
parentSchema
,
final String
the name of the table that exports the key; must match the table name as it is stored in the database
parentTable
,
final String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
foreignCatalog
,
final String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
foreignSchema
,
final String
the name of the table that imports the key; must match the table name as it is stored in the database
foreignTable
)

Implements java.sql.DatabaseMetaData.getCrossReference.

Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).

protected String
getDatabase(String catalog, String schema)

protected DatabaseMetaData.IteratorWithCleanup<String>
public int
getDatabaseMajorVersion()

Implements java.sql.DatabaseMetaData.getDatabaseMajorVersion.

Retrieves the major version number of the underlying database.

public int
getDatabaseMinorVersion()

Implements java.sql.DatabaseMetaData.getDatabaseMinorVersion.

Retrieves the minor version number of the underlying database.

public String
getDatabaseProductName()

Implements java.sql.DatabaseMetaData.getDatabaseProductName.

Retrieves the name of this database product.

public String
getDatabaseProductVersion()

Implements java.sql.DatabaseMetaData.getDatabaseProductVersion.

Retrieves the version number of this database product.

protected List<String>

Returns:

list of database names
getDatabases
()

Retrieves the database names available on this server.

protected List<String>

Returns:

list of database names
getDatabases
(String
database name pattern
dbPattern
)

Retrieves the database names matching the dbPattern available on this server.

public int
getDefaultTransactionIsolation()

Implements java.sql.DatabaseMetaData.getDefaultTransactionIsolation.

Retrieves this database's default transaction isolation level.

public int
getDriverMajorVersion()

Implements java.sql.DatabaseMetaData.getDriverMajorVersion.

Retrieves this JDBC driver's major version number.

public int
getDriverMinorVersion()

Implements java.sql.DatabaseMetaData.getDriverMinorVersion.

Retrieves this JDBC driver's minor version number.

public String
getDriverName()

Implements java.sql.DatabaseMetaData.getDriverName.

Retrieves the name of this JDBC driver.

public String
getDriverVersion()

Implements java.sql.DatabaseMetaData.getDriverVersion.

Retrieves the version number of this JDBC driver as a String.

protected ExceptionInterceptor
public ResultSet
getExportedKeys(String
a catalog name; must match the catalog name as it is stored in this database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
final String
a table name; must match the table name as it is stored in this database
table
)

Implements java.sql.DatabaseMetaData.getExportedKeys.

Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).

public String
getExtraNameCharacters()

Implements java.sql.DatabaseMetaData.getExtraNameCharacters.

Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

protected int[]

Returns:

int[] [0] = delete action, [1] = update action
getForeignKeyActions
(String
the comment from 'SHOW TABLE STATUS'
commentString
)

Returns the DELETE and UPDATE foreign key actions from the given 'SHOW TABLE STATUS' string, with the DELETE action being the first item in the array, and the UPDATE action being the second.

public ResultSet
getFunctionColumns(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a procedure name pattern; must match the function name as it is stored in the database
functionNamePattern
,
String
a parameter name pattern; must match the parameter or column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getFunctionColumns.

Retrieves a description of the given catalog's system or user function parameters and return type.

public ResultSet
getFunctions(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a function name pattern; must match the function name as it is stored in the database
functionNamePattern
)

Implements java.sql.DatabaseMetaData.getFunctions.

Retrieves a description of the system and user functions available in the given catalog.

protected Field[]
public String
getIdentifierQuoteString()

Implements java.sql.DatabaseMetaData.getIdentifierQuoteString.

Retrieves the string used to quote SQL identifiers.

public ResultSet
getImportedKeys(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
final String
a table name; must match the table name as it is stored in the database
table
)

Implements java.sql.DatabaseMetaData.getImportedKeys.

Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).

public ResultSet
getIndexInfo(String
a catalog name; must match the catalog name as it is stored in this database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in this database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
final String
a table name; must match the table name as it is stored in this database
table
,
final boolean
when true, return only indices for unique values; when false, return indices regardless of whether unique or not
unique
,
boolean
when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate
approximate
)

Implements java.sql.DatabaseMetaData.getIndexInfo.

Retrieves a description of the given table's indices and statistics.

protected static DatabaseMetaData
getInstance(JdbcConnection connToSet, String databaseToSet, boolean checkForInfoSchema, ResultSetFactory resultSetFactory)

public int
getJDBCMajorVersion()

Implements java.sql.DatabaseMetaData.getJDBCMajorVersion.

Retrieves the major JDBC version number for this driver.

public int
getJDBCMinorVersion()

Implements java.sql.DatabaseMetaData.getJDBCMinorVersion.

Retrieves the minor JDBC version number for this driver.

public int
getMaxBinaryLiteralLength()

Implements java.sql.DatabaseMetaData.getMaxBinaryLiteralLength.

Retrieves the maximum number of hex characters this database allows in an inline binary literal.

public int
getMaxCatalogNameLength()

Implements java.sql.DatabaseMetaData.getMaxCatalogNameLength.

Retrieves the maximum number of characters that this database allows in a catalog name.

public int
getMaxCharLiteralLength()

Implements java.sql.DatabaseMetaData.getMaxCharLiteralLength.

Retrieves the maximum number of characters this database allows for a character literal.

public int
getMaxColumnNameLength()

Implements java.sql.DatabaseMetaData.getMaxColumnNameLength.

Retrieves the maximum number of characters this database allows for a column name.

public int
getMaxColumnsInGroupBy()

Implements java.sql.DatabaseMetaData.getMaxColumnsInGroupBy.

Retrieves the maximum number of columns this database allows in a GROUP BY clause.

public int
getMaxColumnsInIndex()

Implements java.sql.DatabaseMetaData.getMaxColumnsInIndex.

Retrieves the maximum number of columns this database allows in an index.

public int
getMaxColumnsInOrderBy()

Implements java.sql.DatabaseMetaData.getMaxColumnsInOrderBy.

Retrieves the maximum number of columns this database allows in an ORDER BY clause.

public int
getMaxColumnsInSelect()

Implements java.sql.DatabaseMetaData.getMaxColumnsInSelect.

Retrieves the maximum number of columns this database allows in a SELECT list.

public int
getMaxColumnsInTable()

Implements java.sql.DatabaseMetaData.getMaxColumnsInTable.

Retrieves the maximum number of columns this database allows in a table.

public int
getMaxConnections()

Implements java.sql.DatabaseMetaData.getMaxConnections.

Retrieves the maximum number of concurrent connections to this database that are possible.

public int
getMaxCursorNameLength()

Implements java.sql.DatabaseMetaData.getMaxCursorNameLength.

Retrieves the maximum number of characters that this database allows in a cursor name.

public int
getMaxIndexLength()

Implements java.sql.DatabaseMetaData.getMaxIndexLength.

Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.

public int
getMaxProcedureNameLength()

Implements java.sql.DatabaseMetaData.getMaxProcedureNameLength.

Retrieves the maximum number of characters that this database allows in a procedure name.

public int
getMaxRowSize()

Implements java.sql.DatabaseMetaData.getMaxRowSize.

Retrieves the maximum number of bytes this database allows in a single row.

public int
getMaxSchemaNameLength()

Implements java.sql.DatabaseMetaData.getMaxSchemaNameLength.

Retrieves the maximum number of characters that this database allows in a schema name.

public int
getMaxStatementLength()

Implements java.sql.DatabaseMetaData.getMaxStatementLength.

Retrieves the maximum number of characters this database allows in an SQL statement.

public int
getMaxStatements()

Implements java.sql.DatabaseMetaData.getMaxStatements.

Retrieves the maximum number of active statements to this database that can be open at the same time.

public int
getMaxTableNameLength()

Implements java.sql.DatabaseMetaData.getMaxTableNameLength.

Retrieves the maximum number of characters this database allows in a table name.

public int
getMaxTablesInSelect()

Implements java.sql.DatabaseMetaData.getMaxTablesInSelect.

Retrieves the maximum number of tables this database allows in a SELECT statement.

public int
getMaxUserNameLength()

Implements java.sql.DatabaseMetaData.getMaxUserNameLength.

Retrieves the maximum number of characters this database allows in a user name.

public int
public String
public String
getNumericFunctions()

Implements java.sql.DatabaseMetaData.getNumericFunctions.

Retrieves a comma-separated list of math functions available with this database.

public ResultSet
getPrimaryKeys(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
final String
a table name; must match the table name as it is stored in the database
table
)

Implements java.sql.DatabaseMetaData.getPrimaryKeys.

Retrieves a description of the given table's primary key columns.

protected Field[]
public ResultSet
getProcedureColumns(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a procedure name pattern; must match the procedure name as it is stored in the database
procedureNamePattern
,
String
a column name pattern; must match the column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getProcedureColumns.

Retrieves a description of the given catalog's stored procedure parameter and result columns.

protected ResultSet
getProcedureOrFunctionColumns(Field[] fields, String catalog, String schemaPattern, String procedureOrFunctionNamePattern, String columnNamePattern, boolean returnProcedures, boolean returnFunctions)

protected static int

Returns:

The corresponding COLUMN_TYPE as in java.sql.DatabaseMetaData.getProcedureColumns API.
getProcedureOrFunctionColumnType
(boolean
Indicates whether it's an output parameter.
isOutParam
,
boolean
Indicates whether it's an input parameter.
isInParam
,
boolean
Indicates whether it's a function return parameter.
isReturnParam
,
boolean
Indicates whether the column belong to a function.
forGetFunctionColumns
)

Determines the COLUMN_TYPE information based on parameter type (IN, OUT or INOUT) or function return parameter.

private void
getProcedureOrFunctionParameterTypes(String dbName, String objectName, DatabaseMetaData.ProcedureType procType, String parameterNamePattern, List<Row> resultRows, boolean forGetFunctionColumns)

public ResultSet
getProcedures(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a procedure name pattern; must match the procedure name as it is stored in the database
procedureNamePattern
)

Implements java.sql.DatabaseMetaData.getProcedures.

Retrieves a description of the stored procedures available in the given catalog.

protected ResultSet

Returns:

result set
getProceduresAndOrFunctions
(final Field[]
fields
fields
,
String
catalog
catalog
,
String
schema pattern
schemaPattern
,
final String
procedure name pattern
procedureNamePattern
,
final boolean
true if procedures should be included into result
includeProcedures
,
final boolean
true if functions should be included into result
includeFunctions
)

public String
getProcedureTerm()

Implements java.sql.DatabaseMetaData.getProcedureTerm.

Retrieves the database vendor's preferred term for "procedure".

public ResultSet
getPseudoColumns(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a table name pattern; must match the table name as it is stored in the database
tableNamePattern
,
String
a column name pattern; must match the column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getPseudoColumns.

Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.

public int
getResultSetHoldability()

Implements java.sql.DatabaseMetaData.getResultSetHoldability.

Retrieves this database's default holdability for ResultSet objects.

public RowIdLifetime
getRowIdLifetime()

Implements java.sql.DatabaseMetaData.getRowIdLifetime.

Indicates whether this data source supports the SQL ROWID type, and the lifetime for which a RowId object remains valid.

protected DatabaseMetaData.IteratorWithCleanup<String>
public ResultSet
getSchemas()

Implements java.sql.DatabaseMetaData.getSchemas.

Retrieves the schema names available in this database.

public ResultSet
getSchemas(String
a catalog name; must match the catalog name as it is stored in the database;"" retrieves those without a catalog; null means catalog name should not be used to narrow down the search.
catalog
,
String
a schema name; must match the schema name as it is stored in the database; null means schema name should not be used to narrow down the search.
schemaPattern
)

Implements java.sql.DatabaseMetaData.getSchemas.

Retrieves the schema names available in this database.

public String
getSchemaTerm()

Implements java.sql.DatabaseMetaData.getSchemaTerm.

Retrieves the database vendor's preferred term for "schema".

public String
getSearchStringEscape()

Implements java.sql.DatabaseMetaData.getSearchStringEscape.

Retrieves the string that can be used to escape wildcard characters.

public String

Returns:

the list
getSQLKeywords
()

Implements java.sql.DatabaseMetaData.getSQLKeywords.

Get a comma separated list of all a database's SQL keywords that are NOT also SQL92/SQL2003 keywords.

public int
getSQLStateType()

Implements java.sql.DatabaseMetaData.getSQLStateType.

Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.

public String
getStringFunctions()

Implements java.sql.DatabaseMetaData.getStringFunctions.

Retrieves a comma-separated list of string functions available with this database.

public ResultSet
getSuperTables(String
a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
catalog
,
String
a schema name pattern; "" retrieves those without a schema
schemaPattern
,
String
a table name pattern; may be a fully-qualified name
tableNamePattern
)

Implements java.sql.DatabaseMetaData.getSuperTables.

Retrieves a description of the table hierarchies defined in a particular schema in this database.

public ResultSet
getSuperTypes(String
a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
catalog
,
String
a schema name pattern; "" retrieves those without a schema
schemaPattern
,
String
a UDT name pattern; may be a fully-qualified name
typeNamePattern
)

Implements java.sql.DatabaseMetaData.getSuperTypes.

Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.

public String
getSystemFunctions()

Implements java.sql.DatabaseMetaData.getSystemFunctions.

Retrieves a comma-separated list of system functions available with this database.

public ResultSet
getTablePrivileges(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a table name pattern; must match the table name as it is stored in the database
tableNamePattern
)

Implements java.sql.DatabaseMetaData.getTablePrivileges.

Retrieves a description of the access rights for each table available in a catalog.

public ResultSet
getTables(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a table name pattern; must match the table name as it is stored in the database
tableNamePattern
,
final String[]
a list of table types, which must be from the list of table types returned from getTableTypes, to include; null returns all types
types
)

Implements java.sql.DatabaseMetaData.getTables.

Retrieves a description of the tables available in the given catalog.

public ResultSet
getTableTypes()

Implements java.sql.DatabaseMetaData.getTableTypes.

Retrieves the table types available in this database.

public String
getTimeDateFunctions()

Implements java.sql.DatabaseMetaData.getTimeDateFunctions.

Retrieves a comma-separated list of the time and date functions available with this database.

private byte[][]

Returns:

bytes
getTypeInfo
(String
we use a string name here to allow aliases for the same MysqlType to be listed too
mysqlTypeName
)

public ResultSet
getTypeInfo()

Implements java.sql.DatabaseMetaData.getTypeInfo.

Retrieves a description of all the data types supported by this database.

public ResultSet
getUDTs(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema pattern name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schemaPattern
,
String
a type name pattern; must match the type name as it is stored in the database; may be a fully qualified name
typeNamePattern
,
int[]
a list of user-defined types (JAVA_OBJECT, STRUCT, or DISTINCT) to include; null returns all types
types
)

Implements java.sql.DatabaseMetaData.getUDTs.

Retrieves a description of the user-defined types (UDTs) defined in a particular schema.

public String
getURL()

Implements java.sql.DatabaseMetaData.getURL.

Retrieves the URL for this DBMS.

public String
getUserName()

Implements java.sql.DatabaseMetaData.getUserName.

Retrieves the user name as known to this database.

public ResultSet
getVersionColumns(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
catalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
final String
a table name; must match the table name as it is stored in the database
table
)

Implements java.sql.DatabaseMetaData.getVersionColumns.

Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.

protected Field[]
public boolean
insertsAreDetected(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.insertsAreDetected.

Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

public boolean
isCatalogAtStart()

Implements java.sql.DatabaseMetaData.isCatalogAtStart.

Retrieves whether a catalog appears at the start of a fully qualified table name.

public boolean
isReadOnly()

Implements java.sql.DatabaseMetaData.isReadOnly.

Retrieves whether this database is in read-only mode.

public boolean
isWrapperFor(Class<?>
a Class defining an interface.
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.

public boolean
locatorsUpdateCopy()

Implements java.sql.DatabaseMetaData.locatorsUpdateCopy.

Indicates whether updates made to a LOB are made on a copy or directly to the LOB.

protected String

Returns:

a case-normalized version of the specified entity name
normalizeCase
(String
the entity name to normalize
entity
)

Normalizes the entity name considering how identifiers are stored in relation to their case.

public boolean
nullPlusNonNullIsNull()

Implements java.sql.DatabaseMetaData.nullPlusNonNullIsNull.

Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.

public boolean
nullsAreSortedAtEnd()

Implements java.sql.DatabaseMetaData.nullsAreSortedAtEnd.

Retrieves whether NULL values are sorted at the end regardless of sort order.

public boolean
nullsAreSortedAtStart()

Implements java.sql.DatabaseMetaData.nullsAreSortedAtStart.

Retrieves whether NULL values are sorted at the start regardless of sort order.

public boolean
nullsAreSortedHigh()

Implements java.sql.DatabaseMetaData.nullsAreSortedHigh.

Retrieves whether NULL values are sorted high.

public boolean
nullsAreSortedLow()

Implements java.sql.DatabaseMetaData.nullsAreSortedLow.

Retrieves whether NULL values are sorted low.

public boolean
othersDeletesAreVisible(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.othersDeletesAreVisible.

Retrieves whether deletes made by others are visible.

public boolean
othersInsertsAreVisible(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.othersInsertsAreVisible.

Retrieves whether inserts made by others are visible.

public boolean
othersUpdatesAreVisible(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.othersUpdatesAreVisible.

Retrieves whether updates made by others are visible.

public boolean
ownDeletesAreVisible(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.ownDeletesAreVisible.

Retrieves whether a result set's own deletes are visible.

public boolean
ownInsertsAreVisible(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.ownInsertsAreVisible.

Retrieves whether a result set's own inserts are visible.

public boolean
ownUpdatesAreVisible(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.ownUpdatesAreVisible.

Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

pack-priv DatabaseMetaData.ReferencingAndReferencedColumns

Returns:

a ReferencingAndReferencedColumns instance containing the parsed information
parseTableStatusIntoReferencingAndReferencedColumns
(String
the comment from 'show table status'
keysComment
)

Parses a keysComment section from the 'show table status' SQL command.

pack-priv void
populateKeyResults(String
the database of the parent table
parentDatabase
,
String
the parent key table name
parentTable
,
String
the database of the foreign table
foreignDatabase
,
String
the foreign key table name
foreignTable
,
String
the comment from 'show table status'
keys
,
boolean
export or import keys
forExport
,
List<Row>
the rows to add results to
resultRows
)

Populates the resultRows list with the imported or exported keys of given table based on the keysComment from the 'show table status' SQL command.

protected PreparedStatement

Returns:

PreparedStatement
prepareMetaDataSafeStatement
(String
query
sql
)

Get a prepared statement to query information_schema tables.

public boolean
protected byte[]

Returns:

bytes
s2b
(String
string
s
)

Converts the given string to bytes, using the connection's character encoding, or if not available, the JVM default encoding.

public void
setMetadataCollationIndex(int metadataCollationIndex)

public void
setMetadataEncoding(String metadataEncoding)

public boolean
storesLowerCaseIdentifiers()

Implements java.sql.DatabaseMetaData.storesLowerCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

public boolean
storesLowerCaseQuotedIdentifiers()

Implements java.sql.DatabaseMetaData.storesLowerCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

public boolean
storesMixedCaseIdentifiers()

Implements java.sql.DatabaseMetaData.storesMixedCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

public boolean
storesMixedCaseQuotedIdentifiers()

Implements java.sql.DatabaseMetaData.storesMixedCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

public boolean
storesUpperCaseIdentifiers()

Implements java.sql.DatabaseMetaData.storesUpperCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

public boolean
storesUpperCaseQuotedIdentifiers()

Implements java.sql.DatabaseMetaData.storesUpperCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

public boolean
supportsAlterTableWithAddColumn()

Implements java.sql.DatabaseMetaData.supportsAlterTableWithAddColumn.

Retrieves whether this database supports ALTER TABLE with add column.

public boolean
supportsAlterTableWithDropColumn()

Implements java.sql.DatabaseMetaData.supportsAlterTableWithDropColumn.

Retrieves whether this database supports ALTER TABLE with drop column.

public boolean
supportsANSI92EntryLevelSQL()

Implements java.sql.DatabaseMetaData.supportsANSI92EntryLevelSQL.

Retrieves whether this database supports the ANSI92 entry level SQL grammar.

public boolean
supportsANSI92FullSQL()

Implements java.sql.DatabaseMetaData.supportsANSI92FullSQL.

Retrieves whether this database supports the ANSI92 full SQL grammar supported.

public boolean
supportsANSI92IntermediateSQL()

Implements java.sql.DatabaseMetaData.supportsANSI92IntermediateSQL.

Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.

public boolean
supportsBatchUpdates()

Implements java.sql.DatabaseMetaData.supportsBatchUpdates.

Retrieves whether this database supports batch updates.

public boolean
supportsCatalogsInDataManipulation()

Implements java.sql.DatabaseMetaData.supportsCatalogsInDataManipulation.

Retrieves whether a catalog name can be used in a data manipulation statement.

public boolean
supportsCatalogsInIndexDefinitions()

Implements java.sql.DatabaseMetaData.supportsCatalogsInIndexDefinitions.

Retrieves whether a catalog name can be used in an index definition statement.

public boolean
supportsCatalogsInPrivilegeDefinitions()

Implements java.sql.DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions.

Retrieves whether a catalog name can be used in a privilege definition statement.

public boolean
supportsCatalogsInProcedureCalls()

Implements java.sql.DatabaseMetaData.supportsCatalogsInProcedureCalls.

Retrieves whether a catalog name can be used in a procedure call statement.

public boolean
supportsCatalogsInTableDefinitions()

Implements java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions.

Retrieves whether a catalog name can be used in a table definition statement.

public boolean
supportsColumnAliasing()

Implements java.sql.DatabaseMetaData.supportsColumnAliasing.

Retrieves whether this database supports column aliasing.

public boolean
supportsConvert()

Implements java.sql.DatabaseMetaData.supportsConvert.

Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another.

public boolean
supportsConvert(int
the type to convert from; one of the type codes from the class java.sql.Types
fromType
,
int
the type to convert to; one of the type codes from the class java.sql.Types
toType
)

Implements java.sql.DatabaseMetaData.supportsConvert.

Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType.

public boolean
supportsCoreSQLGrammar()

Implements java.sql.DatabaseMetaData.supportsCoreSQLGrammar.

Retrieves whether this database supports the ODBC Core SQL grammar.

public boolean
supportsCorrelatedSubqueries()

Implements java.sql.DatabaseMetaData.supportsCorrelatedSubqueries.

Retrieves whether this database supports correlated subqueries.

public boolean
supportsDataDefinitionAndDataManipulationTransactions()

Implements java.sql.DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions.

Retrieves whether this database supports both data definition and data manipulation statements within a transaction.

public boolean
supportsDataManipulationTransactionsOnly()

Implements java.sql.DatabaseMetaData.supportsDataManipulationTransactionsOnly.

Retrieves whether this database supports only data manipulation statements within a transaction.

public boolean
supportsDifferentTableCorrelationNames()

Implements java.sql.DatabaseMetaData.supportsDifferentTableCorrelationNames.

Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.

public boolean
supportsExpressionsInOrderBy()

Implements java.sql.DatabaseMetaData.supportsExpressionsInOrderBy.

Retrieves whether this database supports expressions in ORDER BY lists.

public boolean
supportsExtendedSQLGrammar()

Implements java.sql.DatabaseMetaData.supportsExtendedSQLGrammar.

Retrieves whether this database supports the ODBC Extended SQL grammar.

public boolean
supportsFullOuterJoins()

Implements java.sql.DatabaseMetaData.supportsFullOuterJoins.

Retrieves whether this database supports full nested outer joins.

public boolean
supportsGetGeneratedKeys()

Implements java.sql.DatabaseMetaData.supportsGetGeneratedKeys.

Retrieves whether auto-generated keys can be retrieved after a statement has been executed

public boolean
supportsGroupBy()

Implements java.sql.DatabaseMetaData.supportsGroupBy.

Retrieves whether this database supports some form of GROUP BY clause.

public boolean
supportsGroupByBeyondSelect()

Implements java.sql.DatabaseMetaData.supportsGroupByBeyondSelect.

Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.

public boolean
supportsGroupByUnrelated()

Implements java.sql.DatabaseMetaData.supportsGroupByUnrelated.

Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.

public boolean
supportsIntegrityEnhancementFacility()

Implements java.sql.DatabaseMetaData.supportsIntegrityEnhancementFacility.

Retrieves whether this database supports the SQL Integrity Enhancement Facility.

public boolean
supportsLikeEscapeClause()

Implements java.sql.DatabaseMetaData.supportsLikeEscapeClause.

Retrieves whether this database supports specifying a LIKE escape clause.

public boolean
supportsLimitedOuterJoins()

Implements java.sql.DatabaseMetaData.supportsLimitedOuterJoins.

Retrieves whether this database provides limited support for outer joins.

public boolean
supportsMinimumSQLGrammar()

Implements java.sql.DatabaseMetaData.supportsMinimumSQLGrammar.

Retrieves whether this database supports the ODBC Minimum SQL grammar.

public boolean
supportsMixedCaseIdentifiers()

Implements java.sql.DatabaseMetaData.supportsMixedCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

public boolean
supportsMixedCaseQuotedIdentifiers()

Implements java.sql.DatabaseMetaData.supportsMixedCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

public boolean
supportsMultipleOpenResults()

Implements java.sql.DatabaseMetaData.supportsMultipleOpenResults.

Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.

public boolean
supportsMultipleResultSets()

Implements java.sql.DatabaseMetaData.supportsMultipleResultSets.

Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.

public boolean
supportsMultipleTransactions()

Implements java.sql.DatabaseMetaData.supportsMultipleTransactions.

Retrieves whether this database allows having multiple transactions open at once (on different connections).

public boolean
supportsNamedParameters()

Implements java.sql.DatabaseMetaData.supportsNamedParameters.

Retrieves whether this database supports named parameters to callable statements.

public boolean
supportsNonNullableColumns()

Implements java.sql.DatabaseMetaData.supportsNonNullableColumns.

Retrieves whether columns in this database may be defined as non-nullable.

public boolean
supportsOpenCursorsAcrossCommit()

Implements java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit.

Retrieves whether this database supports keeping cursors open across commits.

public boolean
supportsOpenCursorsAcrossRollback()

Implements java.sql.DatabaseMetaData.supportsOpenCursorsAcrossRollback.

Retrieves whether this database supports keeping cursors open across rollbacks.

public boolean
supportsOpenStatementsAcrossCommit()

Implements java.sql.DatabaseMetaData.supportsOpenStatementsAcrossCommit.

Retrieves whether this database supports keeping statements open across commits.

public boolean
supportsOpenStatementsAcrossRollback()

Implements java.sql.DatabaseMetaData.supportsOpenStatementsAcrossRollback.

Retrieves whether this database supports keeping statements open across rollbacks.

public boolean
supportsOrderByUnrelated()

Implements java.sql.DatabaseMetaData.supportsOrderByUnrelated.

Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.

public boolean
supportsOuterJoins()

Implements java.sql.DatabaseMetaData.supportsOuterJoins.

Retrieves whether this database supports some form of outer join.

public boolean
supportsPositionedDelete()

Implements java.sql.DatabaseMetaData.supportsPositionedDelete.

Retrieves whether this database supports positioned DELETE statements.

public boolean
supportsPositionedUpdate()

Implements java.sql.DatabaseMetaData.supportsPositionedUpdate.

Retrieves whether this database supports positioned UPDATE statements.

public boolean
supportsResultSetConcurrency(int
defined in java.sql.ResultSet
type
,
int
type defined in java.sql.ResultSet
concurrency
)

Implements java.sql.DatabaseMetaData.supportsResultSetConcurrency.

Retrieves whether this database supports the given concurrency type in combination with the given result set type.

public boolean
supportsResultSetHoldability(int
one of the following constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
holdability
)

Implements java.sql.DatabaseMetaData.supportsResultSetHoldability.

Retrieves whether this database supports the given result set holdability.

public boolean
supportsResultSetType(int
defined in java.sql.ResultSet
type
)

Implements java.sql.DatabaseMetaData.supportsResultSetType.

Retrieves whether this database supports the given result set type.

public boolean
supportsSavepoints()

Implements java.sql.DatabaseMetaData.supportsSavepoints.

Retrieves whether this database supports savepoints.

public boolean
supportsSchemasInDataManipulation()

Implements java.sql.DatabaseMetaData.supportsSchemasInDataManipulation.

Retrieves whether a schema name can be used in a data manipulation statement.

public boolean
supportsSchemasInIndexDefinitions()

Implements java.sql.DatabaseMetaData.supportsSchemasInIndexDefinitions.

Retrieves whether a schema name can be used in an index definition statement.

public boolean
supportsSchemasInPrivilegeDefinitions()

Implements java.sql.DatabaseMetaData.supportsSchemasInPrivilegeDefinitions.

Retrieves whether a schema name can be used in a privilege definition statement.

public boolean
supportsSchemasInProcedureCalls()

Implements java.sql.DatabaseMetaData.supportsSchemasInProcedureCalls.

Retrieves whether a schema name can be used in a procedure call statement.

public boolean
supportsSchemasInTableDefinitions()

Implements java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions.

Retrieves whether a schema name can be used in a table definition statement.

public boolean
supportsSelectForUpdate()

Implements java.sql.DatabaseMetaData.supportsSelectForUpdate.

Retrieves whether this database supports SELECT FOR UPDATE statements.

public boolean
supportsStatementPooling()

Implements java.sql.DatabaseMetaData.supportsStatementPooling.

Retrieves whether this database supports statement pooling.

public boolean
supportsStoredFunctionsUsingCallSyntax()

Implements java.sql.DatabaseMetaData.supportsStoredFunctionsUsingCallSyntax.

Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.

public boolean
supportsStoredProcedures()

Implements java.sql.DatabaseMetaData.supportsStoredProcedures.

Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.

public boolean
supportsSubqueriesInComparisons()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInComparisons.

Retrieves whether this database supports subqueries in comparison expressions.

public boolean
supportsSubqueriesInExists()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInExists.

Retrieves whether this database supports subqueries in EXISTS expressions.

public boolean
supportsSubqueriesInIns()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInIns.

Retrieves whether this database supports subqueries in IN expressions.

public boolean
supportsSubqueriesInQuantifieds()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInQuantifieds.

Retrieves whether this database supports subqueries in quantified expressions.

public boolean
supportsTableCorrelationNames()

Implements java.sql.DatabaseMetaData.supportsTableCorrelationNames.

Retrieves whether this database supports table correlation names.

public boolean
supportsTransactionIsolationLevel(int
one of the transaction isolation levels defined in java.sql.Connection
level
)

Implements java.sql.DatabaseMetaData.supportsTransactionIsolationLevel.

Retrieves whether this database supports the given transaction isolation level.

public boolean
supportsTransactions()

Implements java.sql.DatabaseMetaData.supportsTransactions.

Retrieves whether this database supports transactions.

public boolean
supportsUnion()

Implements java.sql.DatabaseMetaData.supportsUnion.

Retrieves whether this database supports SQL UNION.

public boolean
supportsUnionAll()

Implements java.sql.DatabaseMetaData.supportsUnionAll.

Retrieves whether this database supports SQL UNION ALL.

public <T> T
unwrap(Class<T>
A Class defining an interface that the result must implement.
iface
)

Implements java.sql.Wrapper.unwrap.

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public boolean
updatesAreDetected(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.updatesAreDetected.

Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

public boolean
usesLocalFilePerTable()

Implements java.sql.DatabaseMetaData.usesLocalFilePerTable.

Retrieves whether this database uses a file for each table.

public boolean
usesLocalFiles()

Implements java.sql.DatabaseMetaData.usesLocalFiles.

Retrieves whether this database stores tables in a local file.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait