Invoice.java


StatusChange .java


if I want to get the list of invoice objects whose history include a record its isCurrent=true and status='new', and I do not want to use HQL but would rather the Criteria like this:

Criteria criteria =session.createCriteria(Invoice.class)
.add(...

How to do it?


[/code]

I think this is what you are looking for:

Sorry, I didn't notice that the history objects was a List.

Hi

You can use Expression for this
e.g crt.add(Expression.eq("status", "new"));

so you will see a where clause in the Hibernate generated Query with status.

Almost correct ;)



The base Criteria you specify by Class.. each relation you specify by creating a criteria for that relation by attribute name.

So this works as well:


N.B.

You property isCurrent should be called only current.
The methods for this property than will be isCurrent() and setCurrent();
That is the normal standard for boolean attributes.

And I thought that the reflection, used by Hibernate will search for a 'get' or 'is' method to get the attributes value.

So if you specify 'isCurrent' in you Criteria, Hibernate will probably seach for getIsCurrent() or isIsCurrent ;)[/b]

Hibernate will return a "collection was not an association" error if the history object is mapped with composite-element.

When using the composite element mapping, you must use hql:


I realize this is a slightly different case, however Truecolor simply needs to use invoice.history.status = ? in the hql instead.

So it looks like you cannot do this without using HQL. The problem lies in that the history is a List instead of a direct association.

Did anyone managed to create Criteria query (not HQL) that sets constraints on collection elements that are composite-elements?

If no one did, should this be reported as a bug?

Basically it fails on CollectionType.getAssociatedEntityName check:



Simply component in not entity.

PLEASE... Can I make Criterias with <composite-element... /> ONE-TO-MANY or MANY-TO-MANY?

Leonardo.

I'm waiting for an answer to this question too. Anyone can help with this?

Found a way to restrict components of classes:

public class MyClass
{
MyComponent myComponent;

setter
getter
}

public class MyComponent
{
String myVariable

setter
getter
}



Criteria c = session.createCriteria(clazz);
c.add(Restrictions.eq("myComponent.myVariable","restriction"));
c.list();

Hope this is what your after

I used HQL instead of Criteria query at last:

This was a helpful post. For hours I struggled why I couldn't query the elements of my collection in a composite element:
<class name="lbControl.Pool" table="pools">

...

<set name="members" table="poolmembers" cascade="all">
<key column="pool_id"/>
<composite-element class="lbControl.PoolMember">
<many-to-one name="service" class="lbControl.Service" cascade="all">
<column name="service_id"/>
</many-to-one>
<property name="ratio" type="long"/>

</composite-element>
</set>

now this HQL wasn't working

select pool from Pool pool where pool.members.service.name = "foo"

I got complaints net.sf.hibernate.QueryException: expecting 'elements' or 'indices' after: name.

for some reason this works though

select pool from Pool pool join pool.members as members where members.service.name = "foo"

Does anyone understand why? And why this is so dreadfully documented? Neither the Hibernate online docs, "Hibernate Programmers Notebook," nor "Hibernate in Action" made clear the need for this syntax. It seems like a rather arbitrary requirement.

I have exactly the same problem. Have you find the reason?

Andrew