hibernate proxool 的配置
hibernate的配置文件
<session-factory>
<!-- Database connection settings -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.pool_alias">Proxool-DBPool</property>
<property name="hibernate.proxool.xml">proxool.properties</property>

............

</session-factory>

proxool.properties配置文件
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>Proxool-DBPool</alias>
<driver-url>jdbc:mysql://localhost:3306/test</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value=""/>
<property name="password" value=""/>
</driver-properties>
<maximum-connection-count>10</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<statistics>1m,15m,1d</statistics>
</proxool>
</something-else-entirely>
老是要报
14:07:09,765 INFO Configuration:879 - processing collection mappings
14:07:09,765 INFO Configuration:888 - processing association property references
14:07:09,765 INFO Configuration:917 - processing foreign key constraints
14:07:10,031 INFO ConnectionProviderFactory:53 - Initializing connection provider: org.hibernate.connection.ProxoolConnectionProvider
14:07:10,062 INFO ProxoolConnectionProvider:136 - Configuring Proxool Provider using Properties File: proxool.properties
14:07:10,062 FATAL ConfigHelper:81 - Unable to locate config file: proxool.properties
14:07:10,125 ERROR ShgxbDAO:38 - get failed
java.lang.NullPointerException
at com.sclh.ShgxbDAO.findById(ShgxbDAO.java:35)
at com.test.TestShgxb.main(TestShgxb.java:26)
%%%% Error Creating SessionFactory %%%%
org.hibernate.HibernateException: Unable to locate config file: proxool.properties
at org.hibernate.util.ConfigHelper.getConfigStream(ConfigHelper.java:82)
at org.hibernate.util.ConfigHelper.getConfigProperties(ConfigHelper.java:115)
at org.hibernate.connection.ProxoolConnectionProvider.configure(ProxoolConnectionProvider.java:146)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:80)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:362)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
可是我的文件明明在同一个目录啊!怎么会收索不到呢?问题出在
ConfigHelper:81
问题原来在 路径的载入上 只怪我们太过于信任hibernate的载入机制了.你只要改为
<property name="hibernate.proxool.xml">com/aflyer
/hibernate/Proxool.xml</property>
就ok了!
<session-factory>
<!-- Database connection settings -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.pool_alias">Proxool-DBPool</property>
<property name="hibernate.proxool.xml">proxool.properties</property>
............
</session-factory>

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>Proxool-DBPool</alias>
<driver-url>jdbc:mysql://localhost:3306/test</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value=""/>
<property name="password" value=""/>
</driver-properties>
<maximum-connection-count>10</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<statistics>1m,15m,1d</statistics>
</proxool>
</something-else-entirely>
14:07:09,765 INFO Configuration:879 - processing collection mappings
14:07:09,765 INFO Configuration:888 - processing association property references
14:07:09,765 INFO Configuration:917 - processing foreign key constraints
14:07:10,031 INFO ConnectionProviderFactory:53 - Initializing connection provider: org.hibernate.connection.ProxoolConnectionProvider
14:07:10,062 INFO ProxoolConnectionProvider:136 - Configuring Proxool Provider using Properties File: proxool.properties
14:07:10,062 FATAL ConfigHelper:81 - Unable to locate config file: proxool.properties
14:07:10,125 ERROR ShgxbDAO:38 - get failed
java.lang.NullPointerException
at com.sclh.ShgxbDAO.findById(ShgxbDAO.java:35)
at com.test.TestShgxb.main(TestShgxb.java:26)
%%%% Error Creating SessionFactory %%%%
org.hibernate.HibernateException: Unable to locate config file: proxool.properties
at org.hibernate.util.ConfigHelper.getConfigStream(ConfigHelper.java:82)
at org.hibernate.util.ConfigHelper.getConfigProperties(ConfigHelper.java:115)
at org.hibernate.connection.ProxoolConnectionProvider.configure(ProxoolConnectionProvider.java:146)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:80)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:362)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463) 
ConfigHelper:81
问题原来在 路径的载入上 只怪我们太过于信任hibernate的载入机制了.你只要改为
<property name="hibernate.proxool.xml">com/aflyer
/hibernate/Proxool.xml</property>

浙公网安备 33010602011771号