To return expected results, you can:
Reduce the number of search terms.
Each term you use focuses the search further.
Check your spelling.
A single misspelled or incorrectly typed term can change your result.
Try substituting synonyms for your original terms.
For example, instead of searching for "java classes", try "java training"
Did you search for an IBM acquired or sold product ?
If so, follow the appropriate link below to find the content you need.
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
