com.northgateis.reality.realsql
Class RealCatalogQuery

java.lang.Object
 |
 +--com.northgateis.reality.realsql.RealCatalogQuery
Direct Known Subclasses:
RealCatalogQueryR81, RealCatalogQueryR82
public abstract class RealCatalogQuery
extends java.lang.Object

This abstract class is the base class for classes generating catalog query statements.

See Also:
RealSQLDatabaseMetaData

Field Summary
protected  RealSQLDatabaseMetaData dbmd
           
protected  RealDebug debug
           
protected  java.lang.StringBuffer sqlStatement
           
 
Constructor Summary
RealCatalogQuery(RealSQLDatabaseMetaData metadata, int traceFlags)
           
 
Method Summary
protected abstract  java.lang.StringcreateBestRowStatement(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)
          Constructs an appropriate catalog query to implement getBestRowIdentifer()
protected abstract  java.lang.StringcreateCatalogStatement()
          Constructs an appropriate catalog query to implement getCatalogs()
protected abstract  java.lang.StringcreateColumnStatement(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String column)
          Constructs an appropriate catalog query to implement getColumns()
protected abstract  java.lang.StringcreateIndexInfoStatement(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)
          Constructs an appropriate catalog query to implement getIndexInfo()
protected abstract  java.lang.StringcreatePrimaryKeyStatement(java.lang.String catalog, java.lang.String schema, java.lang.String table)
          Constructs an appropriate catalog query to implement getPrimaryKeys()
protected abstract  java.lang.StringcreateSchemaStatement()
          Constructs an appropriate catalog query to implement getSchemas()
protected abstract  java.lang.StringcreateTableStatement(java.lang.String catalog, java.lang.String schema, java.lang.String tablename, java.lang.String[] types)
          Constructs an appropriate catalog query to implement getTables()
protected abstract  java.lang.StringcreateTableTypeStatement()
          Constructs an appropriate catalog query to implement getTableTypes()
protected abstract  java.lang.StringcreateTypeInfoStatement()
          Constructs an appropriate catalog query to implement getTypeInfo()
protected abstract  java.lang.StringcreateVersionColumnStatement(java.lang.String catalog, java.lang.String schema, java.lang.String table)
          Constructs an appropriate catalog query to implement getVersionColumns()
protected abstract  java.sql.ResultSetexecuteCatalogQuery(RealSQLStatement catalogStatement, java.lang.String sqlStatement)
          Executes the catalog query statement and returns the result set.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

dbmd

protected RealSQLDatabaseMetaDatadbmd

debug

protected RealDebugdebug

sqlStatement

protected java.lang.StringBuffer sqlStatement
Constructor Detail

RealCatalogQuery

public RealCatalogQuery(RealSQLDatabaseMetaData metadata,
 int traceFlags)
Method Detail

executeCatalogQuery

protected abstract java.sql.ResultSet executeCatalogQuery(RealSQLStatement catalogStatement,
 java.lang.String sqlStatement)
 throws java.sql.SQLException
Executes the catalog query statement and returns the result set.

createTableStatement

protected abstract java.lang.String createTableStatement(java.lang.String catalog,
 java.lang.String schema,
 java.lang.String tablename,
 java.lang.String[] types)
 throws RealSQLException
Constructs an appropriate catalog query to implement getTables()

createCatalogStatement

protected abstract java.lang.String createCatalogStatement()
 throws RealSQLException
Constructs an appropriate catalog query to implement getCatalogs()

createSchemaStatement

protected abstract java.lang.String createSchemaStatement()
 throws RealSQLException
Constructs an appropriate catalog query to implement getSchemas()

createTableTypeStatement

protected abstract java.lang.String createTableTypeStatement()
 throws RealSQLException
Constructs an appropriate catalog query to implement getTableTypes()

createColumnStatement

protected abstract java.lang.String createColumnStatement(java.lang.String catalog,
 java.lang.String schema,
 java.lang.String table,
 java.lang.String column)
 throws RealSQLException
Constructs an appropriate catalog query to implement getColumns()

createBestRowStatement

protected abstract java.lang.String createBestRowStatement(java.lang.String catalog,
 java.lang.String schema,
 java.lang.String table,
 int scope,
 boolean nullable)
 throws RealSQLException
Constructs an appropriate catalog query to implement getBestRowIdentifer()

createVersionColumnStatement

protected abstract java.lang.String createVersionColumnStatement(java.lang.String catalog,
 java.lang.String schema,
 java.lang.String table)
 throws RealSQLException
Constructs an appropriate catalog query to implement getVersionColumns()

createIndexInfoStatement

protected abstract java.lang.String createIndexInfoStatement(java.lang.String catalog,
 java.lang.String schema,
 java.lang.String table,
 boolean unique,
 boolean approximate)
 throws RealSQLException
Constructs an appropriate catalog query to implement getIndexInfo()

createTypeInfoStatement

protected abstract java.lang.String createTypeInfoStatement()
 throws RealSQLException
Constructs an appropriate catalog query to implement getTypeInfo()

createPrimaryKeyStatement

protected abstract java.lang.String createPrimaryKeyStatement(java.lang.String catalog,
 java.lang.String schema,
 java.lang.String table)
 throws RealSQLException
Constructs an appropriate catalog query to implement getPrimaryKeys()