Error Configuring MySQL

[crazypilot3]

Basically I am making a website named: familycentral

I tried to make a data source connection with MySQL, and after reading the
forums I realized that I needed to download a *.jar file. I followed the
directions below exactly:

Download a current, stable version of the MySQL Connector J JDBC driver,
available at: [url]http://dev.mysql.com/doc/connector/j/en/index.html[/url]
Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded
archive file.
Save the mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib
directory.
Restart the ColdFusion MX server.
Add a new data source to the ColdFusion MX Administrator, using the driver
option Other.
Enter the JDBC URL:
jdbc:mysql://[host]:[port]/[database]
Enter the Driver Class:
com.mysql.jdbc.Driver
Complete username/password, and adjust other data source settings, if needed.
Submit the data source for verification.



After I clicked submit, I get this error:


Connection verification failed for data source: familycentral
[]java.sql.SQLException: Unable to instantiate logger class
'com.mysql.jdbc.log.Log4JLogger', exception in constructor?
The root cause was that: java.sql.SQLException: Unable to instantiate logger
class 'com.mysql.jdbc.log.Log4JLogger', exception in constructor?


What does that mean? This website, server, and mysql is completely local, and
I am running XP pro SP1.

Your help is much appreciated!

Anthony

[Mountain Lover]

I fixed this same error by rolling back to
mysql-connector-java-3.1.7-bin.jar

HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[crazypilot3]

My solution was to return to the download site and get the previous stable version:
mysql-connector-java-3.0.16-ga-bin.jar
worked for me and I now have a verified connection to my MySQL 4.1 database

[rmorgan]

To answer your question about Apache. Apache is a webserver. If you are just
doing development and for testing, you dont have to have it. However, if you
are writing an application for a production environment, the CF built in server
is not recommended. Apache in my opinion is one of your best options for a
webserver.