100分解决Hibernate中的left outer join问题,在线等
数据库:orcale9i
hibernate 3.0
left outer join语句在plsql 运行正常,改成hql语句后,却报错误,不知道什么原因,请大家帮忙解决!
hql语句:
StringBuffer hsqlOneLine = new StringBuffer("select new Map(a.bank_code as bankCode,a.bank_name as bankName,a.bank_type as bankType,a.type_name " +
" as typeName,a.bif_code as bifCode,b.bankAcc as bankAcc,b.accName as accName,b.accType as accType,b.isgather as isGather,c.bankBal as bankBal,c.balDate as balDate ) from BtBankAcc b "+
" left outer join VBanKTypeAndBanK a on b.btBank.bankCode = a.bank_code "+
" left outer join BisAccHisBal c on b.bankAcc = c.id.bankAcc "+
" and b.validSign=1 and b.accountstate <> 4 "+
" and b.bisType=? "+
" and c.balDate=to_date(?,'yyyy-MM-dd')");