Using CA Continuous Application Insight › Creating Virtual Services › Virtualize Databases with the Web-Based Recorder › JDBC Service Image

JDBC Service Image

In agent-based JDBC virtualization, the virtual service that you generate includes a service image.

Each transaction in the service image has an operation and a series of arguments.

The operation conveys the main purpose of the SQL statement. For example:

SELECT FROM TRANSACTIONS

The arguments can include the list of columns, each major clause of the SQL statement, and parameter values that are bound to the SQL statement. The final two arguments are always the connection URL and the database user.

The following graphic shows a transaction. The operation is SELECT FROM TRANSACTIONS. The first argument contains the list of columns. The SQL statement has one parameter value: the account ID.

Each transaction in the service image also has an XML document that contains the results of executing the SQL statement. The XML document is located in the Response panel of the Service Image Editor.

The results depend on the type of SQL statement:

• If the SQL statement retrieved data, the results contain one or more data sets.
• If the SQL statement updated data, the results contain update counts.