I am using JBossQL to query a UsersEB. Previous versions of my application I had a Image <1:1> Users CMR relationship. This was updated so that a User can have more than one image; therefore Image <N:1> Users. So the change is instead of returning one Local instance of Image (ImageLocal) it will now return a Collection for each User
For the particular query I am having trouble with, previous version had something similar to
SELECT OBJECT(u) FROM Users u WHERE u.Image IS NULL
And this worked correctly.
In my current query:
SELECT OBJECT(u) FROM Users u WHERE u.Image IS EMPTY
Does not work because in my result set, I do not get Previous version application created users that were NULL as well as Current Version application created users where their Image is EMPTY.
There is no longer a CMR field present in Users and now the CMR field in Image is UserID, which is the PK of Users
- The old users were created under different circumstances therefore when changed to a N:1 relationship, they no longer were NULL but were altered to "" (Empty string in place of NULL).
-Since the application change, Users and Image will need to be recreated for my application to fully understand the new CMR.
I wanted to get some input from posters before I go this long route.