Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

IS NULL selection to CMP Entity EJB from DB

 
Kaido Lepisto
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic