ASA Programming Guide
JDBC Programming
Establishing JDBC connections
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. The internal JDBC driver classes and jConnect share stored procedures for database metadata support. These procedures are installed to all databases by default. The dbinit -i option prevents this installation.
For more information about adding the jConnect system objects to a database, see Using the jConnect JDBC driver.
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.
This example illustrates an external connection, which is a regular client/server connection. For information on how to create an internal connection from Java classes running inside the database server, see Establishing a connection from a server-side JDBC class.
External connection example code
How the external connection example works
Running the external connection example