Summary:

Unable to create datasource for MySQL database successfully. I have followed
the steps for
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url] and
received the error:

Connection verification failed for data source: Sql_Test
[]java.lang.NoClassDefFoundError: java/sql/Savepoint
The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint


Steps to reproduce:

1. Downloaded the "MySQL Connector/J 3.1 from mysql.com.
2. Followed the Steps in TechNote 19170 - extracted the
MySQL-connector-java-3.0.10-stable-bin.jar. etc.
3. I am not sure if this is relevant, but I downloaded the hot fix from the
following link:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108[/url]
4. I entered and saved the classpath:
C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.1.7-bin.jar,
C:\CFusionMX\wwwroot\runtime\servers\lib\hf53852_6 1.jar, in the Java and JVM
page in ColdFusion Admin.
5. When I create a test DSN "SQL_Test". I enter the following information:
JDBC URL: jdbc:mysql://127.0.0.1/test (I have tried localhost also, but it
didn't work.)
Driver Class: com.mysql.jdbc.Driver
Username: root
Password: (I enter my password)

What went wrong?:

Once I submit, I get the error: Connection verification failed for data
source: Sql_Test
[]java.lang.NoClassDefFoundError: java/sql/Savepoint
The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint


What should have happened?:
The DSN should have been created in ColdFusion. So, I can create a recordset
in Dreamweaver MX.

Product version:
Product: ColdFusion MX
Version: 6,0,0,48097
Hardware: Pentium 4, CPU 2.66GHz,
OS Version: Windows XP, Home Edition, Service Pack 2
RAM: 512 MB

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url]