Hi,
I'm using openJPA native query defined in mapping file.
I've a select query where I'm trying to pass a List of values as input parameter to it using IN clause.
select... where... IN
SQL works , but when I use the same query in JPA with a positional parameter, It fails..
How to pass list of values to Query??
Here is the code.
When I execute this code, I'm getting
input Param :: '504152335','504152610','504180177','968718337'
Results size:: 0
With NO exception , no results.
I've treid removing single quotes in param, same output with 0 results.
i've tried making the input parametre as List<String>
When I run this Im getting following exception
Has anyone know about this issue?
Thanks,
Lavanya.