Class  Tree  Deprecated  Index  Help
SUMMARY:  INNER | FIELD | CONSTR | METHOD	DETAIL:  FIELD | CONSTR | METHOD

---

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.String	createBestRowStatement(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.String	createCatalogStatement()           Constructs a psuedo catalog command to implement getCatalogs().
protected  java.lang.String	createColumnStatement(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.String	createIndexInfoStatement(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.String	createPrimaryKeyStatement(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName)           Constructs an appropriate catalog command to implement getPrimarKeys()
protected  java.lang.String	createSchemaStatement()           Constructs an appropriate catalog command to implement getSchemas()
protected  java.lang.String	createTableStatement(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.String	createTableTypeStatement()           Constructs an appropriate catalog command to implement getTableTypes()
protected  java.lang.String	createTypeInfoStatement()           Constructs an appropriate catalog command to implement getTypeInfo()
protected  java.lang.String	createVersionColumnStatement(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.ResultSet	executeCatalogQuery(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

---

Class  Tree  Deprecated  Index  Help
SUMMARY:  INNER | FIELD | CONSTR | METHOD	DETAIL:  FIELD | CONSTR | METHOD

---