session.beginTransaction();
... // call
session.getTransaction().commit();

@Service
public class ServiceImpl implements Service{


    @Autowired
    private SessionFactory sessionFactory;
    private HibernateTemplate ht;

    @PostConstruct
    public void init() {
        ht = new HibernateTemplate(sessionFactory);
        ht.setFlushMode(HibernateAccessor.FLUSH_AUTO);
    }

    @Transactional
    public CancelResult cancel(TCancel tCancel) {
        ...
   }

  @Override
    public ReportResult callReportProcedure(Date from, Date till){

           session = sessionFactory.openSession();
           java.sql.Connection con = session.connection();

           CallableStatement statement = null;

           statement = con.prepareCall("{CALL ONLINE_REPORT(?, ?)}");
           statement.setTimestamp(1, new Timestamp(from.getTime()));
           statement.setTimestamp(2, new Timestamp(till.getTime()));

           statement.execute();
          ResultSet rs = statement.getResultSet();
          ...
          statement.close();
          session.flush();
          session.close();

}