[eclipselink-users] Having problem in 'AND' with JPQL and EclipseLink

[Tanujit Chowdhury <chowdhury.tanujit@xxxxxxxxx>]

Hi,
I am using Eclipselink 1.0.2, and Oracle Weblogic 10.3.2. My database is SQL Server.

I am executing a simple query :
"select c from Certificate c where c.certPIN = 'bK2xEk2'" ---------- This is working fine with the JPQL.
But the below query is not returning any data where it should return :
"select c from Certificate c where c.certPIN = 'bK2xEk2' and c.certState IN ('MLOG')".-------------- It is returning ZERO result but actually it has results.

Can anyone help in this regard?

-- 
Tanujit Chowdhury