Cache JDBC connection help

[jj2.]

Hi,

I am trying to create a JDBC connection to a Cache database in CF10 but I am not really sure where to begin.

I have imported the CacheDB.jar file into C:\ColdFusion10\cfusion\wwwroot\WEB-INF\lib. Is this the correct location?

I then created a CF Data Source in CF admin named test with a Driver Name of CacheDB.jar and a URL of jdbc:dbservername://dbserverip:1973/TESTDB. I have also entered the approriate username and password.

I get the following error when I try to verify the connection:

Connection verification failed for data source: test

java.sql.SQLException: No suitable driver available for test, please check the driver setting in resources file, error:

The root cause was that: java.sql.SQLException: No suitable driver available for test, please check the driver setting in resources file, error:

I am not really suprised as I'm certain my JDBC URL is completely wrong but I'm not sure what the appropriate settings are or even if I have the .jar file in the right spot.

Any assistance would be greatly appreciated.

Thanks.

[carl type3]

Try place JAR file in ColdFusion10\cfusion\lib then restart CF10 application server.

I did a test using Microsoft SQL JDBC driver as opposed to the built in CF macromedia  MS SQL Server driver.

Extract the SQLJDBC.JAR, place it in ColdFusion10\cfusion\lib, restart CF10, add datasource with correct JDBC URL details - worked.

HTH, Carl.

[carl type3]

Something else -  other than having the JDBC URL correct you are going to need a driver class syntax.

For the Microsoft SQL JDBC driver I mentioned the driver class is:

com.microsoft.sqlserver.jdbc.SQLServerDriver

I am not familiar with the cacheDB.jar (reader be aware I  guess) use this driver class syntax:

com.intersys.jdbc.CacheDriver

Hope helps again, Carl.

[jj2.]

Thanks for your help Carl.

For the benefit of others, I was able to get the connection working using the following settings:

JDBC URL: jdbc:Cache://DBSERVERIP:1972/DBNAME

Driver class: com.intersystems.jdbc.CacheDriver

Driver name: CacheDB.jar