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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » JDBC support » The jConnect JDBC driver

 

Installing jConnect system objects into a database

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

Prerequisites

You must have the ALTER DATABASE, BACKUP DATABASE, and SERVER OPERATOR system privileges, and must be the only connection to the database.

Back up your database files before upgrading. If you attempt to upgrade a database and it fails, then the database becomes unusable.

Context and remarks

jConnect system objects are installed into a SQL Anywhere database by default when you use the dbinit utility. Also, jConnect system objects are not required for Windows Mobile databases. 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.

 Task
  1. Use the Sybase Central SQL Anywhere 16 plug-in to connect to the database.

  2. Click Tools » SQL Anywhere 16 and then click Upgrade Database.

  3. Follow the instructions in the Upgrade Database Wizard.

Results

The jConnect system objects are added to the database.

 See also