public Long callProc(final String proc,final List<Object> paramList,final int outIndex, final int type) {
return (Long) getHibernateTemplate().execute(new HibernateCallback<Object>() {
public Object doInHibernate(org.hibernate.Session session) throws org.hibernate.HibernateException {
Long result = null;
Connection conn = null;
CallableStatement cstmt = null;
try {
conn = session.connection();
conn.setAutoCommit(false);
cstmt = conn.prepareCall(proc);
for (int i=0; paramList != null && i<paramList.size(); i++) {
if(i+1 == outIndex) {
cstmt.setInt(i+1,(Integer.parseInt(paramList.get(i).toString())));
} else {
cstmt.setString(i+1, paramList.get(i).toString());
}
}
cstmt.registerOutParameter(outIndex,type);
cstmt.execute();
result = new Long(cstmt.getInt(outIndex));
conn.commit();
} catch (Exception ex) {
try {
conn.rollback();
} catch (SQLException e1) {
logger.error(e1);
e1.printStackTrace();
}
ex.printStackTrace();
} finally {
if(cstmt != null) {
try {
cstmt.close();
}catch(Exception ex) {}
}
}
return result;
}
});
}
必须要用connection,当前代码还没有该用factory来获取connect,而使用已经过期的session.connect()方法。
看介绍在hibernate4.x之后该方法将会被去掉。