Hi all,

I am using Hiberanate 3 on postgres.

I have a problem in using left outer join in HQL query.

the query . in @Named Query
query="select code, detail from Code code left outer join Detail detail
on (detail.id= code.id) where code.category = :category order by code.id"


Here the object Code is not mapped to object Detail.

I came across some threads in this forum but din help.

The same query works fine when i write in sql as sql query in the database directly..

I get the error:
Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Can't resolve reference to bean 'transactionInterceptor' while setting property 'transactionInterceptor'; nested exception is org.springframework.beans.factory.BeanCreationException...................

Is there anyway to join these 2 unmapped objects?

I want to join without mapping..
Please.. If anybody can help me with this..

Thanks in advance..

Waiting desperately for a reply..

No. Left joins are not possible unless you map an association between the entities.

Thanks for the reply..

Somehow i cannot associate these two tables at this point cos it ll interfere with the existing data.

So is there any other way to write the query which does the same without using join.



Thanks in advance.

I guess it would be possible with an SQL query. See http://www.hibernate.org/hib_docs/v3/re ... eries.html

Additional to nordborg's solution (if you want to stick with hql): You could do a cartesian product, so that an association is not necessary, e.g.:

Of course thats not as good as a join.