Hi!
I'm using Hibernate tools for Eclipse but I have found an error that I think is from Hibernate core.
First of all, is "FULL JOIN" supported in HQL?
I'm trying to make a query like this
from Example ex
full join ex.propertyA AnotherClass
ant Hibernate tools says:
org.hibernate.AssertionFailure: undefined join type 23
I've gone to the code of JoinProcessor.java (
http://www.koders.com/java/fid90BBCC560 ... DA6E3.aspx)
and I found that:
Code:
public static int toHibernateJoinType(int astJoinType) {
switch ( astJoinType ) {
case LEFT_OUTER:
return JoinFragment.LEFT_OUTER_JOIN;
case INNER:
return JoinFragment.INNER_JOIN;
case RIGHT_OUTER:
return JoinFragment.RIGHT_OUTER_JOIN;
default:
throw new AssertionFailure( "undefined join type " + astJoinType );
}
}
don't supports something like "FULL_OUTER" or "FULL_JOIN"
but in JoinFragment.java it appears:
Code:
public static final int INNER_JOIN = 0;
public static final int FULL_JOIN = 4;
public static final int LEFT_OUTER_JOIN = 1;
public static final int RIGHT_OUTER_JOIN = 2;
Does this means that full outer joins aren't supported for HQL? And if yes, what is the reason? Is any workaround?
Thanks for the responses
Hibernate version:
3.0
Full stack trace of any exception that occurs:
org.hibernate.AssertionFailure: undefined join type 23
Name and version of the database you are using:
Oracle 10g (Oracle9Dialect)