wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes hibernate undefined alias : 1 error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernate undefined alias : 1 error" Watch "hibernate undefined alias : 1 error" New topic

hibernate undefined alias : 1 error

Barry Van

Joined: Oct 23, 2008
Posts: 22

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(
" 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 >=")
Lalit Bhatt
Ranch Hand

Joined: Dec 27, 2007
Posts: 69
Check if the line

select 1 from CvoJsOccugroup as jsog

should be

select jsog from CvoJsOccugroup as jsog

Java-JavaEE Hibernate Spring Spring Roo Web Applications
I agree. Here's the link: http://aspose.com/file-tools
subject: hibernate undefined alias : 1 error
Similar Threads
Java & Outlook integration - how to go about it
Adding nulls to stringbuffers
How to write such an EJB-QL
Fake a post request from java class
Problem With Algorithm Involving Recursion and String Manipulation