org.sourceforge.jxdbcon.postgresql
Class PGDatabaseMetaData

java.lang.Object
  |
  +--org.sourceforge.jxdbcon.AbstractDatabaseMetaData
        |
        +--org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaData

All Implemented Interfaces:

DatabaseMetaData, PGConstants

Direct Known Subclasses:

PGDatabaseMetaDataV6

public abstract class PGDatabaseMetaData

extends AbstractDatabaseMetaData

implements PGConstants

PGDatabaseMetaData returns the MetaData specific to PostgreSQL.

Version:

$Revision: 1.21 $

Author:

Keve Müller

Field Summary

private static String[][]	dataTableTypes The supported table types.
static int	MAX_NAME
static String	nonSQL92Keywords
static String[]	nonSQL92KeywordsArray In the last line are not real PostgreSQL keywords, but JDBC CTS is assuming that names of types are reserved keywords and in PostgreSQL they aren't.
private static ArrayList	prefTypes
protected boolean	strictSchema
(package private) static String	tablesInfix
(package private) static String[]	tablesPostfix
(package private) static String	tablesPrefix
(package private) static String[]	tableTypes
(package private) Object[]	version

Fields inherited from class org.sourceforge.jxdbcon.AbstractDatabaseMetaData

CN_ATTRIBUTES, CN_BESTROWIDENTIFIER, CN_CATALOGS, CN_COLUMNPRIVILEGES, CN_COLUMNS, CN_CROSSREFERENCE, CN_EXPORTEDKEYS, CN_IMPORTEDKEYS, CN_INDEXINFO, CN_PRIMARYKEYS, CN_PROCEDURECOLUMNS, CN_PROCEDURES, CN_SCHEMAS, CN_SUPERTABLES, CN_SUPERTYPES, CN_TABLEPRIVILEGES, CN_TABLES, CN_TABLETYPES, CN_TYPEINFO, CN_UDTS, CN_VERSIONCOLUMNS, connection, CT_ATTRIBUTES, CT_BESTROWIDENTIFIER, CT_CATALOGS, CT_COLUMNPRIVILEGES, CT_COLUMNS, CT_CROSSREFERENCE, CT_EXPORTEDKEYS, CT_IMPORTEDKEYS, CT_INDEXINFO, CT_PRIMARYKEYS, CT_PROCEDURECOLUMNS, CT_PROCEDURES, CT_SCHEMAS, CT_SUPERTABLES, CT_SUPERTYPES, CT_TABLEPRIVILEGES, CT_TABLES, CT_TABLETYPES, CT_TYPEINFO, CT_UDTS, CT_VERSIONCOLUMNS, NUMERICFUNCTIONS, STRINGFUNCTIONS, SYSTEMFUNCTIONS, TIMEDATEFUNCTIONS, url

Fields inherited from interface org.sourceforge.jxdbcon.postgresql.PGConstants

AUTH_REQ_CRYPT, AUTH_REQ_KRB4, AUTH_REQ_KRB5, AUTH_REQ_MD5, AUTH_REQ_OK, AUTH_REQ_PASSWORD, AUTH_REQ_SCM, NUMERIC_DSCALE_MASK, NUMERIC_NAN, NUMERIC_NEG, NUMERIC_POS, NUMERIC_SIGN_MASK, PG_VERSION_STR, PG_VERSION_STR1, TRIGGER_TYPE_BEFORE, TRIGGER_TYPE_DELETE, TRIGGER_TYPE_INSERT, TRIGGER_TYPE_ROW, TRIGGER_TYPE_UPDATE

Fields inherited from interface java.sql.DatabaseMetaData

attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

Constructor Summary

protected

PGDatabaseMetaData(String url, AbstractConnection connection, Object[] version)

Method Summary

