Hibernate 3 not able to recognize the "ON" word in sql

tkartik · **Joined:** Tue Nov 10, 2009 10:36 am **Posts:** 1

Hello All,
Am using hibernate with MSSQL where am having a query which is joining 4 tables with "ON" condition

Code:

SELECT
 V.Description AS Vendor, P.ProductNumber, R.VendorItemNumber, P.Description, ISNULL(I.InventoryAmount, 0) AS InventoryAmount,
ISNULL(I.ThresholdAmount, 0) AS ThresholdAmount
FROM  tbProducts P  JOIN tbRacks R  ON P.ProductNumber = R.ProductNumber  JOIN tbRacksVendors V   ON R.VendorID = V.VendorID
 LEFT JOIN tbInventory I   ON P.ProductNumber = I.ProductNumber  Join tbBrands T   ON P.brandid=T.brandid  order by
  V.Description asc

Its giving an error at "ON" condition even I checked "WITH" condition but failed even with that.
But the same code is working in MSSQL properly, so the problem is with Hibernate

mmerder · **Posted:** Wed Nov 11, 2009 9:07 am

Remember that in HQL joinColumns are automatically inserted, these are read from your mapping file.
http://docs.jboss.org/hibernate/stable/core/reference/en/html_single/#queryhql-joins