Skip to main content
Inspiring
November 25, 2024
Answered

Coldfusion 2023 and Sybase JDBC 3 datasource error

  • November 25, 2024
  • 2 replies
  • 1650 views

Hello, I am trying to setup a datasource using the Sybase JDBC 3 driver that we have been using since Coldfusion 9 but I am getting an error message: "Connection verification failed for data source
java.sql.SQLException: The method com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getJDBCMajorVersion() has not been completed and should not be called."

 

Please help me on how to resolve this issue. Thanks!

 

This topic has been closed for replies.
Correct answer tope316

Hello Everyone,

 

I managed to resolve this issue.

Error Executing Database Query.

JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.

 

So for anyone that encounters this error in the future, here are the steps I did:

 

Adaptive Server Anywhere 9 Configuration:

  1.  Execute the file: [jConnect home directory]/jConnect-7_0/sp/sql_asa.sql using Interactive SQL.
  2.  Restart the DB Service.

 

Coldfusion 2023 Administrator Data Source Configuration:

  1.  Append this parameter in the JDBC URL: ";USE_METADATA=false"
  2.  For example: jdbc:sybase:Tds:127.0.0.1:59200/cf-utax;USE_METADATA=false

2 replies

tope316AuthorCorrect answer
Inspiring
November 27, 2024

Hello Everyone,

 

I managed to resolve this issue.

Error Executing Database Query.

JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.

 

So for anyone that encounters this error in the future, here are the steps I did:

 

Adaptive Server Anywhere 9 Configuration:

  1.  Execute the file: [jConnect home directory]/jConnect-7_0/sp/sql_asa.sql using Interactive SQL.
  2.  Restart the DB Service.

 

Coldfusion 2023 Administrator Data Source Configuration:

  1.  Append this parameter in the JDBC URL: ";USE_METADATA=false"
  2.  For example: jdbc:sybase:Tds:127.0.0.1:59200/cf-utax;USE_METADATA=false
BKBK
Community Expert
Community Expert
November 27, 2024

Hello @tope316 ,

I'm glad to hear that the issue is finally resolved.

Thanks for sharing the solution.

Charlie Arehart
Community Expert
Community Expert
November 25, 2024

Tope, and while I don't use sybase and don't KNOW your answer, I suspect your error relates to the jdbc3 jar you're using and that you need a jdbc4 version.

 

1) First, are you a license key for cf, or or the free trial or developer edition of cf? In those, as well as when using a cf enterprise license, Adobe provides a licensed sybase jdbc connector for you. Otherwise, yes, you need to provide one.

 

So unless you're using a cf Standard license, try just using the sybase driver option offered when creating a cf datasource (if none is offered, that's further confirmation you're on cf Standard. The top of the cf admin window also reports what cf edition you're running.)

 

If you go that route, you can remove that older sybase jar you'd implemented.

 

2) Finally, if you ARE running cf Standard and MUST add a jdbc driver, the it seems you need a newer one. I've looked, but I and it doesn't seem that sap offers that freely. So first, it seems you should be able to get the jar from within a folder of the installed sybase db you're connecting to. I realize that maybe on another machine, and perhaps you can't even get the people responsible for that to find it for you.

 

In that case, another option is to download the free trial of sybase, just to get the jar. Again, the sap makes you jump through hoops to get that trial (as does Adobe for cf's trial), but give it a shot: https://developers.sap.com/trials-downloads.html?search=jdbc

 

Someday that link may not work, and perhaps this will: https://www.sap.com/products/technology-platform/sybase-ase/trial.html

 

And finally this link used to work but doesn't as I try today: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect

 

Let us know if the simpler first solution above may suit you, or if you try the updated jar route. 

/Charlie (troubleshooter, carehart. org)
Community Expert
November 25, 2024

I agree with @Charlie Arehart here. Get the latest driver that your database supports! You might be able to find an open-source version if you can't use Sybase's own driver. I seem to recall a jTDS version being available.

 

Dave Watts, Eidolon LLC