Webmaster Forum / ColdFusion / Getting Started / November 2007

The TechNotes
(http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170) steps should
work.

To interact with MySQL DB you need to create datasource. To create the
datasources please follow the steps mentioned below.

Download "mysql-connector-java-3.0.17-ga-bin.jar" and paste it inside
C:\CFusionMX7\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar
Hope your CF installation drive is "C".

Now go to CF administartor > Server Settings > Java and JVM.
In ColdFusion Class Path paste the jar file path
"C:\CFusionMX7\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar" and
hit "Submit Changes". Then restart CF.

Now create the MySql data source, give your data source name and select driver
as "Other" and provide the following parameters.

JDBC URL: jdbc:mysql://localhost:3306/yourDBName
Driver Class: com.mysql.jdbc.Driver
Driver Name: MySQL Connector J
User Name: YourMySQL User Name
Password: Your Password

Thanks

Thanks very much for your help.

I did everything you suggested and it worked. Then a few days later I went
back to Dreamweaver and tried to connect to a database only to find I've lost
the connection.

When I try to connect to a database I get the following 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."

Any suggestions would be gratefully appreciated.

Thanks a million.

Sincerely,

Graham A. Kerby

Thanks for the advice. I've somehow got it working, but now I have a new
problem: I can set up the data sources in the ColdFusion Administrator, but I
can't connect to these sites in Dreamweaver where I've created the ColdFusion
pages that will use these databases.

I've just posted this problem in the ColdFusion Databases forum under the name
DRGAK.

Thanks again.

I've solved the DW problem by changing the site folders from 'db' to 'wwwroot'
e.g. 'C:\CFusionMX\db\' is now 'C:\CFusionMX\wwwroot\

However I'm now back to my original problem. I've lost my mqysql connection in
CF Adminstrator. Before I made these changes I could connect to my mysql
databases using the following settings:

JDBC URL: jdbc:mysql://localhost:3306/test
Driver Name: MySQL Connector J

using the following Java path and file:
C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.17-ga-bin.jar

Now these settings give me the following 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"

Any suggestions on this would also be welcome.

Thanks again to everyone for their help.

Sincerely,

Graham A. Kerby