配置c3p0-config.xml資料庫連接池，jdbcurl配置項報錯Type The reference to entity "useUnicode" must end with the ';' delimiter.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xml>
<c3p0-config>
    <named-config name="mysql">
        <property name="user">test01</property>
        <property name="password">test01</property>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://10.49.40.127:3306/testdb?&useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&serverTimezone=Asia/Shanghai</property>
        <property name="initialPoolSize">10</property>
        <!--最大空閑時間，30秒內未使用則連接被丟棄。若為0則永不丟棄。預設值: 0 -->
        <property name="maxIdleTime">30</property>
        <property name="maxPoolSize">100</property>
        <property name="minPoolSize">10</property>
    </named-config>
</c3p0-config>

上邊這種配置方式 會報The reference to entity "useUnicode" must end with the ';' delimiter. 這個錯誤。

這是由xml文件中的編碼規則決定要這麼變換。在xml文件中有以下幾類字元要進行轉義替換：

正確的方式

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xml>
<c3p0-config>
    <named-config name="mysql">
        <property name="user">test01</property>
        <property name="password">test01</property>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://10.49.40.127:3306/testdb?&amp;useUnicode=true&amp;characterEncoding=utf8&amp;autoReconnect=true&amp;failOverReadOnly=false&amp;serverTimezone=Asia/Shanghai</property>
        <property name="initialPoolSize">10</property>
        <!--最大空閑時間，30秒內未使用則連接被丟棄。若為0則永不丟棄。預設值: 0 -->
        <property name="maxIdleTime">30</property>
        <property name="maxPoolSize">100</property>
        <property name="minPoolSize">10</property>
    </named-config>
</c3p0-config>