string sql = {call init_sort()}; callablestatement cs = null; connection conn = null; resultset rs = null; try { conn = sessionfactoryutils.getdatasource(getsessionfactory()) .getconnection(); conn.commit(); conn.setautocommit(true); cs =
string sql = {call init_sort()};
callablestatement cs = null;
connection conn = null;
resultset rs = null;
try {
conn = sessionfactoryutils.getdatasource(getsessionfactory())
.getconnection();
conn.commit();
conn.setautocommit(true);
cs = conn.preparecall(sql);
cs.execute();
} catch (sqlexception e) {
e.printstacktrace();
} finally {
try {
if (null != rs) {
rs.close();
}
if (null != cs) {
cs.close();
}
if (null != conn) {
conn.close();
}
} catch (sqlexception e) {
e.printstacktrace();
}
}