Skip to main content
J
jj2.
Participant
May 30, 2012
Question

Cache JDBC connection help

  • May 30, 2012
  • 2 replies
  • 1597 views

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.

    This topic has been closed for replies.

    2 replies

    J
    jj2.Author
    Participant
    May 31, 2012

    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

    C
    carl type3
    Legend
    May 30, 2012

    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.

    C
    carl type3
    Legend
    May 30, 2012

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices