SAP Knowledge Base Article - Preview

1935412 - How do you install jConnect database metadata support in SQL Anywhere 11 and above? (Error: SQLException: JZ0SJ: Metadata accessor information was not found on this database.)

Symptom

  • The SAP SQL Anywhere database is compatible with the jConnect JDBC driver (which is a Type-4 JDBC driver, and uses the Tabular Data Stream (TDS) protocol for communications). However, some JDBC functionality in jConnect (related to accessing the database metadata class java.sql.DatabaseMetaData) when using SQL Anywhere is only enabled after installing the jConnect metadata database functions into the database file.
  • When connecting or using certain JDBC functions, you receive the error or exception:

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


  • The method to install the jConnect metadata functions changed in SQL Anywhere 11 from previous versions. How do you install the database jConnect metadata support in these newer versions of SQL Anywhere?
  • Where is the "\scripts\jcatalog.sql" jConnect metadata installation file located and why is the "-j" switch for the Initialization Utility (dbinit) in SQL Anywhere 11 (and higher) no longer documented?

Read more...

Environment

  • SAP SQL Anywhere 16
    SAP SQL Anywhere 12
    SAP SQL Anywhere 11
  • All supported platforms
  • SAP jConnect JDBC Driver

Product

SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0

Keywords

11614049, sybase , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.