单元测试JUNIT的时候绿色通过了。 但为什么输出第一个结果后, 就自动shutdown连接池,再输出2,3,4个结果, 最后报错呢?
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
609 [main] INFO proxool.ProxoolFacade - Proxool 0.8.3 (14-Dec-2003 16:06)
656 [main] INFO connection.ProxoolConnectionProvider - Configuring Proxool Provider to use pool alias: proxool.pool1
656 [main] INFO connection.ProxoolConnectionProvider - autocommit mode: false
1047 [main] INFO cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.22-community-nt
1047 [main] INFO cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
1094 [main] INFO dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
1109 [main] INFO transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
1125 [main] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1125 [main] INFO cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
1125 [main] INFO cfg.SettingsFactory - Automatic session close at end of transaction: disabled
1125 [main] INFO cfg.SettingsFactory - JDBC batch size: 15
1125 [main] INFO cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
1125 [main] INFO cfg.SettingsFactory - Scrollable result sets: enabled
1125 [main] INFO cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
1125 [main] INFO cfg.SettingsFactory - Connection release mode: auto
1125 [main] INFO cfg.SettingsFactory - Maximum outer join fetch depth: 2
1125 [main] INFO cfg.SettingsFactory - Default batch fetch size: 1
1125 [main] INFO cfg.SettingsFactory - Generate SQL with comments: disabled
1125 [main] INFO cfg.SettingsFactory - Order SQL updates by primary key: disabled
1125 [main] INFO cfg.SettingsFactory - Order SQL inserts for batching: disabled
1125 [main] INFO cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1125 [main] INFO ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
1125 [main] INFO cfg.SettingsFactory - Query language substitutions: {}
1125 [main] INFO cfg.SettingsFactory - JPA-QL strict compliance: disabled
1125 [main] INFO cfg.SettingsFactory - Second-level cache: enabled
1125 [main] INFO cfg.SettingsFactory - Query cache: disabled
1125 [main] INFO cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
1125 [main] INFO cfg.SettingsFactory - Optimize cache for minimal puts: disabled
1125 [main] INFO cfg.SettingsFactory - Structured second-level cache entries: disabled
1140 [main] INFO cfg.SettingsFactory - Statistics: disabled
1140 [main] INFO cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
1140 [main] INFO cfg.SettingsFactory - Default entity-mode: pojo
1140 [main] INFO cfg.SettingsFactory - Named query checking : enabled
1187 [main] INFO impl.SessionFactoryImpl - building session factory
1484 [main] INFO impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
id:1
name:策划部
1781 [Shutdown Hook] INFO proxool.pool1 - Shutting down 'pool1' pool immediately [Shutdown Hook]
id:2
name:工程部
id:3
name:研发部
id:4
name:人力资源部
1812 [Shutdown Hook] ERROR proxool.ShutdownHook - Problem calling "get cause" on IllegalStateException.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.logicalcobwebs.proxool.ShutdownHook.remove(ShutdownHook.java:40)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:238)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:220)
at org.logicalcobwebs.proxool.ShutdownHook.run(ShutdownHook.java:99)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.IllegalStateException: Shutdown in progress
at java.lang.ApplicationShutdownHooks.remove(ApplicationShutdownHooks.java:55)
at java.lang.Runtime.removeShutdownHook(Runtime.java:220)
... 9 more
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
609 [main] INFO proxool.ProxoolFacade - Proxool 0.8.3 (14-Dec-2003 16:06)
656 [main] INFO connection.ProxoolConnectionProvider - Configuring Proxool Provider to use pool alias: proxool.pool1
656 [main] INFO connection.ProxoolConnectionProvider - autocommit mode: false
1047 [main] INFO cfg.SettingsFactory - RDBMS: MySQL, version: 5.0.22-community-nt
1047 [main] INFO cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
1094 [main] INFO dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
1109 [main] INFO transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
1125 [main] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1125 [main] INFO cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
1125 [main] INFO cfg.SettingsFactory - Automatic session close at end of transaction: disabled
1125 [main] INFO cfg.SettingsFactory - JDBC batch size: 15
1125 [main] INFO cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
1125 [main] INFO cfg.SettingsFactory - Scrollable result sets: enabled
1125 [main] INFO cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
1125 [main] INFO cfg.SettingsFactory - Connection release mode: auto
1125 [main] INFO cfg.SettingsFactory - Maximum outer join fetch depth: 2
1125 [main] INFO cfg.SettingsFactory - Default batch fetch size: 1
1125 [main] INFO cfg.SettingsFactory - Generate SQL with comments: disabled
1125 [main] INFO cfg.SettingsFactory - Order SQL updates by primary key: disabled
1125 [main] INFO cfg.SettingsFactory - Order SQL inserts for batching: disabled
1125 [main] INFO cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1125 [main] INFO ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
1125 [main] INFO cfg.SettingsFactory - Query language substitutions: {}
1125 [main] INFO cfg.SettingsFactory - JPA-QL strict compliance: disabled
1125 [main] INFO cfg.SettingsFactory - Second-level cache: enabled
1125 [main] INFO cfg.SettingsFactory - Query cache: disabled
1125 [main] INFO cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
1125 [main] INFO cfg.SettingsFactory - Optimize cache for minimal puts: disabled
1125 [main] INFO cfg.SettingsFactory - Structured second-level cache entries: disabled
1140 [main] INFO cfg.SettingsFactory - Statistics: disabled
1140 [main] INFO cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
1140 [main] INFO cfg.SettingsFactory - Default entity-mode: pojo
1140 [main] INFO cfg.SettingsFactory - Named query checking : enabled
1187 [main] INFO impl.SessionFactoryImpl - building session factory
1484 [main] INFO impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
id:1
name:策划部
1781 [Shutdown Hook] INFO proxool.pool1 - Shutting down 'pool1' pool immediately [Shutdown Hook]
id:2
name:工程部
id:3
name:研发部
id:4
name:人力资源部
1812 [Shutdown Hook] ERROR proxool.ShutdownHook - Problem calling "get cause" on IllegalStateException.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.logicalcobwebs.proxool.ShutdownHook.remove(ShutdownHook.java:40)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:238)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:220)
at org.logicalcobwebs.proxool.ShutdownHook.run(ShutdownHook.java:99)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.IllegalStateException: Shutdown in progress
at java.lang.ApplicationShutdownHooks.remove(ApplicationShutdownHooks.java:55)
at java.lang.Runtime.removeShutdownHook(Runtime.java:220)
... 9 more
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration> <session-factory>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="connection.driver_class">
org.gjt.mm.mysql.Driver
</property>
<property name="proxool.pool_alias">pool1</property>
<property name="proxool.xml">ProxoolConf.xml</property>
<property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<mapping resource="model/Tdepartment.hbm.xml" />
<mapping resource="model/Temployee.hbm.xml" />
<mapping resource="model/Tjob.hbm.xml" /> </session-factory>
</hibernate-configuration>
hibernate.cfg.xml文件
<something-else-entirely>
<proxool>
<alias>pool1</alias>
<driver-url>jdbc:mysql://localhost:3306/hrm</driver-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="1234"/>
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<simultaneous-build-throttle>5</simultaneous-build-throttle>
<!-- <maximum-new-connections>5</maximum-new-connections> --> <prototype-count>5</prototype-count>
<maximum-connection-count>20</maximum-connection-count>
<minimum-connection-count>15</minimum-connection-count>
</proxool>
</something-else-entirely>