Installing jConnect system objects into a database

ASA Programming Guide
JDBC Programming
Using the jConnect JDBC driver

Installing jConnect system objects into a database

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

By default, the jConnect system objects are added to any new database. You can choose to add the jConnect objects to the database when creating, when upgrading, or at a later time.

You can install the jConnect system objects from Sybase Central or from Interactive SQL.

To add jConnect system objects to a database (Sybase Central )

Connect to the database from Sybase Central as a user with DBA authority.
In the left pane, right-click the database and choose Upgrade database from the popup menu.

The Upgrade a Database Wizard appears.
Follow the instructions in the wizard to add jConnect support to the database.

To add jConnect system objects to a database (Interactive SQL)

Connect to the database from Interactive SQL as a user with DBA authority, and enter the following command in the SQL Statements pane:
```
read path\scripts\jcatalog.sql
```
where path is your SQL Anywhere directory.

Tip

You can also use a command prompt to add the jConnect system objects to a database. At the command prompt, type:

dbisql -c "uid=user;pwd=pwd" path\scripts\jcatalog.sql

where user and pwd identify a user with DBA authority, and path is your SQL Anywhere directory.