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

JIRA | Stéphane Spahni | 4 years ago
  1. 0

    After a while (e.g. a night), a restart of the epSOS-Web component is required because it lost its DB connection (working with mysql 5.1.52). Log in and country selection can be performed, but when trying to search a patient the following exception is raised): DEBUG 2013-03-19 08:44:29,414 org.hibernate.loader.Loader loadEntity.1852 - loading entity: [eu.epsos.configmanager.database.model.Property#NcpServiceConfigManager.security.assertion.PrivateKeystoreLocation] DEBUG 2013-03-19 08:44:29,415 org.hibernate.jdbc.AbstractBatcher logOpenPreparedStatement.366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0) DEBUG 2013-03-19 08:44:29,415 org.hibernate.jdbc.ConnectionManager openConnection.421 - opening JDBC connection DEBUG 2013-03-19 08:44:29,416 org.hibernate.SQL log.401 - select property0_.name as name0_0_, property0_.value as value0_0_ from property property0_ where property0_.name=? WARN 2013-03-19 08:44:29,420 org.hibernate.jdbc.AbstractBatcher closeQueryStatement.280 - exception clearing maxRows/queryTimeout com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) (full stack trace attached).

    JIRA | 4 years ago | Stéphane Spahni
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
  2. 0

    Mysql抛出No operations allowed after statement closed.是不是连接泄露 - 开源中国社区

    oschina.net | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
  3. 0

    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed but no tcp socket reset

    Stack Overflow | 4 years ago | Sean Nguyen
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Strange error using JPA on OpenShift

    Stack Overflow | 2 years ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  6. 0

    Further MySQL woes - possible timeouts again

    apache.org | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

  1. mauritius 6 times, last 2 months ago
  2. tvrmsmith 1 times, last 2 weeks ago
  3. fima 24 times, last 2 months ago
  4. tvrmsmith 3 times, last 3 months ago
  5. linxiaolong 1 times, last 4 months ago
4 more registered users
38 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException

    No operations allowed after statement closed.

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    4 frames
  3. MySQL jdbc
    SQLError.createSQLException
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    2. com.mysql.jdbc.Util.getInstance(Util.java:386)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
    5. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
    5 frames