Search code examples
hibernatehqlcriteriajpql

Hibernate Criteria: Projection with TransferObject


How could I Convert the HQL code below to a Hibernate Criteria query?

SELECT
    new com.project.to.PersonTO(
        person.firstName,
        person.lastName
    )
FROM
    Person person

Solution

  • Try Below :-

    Criteria criteria = session.createCriteria(Person.class);
    criteria.setProjection(Projections.projectionList().add(Projections.property("firstName"), "firstName") .add(Projections.property("lastName"), "lastName"))
                        .setResultTransformer(new AliasToBeanResultTransformer(PersonTO.class));