Hibernate Community • View topic - 'is null' for OneToOne relationship

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

'is null' for OneToOne relationship

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

michalz

Post subject: 'is null' for OneToOne relationship

Posted: Wed Jul 12, 2006 8:23 am

Newbie

Joined: Wed Jul 12, 2006 5:33 am
Posts: 4

I have got Entity A & B. They are in 1-1 relationship. Entity mapping is biderectional, whereas B holds reference to A in db. Performing:

Code:

Select a FROM A a WHERE a.b is null

gives me empty set, even is there are A entities with no Bs attached.
I can omit this problem performin

Code:

Select a FROM A a WHERE (SELECT COUNT(b) FROM B b WHERE b.a = a)=0

but the first method seems to be much more simple to maintain. Why 'is null' is not working?

--
best regards

Top

Page 1 of 1

[ 1 post ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum