Hi
I am having problem in writing qry in hibernate i want to left join programinstance with other tables .

i have writen following qry in mysql . it is working .

this is thw qry

SELECT *
FROM users u
JOIN (
emaillogs e, contacts c
) ON ( u.usersId = e.usersId
AND c.usersId = u.usersId )
LEFT JOIN programinstance pi ON pi.programinstanceId = e.programinstanceId
ORDER BY `e`.`typeOfEmail` ASC

when i write same qry in createQuery it is giving syntax error near JOIN ( . un expected token " ("

thanks





Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

I am unfamiliar with that join notation.
I always specify one join at a time, i.e.:

thanks for the query . query is fetching the desired result .
but i am using createQuery method to execute this query

i am getting followng exception
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1,

is it possible to give join in the createQuery method ?

It is.
What you are getting is some minor SQL error (probably those apostrophes?).

If you know how to send the generated SQL statements to a log (I explain how to do it here), you can copy that generated SQL statement and try to execute it on your database directly.

That will quickly tell you what the problem is.