Problem with org.hibernate.hql.ast.ASTQueryTranslatorFactory

tvan · **Joined:** Fri Aug 04, 2006 12:27 pm **Posts:** 14

Hi,
My application generates bug when I use
org.hibernate.hql.ast.ASTQueryTranslatorFactory. The exception is

Code:

org.hibernate.QueryException: could not resolve property: bholding of: com.bholding.model.domain.Company [SELECT count(*) FROM com.bholding.model.domain.Company AS com WHERE com.name_fr = 'TMASOLUTION' AND com.comId IN(SELECT ad.company FROM com.bholding.model.domain.Address AS ad WHERE upper(ad.street) like '%ALBERT%' )]
   at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(AbstractPropertyMapping.java:43)
   at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:37)
   at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1265)
   at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:279)
   at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:372)

bholding is just the name of a folder, nothing to see with the property of classes such as Company or Address. If I use org.hibernate.hql.classic.ClassicQueryTranslatorFactory, this exception does not occur.
Please let me know if you have any idea about this problem.
I use Hibernate-3.1.3.jar and antlr-2.7.5H3.jar. I have tried with the most recent versions of Hibernate and Antlr.
Thank you in advance.
Tvan

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

I suggest changing the name of your alias from "com" to anything else. The parser can't tell the difference between com the package and com the alias.

tvan · **Joined:** Fri Aug 04, 2006 12:27 pm **Posts:** 14

Hi Tenwit,
It is great from you to see this problem. I have changed the name of the alias and it is OK now.
Thank you a lot
Best wishes
Tvan