Database metadata is always available when using a SQL Anywhere JDBC driver.
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 How to establish a connection from a server-side JDBC class.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|