Adobe Community: Message List - JDBC connection error

Re: JDBC connection error

forums_noreply@adobe.com — Fri, 08 Aug 2014 06:05:09 GMT

Thank you Carl Von Stetten and BKBK for your help.

Just a day ago, I was able fix the connection error. I downloaded the newer version of the JDBC driver (7.0.7) and the DSN was able to connect to the database.

Re: JDBC connection error

forums_noreply@adobe.com — Wed, 06 Aug 2014 11:21:35 GMT

It could be that Sybase jConnect 6.05 is suitable for the Java version of Coldfusion 9 (v1.6), but not for that of Coldfusion 11 (v1.7).

Re: JDBC connection error

forums_noreply@adobe.com — Tue, 05 Aug 2014 01:12:14 GMT

Yes, same driver version (6.05).

Re: JDBC connection error

forums_noreply@adobe.com — Mon, 04 Aug 2014 20:52:52 GMT

Are you using the same driver version (6.05) on the CF9 server?

JDBC connection error

forums_noreply@adobe.com — Thu, 31 Jul 2014 11:02:40 GMT

I'm trying to create a DSN in ColdFusion Standard v11 server using Sybase jConnect 6.05 JDBC driver connecting to a Sybase SQL AnyWhere 12 Server (running on another server machine). ColdFusion has been installed on a brand new Windows 2012 (Standard) Server and uses IIS 8 for the web server.

I have done everything mentioned on this page (of course, the driver class and other details have been modified) ColdFusion MX: Configuring the Sybase jConnect 5.5 driver

When I try to verify the connection in CF Administrator, it throws the following error:

Connection verification failed for data source: ars_jdbc

java.sql.SQLException: The method com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getJDBCMajorVersion() has not been completed and should not be called.

The root cause was that: java.sql.SQLException: The method com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getJDBCMajorVersion() has not been completed and should not be called.

I know that, all the connection parameters are correct because I have been able to create a DSN on another CF instance (CF 9) to the same database that I am trying to create a DSN for from CF 11. Please guide me in the right direction to fix the problem.

Thanks.

Milind