boolean	allProceduresAreCallable() No acls on procedures.
ResultSet	getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) Return oid as the best column to identify rows.
abstract ResultSet	getCatalogs()
String	getCatalogTerm() Catalogs are both called 'database' and 'catalog' internally.
ResultSet	getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
(package private) PGConnection	getConn(String catalog) Return a connection to the given catalog.
int	getDatabaseMajorVersion()
int	getDatabaseMinorVersion()
String	getDatabaseProductName()
String	getDatabaseProductVersion()
int	getDefaultTransactionIsolation() Default and currently only is READ_COMMITTED.
ResultSet	getIndexInfo(String catalog, String schemaPattern, String table, boolean unique, boolean approximate)
int	getMaxCatalogNameLength() A catalog is a system identifier, return 31.
int	getMaxProcedureNameLength() Return MAX_NAME.
String	getNumericFunctions()
ResultSet	getPrimaryKeys(String catalog, String schemaPattern, String table) Get the primary keys of _a_ table.
ResultSet	getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
ResultSet	getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
String	getProcedureTerm() Under PostgreSQL everything is a function.
String	getSchemaTerm() PostgreSQL does not support schemas.
String	getSQLKeywords()
String	getStringFunctions()
ResultSet	getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
ResultSet	getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) Return the tables matching the passed criteria.
ResultSet	getTableTypes() Return SEQUENCE, SYSTEM SEQUENCS, SYSTEM TABLE, TABLE and VIEW.
String	getTimeDateFunctions()
ResultSet	getTypeInfo()
boolean	storesLowerCaseIdentifiers()
boolean	storesUpperCaseIdentifiers()
boolean	supportsAlterTableWithAddColumn() PostgreSQL supports ALTER TABLE table ADD COLUMN.
boolean	supportsBatchUpdates() The driver supports batch updates.
boolean	supportsColumnAliasing()
boolean	supportsDataDefinitionAndDataManipulationTransactions()
boolean	supportsDataManipulationTransactionsOnly()
boolean	supportsGroupBy()
boolean	supportsLikeEscapeClause() ...
boolean	supportsMultipleResultSets() MultipleResultSets.
boolean	supportsMultipleTransactions() Multiple transactions on different connections are supported.
boolean	supportsOpenCursorsAcrossCommit()
boolean	supportsOpenCursorsAcrossRollback()
boolean	supportsOpenStatementsAcrossCommit()
boolean	supportsOpenStatementsAcrossRollback()
boolean	supportsResultSetType(int type) Support scrollable ResultSets.
boolean	supportsStoredProcedures() There are procedures/functions in PostgreSQL.
boolean	supportsTransactionIsolationLevel(int level) Currently only READ_COMMITTED is supported.
boolean	supportsTransactions() Transactions are supported.
boolean	supportsUnion()

Methods inherited from class org.sourceforge.jxdbcon.AbstractDatabaseMetaData

