Adding JDBC properties to JDBC steps

book

Article ID: 75108

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

How to add JDBC properties to JDBC step? For example, when making a connection to JDBC in Java code the properties can be added. How can we do the same in DevTest?

Adding JDBC properties to JDBC steps.

Environment

All DevTest environments

Resolution

Per IBM documentation at http://www-01.ibm.com/support/docview.wss?uid=swg21688139 the general form of the JDBC connection string is jdbc:db2://host:port/dbname:property=value.

You can add the property Key=Value to the connection string as above.