Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

hibernate undefined alias : 1 error

 
Barry Van
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Hi,
I am getting this error 'hibernate undefined alias : 1 error' when i write in hql .... and run the application

private void handleOccupationSearchCategory(StringBuffer fromClause,
StringBuffer whereClause, OccupationSearchCategory category) {
if (category != null && category.isEnabled()) {
logger.debug("Adding search criteria for occupation: " + category);
// fromClause.append(" inner join js.cvoJsOccugroups jsg ");
whereClause.append(" and js.id IN (").append(
"select 1 from CvoJsOccugroup as jsog ").append(
" where jsog.cvoOccugroup.id=").append(
category.getOccupationGroupId()).append(
" and jsog.cvoJobseeker.id=js.id");

// whereClause.append(" and
// jsg.cvoOccugroup.id=").append(category.getOccupationGroupId());
if (category.getExperienceLevelId() != null) {
whereClause.append(" and jsog.cvoExperienceLevel.id >=")
.append(category.getExperienceLevelId());
}
whereClause.append(")");
}
}
 
Lalit Bhatt
Ranch Hand
Posts: 69
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check if the line

select 1 from CvoJsOccugroup as jsog

should be

select jsog from CvoJsOccugroup as jsog
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic