使用Hibernate出现ORA-00921: unexpected end of SQL command错误，那位达人给解释下，在线等

wenquan_java126com 2009-01-06 10:18:10

public List<Map> findAllWithPopedom(final String deptno) {
try {
List list = getHibernateTemplate().executeFind(
new HibernateCallback() {

public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Connection conn = session.connection();
Statement stmt = conn.createStatement();
String sql = "select ap.* ,d.deptname from PC_APPLYCARD ap,PC_DEPARTMENT d "
+ " where (ap.deptno = d.deptno or ap.deptno = d.pardept ) and ap.deptno = "
+ deptno + "";
List<Map> list = new ArrayList<Map>();
try {
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
Map<String, String> map = new HashMap<String, String>();
map.put(ID, rs.getString(ID));
map.put(SEQNO, rs.getString(SEQNO));
map.put(BASETYPE, rs.getString(BASETYPE));
map.put(AREATYPE, rs.getString(AREATYPE));
map.put(FUNTYPE, rs.getString(FUNTYPE));
map.put(MONEY, rs.getString(MONEY));
map.put(MONEYEX, rs.getString(MONEYEX));
map.put(DEPTNO, rs.getString(DEPTNO));
map.put(APPLYDATE, DateHelper.dateToStr(rs
.getDate(APPLYDATE), "yyyy-MM-dd"));
map.put(NOTES, rs.getString(NOTES));
map.put(CARDCOUNT, rs.getString(CARDCOUNT));
map.put(ENDDATE, DateHelper.dateToStr(rs
.getDate(ENDDATE), "yyyy-MM-dd"));
map.put(STATUS, rs.getString(STATUS));
map.put(DESIGN, rs.getString(DESIGN));
map.put(DEPTNAME, rs.getString(DEPTNAME));
list.add(map);
}
rs.close();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
try {
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
});
return list;
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}

...全文