You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by "KARR, DAVID (ATTSI)" <dk...@att.com> on 2010/06/04 20:18:44 UTC

Need to implement query with NULLIF with OpenJPA 1.2.2

Using OpenJPA 1.2.2 (I can't upgrade).

I have to do a query that gets rows where the current date is between a
start/end date range, but if either of the "start" or "end" date is
null, to instead compare it against a date value in a one-to-one
relationship.  This seems like a perfect place to use NULLIF.  NULLIF is
defined in JPA 2.x, but not in 1.x.  Unfortunately, due to restrictions
in my container, I can't run OpenJPA 2.x (running JPA 2.x in WebLogic
10.3 requires significant surgery that I'm not able to do yet).

I know I could use a native query, but I'm hoping that's a last resort.

Can you think of any other strategies I could use?

RE: Need to implement query with NULLIF with OpenJPA 1.2.2

Posted by "KARR, DAVID (ATTSI)" <dk...@att.com>.
> -----Original Message-----
> From: KARR, DAVID (ATTSI)
> Sent: Friday, June 04, 2010 11:19 AM
> To: users@openjpa.apache.org
> Subject: Need to implement query with NULLIF with OpenJPA 1.2.2
> 
> Using OpenJPA 1.2.2 (I can't upgrade).
> 
> I have to do a query that gets rows where the current date is between
a
> start/end date range, but if either of the "start" or "end" date is
> null, to instead compare it against a date value in a one-to-one
> relationship.  This seems like a perfect place to use NULLIF.  NULLIF
> is
> defined in JPA 2.x, but not in 1.x.  Unfortunately, due to
restrictions
> in my container, I can't run OpenJPA 2.x (running JPA 2.x in WebLogic
> 10.3 requires significant surgery that I'm not able to do yet).
> 
> I know I could use a native query, but I'm hoping that's a last
resort.
> 
> Can you think of any other strategies I could use?

Note that I meant "COALESCE", not "NULLIF".