MySQL timeout

abirhasan — Thu, 10 Jan 2013 18:18:51 GMT

I am working on a simple application using JSP/Servlet and MySQL and I am using the Gefion connection pooling class available from http://webdevelopersjournal.com/columns/DBConnectionManager.java. I keep getting timeouts with messages similar to this:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.GeneratedConstructorAccessor103.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance

The same code works fine on my development system. I have read posts about increasing the timeout for connections held in a pool, to avoid this issue.

Since this is a low volume application, connection pooling is probably overkill but I like to do a job properly. Surely I'll consume more LP resources by opening and closing connections each time they are needed, rather than opening and sharing through a pool.

Either way, it doesn't matter to me but would appreciate an 'official' verdict from LunarPages.

Thanks

topic MySQL timeout in Archive

MySQL timeout