Hi,

I have a one-to-many mapping between two of my classes, what I want to archive is that only one of the child gets retrieved when the parent is retrieved.

How can i achieve this, I tried to set lazy="false" and batch-fetch-size as 1, at the same time changed the fetch strategy to Join, but this doesn't seem to be working.

Is there any other way I can achieve this.Can i write a query which can help me do this.I need only one of the child's to be displayed.

Thanks,
Rohit

Take a look at the org.hibernate.Query API, in particular the setFirstResult() and setMaxResults() methods.

Hi,

Thanks for the help, but this will return one or more records.

My requirement is that i want all the parent records but only one child for each parent.

Thanks,
Rohit

Hi,

Thanks for the help, but this will return one or more records.

My requirement is that i want all the parent records but only one child for each parent.

Thanks,
Rohit

Try this....


1. setFirstResult(1)
2. setMaxResults(1)



Maybe this would work....

Do you need something like this?



and when you execute this set the maximum results to 1.

this is pretty much crap but it would work


public void setChildren(List<Child> children) {
this.children = children.subList(0, 1);
}

obviously you'd want some bounds & null checks in there. More obviously you're probably looking for a solution at the db/hibernate level, just thought I'd throw this out there as a potential idea.

Don't forget to rate

Is there something new?

I have a Parent with a List of Children. There can be thousands of children which were added over the applications life time.
Often I only want to load the newest child. (I use Criteria, Fluent NHibernate)

Is there meanwhile a meachnismen that (N)Hibernate do not load all children of the list in such a case?
I tried multiple thinks, but have no success.