Hi all,
I am using hibernate-core3.3.2.GA.
Here is my code:
Code:
public void execute(Connection con) throws SQLException {
CallableStatement st = null;
try {
st = con.prepareCall(DDBB_PCK.execStoreProc());
st.setLong(1, param);
st.execute();
} catch (SQLException e) {
throw e;
} finally {
try { st.close(); } catch (Exception e){}
}
}
Should i close the connection when an exception is thrown?
My work is being executed every minute. So if the database fails executing the stored procedure, I get this error:
Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
Thanks in advance
Joseba