连接池报错 Proxool Provider unable to load JAXP configurator file: proxool.xml

上篇博文讲到简易配置 proxool 连接池：http://www.cnblogs.com/linnuo/p/7232380.html

由于把说明注释留在了 proxool.xml 配置文件里导致配置后报错，原因如下：

hibernate.cfg.xml 代码片段：

<session-factory>
    <property name="show_sql">trueproperty>
    <property name="generate_statistics">falseproperty>
    <property name="connection.useUnicode">trueproperty>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialectproperty>
        
    <property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProviderproperty>  
    <property name="hibernate.proxool.xml">proxool.xmlproperty>  
    <property name="hibernate.proxool.pool_alias">mysqldbproperty>        
session-factory>

proxool.xml 完整代码：

<?xml version="1.0" encoding="UTF-8"?>

<something-else-entirely>
<proxool>

<alias>mysqldbalias>

<driver-url>jdbc:mysql://127.0.0.1:3306/ucom?useUnicode=true&characterEncoding=UTF8driver-url>

<driver-class>com.mysql.jdbc.Driverdriver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="gdyl2017"/>
driver-properties>

<house-keeping-sleep-time>90000house-keeping-sleep-time>

<maximum-new-connections>20maximum-new-connections>

<prototype-count>5prototype-count>

<maximum-connection-count>100maximum-connection-count>

<minimum-connection-count>10minimum-connection-count>

<test-before-use>truetest-before-use>  
<test-after-use>truetest-after-use>  
  
<house-keeping-test-sql>SELECT CURRENT_USERhouse-keeping-test-sql>  
proxool>
something-else-entirely>

　　　　以上代码放在本地运行没问题，但是放到服务器报错

　　找了许久终于发现了问题：proxool.xml 文件里不能存在中文，包括注释

　　解决方案：

　　　　将 proxool.xml 的中文去掉即可，如下：

<?xml version="1.0" encoding="UTF-8"?>

<something-else-entirely>
　　<proxool>
　　　　<alias>mysqldbalias>
　　　　<driver-url>jdbc:mysql://127.0.0.1:3306/ucom?useUnicode=true&characterEncoding=UTF8driver-url>
　　　　<driver-class>com.mysql.jdbc.Driverdriver-class>
　　　　<driver-properties>
　　　　　　<property name="user" value="root"/>
　　　　　　<property name="password" value="gdyl2017"/>
　　　　driver-properties>
　　　　<house-keeping-sleep-time>90000house-keeping-sleep-time>
　　　　<maximum-new-connections>20maximum-new-connections>
　　　　<prototype-count>5prototype-count>
　　　　<maximum-connection-count>100maximum-connection-count>
　　　　<minimum-connection-count>10minimum-connection-count>
　　　　<test-before-use>truetest-before-use>  
　　　　<test-after-use>truetest-after-use>  
　　　　<house-keeping-test-sql>SELECT CURRENT_USERhouse-keeping-test-sql>  
　　proxool>
something-else-entirely>