Hi I switched hosting providers about a month ago and have had quite a few issues. Least of which is the one I have now with regards to a connection to the database timeout . When I load my site in a browser, I can click on a page or two. If I leave the pc a few minutes, come back to the pc, click back on the browser window then click the same page again, I get an error saying:
Error Executing Database Query.
Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software caused connection abort: socket write error STACKTRACE: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) at com.mysql.jdbc.Statement.execute(Statement.java:727) at com.mysql.jdbc.Statement.execute(Statement.java...
|
I have emailed back and forth with support and they said I need to set up timeout management in my application. They said "please apply some kind of connection pooling or keepalives."
I have never had this issue until I switched hosting providers. They may indeed set up their database connections differently than other hosting companies. What I would like to know, is there a way to do as they suggest? Set up some kind of connection maintanance within my cfm applications. I'm fairly new to CF, so dont know of anything like this. Thanks for any help in advance!
1
Reply
AdChoices