hibernate中的session未释放连接

Question

本帖最后由 caonimazige 于 2012-04-17 11:10:18 编辑

Answer 1

new AnnotationConfiguration().configure().buildSessionFactory();  创建session的Session session = HiberanateSessionFactory.getSf().getCurrentSession();
session.beginTransaction();
List list=session.createQuery("from Sys_employee "+where).list();
session.beginTransaction().commit();hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>    <session-factory>         
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost/shangli</property>
        <property name="connection.username">root</property>
        <property name="connection.password">123</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>  
             
<!--        <property name="connection.pool_size">1</property>-->        <property name="current_session_context_class">thread</property>
        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>        <!-- Echo all executed SQL to stdout -->
        
         <property name="show_sql">true</property>
         <property name="format_sql">true</property>
         <property name="hibernate.hbm2ddl.auto">update</property>

<!-- ALl Transcation commit-->
<!--          <property name="connection.autocommit">true</property>-->
           <mapping class="com.somelu.hht.entity.Sys_employee"/>
 <mapping class="com.somelu.hht.entity.FunctionItems"/>
 <mapping class="com.somelu.hht.entity.Functions"/>
 <mapping class="com.somelu.hht.entity.RoleToFunction"/>
 <mapping class="com.somelu.hht.entity.Role"/>
 <mapping class="com.somelu.hht.entity.RoleToItem"/>
    </session-factory></hibernate-configuration>