Alex Rivera | Logout

Hibernate's Transformers.aliasToBean() method

Asked 2010-03-15T04:33:14.620
17
 Query query =  getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery(
                 "select proj_employee.employee_no as employeeNo, ...
 .setResultTransformer(Transformers.aliasToBean(User.class));

Inside User.class does the property employeNo need to be in capital letter?

private String EMPLOYEENO; 
//get/set for EMPLOYEENO


If I change the EMPLOYEENO to small letter, it doesn't work. Can anyone explain why the variable name must be all capital letters?

Edit
Report

1 Answer

13

Consider putting column aliases in double quotes. Oracle doesn't uppercase aliases specified in double quotes.

Query query =  getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery(
                 "select proj_employee.employee_no \"employeeNo\", ...
 .setResultTransformer(Transformers.aliasToBean(User.class))

;

answered 2010-06-17T13:24:52.240

Your Answer