usage example of org.hibernate.Transformers.aliasToBean

CustomerDTO.java

public class CustomerDTO {
    
	private String firstName, lastName;

	// getter & setters

}

TransformersAliasToBeanDemo.java

import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.transform.Transformers;

...

SQLQuery query = session.createSQLQuery("SELECT FNAME as firstName, LNAME as lastName FROM CUSTOMER");
query.setResultTransformer(Transformers.aliasToBean(CustomerDTO.class));
query.addScalar("firstName").addScalar("lastName");
List<CustomerDTO> list = query.list();