Skip to main content
Inspiring
November 25, 2024
Answered

Coldfusion 2023 and Sybase JDBC 3 datasource error

  • November 25, 2024
  • 2 replies
  • 1612 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
Braniac
November 27, 2024

Hello @tope316 ,

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

Thanks for sharing the solution.

Charlie Arehart
Braniac
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)
tope316Author
Inspiring
November 26, 2024

Hello @Charlie Arehart  and @Dave Watts , thanks for your replies.

 

We are using standard version and I was able to setup the JDBC 4 connector and was able to add the datasource in Coldfusion Admin.

 

However, when querying the tables there is an error message: 

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.

 

By the way we are using Adaptive Server Anywhere 9 as the database server. Thanks for all your help.

tope316Author
Inspiring
November 26, 2024
quote

By the way, when I use this to connect to SQL Anywhere 17 it works. It just does not work on Adaptive Server Anywhere 9.

 

Does this mean we need to upgrade our database server from version 9 to 17?


By @tope316

Good to hear that Anywhere 17 works. JConnect is indeed the correct JDBC driver to use, not the SQL Anywhere JDBC 3 or SQL Anywhere JDBC 4 driver. As JConnect is a pure-Java driver, chances are high that it will be compatible with different ColdFusion versions. After all, ColdFusion is itself a Java application.

Whereas, the SQL Anywhere JDBC drivers, not being pure-Java, will depend on the Operating System. For example, the SQL Anywhere JDBC 4.0 driver depends on the Windows native component dbjdbc12.dll.


So, stay with the JConnect driver, even for Anywhere 9. The error message,

 Connection verification failed for data source: java.sql.SQLException: JZ00L: Login failed.

suggests you're on the right track. Make sure you use the correct credentials for logging into the database.

 


Hello @BKBK,

 

Thank you for your reply.

 

I double checked and I am using the correct username and password. I do not know why this is giving me this error message.