Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JPQL problem with Date

751258Apr 8 2010 — edited Apr 9 2010

Hi,

I have a JPQL like..

select o from objectClass o where o.dateField : P_DATE

And the query don't returns nothing.
The types of variables are java.sql.Date, my _DB is Oracle 10.

If I look the server console i get the transformed SQL, someting like

SELECT * FROM tableMapping t WHERE t.dateField = ?

If I put a TRUNC in my parameter, its works fine.

So.. How make this in my JPQL?

Any Idea

This post has been answered by 718467 on Apr 9 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2010

Added on Apr 8 2010

#application-servers, #toplink-jpa

5 comments

19,065 views