SQL problems

Hi.

So, I seem to be having some sql problems in my plugin. Most of the time it works fine but sometimes it fail. I think that the connection might be timing out or something but im not sure how to fix it. here is the error that i receive

http://pastie.org/4031769


Help is appreciated as this is with my SurvivalGames plugin

 

Code:

if(conn == null || conn.isClosed())
    //Reconnect
 
conn.prepareStatement(<blabla>);

I do the above and haven't got any issues yet.
conn is an instance of the connection (using the java MysqlConnector included in craftbukkit)

 

I would use the isValid(int) method as you can not use the isClosed() to correctly determine if a connection is active or not; according to the javadoc.

Code:

conn.isValid(0);

With that said, if you catch any exceptions, you can force a reconnect.

 

Thanks for clearing that up

 

Thanks, I'll implement this into the next update

 

I use something like "keep connection alive thread". Simple "Select 1;" query every minute.