1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
return(List) super.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(org.hibernate.Session session)
throws HibernateException, SQLException {
Object o= session.createSQLQuery(
select
rn.date
ins.NAME
DRRAS.CODE
rra.DESC
from
Rra_ins RRA,
rnt_agrs rn,
ins_typs INS,
dvr_rras DRRAS
where
rn.RNT_AGR_NBR=rra.RDY_RNT_AGR_NBR(+)
and rra.INT_INS_TYP_ID=ins.INS_TYP_ID(+)
and rra.INT_CRY_ARIMP_CRY_CD=ins.CRY_ARIMP_CRY_CD(+)
and rn.RNT_AGR_NBR=DRRAS.RDY_RNT_AGR_NBR
.addScalar("date", Hibernate.TIMESTAMP)
.addScalar("NAME", Hibernate.STRING)
.addScalar("CODE", Hibernate.STRING)
.addScalar("DESC", Hibernate.STRING) |
Partager