With some code like this:

Then i need a projection like this:

It shouldn't create an instance of Course inside Student with the description??

Because is returning:
Could not find setter for course.description on class test.Student

If Student.java has and "courseDescription" property you should use:

pl.add(Projections.property("course.description"), "coursDescription");

Look at this example:

List resultWithAliasedBean = s.createCriteria(Enrolment.class)
.createAlias("student", "st")
.createAlias("course", "co")
.setProjection( Projections.projectionList()
.add( Projections.property("co.description"), "courseDescription" )
)
.setResultTransformer( new AliasToBeanResultTransformer(StudentDTO.class) )
.list();

StudentDTO dto = (StudentDTO)resultWithAliasedBean.get(0);

But no.... Student has an Object, Course, and this Course has a description (and an Id, etc)...
How can I transform it? :/



Thanks in advance... :)

Maybe what you need, then, is something like

c.createAlias("student", "student")
.createAlias("course", "course")
.setProjection( Projections.projectionList()
.add( Projections.property("course"), "course" )
)
.setResultTransformer( new AliasToBeanResultTransformer(StudentDTO.class) )
.list();

StudentDTO dto = (StudentDTO)resultWithAliasedBean.get(0);

Anyway, please post your POJOs and mappings and the results you want to achieve, your question is not very clear...

Sorry... i was trying to be short and direct to the point... but... here goes the code...

Student POJO


Course POJO


TestDAO


Now... the point is, I want to bring just what I need, because in my real application I have a lot of fields (properties) in the POJOs (both of them)...

Thanks again!

So... if i understand you what you want is to retrieve

studendt.id
student.name
course.description

only?

Then you need a StudentDTO.java like this:

class StudentDTO{
private Integer id;
private String courseDescription;
private String name;
}
and use the following projections:

Criteria c = SessionManager.getSession().createCriteria(Student.class);
c.createAlias("course", "course", CriteriaSpecification.LEFT_JOIN);
ProjectionList pl = Projections.projectionList();
pl.add(Projections.property("id"), "id");
pl.add(Projections.property("name"), "name");
pl.add(Projections.property("course.description"), "course.description");
c.setProjection(pl);
c.setResultTransformer(new AliasToBeanResultTransformer(StudentDTO.class));

Same error:
Could not find setter for course.description on class teste.StudentDTO

But, if i change to this:
pl.add(Projections.property("course.description"), "courseDescription");

It works as i thought...

But I wouldn't want to change my DTOs... Maybe in another time I would like to retrieve another property of Course, and them I would have to add it to StudentDTO...
And this is the subject of my post: Doesn't AliasToBeanResultTransformer create a child?
Meaning... Why this transformer doesn't create a Course inside of Student with the fields that I want to retrieve?

Thank you very very much again!!

Yes, sorry, i typed it wrong before



AliasToBeanResultTransformer only works with raw "properties". I mean, he will only call "setXXXXX()'s" one your Bean.


You can thank me rating a couple of my answers O:)

The maximum number of credit allotments for this topic has been reached.

But... thank you again! I'll code myself Transformer then... :D