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

Virtualize Databases with the Web-Based Recorder

You can use the DevTest Java Agent with a web-based recorder to virtualize JDBC-based database traffic. This feature is also known as agent-based JDBC virtualization.

Note: JDBC is a chatty protocol. For example, a few clicks in a user interface that retrieves data from a database can result in a huge number of JDBC API calls. This behavior can make it difficult to model properly. If you want to capture and virtualize JDBC database traffic, consider doing so at a higher layer.

The following JDBC drivers and databases are supported:

• Apache Derby
  • Apache Derby 4.2.3 JDBC driver to Apache Derby database
• Oracle
  • Oracle 11g JDBC driver to Oracle 11g database
  • Oracle 11g JDBC driver to Oracle 12c database
• IBM DB2:
  • IBM DB2 9.5 JDBC driver to IBM DB2 9.5 database
  • IBM DB2 9.5 JDBC driver to IBM DB2 9.8 database
  • IBM DB2 9.5 JDBC driver to IBM DB2 10.5 database
• Microsoft SQL Server
  • Microsoft JDBC Driver 4.0 to Microsoft SQL Server 2008 R2 database
  • Microsoft JDBC Driver 4.0 to Microsoft SQL Server 2012 database
  • jTDS 1.3.1 JDBC driver to Microsoft SQL Server 2008 R2 database
  • jTDS 1.3.1 JDBC driver to Microsoft SQL Server 2012 database

Before you capture the JDBC traffic, install and configure the agent on the computer where the application makes JDBC calls to the database. The database itself can reside on a separate computer. When you configure the agent, be sure to perform the following actions:

• Set the capture level for the JDBC protocol to Full Data.
• Set the capture level for any protocol above the JDBC protocol to Counts and Paths or to Full Data.

Important! During the playback phase, start the virtual service before you start the system under test.

Note: For information about installing the agent, see Agents. For information about deploying the virtual service, see Using CA Service Virtualization.