Host Integrator JDBC Connector Introduction

The JDBC connector provides an industry standard Structured Query Language (SQL) interface to Host Integrator Servers. Although the server is not a relational database system, the Design Tool's Table and Procedure feature provides access to the host application in a way that simulates traditional relational database tables. The JDBC connector works only if you're accessing host data using procedures; accessing host data at the model or terminal level is not an option.

This section describes how to use the JDBC connector and covers the following topics:

Connecting to a Host Integrator Server using the ApptrieveDriver class.
Using standard SQL statements to retrieve, create, update, and delete information.
Handling SQLExceptions.
Using Prepared statements.
Executing Table Procedures using the CallableStatement class.
Accessing table metadata.

This document assumes that you are familiar with using JDBC to access a standard relational database and also that you understand the basics of creating procedures and tables using the Design Tool. Click here for links to Sun Javasoft web pages that describe how to use JDBC and how to find helpful books about JDBC.