Hibernate / Stored Procedure / Reporting

[Hanna Habashy]

I need to call some stored procedure for reporting. The Store Proc. DO NOT return an entity, so I cannot configure them as name queries in a configuration files.

The only way I know is to:

  con = getHbnSession().connection();
      cs = con.prepareCall("{call someStoreProc(?)}");
      cs.setInt(1, 1);
      rs = cs.executeQuery();  

The session.connection() method is deprecated, and I couldn't find any other way of obtaining a connection object.

Please advise how to obtain a connection object, and if there is any other way of calling a stored procedure.

Thanks

[Justin Chi]

To get the connection:

 new Configuration().configure("hibernate.cfg.xml").buildSettings().getConnectionProvider().getConnection();