Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Mapping documents:

1- Categoria

<hibernate-mapping default-lazy="false">
<class name="com.coginfo.kf.bean.Categoria" table="KFT_CATEGORIA" select-before-update="true">
<id name="codint" type="long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">KF_SEQ_CATEGORIA</param>
</generator>
</id>

<property name="cafdsc" type="string">
<column name="cafdsc" length="1000" sql-type="string" not-null="true"/>
</property>


<set name="categoriaAclAmministratori" where="stsacl = '1'">
<key column="codintctg"/>
<one-to-many class="com.coginfo.kf.bean.CategoriaAcl"/>
</set>
</class>
</hibernate-mapping>

-KFT_CATEGORIA_ACL

<hibernate-mapping default-lazy="false">
<class name="com.coginfo.kf.bean.CategoriaAcl" table="KFT_ACL_CATEGORIA" select-before-update="true">
<composite-id name="id" class="com.coginfo.kf.bean.CategoriaAclPk">
<key-many-to-one name="codintacl" class="com.coginfo.kf.bean.Acl"/>
<key-many-to-one name="codintctg" class="com.coginfo.kf.bean.Categoria"/>
<key-property name="stsacl"/>
</composite-id>

<discriminator column="stsacl" insert="false"/>

<subclass name="com.coginfo.kf.bean.CategoriaAclAdm" discriminator-value="1"/>
<subclass name="com.coginfo.kf.bean.CategoriaAclSvil" discriminator-value="2"/>
<subclass name="com.coginfo.kf.bean.CategoriaAclCol" discriminator-value="3"/>
</class>
</hibernate-mapping>

- ACL

is a simple map with id and property cafute


I must write with Criteria this sql:
select ca.* from kft_categoria c, kft_acl_categoria ca, kft_acl acl
where ca.codintctg = c.codint and ca.codintacl = acl.codint and acl.cafute = 'AV09901' and ca.stsacl = '1'


Can anyone help me plz?

thanks

any help? any solutions?

You didn't really provide a whole lot of information, but here's a stab:



I don't really know how discriminators fit into Criteria queries; I suspect you would just reference the subclass in the initial createCriteria( ) call (I could be wrong). If I am, then you can probably do something like this:



Not sure, though. I suspect this is covered in the criteria query section of the documentation.

- Jesse

thanks, but i 've just wrote this code but it is not what i want, becouse, i would get all categories like this query :

select ca.* from kft_categoria c, kft_acl_categoria ca, kft_acl acl
where ca.codintctg = c.codint and ca.codintacl = acl.codint and acl.cafute = 'AV09901' and ca.stsacl = '1'


your solution find only records about this table: kft_acl_categoria.

I need a criteria that connect in join 3 tables. kft_categoria , kft_acl_categoria , kft_acl

thanks.

The query



Will only select columns from the "ca" alias (the kft_acl_categoria table), so I thought that was the desired result. I think you can use HQL to return maps of objects or you can use subselect fetching (which I know nothing about).

- Jesse