allTablesAreSelectable, dataDefinitionCausesTransactionCommit, dataDefinitionIgnoredInTransactions, deletesAreDetected, doesMaxRowSizeIncludeBlobs, getAttributes, getCatalogSeparator, getColumnPrivileges, getConnection, getCrossReference, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExportedKeys, getExtraNameCharacters, getIdentifierQuoteString, getImportedKeys, getJDBCMajorVersion, getJDBCMinorVersion, getMaxBinaryLiteralLength, getMaxCharLiteralLength, getMaxColumnNameLength, getMaxColumnsInGroupBy, getMaxColumnsInIndex, getMaxColumnsInOrderBy, getMaxColumnsInSelect, getMaxColumnsInTable, getMaxConnections, getMaxCursorNameLength, getMaxIndexLength, getMaxRowSize, getMaxSchemaNameLength, getMaxStatementLength, getMaxStatements, getMaxTableNameLength, getMaxTablesInSelect, getMaxUserNameLength, getResultSetHoldability, getResultSetHoldability, getSchemas, getSearchStringEscape, getSQLStateType, getSuperTables, getSuperTypes, getSystemFunctions, getUDTs, getURL, getUserName, getVersionColumns, insertsAreDetected, isCatalogAtStart, isReadOnly, locatorsUpdateCopy, nullPlusNonNullIsNull, nullsAreSortedAtEnd, nullsAreSortedAtStart, nullsAreSortedHigh, nullsAreSortedLow, othersDeletesAreVisible, othersInsertsAreVisible, othersUpdatesAreVisible, ownDeletesAreVisible, ownInsertsAreVisible, ownUpdatesAreVisible, storesLowerCaseQuotedIdentifiers, storesMixedCaseIdentifiers, storesMixedCaseQuotedIdentifiers, storesUpperCaseQuotedIdentifiers, supportsAlterTableWithDropColumn, supportsANSI92EntryLevelSQL, supportsANSI92FullSQL, supportsANSI92IntermediateSQL, supportsCatalogsInDataManipulation, supportsCatalogsInIndexDefinitions, supportsCatalogsInPrivilegeDefinitions, supportsCatalogsInProcedureCalls, supportsCatalogsInTableDefinitions, supportsConvert, supportsConvert, supportsCoreSQLGrammar, supportsCorrelatedSubqueries, supportsDifferentTableCorrelationNames, supportsExpressionsInOrderBy, supportsExtendedSQLGrammar, supportsFullOuterJoins, supportsGetGeneratedKeys, supportsGroupByBeyondSelect, supportsGroupByUnrelated, supportsIntegrityEnhancementFacility, supportsLimitedOuterJoins, supportsMinimumSQLGrammar, supportsMixedCaseIdentifiers, supportsMixedCaseQuotedIdentifiers, supportsMultipleOpenResults, supportsNamedParameters, supportsNonNullableColumns, supportsOrderByUnrelated, supportsOuterJoins, supportsPositionedDelete, supportsPositionedUpdate, supportsResultSetConcurrency, supportsResultSetHoldability, supportsSavepoints, supportsSchemasInDataManipulation, supportsSchemasInIndexDefinitions, supportsSchemasInPrivilegeDefinitions, supportsSchemasInProcedureCalls, supportsSchemasInTableDefinitions, supportsSelectForUpdate, supportsStatementPooling, supportsSubqueriesInComparisons, supportsSubqueriesInExists, supportsSubqueriesInIns, supportsSubqueriesInQuantifieds, supportsTableCorrelationNames, supportsUnionAll, toString, updatesAreDetected, usesLocalFilePerTable, usesLocalFiles

Methods inherited from class java.lang.Object

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

Field Detail

dataTableTypes

private static final String[][] dataTableTypes

The supported table types.

MAX_NAME

public static final int MAX_NAME

See Also:

Constant Field Values

nonSQL92Keywords

public static final String nonSQL92Keywords

nonSQL92KeywordsArray

public static final String[] nonSQL92KeywordsArray

In the last line are not real PostgreSQL keywords, but JDBC CTS is assuming that names of types are reserved keywords and in PostgreSQL they aren't. These must be kept sorted!

prefTypes

private static final ArrayList prefTypes

strictSchema

protected boolean strictSchema

tablesInfix

static final String tablesInfix

See Also:

Constant Field Values

tablesPostfix

static final String[] tablesPostfix

tablesPrefix

static final String tablesPrefix

See Also:

Constant Field Values

tableTypes

static final String[] tableTypes

version

final Object[] version

Constructor Detail

PGDatabaseMetaData

protected PGDatabaseMetaData(String url,
                             AbstractConnection connection,
                             Object[] version)

Method Detail

allProceduresAreCallable

public boolean allProceduresAreCallable()
                                 throws SQLException

No acls on procedures.

Specified by:

allProceduresAreCallable in interface DatabaseMetaData

Overrides:

allProceduresAreCallable in class AbstractDatabaseMetaData

Returns:

true

SQLException

getBestRowIdentifier

public ResultSet getBestRowIdentifier(String catalog,
                                      String schema,
                                      String table,
                                      int scope,
                                      boolean nullable)
                               throws SQLException

Return oid as the best column to identify rows. TODO:

