wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes Seemingly simple EJB-QL question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Seemingly simple EJB-QL question" Watch "Seemingly simple EJB-QL question" New topic
Author

Seemingly simple EJB-QL question

Greg Charles
Sheriff

Joined: Oct 01, 2001
Posts: 2841
    
  11

I need to retrieve a single record matching two fields, call them jib and jab. The query is easy enough:



I know there will only be a single record, because I have a unique key constraint on jib and jab. However, jab can be null, and equality comparison doesn't work with nulls. I tried something like:


Checking parameters with "IS NULL" apparently doesn't work though, even though it works in ordinary SQL. The only solution I can think of is to write two queries and force the application to decide which one to use. I'd appreciate any suggestions!

We're using BEA WebLogic 8.1 and Oracle 9i.
 
Consider Paul's rocket mass heater.
 
subject: Seemingly simple EJB-QL question
 
Similar Threads
I got a Numeric Overflow error.
problem in finder method
Got exception when running Headfirst Customer find method
need help in EJB QL with upper and like
Crisis in making CMP2.0 relationship