[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: HQL and enum constants

[andydale]

Hi.

try this:

SELECT DISTINCT m FROM Material m, IN(m.suppliers) s WHERE m.unit <> Material$MaterialUnit.SQUARE_METRES AND s.id = :id

I am not sure if you will need the package name before Material.

Cheers,

Andy

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

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