• Views have no oid column!
• Check this code against recent versions of PG where not all tables have an oid column.

Specified by:

getBestRowIdentifier in interface DatabaseMetaData

Overrides:

getBestRowIdentifier in class AbstractDatabaseMetaData

SQLException

getCatalogs

public abstract ResultSet getCatalogs()
                               throws SQLException

Specified by:

getCatalogs in interface DatabaseMetaData

Overrides:

getCatalogs in class AbstractDatabaseMetaData

SQLException

getCatalogTerm

public String getCatalogTerm()

Catalogs are both called 'database' and 'catalog' internally.

Specified by:

getCatalogTerm in interface DatabaseMetaData

Overrides:

getCatalogTerm in class AbstractDatabaseMetaData

Returns:

"Database"

getColumns

public ResultSet getColumns(String catalog,
                            String schemaPattern,
                            String tableNamePattern,
                            String columnNamePattern)
                     throws SQLException

Specified by:

getColumns in interface DatabaseMetaData

Overrides:

getColumns in class AbstractDatabaseMetaData

SQLException

getConn

PGConnection getConn(String catalog)
               throws SQLException

Return a connection to the given catalog. If the current connection is to the given catalog, return it, otherwise clone it and connect to the other catalog.

SQLException

getDatabaseMajorVersion

public final int getDatabaseMajorVersion()

Specified by:

getDatabaseMajorVersion in interface DatabaseMetaData

getDatabaseMinorVersion

public final int getDatabaseMinorVersion()

Specified by:

getDatabaseMinorVersion in interface DatabaseMetaData

getDatabaseProductName

public final String getDatabaseProductName()

Specified by:

getDatabaseProductName in interface DatabaseMetaData

getDatabaseProductVersion

public final String getDatabaseProductVersion()

Specified by:

getDatabaseProductVersion in interface DatabaseMetaData

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()
                                   throws SQLException

Default and currently only is READ_COMMITTED.

Specified by:

getDefaultTransactionIsolation in interface DatabaseMetaData

Overrides:

getDefaultTransactionIsolation in class AbstractDatabaseMetaData

Returns:

Connection.TRANSACTION_READ_COMMITTED

SQLException

getIndexInfo

public ResultSet getIndexInfo(String catalog,
                              String schemaPattern,
                              String table,
                              boolean unique,
                              boolean approximate)
                       throws SQLException

Specified by:

getIndexInfo in interface DatabaseMetaData

Overrides:

getIndexInfo in class AbstractDatabaseMetaData

SQLException

getMaxCatalogNameLength

public int getMaxCatalogNameLength()

A catalog is a system identifier, return 31.

Specified by:

getMaxCatalogNameLength in interface DatabaseMetaData

Overrides:

getMaxCatalogNameLength in class AbstractDatabaseMetaData

Returns:

31, the length of a PostgreSQL name type

getMaxProcedureNameLength

public int getMaxProcedureNameLength()
                              throws SQLException

Return MAX_NAME.

Specified by:

getMaxProcedureNameLength in interface DatabaseMetaData

Overrides:

getMaxProcedureNameLength in class AbstractDatabaseMetaData

Returns:

MAX_NAME.

SQLException

getNumericFunctions

public String getNumericFunctions()

Specified by:

getNumericFunctions in interface DatabaseMetaData

Overrides:

getNumericFunctions in class AbstractDatabaseMetaData

getPrimaryKeys

public ResultSet getPrimaryKeys(String catalog,
                                String schemaPattern,
                                String table)
                         throws SQLException

Description copied from class: AbstractDatabaseMetaData

Get the primary keys of _a_ table.

Specified by:

getPrimaryKeys in interface DatabaseMetaData

Overrides:

getPrimaryKeys in class AbstractDatabaseMetaData

SQLException

getProcedureColumns

public ResultSet getProcedureColumns(String catalog,
                                     String schemaPattern,
                                     String procedureNamePattern,
                                     String columnNamePattern)
                              throws SQLException

