java.sql.SQLException: Missing IN or OUT parameter at index

book

Article ID: 225018

calendar_today

Updated On:

Products

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

Issue/Introduction

DevTest 10.6

The DB step which runs query (call DAAS_VALIDATION_REQID(?,?,?,?,?) with 5 parameters as attached snapshot)

 

The connection is successful however running the Query throws an error: java.sql.SQLException: Missing IN or OUT parameter at index:: 6

Where as it is working fine in Devtest10.3.

Cause

A code change was done after 10.3 to this functionality. That's why it used to work in 10.3 but not now.

This issue was introduced by that change. There is a bug in it where it adds all the parameter placeholders to the query that is provided by the user. 

Environment

Release : 10.6

Component : DevTest Virtual Service

Resolution

This issue has been fixed via a patch. Open a support case and request for patch patch_DE515831_10.6.0_GA.jar

Below are the steps to be followed in order to apply the patch: 

1. Stop all DevTest services except IAM and ED.

2. Copy the attached patch to <DEVTEST_HOME>/lib/patches folder. If the patches folder doesn't exist then create one in "<DEVTEST_HOME>/lib/"

3. Restart the services and reopen the Workstation.

Note Make sure this patch is applied in all the machines (except ED and IAM) where DevTest is installed.