0 Replies Latest reply on Jan 30, 2008 6:04 AM by Andreas Arens

    Join in subselect does not work anymore after upgrade to JBo

    Andreas Arens Newbie

      Hi All!

      To speed up queries, I use a subselect in conjunction with an INNER JOIN, something like this:

      "SELECT OBJECT(o) FROM Userfood o
       WHERE o.id NOT IN
       (SELECT uf.id FROM IngredientAllergen ia INNER JOIN ia.userfoods uf
       WHERE ia = :ingAll)"

      This worked perfectly well under JBoss 4.0.4 GA, but when I switch to JBoss 4.0.5 GA, it doesn't even send the query to the database and I don't get any error message.

      Sorry if this issue has been handlled before, but I didn't find any references.

      Thanks for any help,