java.sql.SQLException: Operation not allowed after ResultSet closed

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,
    Expert tip

    MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

  2. ,

    Make sure you are using InnoDB storage engine and READ-COMMITTED transaction isolation level and increase the database server innodb_lock_wait_timeout variable to about 500.

Solutions on the web

via Stack Overflow by Priv
, 1 year ago
Operation not allowed after ResultSet closed
via mysql.com by Unknown author, 1 year ago
Operation not allowed after ResultSet closed
via Stack Overflow by Gorakh Shrestha
, 2 years ago
Operation not allowed after ResultSet closed
via Stack Overflow by M Bta
, 2 years ago
Operation not allowed after ResultSet closed
via mysql.com by Unknown author, 1 year ago
Operation not allowed after ResultSet closed
via Stack Overflow by ratnesh
, 2 years ago
Operation not allowed after ResultSet closed
java.sql.SQLException: Operation not allowed after ResultSet closed	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)	at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:743)	at com.mysql.jdbc.ResultSetImpl.isBeforeFirst(ResultSetImpl.java:6135)	at eu.taigacraft.powerperms.Permissions.getMysqlPlayerPrefix(Permissions.java:283)	at eu.taigacraft.powerperms.Permissions$2.run(Permissions.java:129)	at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:71)	at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)	at java.lang.Thread.run(Thread.java:745)