Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.iapi.db.ConsistencyChecker

The ConsistencyChecker class provides static methods for verifying the consistency of the data stored within a database.

This class can only be used within an SQL-J statement, a Java procedure or a server side Java method.

This class can be accessed using the class alias CONSISTENCYCHECKER in SQL-J statements.

Access	Constructor and Description
private	ConsistencyChecker() no requirement for a constructor

Method Summary

Modifier and Type	Method and Description
public static boolean	Returns: true, if the table is consistent, exception thrown if inconsistent checkTable(String The schema name of the table. schemaName, String The name of the table tableName) Check the named table, ensuring that all of its indexes are consistent with the base table.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

ConsistencyChecker	back to summary
private ConsistencyChecker() no requirement for a constructor

Method Detail

checkTable back to summary

checkTable	back to summary
public static boolean checkTable(String schemaName, String tableName) throws SQLException Check the named table, ensuring that all of its indexes are consistent with the base table. Use this method only within an SQL-J statement; do not call it directly. When tables are consistent, the method returns true. Otherwise, the method throws an exception. To check the consistency of a single table: `VALUES ConsistencyChecker::checkTable(SchemaName, TableName)` For example, to check the consistency of the table APP.Flights: `VALUES ConsistencyChecker::checkTable('APP', 'FLIGHTS')` To check the consistency of all of the tables in the 'APP' schema, stopping at the first failure: `SELECT tablename, ConsistencyChecker::checkTable( 'APP', tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaname = 'APP' AND s.schemaid = t.schemaid` To check the consistency of an entire database, stopping at the first failure: `SELECT schemaname, tablename, ConsistencyChecker::checkTable(schemaname, tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid = t.schemaid` Parameters schemaName:String The schema name of the table. tableName:String The name of the table Returns:boolean true, if the table is consistent, exception thrown if inconsistent Exceptions SQLException: Thrown if some inconsistency is found, or if some unexpected exception is thrown..

public static boolean checkTable(String schemaName, String tableName) throws SQLException

Check the named table, ensuring that all of its indexes are consistent with the base table. Use this method only within an SQL-J statement; do not call it directly.

When tables are consistent, the method returns true. Otherwise, the method throws an exception.

To check the consistency of a single table:

VALUES ConsistencyChecker::checkTable(SchemaName, TableName)

For example, to check the consistency of the table APP.Flights:

VALUES ConsistencyChecker::checkTable('APP', 'FLIGHTS')

To check the consistency of all of the tables in the 'APP' schema, stopping at the first failure:

SELECT tablename, ConsistencyChecker::checkTable( 'APP', tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaname = 'APP' AND s.schemaid = t.schemaid

To check the consistency of an entire database, stopping at the first failure:

SELECT schemaname, tablename, ConsistencyChecker::checkTable(schemaname, tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid = t.schemaid

Parameters

schemaName:String: The schema name of the table.
tableName:String: The name of the table

Returns:boolean

true, if the table is consistent, exception thrown if inconsistent

Exceptions

SQLException:: Thrown if some inconsistency is found, or if some unexpected exception is thrown..

public Class ConsistencyChecker

Constructor Summary

Method Summary

Constructor Detail

Method Detail