org.sourceforge.jxdbcon.postgresql
Class PGDatabaseMetaDataV7

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

All Implemented Interfaces:

DatabaseMetaData, PGConstants

Direct Known Subclasses:

PGDatabaseMetaDataV71

public class PGDatabaseMetaDataV7

extends PGDatabaseMetaDataV6

PGDatabaseMetaDataV7 returns the MetaData specific to PostgreSQL version 7.

Version:

$Revision: 1.12 $

Author:

Keve Müller

Nested Class Summary

private class	PGDatabaseMetaDataV7.ExportedKeysComparator
private class	PGDatabaseMetaDataV7.ImportedKeysComparator

Field Summary

private static String[][]

imports

Fields inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaData

MAX_NAME, nonSQL92Keywords, nonSQL92KeywordsArray, strictSchema, tablesInfix, tablesPostfix, tablesPrefix, tableTypes, 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

(package private)

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

Method Summary

ResultSet	getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)
private Short	getDeleteUpdatePolicy(String fname)
ResultSet	getExportedKeys(String catalog, String schema, String table)
private ResultSet	getImpExpKeys(String catalog, String schema, String impTable, String expTable)
ResultSet	getImportedKeys(String catalog, String schema, String table)

Methods inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaDataV6

getCatalogs

Methods inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaData

allProceduresAreCallable, getBestRowIdentifier, getCatalogTerm, getColumns, getConn, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDefaultTransactionIsolation, getIndexInfo, getMaxCatalogNameLength, getMaxProcedureNameLength, getNumericFunctions, getPrimaryKeys, getProcedureColumns, getProcedures, getProcedureTerm, getSchemaTerm, getSQLKeywords, getStringFunctions, getTablePrivileges, getTables, getTableTypes, getTimeDateFunctions, getTypeInfo, storesLowerCaseIdentifiers, storesUpperCaseIdentifiers, supportsAlterTableWithAddColumn, supportsBatchUpdates, supportsColumnAliasing, supportsDataDefinitionAndDataManipulationTransactions, supportsDataManipulationTransactionsOnly, supportsGroupBy, supportsLikeEscapeClause, supportsMultipleResultSets, supportsMultipleTransactions, supportsOpenCursorsAcrossCommit, supportsOpenCursorsAcrossRollback, supportsOpenStatementsAcrossCommit, supportsOpenStatementsAcrossRollback, supportsResultSetType, supportsStoredProcedures, supportsTransactionIsolationLevel, supportsTransactions, supportsUnion

Methods inherited from class org.sourceforge.jxdbcon.AbstractDatabaseMetaData

allTablesAreSelectable, dataDefinitionCausesTransactionCommit, dataDefinitionIgnoredInTransactions, deletesAreDetected, doesMaxRowSizeIncludeBlobs, getAttributes, getCatalogSeparator, getColumnPrivileges, getConnection, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExtraNameCharacters, getIdentifierQuoteString, 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

imports

private static final String[][] imports

Constructor Detail

PGDatabaseMetaDataV7

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

Method Detail

getCrossReference

public ResultSet getCrossReference(String primaryCatalog,
                                   String primarySchema,
                                   String primaryTable,
                                   String foreignCatalog,
                                   String foreignSchema,
                                   String foreignTable)
                            throws SQLException

Specified by:

getCrossReference in interface DatabaseMetaData

Overrides:

getCrossReference in class AbstractDatabaseMetaData

SQLException

getDeleteUpdatePolicy

private Short getDeleteUpdatePolicy(String fname)

getExportedKeys

public ResultSet getExportedKeys(String catalog,
                                 String schema,
                                 String table)
                          throws SQLException

Specified by:

getExportedKeys in interface DatabaseMetaData

Overrides:

getExportedKeys in class AbstractDatabaseMetaData

SQLException

getImpExpKeys

private ResultSet getImpExpKeys(String catalog,
                                String schema,
                                String impTable,
                                String expTable)
                         throws SQLException

SQLException

getImportedKeys

public ResultSet getImportedKeys(String catalog,
                                 String schema,
                                 String table)
                          throws SQLException

Specified by:

getImportedKeys in interface DatabaseMetaData

Overrides:

getImportedKeys in class AbstractDatabaseMetaData

SQLException