0 Replies Latest reply on Nov 15, 2007 7:09 PM by Blake Salvador

    JBossQL IS EMPTY not acting correctly

    Blake Salvador Newbie

      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