To support JDBC DatabaseMetaData methods, Sybase provides a set of stored procedures that jConnect can call for metadata about a database. These stored procedures must be installed on the server for the JDBC metadata methods to work.
Previously, jConnect provided only one script to install the SQL Anywhere® stored procedures. In ESD #14, jConnect separates the metadata script files for the different versions of SQL Anywhere:
sql_asa.sql – installs stored procedures on the SQL Anywhere 9.x database
sql_asa10.sql – installs stored procedures on the SQL Anywhere 10.x database
sql_asa11.sql – installs stored procedures on the SQL Anywhere 11.x database
For more information, see the “Accessing database metadata” section of the jConnect for JDBC Programmer’s Reference.
