- 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
SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0
11614049, sybase , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.