Specified by:

getProcedureColumns in interface DatabaseMetaData

Overrides:

getProcedureColumns in class AbstractDatabaseMetaData

SQLException

getProcedures

public ResultSet getProcedures(String catalog,
                               String schemaPattern,
                               String procedureNamePattern)
                        throws SQLException

Specified by:

getProcedures in interface DatabaseMetaData

Overrides:

getProcedures in class AbstractDatabaseMetaData

SQLException

getProcedureTerm

public String getProcedureTerm()
                        throws SQLException

Under PostgreSQL everything is a function.

Specified by:

getProcedureTerm in interface DatabaseMetaData

Overrides:

getProcedureTerm in class AbstractDatabaseMetaData

Returns:

"Function"

SQLException

getSchemaTerm

public String getSchemaTerm()

PostgreSQL does not support schemas.

Specified by:

getSchemaTerm in interface DatabaseMetaData

Overrides:

getSchemaTerm in class AbstractDatabaseMetaData

Returns:

""

getSQLKeywords

public String getSQLKeywords()

Specified by:

getSQLKeywords in interface DatabaseMetaData

Overrides:

getSQLKeywords in class AbstractDatabaseMetaData

getStringFunctions

public String getStringFunctions()

Specified by:

getStringFunctions in interface DatabaseMetaData

Overrides:

getStringFunctions in class AbstractDatabaseMetaData

getTablePrivileges

public ResultSet getTablePrivileges(String catalog,
                                    String schemaPattern,
                                    String tableNamePattern)
                             throws SQLException

Specified by:

getTablePrivileges in interface DatabaseMetaData

Overrides:

getTablePrivileges in class AbstractDatabaseMetaData

SQLException

getTables

public ResultSet getTables(String catalog,
                           String schemaPattern,
                           String tableNamePattern,
                           String[] types)
                    throws SQLException

Return the tables matching the passed criteria. If a different catalog than the current is queried, then the query is done in a new cloned Connection. If schemaPattern is given and is not %, then the resultset is empty. If types is null, all types are queried. Additionally to the required colums the tables' oid is returned in the 6th column.

Specified by:

getTables in interface DatabaseMetaData

Overrides:

getTables in class AbstractDatabaseMetaData

SQLException

getTableTypes

public ResultSet getTableTypes()
                        throws SQLException

Return SEQUENCE, SYSTEM SEQUENCS, SYSTEM TABLE, TABLE and VIEW.

Specified by:

getTableTypes in interface DatabaseMetaData

Overrides:

getTableTypes in class AbstractDatabaseMetaData

SQLException

getTimeDateFunctions

public String getTimeDateFunctions()

Specified by:

getTimeDateFunctions in interface DatabaseMetaData

Overrides:

getTimeDateFunctions in class AbstractDatabaseMetaData

getTypeInfo

public ResultSet getTypeInfo()
                      throws SQLException

Specified by:

getTypeInfo in interface DatabaseMetaData

Overrides:

getTypeInfo in class AbstractDatabaseMetaData

SQLException

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()

Specified by:

storesLowerCaseIdentifiers in interface DatabaseMetaData

Overrides:

storesLowerCaseIdentifiers in class AbstractDatabaseMetaData

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()

Specified by:

storesUpperCaseIdentifiers in interface DatabaseMetaData

Overrides:

storesUpperCaseIdentifiers in class AbstractDatabaseMetaData

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()

PostgreSQL supports ALTER TABLE table ADD COLUMN.

Specified by:

supportsAlterTableWithAddColumn in interface DatabaseMetaData

Overrides:

supportsAlterTableWithAddColumn in class AbstractDatabaseMetaData

Returns:

true

supportsBatchUpdates

public boolean supportsBatchUpdates()
                             throws SQLException

The driver supports batch updates.

Specified by:

supportsBatchUpdates in interface DatabaseMetaData

Overrides:

supportsBatchUpdates in class AbstractDatabaseMetaData

