Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere JDBC driver » Using the jConnect JDBC driver


Installing jConnect system objects into a database

If you want to use jConnect to access system table information (database metadata), you must add the jConnect system objects to your database.

You can add the jConnect system objects to the database when creating the database or at a later time by upgrading the database. You can upgrade a database from Sybase Central or by using the dbupgrad utility.

Windows Mobile

Do not add jConnect system objects to your Windows Mobile database. See Using jConnect on Windows Mobile.


You should always back up your database files before upgrading. If you apply the upgrade to the existing files, then these files become unusable if the upgrade fails. For information about backing up your database, see Backup and data recovery.

To add jConnect system objects to a database (Sybase Central)
  1. Connect to the database from Sybase Central as a DBA user.

  2. Select the database, if necessary, and then from the Tools menu choose SQL Anywhere 11 and then Upgrade Database.

  3. Follow the instructions in the Upgrade Database Wizard.

To add jConnect system objects to a database (dbupgrad)