Overview  Package   Class  Tree  Index  Help 
jxDBCon 0.9z
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.sourceforge.jxdbcon
Class AbstractDatabaseMetaData

java.lang.Object
  |
  +--org.sourceforge.jxdbcon.AbstractDatabaseMetaData
All Implemented Interfaces:
DatabaseMetaData
Direct Known Subclasses:
PGDatabaseMetaData
public abstract class AbstractDatabaseMetaData
extends Object
implements DatabaseMetaData

AbstractDatabaseMetaData implements generics of the DatabaseMetaData interface.
When extending you must define:

Version:
$Revision: 1.8 $, $Date: 2002/03/16 01:26:07 $
Author:
Keve Müller

Field Summary
static String[] CN_ATTRIBUTES
           
static String[] CN_BESTROWIDENTIFIER
           
static String[] CN_CATALOGS
           
static String[] CN_COLUMNPRIVILEGES
           
static String[] CN_COLUMNS
           
static String[] CN_CROSSREFERENCE
           
static String[] CN_EXPORTEDKEYS
           
static String[] CN_IMPORTEDKEYS
           
static String[] CN_INDEXINFO
           
static String[] CN_PRIMARYKEYS
           
static String[] CN_PROCEDURECOLUMNS
           
static String[] CN_PROCEDURES
           
static String[] CN_SCHEMAS
           
static String[] CN_SUPERTABLES
           
static String[] CN_SUPERTYPES
           
static String[] CN_TABLEPRIVILEGES
           
static String[] CN_TABLES
           
static String[] CN_TABLETYPES
           
static String[] CN_TYPEINFO
           
static String[] CN_UDTS
           
static String[] CN_VERSIONCOLUMNS
           
protected  AbstractConnection connection
           
static AbstractType[] CT_ATTRIBUTES
           
static AbstractType[] CT_BESTROWIDENTIFIER
           
static AbstractType[] CT_CATALOGS
           
static AbstractType[] CT_COLUMNPRIVILEGES
           
static AbstractType[] CT_COLUMNS
           
static AbstractType[] CT_CROSSREFERENCE
           
static AbstractType[] CT_EXPORTEDKEYS
           
static AbstractType[] CT_IMPORTEDKEYS
           
static AbstractType[] CT_INDEXINFO
           
static AbstractType[] CT_PRIMARYKEYS
           
static AbstractType[] CT_PROCEDURECOLUMNS
           
static AbstractType[] CT_PROCEDURES
           
static AbstractType[] CT_SCHEMAS
           
static AbstractType[] CT_SUPERTABLES
           
static AbstractType[] CT_SUPERTYPES
           
static AbstractType[] CT_TABLEPRIVILEGES
           
static AbstractType[] CT_TABLES
           
static AbstractType[] CT_TABLETYPES
           
static AbstractType[] CT_TYPEINFO
           
static AbstractType[] CT_UDTS
           
static AbstractType[] CT_VERSIONCOLUMNS
           
static String[] NUMERICFUNCTIONS
           
static String[] STRINGFUNCTIONS
           
static String[] SYSTEMFUNCTIONS
           
static String[] TIMEDATEFUNCTIONS
           
