Webmaster Forum / ColdFusion / Getting Started / November 2007

I can't create a mysql datasource in CF Administrator.

If I use the following datasource settings in CF Administrator:

JDBC URL: jdbc:mysql://localhost:3306/test
Drive Class: MySQL Connector J

AND (note the emphasis) I set my local and remote folders in my DW site local
folder, remote folder and testing server folders all  to  C:\CFusionMX\db\, I
can connect to my mysql database in CF Administrator.

However, with these DW site folder settings, DW doesn't recognize any
databases (Access or Mysql) at all.

When I change my DW site folder settings to 'wwwroot' (e.g.local folder  
C:\CFusionMX\db\' is changed to 'C:\CFusionMX\wwwroot') DW now lists all my CF
Administrator databases.

The problem is CF Administrator can't connect to my Mysql data sources. It
gives me the error:

"Connection verification failed for data source: javaserver
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info"

I've tried changing the 3306 port to 8500, but this doesn't help.

My java path and connector file is:
C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar,

Is this a ID/password problem? I've tried both 'root' and leaving the ID field
in the CF Administrator add data source block, both to no avail. I don't have a
password set in Mysql for 'root' either.

Any help would be gratefully appreciated. I've been working on this for weeks
and keep running into one problem after another.

Thanks a million in advance.

Sincerely,

Graham A. Kerby