项目部署后第二天报错：MySQL数据路连接异常

Question

我的项目用的是MySQL数据库，部署到服务器上后，第二天就报这个错误，哪位大神有解决办法，
[2018-04-27 09:38:48] [http-bio-8080-exec-5] [ERROR] com.manage.controller.appcontrol.AppUserController ：手机号登录验证异常：com.manage.exception.AtomException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

The error may exist in file [/usr/tomcat/apache-tomcat-7.0.82/webapps/Tophotoart/WEB-INF/classes/com/manage/dao/mapper/TopUserMapper.xml]

The error may involve com.manage.dao.TopUserMapper.getAppExternalUser

The error occurred while executing a query

SQL: SELECT us.userId,us.nickname,us.realName, us.sexId, us.birthday,us.avatar,us.phone FROM topuser AS us WHERE us.userType=0 and us.phone=?

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

; SQL []; No operations allowed after connection closed.; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
[com.manage.controller.appcontrol.AppUserController] [手机号登录验证异常：com.manage.exception.AtomException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

The error may exist in file [/usr/tomcat/apache-tomcat-7.0.82/webapps/Tophotoart/WEB-INF/classes/com/manage/dao/mapper/TopUserMapper.xml]

The error may involve com.manage.dao.TopUserMapper.getAppExternalUser

The error occurred while executing a query

SQL: SELECT us.userId,us.nickname,us.realName, us.sexId, us.birthday,us.avatar,us.phone FROM topuser AS us WHERE us.userType=0 and us.phone=?

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

; SQL []; No operations allowed after connection closed.; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.]

Answer 1

不行就试试这个，

     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${database.driver}"/>
        <property name="jdbcUrl" value="${database.url}"/>
        <property name="user" value="${database.username}"/>
        <property name="password" value="${database.password}"/>
        <property name="minPoolSize" value="1"/>
        <property name="maxPoolSize" value="20"/>
        <property name="maxIdleTime" value="1800"/>
        <property name="acquireIncrement" value="2"/>
        <property name="maxStatements" value="0"/>
        <property name="initialPoolSize" value="2"/>
        <property name="idleConnectionTestPeriod" value="1800"/>
        <property name="acquireRetryAttempts" value="30"/>
        <property name="breakAfterAcquireFailure" value="true"/>
        <property name="testConnectionOnCheckout" value="false"/>
    </bean>