protected  String url
           
 
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 AbstractDatabaseMetaData(String url, AbstractConnection connection)
           
 
Method Summary
 boolean allProceduresAreCallable()
           
 boolean allTablesAreSelectable()
           
 boolean dataDefinitionCausesTransactionCommit()
           
 boolean dataDefinitionIgnoredInTransactions()
           
 boolean deletesAreDetected(int type)
           
 boolean doesMaxRowSizeIncludeBlobs()
           
 ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
           
 ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)
           
 ResultSet getCatalogs()
           
 String getCatalogSeparator()
           
 String getCatalogTerm()
           
 ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
           
 ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
           
 Connection getConnection()
           
 ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)
           
 int getDefaultTransactionIsolation()
           
 int getDriverMajorVersion()
          Get the driver major version.
 int getDriverMinorVersion()
          Get the driver minor version.
 String getDriverName()
          Get the driver name.
 String getDriverVersion()
          Get the driver version.
 ResultSet getExportedKeys(String catalog, String schema, String table)
           
 String getExtraNameCharacters()
           
 String getIdentifierQuoteString()
           
 ResultSet getImportedKeys(String catalog, String schema, String table)
           
 ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)
           
 int getJDBCMajorVersion()
          Get the JDBC major version.
 int getJDBCMinorVersion()
          Get the JDBC minor version.
 int getMaxBinaryLiteralLength()
           
 int getMaxCatalogNameLength()
           
 int getMaxCharLiteralLength()
           
 int getMaxColumnNameLength()
           
 int getMaxColumnsInGroupBy()
           
 int getMaxColumnsInIndex()
           
 int getMaxColumnsInOrderBy()
           
 int getMaxColumnsInSelect()
           
 int getMaxColumnsInTable()
           
 int getMaxConnections()
           
 int getMaxCursorNameLength()
           
 int getMaxIndexLength()
           
 int getMaxProcedureNameLength()
           
 int getMaxRowSize()
           
 int getMaxSchemaNameLength()
           
 int getMaxStatementLength()
           
 int getMaxStatements()
           
 int getMaxTableNameLength()
           
 int getMaxTablesInSelect()
           
 int getMaxUserNameLength()
           
 String getNumericFunctions()
           
 ResultSet getPrimaryKeys(String catalog, String schema, 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()
           
 int getResultSetHoldability()
           
 int getResultSetHoldability(int holdability)
           
 ResultSet getSchemas()
           
 String getSchemaTerm()
           
 String getSearchStringEscape()
           
 String getSQLKeywords()
           
 int getSQLStateType()
           
 String getStringFunctions()
           
 ResultSet getSuperTables(String catalog, String schemaPattern, String typeNamePattern)
           
 ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
           
 String getSystemFunctions()
           
 ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
           
 ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
           
 ResultSet getTableTypes()
           
 String getTimeDateFunctions()
           
 ResultSet getTypeInfo()
           
 ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
           
 String getURL()
           
 String getUserName()
           
 ResultSet getVersionColumns(String catalog, String schema, String table)
           
 boolean insertsAreDetected(int type)
           
 boolean isCatalogAtStart()
           
 boolean isReadOnly()
           
 boolean locatorsUpdateCopy()
          Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
 boolean nullPlusNonNullIsNull()
           
 boolean nullsAreSortedAtEnd()
           
 boolean nullsAreSortedAtStart()
           
 boolean nullsAreSortedHigh()
           
 boolean nullsAreSortedLow()
           
 boolean othersDeletesAreVisible(int type)
           
 boolean othersInsertsAreVisible(int type)
           
 boolean othersUpdatesAreVisible(int type)
           
 boolean ownDeletesAreVisible(int type)
           
 boolean ownInsertsAreVisible(int type)
           
 boolean ownUpdatesAreVisible(int type)
           
 boolean storesLowerCaseIdentifiers()
           
 boolean storesLowerCaseQuotedIdentifiers()
           
 boolean storesMixedCaseIdentifiers()
           
 boolean storesMixedCaseQuotedIdentifiers()
           
 boolean storesUpperCaseIdentifiers()
           
 boolean storesUpperCaseQuotedIdentifiers()
           
 boolean supportsAlterTableWithAddColumn()
           
 boolean supportsAlterTableWithDropColumn()
           
 boolean supportsANSI92EntryLevelSQL()
          ANSI SQL 92 is not supported by default.
 boolean supportsANSI92FullSQL()
          ANSI SQL 92 Full is not supported by default.
 boolean supportsANSI92IntermediateSQL()
          ANSI SQL 92 Intermediate is not supported by default.
 boolean supportsBatchUpdates()
           
 boolean supportsCatalogsInDataManipulation()
           
 boolean supportsCatalogsInIndexDefinitions()
           
 boolean supportsCatalogsInPrivilegeDefinitions()
           
 boolean supportsCatalogsInProcedureCalls()
           
 boolean supportsCatalogsInTableDefinitions()
           
 boolean supportsColumnAliasing()
           
 boolean supportsConvert()
           
 boolean supportsConvert(int fromType, int toType)
           
 boolean supportsCoreSQLGrammar()
          Core SQL is not supported by default.
 boolean supportsCorrelatedSubqueries()
           
 boolean supportsDataDefinitionAndDataManipulationTransactions()
           
 boolean supportsDataManipulationTransactionsOnly()
           
 boolean supportsDifferentTableCorrelationNames()
           
 boolean supportsExpressionsInOrderBy()
           
 boolean supportsExtendedSQLGrammar()
          Extended SQL is not supported by default.
 boolean supportsFullOuterJoins()
           
 boolean supportsGetGeneratedKeys()
           
 boolean supportsGroupBy()
           
 boolean supportsGroupByBeyondSelect()
           
 boolean supportsGroupByUnrelated()
           
 boolean supportsIntegrityEnhancementFacility()
           
 boolean supportsLikeEscapeClause()
           
 boolean supportsLimitedOuterJoins()
           
 boolean supportsMinimumSQLGrammar()
          Some SQL is surely supported.
 boolean supportsMixedCaseIdentifiers()
           
 boolean supportsMixedCaseQuotedIdentifiers()
           
 boolean supportsMultipleOpenResults()
           
 boolean supportsMultipleResultSets()
           
 boolean supportsMultipleTransactions()
           
 boolean supportsNamedParameters()
           
 boolean supportsNonNullableColumns()
           
 boolean supportsOpenCursorsAcrossCommit()
           
 boolean supportsOpenCursorsAcrossRollback()
           
 boolean supportsOpenStatementsAcrossCommit()
           
 boolean supportsOpenStatementsAcrossRollback()
           
 boolean supportsOrderByUnrelated()
           
 boolean supportsOuterJoins()
           
 boolean supportsPositionedDelete()
           
 boolean supportsPositionedUpdate()
           
 boolean supportsResultSetConcurrency(int type, int concurrency)
           
 boolean supportsResultSetHoldability(int holdability)
           
 boolean supportsResultSetType(int type)
           
 boolean supportsSavepoints()
           
 boolean supportsSchemasInDataManipulation()
           
 boolean supportsSchemasInIndexDefinitions()
           
 boolean supportsSchemasInPrivilegeDefinitions()
           
 boolean supportsSchemasInProcedureCalls()
           
 boolean supportsSchemasInTableDefinitions()
           
 boolean supportsSelectForUpdate()
           
 boolean supportsStatementPooling()
           
 boolean supportsStoredProcedures()
           
 boolean supportsSubqueriesInComparisons()
           
 boolean supportsSubqueriesInExists()
           
 boolean supportsSubqueriesInIns()
           
 boolean supportsSubqueriesInQuantifieds()
           
 boolean supportsTableCorrelationNames()
           
 boolean supportsTransactionIsolationLevel(int level)
           
 boolean supportsTransactions()
           
 boolean supportsUnion()
           
 boolean supportsUnionAll()
           
 String toString()
          Dump everything into a String (costy operation).
 boolean updatesAreDetected(int type)
           
 boolean usesLocalFilePerTable()
           
 boolean usesLocalFiles()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface java.sql.DatabaseMetaData
getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion
 

Field Detail

CN_ATTRIBUTES

public static final String[] CN_ATTRIBUTES

CN_BESTROWIDENTIFIER

public static final String[] CN_BESTROWIDENTIFIER

CN_CATALOGS

public static final String[] CN_CATALOGS

CN_COLUMNPRIVILEGES

public static final String[] CN_COLUMNPRIVILEGES

CN_COLUMNS

public static final String[] CN_COLUMNS

CN_CROSSREFERENCE

public static final String[] CN_CROSSREFERENCE

CN_EXPORTEDKEYS

public static final String[] CN_EXPORTEDKEYS

CN_IMPORTEDKEYS

public static final String[] CN_IMPORTEDKEYS

CN_INDEXINFO

public static final String[] CN_INDEXINFO

CN_PRIMARYKEYS

public static final String[] CN_PRIMARYKEYS

CN_PROCEDURECOLUMNS

public static final String[] CN_PROCEDURECOLUMNS

CN_PROCEDURES

public static final String[] CN_PROCEDURES

CN_SCHEMAS

public static final String[] CN_SCHEMAS

CN_SUPERTABLES

public static final String[] CN_SUPERTABLES

CN_SUPERTYPES

public static final String[] CN_SUPERTYPES

CN_TABLEPRIVILEGES

public static final String[] CN_TABLEPRIVILEGES

CN_TABLES

public static final String[] CN_TABLES

CN_TABLETYPES

public static final String[] CN_TABLETYPES

CN_TYPEINFO

public static final String[] CN_TYPEINFO

CN_UDTS

public static final String[] CN_UDTS

CN_VERSIONCOLUMNS

public static final String[] CN_VERSIONCOLUMNS

connection

protected AbstractConnection connection

CT_ATTRIBUTES

public static final AbstractType[] CT_ATTRIBUTES

CT_BESTROWIDENTIFIER

public static final AbstractType[] CT_BESTROWIDENTIFIER

CT_CATALOGS

public static final AbstractType[] CT_CATALOGS

CT_COLUMNPRIVILEGES

public static final AbstractType[] CT_COLUMNPRIVILEGES

CT_COLUMNS

public static final AbstractType[] CT_COLUMNS

CT_CROSSREFERENCE

public static final AbstractType[] CT_CROSSREFERENCE

CT_EXPORTEDKEYS

public static final AbstractType[] CT_EXPORTEDKEYS

CT_IMPORTEDKEYS

public static final AbstractType[] CT_IMPORTEDKEYS

CT_INDEXINFO

public static final AbstractType[] CT_INDEXINFO

CT_PRIMARYKEYS

public static final AbstractType[] CT_PRIMARYKEYS

CT_PROCEDURECOLUMNS

public static final AbstractType[] CT_PROCEDURECOLUMNS

CT_PROCEDURES

public static final AbstractType[] CT_PROCEDURES

CT_SCHEMAS

public static final AbstractType[] CT_SCHEMAS

CT_SUPERTABLES

public static final AbstractType[] CT_SUPERTABLES

CT_SUPERTYPES

public static final AbstractType[] CT_SUPERTYPES

CT_TABLEPRIVILEGES

public static final AbstractType[] CT_TABLEPRIVILEGES

CT_TABLES

public static final AbstractType[] CT_TABLES

CT_TABLETYPES

public static final AbstractType[] CT_TABLETYPES

CT_TYPEINFO

public static final AbstractType[] CT_TYPEINFO

CT_UDTS

public static final AbstractType[] CT_UDTS

CT_VERSIONCOLUMNS

public static final AbstractType[] CT_VERSIONCOLUMNS

NUMERICFUNCTIONS

public static final String[] NUMERICFUNCTIONS

STRINGFUNCTIONS

public static final String[] STRINGFUNCTIONS

SYSTEMFUNCTIONS

public static final String[] SYSTEMFUNCTIONS

TIMEDATEFUNCTIONS

public static final String[] TIMEDATEFUNCTIONS

url

protected String url
Constructor Detail

AbstractDatabaseMetaData

protected AbstractDatabaseMetaData(String url,
                                   AbstractConnection connection)
Method Detail

allProceduresAreCallable

public boolean allProceduresAreCallable()
                                 throws SQLException
Specified by:
allProceduresAreCallable in interface DatabaseMetaData
SQLException

allTablesAreSelectable

public boolean allTablesAreSelectable()
                               throws SQLException
Specified by:
allTablesAreSelectable in interface DatabaseMetaData
Returns:
false
SQLException

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()
Specified by:
dataDefinitionCausesTransactionCommit in interface DatabaseMetaData

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()
                                            throws SQLException
Specified by:
dataDefinitionIgnoredInTransactions in interface DatabaseMetaData
SQLException

deletesAreDetected

public boolean deletesAreDetected(int type)
                           throws SQLException
Specified by:
deletesAreDetected in interface DatabaseMetaData
SQLException

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()
                                   throws SQLException
Specified by:
doesMaxRowSizeIncludeBlobs in interface DatabaseMetaData
SQLException

getAttributes

public ResultSet getAttributes(String catalog,
                               String schemaPattern,
                               String typeNamePattern,
                               String attributeNamePattern)
                        throws SQLException
Specified by:
getAttributes in interface DatabaseMetaData
SQLException

getBestRowIdentifier

public ResultSet getBestRowIdentifier(String catalog,
                                      String schema,
                                      String table,
                                      int scope,
                                      boolean nullable)
                               throws SQLException
Specified by:
getBestRowIdentifier in interface DatabaseMetaData
SQLException

getCatalogs

public ResultSet getCatalogs()
                      throws SQLException
Specified by:
getCatalogs in interface DatabaseMetaData
SQLException

getCatalogSeparator

public String getCatalogSeparator()
                           throws SQLException
Specified by:
getCatalogSeparator in interface DatabaseMetaData
SQLException

getCatalogTerm

public String getCatalogTerm()
                      throws SQLException
Specified by:
getCatalogTerm in interface DatabaseMetaData
SQLException

getColumnPrivileges

public ResultSet getColumnPrivileges(String catalog,
                                     String schema,
                                     String table,
                                     String columnNamePattern)
                              throws SQLException
Specified by:
getColumnPrivileges in interface DatabaseMetaData
SQLException

getColumns

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