Hello,
Can you turn on logging and then post the SQL that is used for the
query?
try adding <property name="eclipselink.logging.level"
value="FINEST"/>
and showing the sql for both queries. Also try the sql on the database
directly to see if you get the expected results.
Best Regards,
Chris
On 06/08/2010 6:01 AM, Tanujit Chowdhury wrote:
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
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
|