I keep getting this error

INFO: org.springframework.orm.hibernate.HibernateQueryException: undefined alias: fileN [SELECT fileN,workItemTyC,workItemSbtyC,accN,usTaxIdN,orgId,orgNm,creD,lstEvtD,archD,workDesc,nysePrblC,nysePrdC,fstNm,lstNm,xmlXSz,tsfString FROM com.fmr.xtrac.hibernate.TTkawArchWorkItem WHERE orgId = ? AND workItemSbtyC = 'DUSA']; nested exception is net.sf.hibernate.QueryException: undefined alias: fileN [SELECT fileN,workItemTyC,workItemSbtyC,accN,usTaxIdN,orgId,orgNm,creD,lstEvtD,archD,workDesc,nysePrblC,nysePrdC,fstNm,lstNm,xmlXSz,tsfString FROM com.fmr.xtrac.hibernate.TTkawArchWorkItem WHERE orgId = ? AND workItemSbtyC = 'DUSA']

Here is the code I am using


List WorkItemSearchResultList =
_hibernateTemplate.find(
"SELECT fileN,"
+ "workItemTyC,"
+ "workItemSbtyC,"
+ "accN,"
+ "usTaxIdN,"
+ "orgId,"
+ "orgNm,"
+ "creD,"
+ "lstEvtD,"
+ "archD,"
+ "workDesc,"
+ "nysePrblC,"
+ "nysePrdC,"
+ "fstNm,"
+ "lstNm,"
+ "xmlXSz,"
+ "tsfString"
+ " FROM com.fmr.xtrac.hibernate.TTkawArchWorkItem "
+ "WHERE orgId = ?" + createSearchWhereClause(srchCriteria),
new Object[] {new BigDecimal(cookie.getOrgId())},
new Type[] {Hibernate.BIG_DECIMAL });

Please read http://www.hibernate.org/hib_docs/v3/re ... hql-select

You need to alias the class you're selecting from. Instead of:



you need to be aliasing the class, and then referring back to it in the column:



(Should work, AFAIK)

I'm not really seeing why you need to even specify the select portion, anyway. Just using:

should suffice.

I would highly suggest looking at the Criteria API--especially since you appear to be building the where clause on-the-fly.

http://www.hibernate.org/hib_docs/v3/re ... teria.html