org.sourceforge.jxdbcon.postgresql
Class PGDatabaseMetaDataV71

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

All Implemented Interfaces:

DatabaseMetaData, PGConstants

Direct Known Subclasses:

PGDatabaseMetaDataV72

public class PGDatabaseMetaDataV71

extends PGDatabaseMetaDataV7

PGDatabaseMetaDataV71 returns the MetaData specific to PostgreSQL version 7.1

Version:

$Revision: 1.2 $

Author:

Keve Müller

Nested Class Summary

Nested classes inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaDataV7

Field Summary

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

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)

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

Method Summary

ResultSet

getCatalogs() Return the databases from pg_database which allow connections.

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

getCrossReference, getExportedKeys, getImportedKeys

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

Constructor Detail

PGDatabaseMetaDataV71

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

Method Detail

getCatalogs

public ResultSet getCatalogs()
                      throws SQLException

Return the databases from pg_database which allow connections.

Specified by:

getCatalogs in interface DatabaseMetaData

Overrides:

getCatalogs in class PGDatabaseMetaDataV6

Returns:

SELECT datname AS table_cat FROM pg_database WHERE datallowconn

SQLException