Hello,
I'm unable to do a right outer join. It fails because OracleJoinFragment.java throws an exception.
Code:
public void addJoin(String tableName, String alias, String[] fkColumns, String[] pkColumns, int joinType, String on) {
//arbitrary on clause ignored!!
addJoin( tableName, alias, fkColumns, pkColumns, joinType );
if ( joinType == JoinFragment.INNER_JOIN ) {
addCondition( on );
}
else if ( joinType == JoinFragment.LEFT_OUTER_JOIN ) {
addLeftOuterJoinCondition( on );
}
else {
throw new UnsupportedOperationException( "join type not supported by OracleJoinFragment (use Oracle9Dialect)" );
}
}
I'm using hibernate 3.0.5 and oracle 11g. Here it is my HQL request :
Code:
select distinct a.toto from b right join b.a
Is there a way to perform a right outer join with this version of hibernate.
Thanks in advance.