!-Use Connection Pool in SQL Database connection step in DevTest VSM

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

Using a VSM for SQL Database Connect and getting an error and then going offline until enabling the "Use connection pool" feature. But the server is not responding and the transaction count is not increasing.

Environment

A;; supported DevTest releases.

Cause

N/A

Resolution

When using connection pooling for load tests (multi-VUs), it may be needing to configure the lisa.jdbc.pool.maxPoolSize property not to run out of connections (starvation).

Add  lisa.jdbc.pool.maxPoolSize=25 ( default is 10) in the local.properties file of the VSE Server.

Restart the VSE.

Additional Information

Refer to section "SQL Database Execution (JDBC)" in the documentation of the DevTest release you are running.