"No operations allowed after statement closed." WTF part 2

I have small plugin, I try test everything, but one (or two) person still have that errors:

http://pastebin.com/rD2cjy9S


KOD:
https://github.com/BukkitSmerf/Kill...llPoints/src/com/gmail/bukkitSmerf/killPoints


Anyone can help with that? ;/ I testing on SQLite/MySQL (on db4free.net) and flooding my test server with fake LocalPlayers ;/
I just don't know how to fix that error... because I can't get it ;/

 

Make a new statement everytime you want to work against the database.

EDIT:
There is a timeout for the statement-object. It will close if it isn't used within that timeframe if I remember correctly.

 

SQLite don't like many statements if I remember? (or that only for connections?)

And then...
I must do something like that: (Db class)

Code:

        private static void update(String sql) {
                try {
                        st = con.createStatement();
                        st.executeUpdate(sql);
                        st.close();
                } catch (SQLException e) {
                        e.printStackTrace();
                }
        }
 
        private static ResultSet query(String sql) throws SQLException {
                st = con.createStatement();
                ResultSet r = st.executeQuery(sql);
                st.close();
                return r;
        }

Or

Code:

        private static void update(String sql) {
                try {
                        Statement s = con.createStatement();
                        s.executeUpdate(sql);
                        s.close();
                } catch (SQLException e) {
                        e.printStackTrace();
                }
        }
 
        private static ResultSet query(String sql) throws SQLException {
                Statement s = con.createStatement();
                ResultSet r = s.executeQuery(sql);
                s.close();
                return r;
        }

 

I would use the second version, but you should also remember to manually close the resultsets when you are done with them as well.

 

Ok, Thanks I try this, (but not today).

PS: About your edit... that possible to just check the statement and open it if is closed? Or it's just better to create other?

 

bfgbfggf
http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#isClosed()