Highlighted

JDBC connection error

Explorer ,
Jul 31, 2014

Copy link to clipboard

Copied

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

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.

TOPICS
Database access

Views

650

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

JDBC connection error

Explorer ,
Jul 31, 2014

Copy link to clipboard

Copied

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

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.

TOPICS
Database access

Views

651

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 31, 2014 0
Most Valuable Participant ,
Aug 04, 2014

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 04, 2014 0
Explorer ,
Aug 04, 2014

Copy link to clipboard

Copied

Yes, same driver version (6.05).

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 04, 2014 0
Adobe Community Professional ,
Aug 06, 2014

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 06, 2014 0
Explorer ,
Aug 07, 2014

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 07, 2014 0