File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes IS NULL selection to CMP Entity EJB from DB 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 "IS NULL selection to CMP Entity EJB from DB" Watch "IS NULL selection to CMP Entity EJB from DB" New topic
Author

IS NULL selection to CMP Entity EJB from DB

Kaido Lepisto
Greenhorn

Joined: Aug 22, 2001
Posts: 1
Is there a way to find entities with a null in the db column in CMP type of Entity EJB-s ?
( Like in BMP Entity EJB one would get when issuig the statement "select column from table where foo IS NULL")
Right now ejbFindByFoo(Integer x) returns nothing when x==null
I would need it to return all the primary keys that have NULL in the database column.
thanks in advance,
K.L.

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I think this is container specific. If the vendor' ql allows queries of the type 'WHERE SOMETHING IS NULL' this should b no problem. In EJB 2.0 it would not be a problem thanks to Ejb QL.
 
GeeCON Prague 2014
 
subject: IS NULL selection to CMP Entity EJB from DB