I tried to upgrade the hibernate jars in my application
Old Hibernate Version: 3.2.1.ga
Upgraded Hibernate Version:
Package Version Release date Category
===============|===========|================================
Hibernate Core | 3.2.5.ga | 31.07.2007 Production
-------------------|-----------|---------------------------------
Hibernate | 3.3.0 GA | 20.03.2007 Production
Annotations | |
---------------|-----------|---------------------------------


And i get the exception,
org.hibernate.hql.ast.QuerySyntaxException: with-clause referenced two different from-clause elements

for this HQL
select new com.wsi.mm.model.directship.vo.ItemDirectShipSearchResultVO
(item.id, item.description, item.style.id, directShipItemAttribute )
from com.wsi.mm.model.item.ItemImpl item join item.department department
join department.group bannerGroup with bannerGroup.id=:bannerId
left outer join item.directShipItemAttributes directShipItemAttribute with
directShipItemAttribute.class=DirectShipItemAttribute
and directShipItemAttribute.banner=:directShipItemAttribute_banner
and directShipItemAttribute.supplier=:directShipItemAttribute_supplier
join item.itemSuppliers itemSupplier with itemSupplier.class = DirectShipItemSupplier
and itemSupplier.supplier.id=:itemSupplier_supplier_id
where ( item.itemLevel = item.transactionLevel and item.statusCode = 'A'
and (item.id in (select iim2.id from com.wsi.mm.model.item.ItemImpl iim2 where iim2.packFlag = 1)
or item.id in (select iim3.id from com.wsi.mm.model.item.ItemImpl iim3 where iim3.class = SkuImpl ))
and item.department.id=:item_department_id )

Does anyone knows what's wrong or need to change, as this works fine with older version of hibernate.

Thanks