I’m trying to pass an array to the JDBC adapter. The input type is ARRAY (input field type java.sql.Array).
I’m trying to map String list to JDBC input or mapping object list to JDBC input in both cases it’s throwing following exception.
[ADA.1.340] The input data for field “empIds” is not “java.sql.Array”.
java.lang.String cannot be cast to java.sql.Array
I’ve written very simple custom SQL just trying to pass employee ids as string type.
SELECT e.empName from Employee e where e.empNo in (?)
So please could anyone help in mapping string list to java.sql.Array?