devbox@COMPUTEC The Computec development blog

18Jun/106

ColdFusion 8 and MySQL 5.1 via JDBC: Help needed! [Solved]

UPDATE: We have now found the cause of the issue. Please scroll to the end of the article for explanation and workaround.

In one of our latest projects we need to access a MySQL 5.1 server (5.1.45) from ColdFusion 8 (8,0,1,195765). Creating the datasource was no problem, the datasource does verify okay - but there obviously is some bug or incompatibility in ColdFusion that causes the connection to be anything but reliable.