issue in HQL

[Amitosh Mishra]

Hi all,

i am very new Hibernate.

please help me to understand the issue..
query

  " FROM CCLS as ccls, CLS as cls WHERE cls.cusCountryLocaleSgmntId= ccls.id "
				+ "AND ( ccls.helpUserSegmentTypeCode = 'DEFLT' OR ccls.helpUserSegmentTypeCode = 'Business' )"

but iam getting exception

Exception in thread "main" org.hibernate.QueryException: could not resolve property: cusCountryLocaleSgmntId of: 
com.test.hibernate.model.CLS [ 
FROM com.test.hibernate.model.CCLS as ccls, com.test.hibernate.model.CLS as cls 
WHERE cls.cusCountryLocaleSgmntId= ccls.id 
AND ( ccls.helpUserSegmentTypeCode = 'DEFLT' OR ccls.helpUserSegmentTypeCode = 'Business' )]
	at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:44)
	at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:38)
	at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1362)
	at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:279)
	at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:386)
	at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:567)
	at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:241)
	at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:188)
	at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:94)
	at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:90)
	at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:728)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1216)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4041)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3525)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1687)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
	at com.util.MainClass.main(MainClass.java:19)

object classes are
CLS.java

package com.test.hibernate.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "CUS_CHANNEL_LISTING")
public class CLS {
	private long cusCountryLocaleSgmntId;
	private String cusChannelCode;
	private String cusVisibilityTypeCode;
	private long channelDisplayOrder;
	private long timeCreated;

	@Id
	@Column(name = "CUS_COUNTRY_LOCALE_SEGMENT_ID")
	public long getCusCountryLocaleSgmntId() {
		return this.cusCountryLocaleSgmntId;
	}

	public void setCusCountryLocaleSgmntId(long cusCountryLocaleSegmentId) {
		this.cusCountryLocaleSgmntId = cusCountryLocaleSegmentId;
	}

	@Id
	@Column(name = "CUS_CHANNEL_CODE")
	public String getCusChannelCode() {
		return this.cusChannelCode;
	}

	public void setCusChannelCode(String cusChannelCode) {
		this.cusChannelCode = cusChannelCode;
	}

	@Column(name = "CUS_VISIBILITY_TYPE_CODE")
	public String getCusVisibilityTypeCode() {
		return this.cusVisibilityTypeCode;
	}

	public void setCusVisibilityTypeCode(String cusVisibilityTypeCode) {
		this.cusVisibilityTypeCode = cusVisibilityTypeCode;
	}

	@Column(name = "CHANNEL_DISPLAY_ORDER")
	public long getChannelDisplayOrder() {
		return this.channelDisplayOrder;
	}

	public void setChannelDisplayOrder(long channelDisplayOrder) {
		this.channelDisplayOrder = channelDisplayOrder;
	}

	@Column(name = "TIME_CREATED")
	public long getTimeCreated() {
		return this.timeCreated;
	}

	public void setTimeCreated(long timeCreated) {
		this.timeCreated = pyplTimeTouched;
	}

	
}

CCLS.java

package com.test.hibernate.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "CUS_COUNTRY_LOCALE_SEGMENT")
public class CCLS {

	private long id;
	private String countryCode;
	private String helpUserSegmentTypeCode;
	private long timeCreated;
	private String locale;
	

	@Id
	public long getId() {
		return this.id;
	}

	public void setId(long id) {
		this.id = id;
	}

	@Column(name = "COUNTRY_CODE")
	public String getCountryCode() {
		return countryCode;
	}

	public void setCountryCode(String countryCode) {
		this.countryCode = countryCode;
	}

	public String getLocale() {
		return locale;
	}

	public void setLocale(String locale) {
		this.locale = locale;
	}

	@Override
	public String toString() {
		return "CCLS [id=" + id + ", countryCode=" + countryCode
				+ ", helpUserSegmentTypeCode=" + helpUserSegmentTypeCode
				+ ", timeCreated=" + timeCreated + ", locale=" + locale + "]";
	}

	@Column(name = "HELP_USER_SEGMENT_TYPE_CODE")
	public String getHelpUserSegmentTypeCode() {
		return helpUserSegmentTypeCode;
	}

	public void setHelpUserSegmentTypeCode(String helpUserSegmentTypeCode) {
		this.helpUserSegmentTypeCode = helpUserSegmentTypeCode;
	}

	@Column(name = "TIME_CREATED")
	public long getTimeCreated() {
		return this.timeCreated;
	}

	public void setTimeCreated(long timeCreated) {
		this.timeCreated = timeCreated;
	}
}

regards
Amitosh

[Jelle Klap]

The composite key mapping in the CLS class is wonky.
Have a look at the Hibernate reference material on the subject.

[Amitosh Mishra]

Thanks Jelle Klap,

i am to resolve the issue .
can you suggest me how can i use criteria for such queries

query i am trying to process is

select ccls.countryCode, ccls.locale ,ccls.helpUserSegmentTypeCode,cls.id.cusCuntryLcaleSgmntId,cls.id.cusChannelCode,cls.cusVisibilityTypeCode,cls.channelDisplayOrder FROM CCLS  ccls, CLS  cls WHERE cls.id.cusCuntryLcaleSgmntId=ccls.id "
				+ "AND ( ccls.helpUserSegmentTypeCode = 'DEFLT' OR ccls.helpUserSegmentTypeCode = 'Business' )

regrads
Amitosh

[Bill Gorder]

Take a look at the link Jelle provided.

You cannot have multiple @Id annotations on one @Entity without an @IdClass defined. Alternatively you can define an @EmbeddedId