Connect From a JDBC Client Application Using jConnect

If you wish to access database system tables (database metadata) from a JDBC application, you must add a set of jConnect system objects to your database.

If you wish to access database system tables (database metadata) from a JDBC application, you must add a set of jConnect system objects to your database. Asajdbc shares the same stored procedures for database metadata support with jConnect. These procedures are installed to all databases by default. The iqinit switch -i prevents this installation.

The -i switch is common to iqinit and the SQL Anywhere utility dbinit. For descriptions of the -i switch, see SQL Anywhere Server - Database Administration > Administering Your Database > Database administration utilities > Initialization utility (dbinit).

The following complete Java application is a command-line application that connects to a running database, prints a set of information to your command line, and terminates.

Establishing a connection is the first step any JDBC application must take when working with database data.

• External Connection Example Code
  The source code for the methods used to make a connection.
• How the External Connection Example Works
  The external connection example is a Java command-line application.
• Running the External Connection Example
  This section describes how to run the external connection example