com.northgateis.reality.realsql
Class RealCatalogQueryR82

java.lang.Object
 |
 +--com.northgateis.reality.realsql.RealCatalogQuery
        |
 +--com.northgateis.reality.realsql.RealCatalogQueryR82

public class RealCatalogQueryR82
extends RealCatalogQuery

This class is used to generate SQL catalog query statements for connections to an 8.2 (or later) Reality database.

See Also:
RealSQLDatabaseMetaData, DatabaseMetaData

Fields inherited from class com.northgateis.reality.realsql.RealCatalogQuery
dbmd, debug, sqlStatement
 
Constructor Summary
RealCatalogQueryR82(RealSQLDatabaseMetaData metadata, int traceFlags)
           
 
Method Summary
protected  java.lang.StringcreateBestRowStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName, int scope, boolean nullable)
          Constructs an appropriate catalog command to implement getBestRowIdentifier()
protected  java.lang.StringcreateCatalogStatement()
          Constructs a psuedo catalog command to implement getCatalogs().
protected  java.lang.StringcreateColumnStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName, java.lang.String columnName)
          Constructs an appropriate catalog command to implement getColumns()
protected  java.lang.StringcreateIndexInfoStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName, boolean unique, boolean approximate)
          Constructs an appropriate catalog command to implement getIndexInfo()
protected  java.lang.StringcreatePrimaryKeyStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName)
          Constructs an appropriate catalog command to implement getPrimarKeys()
protected  java.lang.StringcreateSchemaStatement()
          Constructs an appropriate catalog command to implement getSchemas()
protected  java.lang.StringcreateTableStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName, java.lang.String[] types)
          Constructs an appropriate psuedo catalog command to implement getTables() Reality supports the following table types : "TABLE", "SYSTEM TABLE".
protected  java.lang.StringcreateTableTypeStatement()
          Constructs an appropriate catalog command to implement getTableTypes()
protected  java.lang.StringcreateTypeInfoStatement()
          Constructs an appropriate catalog command to implement getTypeInfo()
protected  java.lang.StringcreateVersionColumnStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName)
          Constructs an appropriate catalog command to implement getVersionColumns() Reality does not support columns that are automatically updated when any value in a row is updated, therefore this query will always return a ResultSet containing zero rows.
protected  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
 

Constructor Detail

RealCatalogQueryR82

public RealCatalogQueryR82(RealSQLDatabaseMetaData metadata,
 int traceFlags)
 throws RealSQLException
Method Detail

executeCatalogQuery

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

Parameters:
catalogStatement - the catalog object used for the statement generation.
sqlStatement - the completed SQL statement being passed to the Reality server.
Returns:
ResultSet generated from executing this catalog query.
Overrides:
executeCatalogQuery in class RealCatalogQuery


createTableStatement

protected java.lang.String createTableStatement(java.lang.String catalogName,
 java.lang.String schemaName,
 java.lang.String tableName,
 java.lang.String[] types)
 throws RealSQLException
Constructs an appropriate psuedo catalog command to implement getTables()

Reality supports the following table types : "TABLE", "SYSTEM TABLE".

Parameters:
catalogName - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria.
schemaName - a schema name pattern; "" retrieves those without a schema.
tableName - a table name pattern.
types - a list of table types to include; null returns all types.
Returns:
String SQL statement representing this query.
Throws:
RealSQLException -  
Overrides:
createTableStatement in class RealCatalogQuery


createCatalogStatement

protected java.lang.String createCatalogStatement()
 throws RealSQLException
Constructs a psuedo catalog command to implement getCatalogs().

Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createCatalogStatement in class RealCatalogQuery


createSchemaStatement

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

Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createSchemaStatement in class RealCatalogQuery


createTableTypeStatement

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

Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createTableTypeStatement in class RealCatalogQuery


createColumnStatement

protected java.lang.String createColumnStatement(java.lang.String catalogName,
 java.lang.String schemaName,
 java.lang.String tableName,
 java.lang.String columnName)
 throws RealSQLException
Constructs an appropriate catalog command to implement getColumns()

Parameters:
catalogName - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria.
schemaName - a schema name pattern; "" retrieves those without a schema.
tableName - a table name pattern.
columnName - a column name pattern.
Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createColumnStatement in class RealCatalogQuery


createBestRowStatement

protected java.lang.String createBestRowStatement(java.lang.String catalogName,
 java.lang.String schemaName,
 java.lang.String tableName,
 int scope,
 boolean nullable)
 throws RealSQLException
Constructs an appropriate catalog command to implement getBestRowIdentifier()

Parameters:
catalogName - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria.
schemaName - a schema name; "" retrieves those without a schema.
tableName - a table name.
columnName - a column name.
scope - - the scope of interest; use same values as SCOPE
nullable - - include columns that are nullable?
Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createBestRowStatement in class RealCatalogQuery


createVersionColumnStatement

protected java.lang.String createVersionColumnStatement(java.lang.String catalogName,
 java.lang.String schemaName,
 java.lang.String tableName)
 throws RealSQLException
Constructs an appropriate catalog command to implement getVersionColumns()

Reality does not support columns that are automatically updated when any value in a row is updated, therefore this query will always return a ResultSet containing zero rows.

Parameters:
catalogName - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria.
schemaName - a schema name; "" retrieves those without a schema.
tableName - a table name.
columnName - a column name.
Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createVersionColumnStatement in class RealCatalogQuery


createIndexInfoStatement

protected java.lang.String createIndexInfoStatement(java.lang.String catalogName,
 java.lang.String schemaName,
 java.lang.String tableName,
 boolean unique,
 boolean approximate)
 throws RealSQLException
Constructs an appropriate catalog command to implement getIndexInfo()

Parameters:
catalogName - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria.
schemaName - a schema name; "" retrieves those without a schema.
tableName - a table name.
columnName - a column name.
unique - - when true, return only indices for unique values; when false, return indices regardless of whether unique or not
approximate - - when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate
Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createIndexInfoStatement in class RealCatalogQuery


createTypeInfoStatement

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

Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createTypeInfoStatement in class RealCatalogQuery


createPrimaryKeyStatement

protected java.lang.String createPrimaryKeyStatement(java.lang.String catalogName,
 java.lang.String schemaName,
 java.lang.String tableName)
 throws RealSQLException
Constructs an appropriate catalog command to implement getPrimarKeys()

Parameters:
catalogName - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria.
schemaName - a schema name; "" retrieves those without a schema.
tableName - a table name.
columnName - a column name.
Returns:
String SQL command representing this query.
Throws:
RealSQLException -  
Overrides:
createPrimaryKeyStatement in class RealCatalogQuery