Zorgoban, I think you can apply the same solution to your problem. But I would probably use a named SQL query instead.
On Sun, Feb 28, 2010 at 7:35 PM, Zorgoban <[email protected]> wrote: > 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.
