Hi,

I have 2 entities with a join condition on column BOOK_ID. One is Chapter, which has its own BOOK_ID column and one is Book whose getId() column is also BOOK_ID. Note that I have not done a many-to-one mapping on Chapter.BOOK_ID to let Hibernate know about the possible join.

I'm trying to use createSQLQuery:

select c.CHAPTER_ID, (b.*)
from CHAPTERS c
join BOOKS b
on b.BOOK_ID = c.BOOK_ID
where c.CHAPTER_ID in (:idlist)

and my java snippet to create this query with bindings is:

SQLQuery q = createSQLQuery(above_snippet);
q.addEntity("c", Chapter.class);
q.addEntity("b", Book.class);
q.addJoin("b", "c.bookId");
q.setParameterList("idlist", idarray, new LongType());

then execute and get ClassCastException:

Exception in thread "main" java.lang.ClassCastException: org.hibernate.type.LongType
at org.hibernate.loader.custom.CustomLoader.<init>(CustomLoader.java:174)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1715)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)

Am I doing something wrong, or is it not possible to use SQLQuery with join unless you have a Hibernate many-to-one mapping on the join column.

Andy

Have you tried with:


Christophe

Yes, I tried this, with the same result. It appears that hibernate parses the native SQL query to marshall objects, and it only allows me to do table joins on business objects that I've given it many-to-one relationships on. I'm really disappointed.