Ask a Question related to Coldfusion Database Access, Design and Development.
-
rpmon #1
MySQL Communication link failure
I have recently setup a MySQL 4.1.12 database on FreeBSD. I connect to the
database using Coldfusion on a Windows 2003 computer. The database seems to be
working fairly well, about 95% of the time. The other time it gives me the
error below and i have no idea what to do.
I can't tell if it is MySQL or the connector i am using
(mysql-connector-java-3.0.16-ga-bin.jar). Any ideas at what to try or do to
get this working?
Error Detail:
Communication link failure: java.io.EOFException, underlying cause: null
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394 )
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1538)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1929)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 67)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1278)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2248)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2196)
at com.mysql.jdbc.Statement.execute(Statement.java:90 6)
at coldfusion.server.j2ee.sql.JRunStatement.execute(J RunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:974)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:886)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:44...
rpmon Guest
-
MySQL 4.1.16 compile failure under Linux 2.6.12.2
Hello: Trying to upgrade from MySQL 3.23.40 to 4.1.16 and am having no luck getting the sources compiled. If you need further information or... -
Failure MySQL JDBC driver 3.1 or 3.2
I want to use MySQL 5 with ColdFusion MX 7 standard. I tried the JDBC Connector 3.1 and 3.2. Adding a new DSN works fine in administratrion, but if... -
Communication App Inspector login failure
yesterday i could. today i can't. same username, same password. the documentation gives no indication of what to do in the circumstance (it reads... -
Error Executing Database Query.Communication link
Pretty much everyday when I get up now all my coldfusion sites that use MySQL just take forever to load. In fact they never load or even time out,... -
#24724 [NEW]: Link failure with --disable-cgi --enable-cli
From: kyle at putnamcabinets dot com Operating system: Debian GNU/Linux (Sid) PHP version: 4.3.3RC1 PHP Bug Type: Compile... -
rpmon #2
Re: MySQL Communication link failure
I am still having this issue but it seems to happen only if the server is idle
for more than 5 minutes.
I have a scheduled task running to check the server status. If i set it to
recur every 5 minutes i do not see this error again. Is there some place i
need to change a time out setting for this connector?
rpmon Guest



Reply With Quote

