Database metadata is always available when using a SQL Anywhere JDBC driver.
If you want to access database system tables (database metadata) from a JDBC application that uses jConnect, you must add a set of jConnect system objects to your database. 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 The jConnect JDBC driver.
The following complete Java application is a command line program 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 about how to create an internal connection from Java classes running inside the database server, see Establishing a connection from a server-side JDBC class.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|