No Dialect mapping for JDBC type: 1111 with sum function

Vote count:

0

it normally runs on Oracle Database, but does not run on DB2 with sum function !!! help me!!!!!!! if(saleReportForm.getSelectService().equals("All") && !saleReportForm.getTransactionAction().equals("0") && saleReportForm.getSelectPartners().equals("-1")){ sql=" select to_char(sta_datetime, 'dd/MM/yyyy'), sum(charge) from " + " ( " + " (select info3, info1,sta_datetime, called_number,charge from bccs_gw.VAS_CALL_POST " + " where sta_datetime > to_date(?,'dd/MM/yyyy') " + " and sta_datetime < to_date(?,'dd/MM/yyyy') " + " and info3=? ) " + " union all " + " (select info3, info1,sta_datetime, called_number,charge from bccs_gw.VAS_CALL_PRE " + " where sta_datetime > to_date(?,'dd/MM/yyyy')" + " and sta_datetime < to_date(?,'dd/MM/yyyy') " + " and info3=? ) " + " )" + " group by to_char(sta_datetime, 'dd/MM/yyyy')" + " order by to_char(sta_datetime, 'dd/MM/yyyy') "; Query q = getSession("chargw").createSQLQuery(sql); q.setParameter(0, CVFirstDayMonth(saleReportForm.getSelectMonth().toString())); q.setParameter(1, CVFirstDayMonLater()); q.setParameter(2, saleReportForm.getSelectPartners().toString()); q.setParameter(3, saleReportForm.getTransactionAction().toString()); q.setParameter(4, saleReportForm.getSelectService().toString()); q.setParameter(5, CVFirstDayMonth(saleReportForm.getSelectMonth().toString())); q.setParameter(6, CVFirstDayMonLater()); q.setParameter(7, saleReportForm.getSelectPartners().toString()); q.setParameter(8, saleReportForm.getTransactionAction().toString()); q.setParameter(9, saleReportForm.getSelectService().toString()); lst = q.list(); }

asked 52 secs ago

Nguyễn Nghĩa

1

No Dialect mapping for JDBC type: 1111 with sum function