TechNote (Archived)

Diagnostic JAR file for data source connection issues

Issue

When creating or configuring a data source in Macromedia ColdFusion MX (English version only) and the verification process fails, the following error is displayed:

 Connection verification failed for data source:data_source_name   []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.

Although accurate in some cases, the error above is generated for any data source connection error, regardless of the true error. This TechNote provides a diagnostic JAR file that enables ColdFusion MX to provide the proper error message, which assists in diagnosing the issue preventing a successful connection to the data source. This diagnostic tool is included in ColdFusion MX Updater Release 3 or higher, so the JAR file below is not needed if Updater 3 or MX 6.1 has been installed.

Solution

Windows:

Download the JAR file (1.6 KB).
Stop the ColdFusion Application service.
Unzip the downloaded JAR file into thecf_root/runtime/servers/lib directory.

Note: If this directory does not exist, you will need to create it.
Restart the ColdFusion Application service.
Step through the verification process for the data source to generate the proper error message.

Unix:

Download the JAR file (1.6 KB).
Stop the ColdFusion process.
Unzip the downloaded JAR file into thecf_root/runtime/servers/lib directory.

Note: If this directory does not exist, you will need to create it.
Edit the cf_root/runtime/bin/jvm.config file, adding the path for runtime/servers/lib into the classpath. Thismust go first in the classpath, not at the end.

Here is an example:
java.class.path={application.home}/runtime/servers/lib,{application.home}/runtime/../../src,{application.home}/lib/cfusion.jar,{application.home}/runtime/pointbase/lib/pbclient42RE.jar,{application.home}/runtime/pointbase/lib/pbembedded42RE.jar,{application.home}/runtime/pointbase/lib/pbserver42RE.jar,{application.home}/runtime/pointbase/lib/pbtools42RE.jar,{application.home}/runtime/lib/webservices.jar,
Restart the ColdFusion Application service.
Step through the verification process for the data source to generate the proper error message.