Fórum

Failing execution dynamic query

thumbnail
jaid shaik, modificado 11 Anos atrás.

Failing execution dynamic query

Regular Member Postagens: 171 Data de Entrada: 08/10/10 Postagens Recentes
Hi,


String mobile = ParamUtil.getString(resourceRequest, "mobilePhone");
	DynamicQuery query  = DynamicQueryFactoryUtil.forClass(Phone.class, PortalClassLoaderUtil.getClassLoader())
						.add(PropertyFactoryUtil.forName("number_").eq((mobile)));



Failing the above line execution

Caused by: org.hibernate.QueryException: could not resolve property: number_ of: com.liferay.portal.model.impl.PhoneImpl
	at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)
	at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:75)
	at org.hibernate.persister.entity.AbstractEntityPersister.getSubclassPropertyTableNumber(AbstractEntityPersister.java:1468)
	at org.hibernate.persister.entity.BasicEntityPropertyMapping.toColumns(BasicEntityPropertyMapping.java:62)
	at org.hibernate.persister.entity.AbstractEntityPersister.toColumns(AbstractEntityPersister.java:1443)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumns(CriteriaQueryTranslator.java:483)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumnsUsingProjection(CriteriaQueryTranslator.java:443)
	at org.hibernate.criterion.SimpleExpression.toSqlString(SimpleExpression.java:68)
	at org.hibernate.loader.criteria.CriteriaQueryTranslator.getWhereCondition(CriteriaQueryTranslator.java:380)
	at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:114)
	at org.hibernate.loader.criteria.CriteriaJoinWalker.<init>(CriteriaJoinWalker.java:83)
	at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:92)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1687)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:88)
	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:83)
	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:117)
	... 180 more
</init></init></init>


can any one help in this, where am doing wrong.

Thanks
thumbnail
Gnaniyar Zubair, modificado 11 Anos atrás.

RE: Failing execution dynamic query

Liferay Master Postagens: 722 Data de Entrada: 19/12/07 Postagens Recentes
Try number instead of number_

.add(PropertyFactoryUtil.forName("number").eq((mobile)));
thumbnail
jaid shaik, modificado 11 Anos atrás.

RE: Failing execution dynamic query

Regular Member Postagens: 171 Data de Entrada: 08/10/10 Postagens Recentes
Thanks Zubair bhai,


It works great emoticon