JDBC proxy

The Rational® Integration Tester JDBC proxy package is provided with IBM® Rational Test Control Panel that must be deployed on any stand-alone applications or application servers that host applications that use JDBC to access any live databases that you want to record or virtualize.

For information, about the JDBC proxy package, see Rational Integration Tester tool packages

Proxy capabilities

The Rational Integration Tester JDBC proxy enables Rational Integration Tester to:

Record SQL executed against databases from applications that use JDBC.
Create and edit database stubs (IBM Rational Test Virtualization Server only). Database stubs contain subsets of data from a "live" (production) database. The contents of the stubs are built by analyzing an application’s use of SQL against the live database.
Start a database stub (Rational Test Virtualization Server only). Starting a stub loads the stub data into a simulation database and transparently redirects the application to that simulation database.

These capabilities enable you to test JDBC applications in a more deterministic manner.

Proxy modes

When creating database stubs, the following modes of the Rational Integration Tester JDBC proxy are relevant:

Live
Learn
Simulate

The purpose of learn mode is to fill the simulation database, which facilitates creation of database stubs. Creating a stub then starting it moves learn mode to simulate mode, and stopping the stub moves simulate mode to live mode. When in live mode, it is possible to enter learn mode again.

The following diagram illustrates the lifecycle for these modes.

The following diagram illustrates live mode.

The following diagram illustrates learn mode.

The following diagram illustrates simulate mode.

Datatypes supported by the proxy

The Rational Integration Tester JDBC proxy supports VARCHAR(MAX) and NVARCHAR(MAX) types. You can use both in table columns and in stored procedure parameters in any database management system that supports these types.

Feedback