mysql - 是否 hibernate 关闭连接？

Question

我的代码如下。可能我以类似的方式多次使用它，即简单地说，我正在以这种方式管理 session 和事务:

 List<Login> users= null;
        try{
            session=HibernateUtil.getSessionFactory().getCurrentSession();
            tx=session.beginTransaction();
            users=session.createQuery("from Login").list();
            tx.commit();
        }catch(Exception e){System.out.println("commit exception:"+e);
            try {tx.rollback();} catch (Exception ex) {System.out.println("rollback exception:"+ex);} 
        }finally{if(session!=null && session.isOpen()){session.close();}}
        return users;

现在，当我第一次运行数据库服务(使用 MySQL)并使用此查询从命令提示符检查时...

show status like 'Conn%';

...结果是:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Connections   | 2     |
+---------------+-------+

当我启动我的应用程序并使用它时。打开几页并查询相同的内容后。我得到的连接数为 6，甚至超过 20。

现在我想知道 hibernate 是否正在关闭连接？

我以这种方式处理所有事务，我交叉检查并在不关闭 session 的情况下看到任何代码块。

hibernate .cfg.xml

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->
        <property name="connection.driver_class">
            com.mysql.jdbc.Driver
        </property>
        <property name="connection.url">
            jdbc:mysql://localhost:3306/shareapp
        </property>
        <property name="connection.username">pluto</property>
        <property name="connection.password">admin</property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">
            org.hibernate.dialect.MySQLDialect
        </property>

        <!-- Enable Hibernate's automatic session context management -->
        <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>

        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">update</property>


    </session-factory>

hibernate 工具类

public class HibernateUtil {
    private static final SessionFactory sessionFactory;

    static {
        try {
            AnnotationConfiguration config = new AnnotationConfiguration();
        config.addAnnotatedClass(Login.class);
        config.addAnnotatedClass(FilesInfo.class);
        config.addAnnotatedClass(FilesShare.class);

        config.configure("hibernate.cfg.xml");
     //   new SchemaExport(config).create(true,true);

        sessionFactory = config.buildSessionFactory();

        } catch (Throwable ex) {
            // Log the exception. 
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

谢谢!

Answer 1

“连接”状态变量只是指

The number of connection attempts (successful or not) to the MySQL server,

而不是事件连接数。这是链接:http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html#statvar_Connections

要获取打开的连接数，请检查“Threads_connected”变量，记录在 http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html#statvar_Threads_connected