SQLException

supportsColumnAliasing

public boolean supportsColumnAliasing()

Specified by:

supportsColumnAliasing in interface DatabaseMetaData

Overrides:

supportsColumnAliasing in class AbstractDatabaseMetaData

Returns:

true

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()

Specified by:

supportsDataDefinitionAndDataManipulationTransactions in interface DatabaseMetaData

Overrides:

supportsDataDefinitionAndDataManipulationTransactions in class AbstractDatabaseMetaData

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()

Specified by:

supportsDataManipulationTransactionsOnly in interface DatabaseMetaData

Overrides:

supportsDataManipulationTransactionsOnly in class AbstractDatabaseMetaData

supportsGroupBy

public boolean supportsGroupBy()

Specified by:

supportsGroupBy in interface DatabaseMetaData

Overrides:

supportsGroupBy in class AbstractDatabaseMetaData

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()

...

Specified by:

supportsLikeEscapeClause in interface DatabaseMetaData

Overrides:

supportsLikeEscapeClause in class AbstractDatabaseMetaData

supportsMultipleResultSets

public boolean supportsMultipleResultSets()

MultipleResultSets. Supported by both (lib / net) protocols.

Specified by:

supportsMultipleResultSets in interface DatabaseMetaData

Overrides:

supportsMultipleResultSets in class AbstractDatabaseMetaData

supportsMultipleTransactions

public boolean supportsMultipleTransactions()

Multiple transactions on different connections are supported.

Specified by:

supportsMultipleTransactions in interface DatabaseMetaData

Overrides:

supportsMultipleTransactions in class AbstractDatabaseMetaData

Returns:

true

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()
                                        throws SQLException

Specified by:

supportsOpenCursorsAcrossCommit in interface DatabaseMetaData

Overrides:

supportsOpenCursorsAcrossCommit in class AbstractDatabaseMetaData

SQLException

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()
                                          throws SQLException

Specified by:

supportsOpenCursorsAcrossRollback in interface DatabaseMetaData

Overrides:

supportsOpenCursorsAcrossRollback in class AbstractDatabaseMetaData

SQLException

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()
                                           throws SQLException

Specified by:

supportsOpenStatementsAcrossCommit in interface DatabaseMetaData

Overrides:

supportsOpenStatementsAcrossCommit in class AbstractDatabaseMetaData

SQLException

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()
                                             throws SQLException

Specified by:

supportsOpenStatementsAcrossRollback in interface DatabaseMetaData

Overrides:

supportsOpenStatementsAcrossRollback in class AbstractDatabaseMetaData

SQLException

supportsResultSetType

public boolean supportsResultSetType(int type)
                              throws SQLException

Support scrollable ResultSets.

Specified by:

supportsResultSetType in interface DatabaseMetaData

Overrides:

supportsResultSetType in class AbstractDatabaseMetaData

SQLException

supportsStoredProcedures

public boolean supportsStoredProcedures()
                                 throws SQLException

There are procedures/functions in PostgreSQL.

Specified by:

supportsStoredProcedures in interface DatabaseMetaData

Overrides:

supportsStoredProcedures in class AbstractDatabaseMetaData

Returns:

true

SQLException

supportsTransactionIsolationLevel

public boolean supportsTransactionIsolationLevel(int level)
                                          throws SQLException

Currently only READ_COMMITTED is supported.

Specified by:

supportsTransactionIsolationLevel in interface DatabaseMetaData

Overrides:

supportsTransactionIsolationLevel in class AbstractDatabaseMetaData

SQLException

supportsTransactions

public boolean supportsTransactions()

Transactions are supported.

Specified by:

supportsTransactions in interface DatabaseMetaData

Overrides:

supportsTransactions in class AbstractDatabaseMetaData

Returns:

true

supportsUnion

public boolean supportsUnion()

Specified by:

supportsUnion in interface DatabaseMetaData

Overrides:

supportsUnion in class AbstractDatabaseMetaData