我需要手动关闭从Hibernate会话中获取的连接吗?
如果我这样做,我会关闭连接池中的一个连接吗?
如果我不这样做,Hibernate会自动关闭连接吗?
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
String query = "sql query";
try {
Session session = this.sessionFactory.getCurrentSession();
con = session.connection();
ps = con.prepareStatement(query);
rs = ps.executeQuery();
while (rs.next()) {
//read result set
}
} catch (SQLException exp) {
log.error("Error: ", exp);
} finally{
if(ps != null)
ps.close();
if(con != null)
con.close(); //Is this required?
}