[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Join Fetch returning cartesian product

[ge0ffrey]

Adding DISTINCT solves this (for hsql, mysql, ...), but my database (ms sqlserver...) doesn't allow to do this because it contains ntexts.

It seems as if adding DISTINCT, does not only change the query to the database, but also triggers Hibernate to distinct them. Can I do the second without doing hte first?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3968366#3968366

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3968366