javaEE hibernate中的Session关闭问题.

在pl/sql中查hibernate的session连接数

select count(*) from v$session

select count(*) from V$SESSION_WAIT

==========================

带openSession()必须手动关闭session，没带的hibernate可以自动关闭.

1.  ====

String hql = " Select u From UserBean u left join fetch u.roles r left join fetch r.permits where u.userid = :userid";
        Session ss = getHibernateTemplate().getSessionFactory().openSession();
        UserBean us =(UserBean)ss.createQuery(hql).setParameter("userid",user.getUserid()).uniqueResult();
        try{
            return us ;
        }
        finally{
            ss.close();
        }

2. ====

public List queryForPage(final String hql, final int offset,
            final int length) {
        List list = getHibernateTemplate().executeFind(new HibernateCallback() {
            public Object doInHibernate(Session session)
                    throws HibernateException, SQLException {
                Query query = session.createQuery(hql);
                query.setFirstResult(offset);
                query.setMaxResults(length);
                List list = query.list();
//                releaseSession(session);
                try{
                    return list;
                }
                finally{
                    session.close();
                }
            }
        });
        return list;
    }

 

3.  ===hibernate会自动关闭的如:

PlacardBean pt=(PlacardBean)this.getHibernateTemplate().get(PlacardBean.class, typeId);

------------

String hql="FROM OqcReturnBean as O WHERE O.mblnr='"+value+"'";
  List list = getHibernateTemplate().find(hql);

-------------