[JBoss-user] [Persistence & CMP/JBoss] - Re: Nulls in CMR where clause

[hbaxmann <nu...@jb...>]

IMHO there is no big, but fundamental problem:

- if your app rely on more then one _significant_ optional field - your ER model sucks
- NULL compared to anything gives false, even NULL=NULL

solution: build a db view per optional field, null-'key' rows will vanish, not the denormalized table

what you are trying to accomplish is a case clause in SQL, as we know: every case statement could be outfactored better by working on your model 

;-)

bax

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3836342#3836342

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3836342