Data Access Using JDBC

This appendix describes how to use JDBC to access data.

JDBC can be used both from client applications and inside the database. Java classes using JDBC provide a more powerful alternative to SQL stored procedures for incorporating programming logic in the database.

• JDBC Overview
  JDBC provides a SQL interface for Java applications: if you want to access relational data from Java, use JDBC calls.
• Establish JDBC Connections
  This section presents classes that establish a JDBC database connection from a Java application.
• Use JDBC to Access Data
  Java applications that hold some or all classes in the database have significant advantages over traditional SQL stored procedures. At an introductory level, however, it may be helpful to use the parallels with SQL stored procedures to demonstrate the capabilities of JDBC.
• Sybase jConnect JDBC Driver
  If you wish to use JDBC from a client application or applet, you must have Sybase jConnect to connect to Sybase IQ databases.
• Distributed Applications
  In a distributed application, parts of the application logic run on one machine, and parts run on another machine. With Sybase IQ, you can create distributed Java applications, where part of the logic runs in the database server, and part on the client machine.