Package com.sptci.rwt

A database abstraction API for analysing and interacting with relational databases using JDBC.

See:
Description

Class Summary

AbstractProcedureAnalyser	An abstract base class for database engine specific procedure analysers.
AbstractQueryExecutor	A utility class to execute SQL statement (only one statement allowed).
AbstractSequenceAnalyser	An abstract analyser for analysing sequence type objects in the database.
AbstractTriggerAnalyser	An abstract analyser for analysing trigger type objects in the database.
AbstractViewAnalyser	An abstractanalyser for analysing view type objects in the database.
AllTests	Execute all the tests for the project.
Analyser	An abstract base class analyser for the various database objects.
BatchQueryExecutor	A utility class to execute SQL statements (single or batch).
BatchQueryExecutorTest	Unit test for the BatchQueryExecutor class.
CatalogueAnalyser	An analyser for analysing catalogues in a database.
CatalogueMetaData	A value object that represents database catalogues.
Category	A simple data object used to represent a category under which named queries are stored.
Column	A simple value object that represents a column in a result set row.
ColumnAnalyser	An analyser for analysing column type objects in the database.
ColumnAnalyserTest	Unit test for the ColumnAnalyser object.
ColumnMetaData	A value object that represents metadata for columns.
ConnectionData	A simple bean used to represent different types of database engines that the application can connect to.
ConnectionFactory	A factory used to obtain database connections.
ConnectionManager	A manager used to globally maintain a single means of connecting to a database.
ConnectionParameters	A simple value object used to represent the data required to initiate a connection to a database.
Connections	A serializable wrapper used to represent saved JDBC connections for the application.
ConnectionsTest	Unit test for the Connections object.
CreateTestObjects	Unit test setup class for creating test database objects to use in the unit test suite.
DatabaseType	A simple bean used to represent different types of database engines that the application can connect to.
DBMSAnalyser	An analyser for analysing metadata about a database.
DBMSAnalyserTest	Unit test for the DBMSAnalyser object.
DBMSMetaData	A value object that represents metadata for the database.
DeleteTestObjects	Unit test for closing a JDBC Connection through ConnectionFactory.close(java.sql.Connection) method.
ExcelGenerator	An Excel workbook generator for data contained in a Rows object.
ForeignKeyAnalyser	An analyser for analysing foreign key columns for tables in the database.
ForeignKeyAnalyserTest	Unit test for the ForeignKeyAnalyser object.
ForeignKeyMetaData	A metadata object that represents foreign key constraint types.
IndexAnalyser	An analyser for analysing index columns for tables in the database.
IndexAnalyserTest	Unit test for the IndexAnalyser object.
IndexMetaData	A metadata object that represents table indices.
JDBCMetaData	A value object that represents metadata for the JDBC driver.
KeyAnalyser	An abstract analyser for analysing constraints and indices for tables.
KeyMetaData	An abstract metadata object that represents constraint types (primary and foreign keys).
LimitsMetaData	A value object that represents metadata about limits enforced by the database.
MetaData	An abstract base class for all value objects that represent metadata for database objects.
ObjectMetaData	An abstract value object that is used to represent database objects such as tables, views, columns etc that support having comments.
OracleProcedureAnalyser	An analyser for analysing procedure type objects in the database.
OracleSequenceAnalyser	An analyser for analysing sequence type objects in the database.
OracleTriggerAnalyser	An analyser for analysing trigger type objects in the database.
OracleViewAnalyser	An analyser for analysing view type objects in the database.
PrimaryKeyAnalyser	An analyser for analysing primary key columns for tables in the database.
PrimaryKeyAnalyserTest	Unit test for the PrimaryKeyAnalyser object.
PrimaryKeyMetaData	A metadata object that represents primary key constraint types.
ProcedureAnalyser	An analyser for analysing procedure type objects in the database.
ProcedureAnalyserTest	Unit test for the ProcedureAnalyser object.
ProcedureMetaData	A metadata object that represents procedure/function objects.
Queries	A serializable wrapper used to represent saved SQL queries for the application.
QueriesTest	Unit test for the Queries object.
Query	A simple sub-class of KeyValue used to represent a saved query.
QueryExecutor	A utility class to execute SQL statement (only one statement allowed).
QueryExecutorTest	Unit test for the QueryExecutor class.
RootMetaData	An asbtract base class that represents objects that serve as the root of the database.
Row	A simple value object that represents a row in a ResultSet.
Rows	A simple value object that represents a ResultSet.
SchemaAnalyser	An analyser for analysing schemas in a database.
SchemaAnalyserTest	Unit test for the SchemaAnalyser object.
SchemaMetaData	A value object that represents database schemas.
SequenceAnalyser	An analyser for analysing sequence type objects in the database.
SequenceAnalyserTest	Unit test for the SequenceAnalyser object.
SequenceMetaData	A value object that represents metadata for sequences.
StandardProcedureAnalyser	An analyser for analysing procedure type objects in the database.
StandardSequenceAnalyser	An analyser for analysing sequence type objects in the database.
StandardTriggerAnalyser	An analyser for analysing trigger type objects in the database.
StandardViewAnalyser	An analyser for analysing view type objects in the database.
TableAnalyser	An analyser for analysing table type objects in the database.
TableAnalyserTest	Unit test for the TableAnalyser object.
TableMetaData	A value object that represents metadata for tables.
TableTypeAnalyser	An analyser for analysing table type objects in the database.
TableTypeMetaData	An abstract value object that represents metadata for tables, views, synonyms and other similar objects.
TriggerAnalyser	An analyser for analysing trigger type objects in the database.
TriggerAnalyserTest	Unit test for the TriggerAnalyser object.
TriggerMetaData	A metadata object that represents trigger objects.
ViewAnalyser	An analyser for analysing view type objects in the database.
ViewAnalyserTest	Unit test for the ViewAnalyser object.
ViewMetaData	A value object that represents metadata for views.

Enum Summary

DBMSMetaData.Transaction	An enumeration for the various types of transaction isolation levels supported by the database.
ForeignKeyMetaData.Deferrability	The enumeration of deferrability for keys.
ForeignKeyMetaData.Rule	The enumeration of UPDATE_RULE and DELETE_RULE values for keys.
IndexMetaData.SortSequence	An enumerationg for the sort sequence of indices.
IndexMetaData.Type	An enumeration for the index types.
TriggerMetaData.Event	An enumeration of event types that cause a trigger to fire.
TriggerMetaData.Orientation	An enumeration of action_orientation values.
TriggerMetaData.Timing	An enumeration of timing values for trigger execution.

Exception Summary

ConnectionException	A custom exception that is used to wrap any exceptions raised when fetching Connections.
QueryException	A custom exception that is used to wrap any exceptions raised when executing SQL statements.

Package com.sptci.rwt Description

A database abstraction API for analysing and interacting with relational databases using JDBC.