Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”

by

When you run the Delete query, you use the same Statement that was used in the Select query. When you re-execute on the same Statement, the previous ResultSet gets closed.

To avoid this, you should create a new Statement everytime you execute a query. So remove statement = connection.createStatement(); from the connect() method in MySQLDatabase class, and replace all statement in that class to connection.createStatement(). You may also choose to delete the private variable statement altogether.

You can read more about it here.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. Multiple queries executed in java in single statement
  6. Java: Insert multiple rows into MySQL with PreparedStatement
  7. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  8. Cannot issue data manipulation statements with executeQuery()
  9. Handling MySQL datetimes and timestamps in Java
  10. Closing JDBC Connections in Pool
  11. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  12. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  13. Java JDBC Access denied for user [closed]
  14. How to configure Tomcat to connect with MySQL
  15. Retrieve an Image stored as BLOB on a MYSQL DB
  16. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. mysql prepared statement error: MySQLSyntaxErrorException
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. Access denied for user ‘root’@’localhost’
  23. How to correctly write UTF-8 strings into MySQL through JDBC interface
  24. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  25. java.sql.SQLException: Before start of result set [duplicate]
  26. How to use prepared statement for select query in Java?
  27. Stumped SQL Exception for JDBC
  28. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  29. How to connect to a remote MySQL database with Java?
  30. java.sql.SQLException: No database selected – why?

Leave a Comment