Hibernate Community • View topic - left join fetch question...

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

left join fetch question...

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jpestrada

Post subject: left join fetch question...

Posted: Fri Jun 13, 2008 5:55 am

Newbie

Joined: Sun Jul 01, 2007 12:15 pm
Posts: 7
Location: Philippines

I have this query:

from CustomerActivitySector cca where cca.customer_id.customer_id=:x left join fetch cca.activity_sector_id

Is there something wrong with the syntax? Why am i having this error?:

Exception in thread "main" org.hibernate.HibernateException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: left near line 1, column 92 [from com.ibm.pli.databeans.CustomerActivitySector cca where cca.customer_id.customer_id=:x left join fetch cca.activity_sector_id left join fetch cca.customer_id]
at com.ibm.pli.DAO.AbstractDAO.handleException(AbstractDAO.java:116)
at com.ibm.pli.DAO.CustomerActivitySectorDAO.find(CustomerActivitySectorDAO.java:115)
at com.ibm.pli.model.test.MyTest.testRetrieval(MyTest.java:38)

Top

mar

Post subject:

Posted: Fri Jun 13, 2008 9:08 am

Regular

Joined: Thu Dec 22, 2005 7:47 am
Posts: 62
Location: Czech Republic

Code:

from CustomerActivitySector cca
where cca.customer_id.customer_id=:x
left join fetch cca.activity_sector_id 

try it this way :)