I'm having a similar problem. But I posted my question in the old forums: https://forum.hibernate.org/viewtopic.php?f=25&t=1002868
For now I solved it with SQL and a parameter. That is injection save, but not the solution I would like. I was also able to solve this in HQL, but it generated a really ugly in (subquery) statement. As far as performance goes, you should avoid the in statement in sql and the combination in (subquery) is the worst of them all. Greetings! Zorgoban -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
