I am trying to filter a Enterprises Collection by segments (many-to-many relationship) but I get a Non-persistent collection Exception

My java code is:


objects=session.find(
"select Enterprise from Enterprise in class adama.supplier.Enterprise where deleted != ? order by name",
new Boolean(true),Hibernate.BOOLEAN);

Long seg=new Long(14);
Collection ents=hibernate.filter(objects, "where ? in this.segments", seg, Hibernate.LONG);
log.info("I found "+ents.size()+" enterpises with this segment");


Mapping documents:
<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="deleted"
type="boolean"
column="deleted"
/>


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

</class>




<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"
/>


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

</class>

Full stack trace of any exception that occurs:
SEVERE: Error filtering enterprises:cirrus.hibernate.TransientObjectException: Collection was not yet persistent

Name and version of the database you are using:

Hibernate.filter() works on persisted collections i.e. collections that are property of a persistent entity.

For example:



Where myEnterprise is an Enterprise instance loaded previously...

This filtering applies to a collection of a single entity - which is not what you want. It seems you need something like:

Yes. That is what I need, but it does not work.
I get a "SEVERE: Error filtering enterprises:cirrus.hibernate.QueryException: IN expected [from Enterprise as e where e.deleted=:isDeleted and :mySegment in e.segments]"

I don't know what is missing.... :(

My mistake... Try this one:



elements() keyword was missing to refer to the elements of the segments collection... Should be ok now (bit too late here - need some sleep ;)

Turn on SQL output and you will see the difference (log.4.logger.net.sf.hibernate.SQL=DEBUG)

Perhaps you could also do something like this:



But then you may have have duplicates...

I try that again and get the same result:

SEVERE: Error filtering enterprises:cirrus.hibernate.QueryException: IN expected [from Enterprise as e where e.deleted!=:isDeleted and :mySegment in elements(e.segments)]

And I try another adjust:

Query query = sessioncreateQuery("from Enterprise in class adama.supplier.Enterprise where Enterprise.deleted!=:isDeleted and :mySegment in elements(Enterprise .segments)");
query.setParameter("isDeleted", Boolean.TRUE);
query.setParameter("mySegment", new Long(segment));
objects = query.list();

and get the follow Exception:

SEVERE: Error filtering enterprises:cirrus.hibernate.QueryException: unindexed collection before [] [from Enterprise in class adama.supplier.Enterprise where Enterprise.deleted!=:isDeleted and :mySegment in elements(Enterprise.segments)]

Any idea? :.([/i]

This error comes from the first example I guess - not the second with the 'left join'...

Note sure yet why (need some sleep) but the :mySegment parameter must be an instance of "SupplierSegment" and not its ID (in both examples) !

If you don't have the SuppliedSegment entity loaded yet then this approach should do:

Check the docs,

I try te above QUERY, but the hibernate still trhowning a "IN Expected".

I try the 11.8 Chapther, but I get the same unindexed collection result.

I just trying to do it:

select Enterprise from Enterprise,SupplierSegmentEnterpriseXref where SupplierSegmentEnterpriseXref.segment=14 and Enterprise.oid=SupplierSegmentEnterpriseXref.enterprise and Enterprise.deleted !=1

...with the follow map file:


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

I already try the session.createSQLQuery, but my hibernate does not seem to have this method.

Where can I search more documentation, hints,.... :(

Sorry but can't believe the example 2 posts before can throw the "IN expected" exception - there is simply no IN involved ...

Try to post a complete stack trace and an excerpt of the Hibernate log at debug level... It might help.

I will try that.
Thank you for all your help.
Beleive me:You help me a lot.
I will trace all the system, step by step.