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

• 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?

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

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