Hibernate Session提供了doWork()
一种直接访问的方法java.sql.Connection
。然后,您可以创建并用于java.sql.CallableStatement
执行功能:
session.doWork(new Work() {
public void execute(Connection connection) throws sqlException {
CallableStatement call = connection.prepareCall("{ ? = call MYSCHEMA.MYFUNC(?,?) }");
call.registerOutParameter( 1, Types.INTEGER ); // or whatever it is
call.setLong(2, id);
call.setLong(3, transId);
call.execute();
int result = call.getInt(1); // propagate this back to enclosing class
}
});