I have a trouble driving me crazy.

I have 2 objects:

Enterprises and Segments and a one-to-many relationship between them.

I have a primary key from a Segment (14) and need in just one step get all Entreprises with this segment.
I try a lot of thinks buy can not do that.

I need to filter some another properties of enterprise too.
I have now:

"select Enterprise from Enterprise in class adama.supplier.Enterprise " +
"where Enterprise.deleted != ? and ? in Enterprise.segments " +
"order by name",
{Boolean, Long}

segments is a List

Please, I really need some help.

Well, if your really need our help, why not post your mapping documents. The red box you know.

HTH
Ernst

Number 1: Sure
Number 2: Sorry. I am confusing, for now, and forget it. ;)
Number 3: Thanks a lot.


<hibernate-mapping>
<class
name="adama.supplier.SupplierSegment"
table="SupplierSegment"
>

<id
name="oid"
column="oid"
type="long"
>
<generator class="native">
</generator>
</id>

<property
name="descr"
type="java.lang.String"
column="descr"
/>

<property
name="name"
type="java.lang.String"
column="name"
/>

<property
name="status"
type="int"
column="status"
/>

<bag role="suppliers" table="SupplierSegmentEnterpriseXref">
<key column="segment"/>
<many-to-many column="enterprise" class="adama.supplier.Enterprise"/>
</bag>

</class>

</hibernate-mapping>

<hibernate-mapping>
<class
name="adama.supplier.Enterprise"
table="Enterprise"
>

<id
name="oid"
column="oid"
type="long"
>
<generator class="native">
</generator>
</id>

<property
name="name"
type="java.lang.String"
column="name"
/>

<property
name="descr"
type="java.lang.String"
column="descr"
/>

<property
name="cnpj"
type="java.lang.String"
column="cnpj"
/>

<property
name="ie"
type="java.lang.String"
column="ie"
/>

<property
name="im"
type="java.lang.String"
column="im"
/>

<property
name="status"
type="int"
column="status"
/>

<property
name="supplier"
type="boolean"
column="supplier"
/>

<property
name="deleted"
type="boolean"
column="deleted"
/>

<property
name="fantasy"
type="java.lang.String"
column="fantasy"
/>

<property
name="email"
type="java.lang.String"
column="email"
/>

<property
name="website"
type="java.lang.String"
column="website"
/>

<property
name="obs"
type="java.lang.String"
column="obs"
/>

<property
name="address"
type="java.lang.String"
column="address"
/>

<property
name="addressType"
type="int"
column="addressType"
/>

<property
name="addressNumber"
type="int"
column="addressNumber"
/>

<property
name="complement"
type="java.lang.String"
column="complement"
/>

<property
name="zip"
type="java.lang.String"
column="zip"
/>

<property
name="city"
type="java.lang.String"
column="city"
/>

<property
name="county"
type="java.lang.String"
column="county"
/>

<many-to-one
name="state"
class="com.md5.geo.State"
cascade="none"
outer-join="auto"
column="state"
/>

<many-to-one
name="country"
class="com.md5.geo.Country"
cascade="none"
outer-join="auto"
column="country"
/>

<property
name="client"
type="boolean"
column="client"
/>

<bag role="segments" table="SupplierSegmentEnterpriseXref">
<key column="enterprise"/>
<many-to-many column="segment" class="adama.supplier.SupplierSegment"/>
</bag>

<bag role="contacts" table="EnterpriseContactXref">
<key column="enterprise"/>
<many-to-many column="person" class="adama.sell.Person"/>
</bag>

</class>

</hibernate-mapping>