Fórum
Failing execution dynamic query
jaid shaik, modificado 11 Anos atrás.
Failing execution dynamic query
Regular Member Postagens: 171 Data de Entrada: 08/10/10 Postagens Recentes
Hi,
Failing the above line execution
can any one help in this, where am doing wrong.
Thanks
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
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)));
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
It works great