Skip to main content
Jul 31, 2014 11:02 AM UTC
Answered

JDBC connection error

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

This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer
Aug 8, 2014 6:05 AM UTC

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.

4 replies

Correct answer
Aug 8, 2014 6:05 AM UTC

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.

Translate
Carl Von Stetten
Legend
Aug 4, 2014 8:52 PM UTC

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

Translate
Aug 5, 2014 1:12 AM UTC

Yes, same driver version (6.05).

Translate
BKBK
Community Expert
Community Expert
Aug 6, 2014 11:21 AM UTC

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).

Translate