No suitable driver - CF8 - JDBC sqljdbc.jar

Report · Jan 12, 2009

I have a new 64-bit server with Windows Server Standard 2007, SP1 and CF8 and am trying to get the Microsoft SQL Server 2005 JDBC Driver 1.2 set up for my data sources. We are using this driver today in our CF7 server just fine.

First, I was not the one who installed CF8 on this server, so I'm not sure if the issue is with that or not. But I have it configured for multi-instance and configured two additional instances, but for now I am just trying to create a data source in the default installation. I am able to use the built-in SQL Server driver with no issues, but we currently use the JDBC and don't want to switch now in case there are unanticipated variances.

I have followed the instructions in this configuration article, but I don't have a Java and JVM screen in my administrator, so I have added the driver path directly to my jvm.config file, stopped and restarted CF. Still I get the error. Here are the settings for my JVM classpath...

# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/servers/lib,{application.home}/lib
,C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar

I tried it in quotes, I tried it with forward slashes instead of backslashes. None of that worked. Here is the error I receive...

Connection verification failed for data source: Testing3
java.sql.SQLException: No suitable driver available for Testing3, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver
The root cause was that: java.sql.SQLException: No suitable driver available for Testing3, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver

Here are the data source settings (the same that work for us in CF7):

JDBC URL: jdbc:sqlserver://204.73.44.103:1433;DatabaseName=Testing3
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: JDBC

I don't know if my issue is that I have a J2EE installation (maybe why I don't see the Java and JVM settings page in Administrator). If that is my issue, how should I configure the driver? I've found nothing else online to address this.

Anyone who can help I'd much appreciate it! Thank you.

Report · Jan 12, 2009

I have found the solution to this. The sqljdbc.jar file must be placed in the ColdFusion classpath, then restart CF. For example,
cf_root/cfusion/lib (server configuration) or cf_webapp_root/WEB-INF/cfusion/lib (multiserver or J2EE configuration).

I was focusing on editing the jvm.config's class path, and all we needed to do was place the file in the noted directory. See this configuration document, page 48 - http://livedocs.adobe.com/coldfusion/8/configuring.pdf.

Report · Jan 23, 2009

The link posted in the reply includes a period at the end which will cause a broken link. ...pdf.