Keep Connection Open functionality in JDBC step

Document ID : KB000010273
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

How the "Keep Connection Open" functionality is used in the JDBC step.

Background:

How JDBC step in DevTest handles the database connectivity.

Environment:
All supported DevTest versions.
Instructions:

Keep Connection Open: 

If this option is selected in the JDBC Step, the database connection that is opened the first time that the step executes is cached. That database connection is then closed when garbage collection happens for the step. If "Keep Connection Open" is not selected, the connection is closed each time that the step executes. 

Additional Information:

Documentation on this is available in WIKI at https://docops.ca.com/devtest-solutions/9-1/en/reference/test-step-descriptions/other-transaction-steps/sql-database-execution-jdbc.