All,
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
My Thinking:
- 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.
Thanks,
Blake
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4105283#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...