我百度了好多,都说把maxStatements设置为0,但是没有用,还是会产生这样的错误!

解决方案 »

  1.   

    详细的配置文件如下:
    <?xml version='1.0' encoding='UTF-8'?>
    <Context docBase="E:\MyJavaApp\template\template\WebRoot" reloadable="false" path="">
    <Resource name="jdbc/template"
                    type="com.mchange.v2.c3p0.ComboPooledDataSource"
    minPoolSize="10"
                    maxPoolSize="50"
    initialPoolSize="10"
    maxIdleTime="7200"
    acquireIncrement="5"
    acquireRetryAttempts="30"
    acquireRetryDelay="2000"
    autoCommitOnClose="true"
    idleConnectionTestPeriod="18000"
    maxStatements="0"
    checkoutTimeout="50000"
    numHelperThreads="5"
                    factory="org.apache.naming.factory.BeanFactory"
                    user="root"
    password="root"
                    driverClass="com.mysql.jdbc.Driver"
                    jdbcUrl="jdbc:mysql://localhost:8080/sd_template?autoReconnect=true" /> <Resource name="jdbc/test"
                    type="com.mchange.v2.c3p0.ComboPooledDataSource"
    minPoolSize="10"
                    maxPoolSize="50"
    initialPoolSize="10"
    maxIdleTime="7200"
    acquireIncrement="5"
    acquireRetryAttempts="30"
    acquireRetryDelay="2000"
    autoCommitOnClose="true"
    idleConnectionTestPeriod="18000"
    maxStatements="0"
    checkoutTimeout="50000"
    numHelperThreads="5"
                    factory="org.apache.naming.factory.BeanFactory"
                    user="root"
    password="root"
                    driverClass="com.mysql.jdbc.Driver"
                    jdbcUrl="jdbc:mysql://localhost:8080/sd_test?autoReconnect=true" />
    </Context>