Guennadi M

Keeping Fast Hit servers up to date with the latest hotfixes sometimes creates more problems. There’s been a few reports that after the latest update, people get errors connecting to their mySQL databases. The exact error message is

Error Executing Database Query.
Communication link failure: Unknown command

Digging a bit deeper into the issue we found that Connector J drivers that come with CFMX 7 have known bugs/issues relating to the use of certain MySQL syntax.

A solution is (as outlined in this CF TechNote) to download and use the latest JDBC drivers for DSN connections with mySQL databases. If you’re with Fast Hit and experiencing similar difficulties, just contact support.