,expected in select

[Amirtharaj Chinnaraj]

Hi,
i am trying to select two columns in the entity i am getting below error like

, expected in SELECT [select itc.interestTypeKey as interestTypeKey from com.org.state.dsl.btlds.admin.entities.InterestTypeCodeEntity itc ]

This is my java code , i am not able to figure out where iam doing mistake, Please help me in understanding the problem.

 String sql = "select itc.interestTypeKey as interestTypeKey , itc.interestTypeName as interestTypeName from InterestTypeCodeEntity itc  where itc.endDate is null ";
            Query q=getHibernateSession().createQuery(sql).setResultTransformer(Transformers.aliasToBean(InterestTypeCodeEntity.class));
            List<InterestTypeCodeEntity> interestTypeCodeEntities=q.list();

if i change the select query like as below it is working fine


String sql=" select new InterestTypeCodeEntity( itc.interestTypeKey , itc.interestTypeName) from InterestTypeCodeEntity itc where itc.endDate is null

i dont like to create any constructors in my class


Thanks
Amir

[Dave Tolls]

Just select itc.
You want the whole entity, so select it:

SELECT itc
FROM InterestTypeCodeEntity itc
WHERE etc etc

[Amirtharaj Chinnaraj]

Hi Dave,

Thanks for the reply.

i just want to select only the two columns not the whole entity.

Thanks
Amir

[Dave Tolls]

But you're assigning it to the entity:

List<InterestTypeCodeEntity> interestTypeCodeEntities=q.list();

which is where the problem is.

If you only want those two columns (as in your original query) then the returned List is a List<Object[]>.