When using Query BO with a jdbcwhereclause, after input the parameters of WHERE clause, during the JDBC adapter running the error likes "Missing IN or OUT parameter at index:: 1, error code: 17041" is encountered
Resolving The Problem
When using Query BO with the test component for the JDBC Import component, in the test component perspective, it showed like below for the parameters and the jdbcwhereclause attribute
Where the jdbcwhereclause attribute default value is same as ASI.
If just input the parameter1 and other parameters value then run the test, the Error like "Missing IN or OUT parameter at index:: 1, error code: 17041" will be raised, this is because during runtime the JDBC adapter will directly bring this
WHERE clause to create the SQL then implement on database, as the value are all as "?" in the jdbcwhereclause attribute so the
error where will be occurred.
To prevent such problem, need to follow below steps to test the JDBC Import:
1. Set the Parameter1 attribute as the proper value
2. Set the Parameter2 attribute as the proper value
3. Unset the jdbcwhereclause attribute, this is important to prevent the adapter to use the default ASI value to this attribute
15 June 2018