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

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