|
|
|||||||
| 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 SCOPEnullable- - 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 notapproximate- - 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
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||