Progress
JDBC Driver Guide


Preface

Purpose

This guide provides an overview of the Java Database Connectivity (JDBC) interface and the Progress SQL-92 JDBC Driver, which provides access to the Progress database from applications that support JDBC. It describes how to set up and use the driver and details the driver’s support for the JDBC interface. The Progress SQL-92 JDBC Driver is supplied by MERANT Inc., formerly known as INTERSOLV.

Audience

This book is designed as a guide for anyone who wants to use the Progress SQL-92 JDBC driver to access a Progress Version 9 database from a Java application.

Organization of This Manual

"Introduction"

Introduces the Progress SQL-92 JDBC driver and describes how it works.

"Basic JDBC Driver Operations"

Describes basic JDBC Driver operations: setup, required software, using the sample program, connecting to databases, and managing transactions.

"JDBC Conformance Notes"

Details the information returned by the JDBC driver to the DatabaseMetadata methods and lists the supported SQL and corresponding Java data types.

"Sample Program Source Code"

Provides a source-code listing of the ProgressTest.java sample Java application that uses the JDBC Driver.

"Glossary"

Defines terms introduced in this guide.

How to Use This Manual

This book assumes that you have successfully installed the Progress database as described in the Installation Notes Progress Version 9 for Windows or the Installation Notes Progress Version 9 for UNIX .

Typographical Conventions

This manual uses the following typographical conventions:

The following typographical conventions are used to represent keystrokes:

Syntax Notation

The syntax for each SQL-92 component follows a set of conventions:

Other Useful Documentation

This section lists Progress Software Corporation documentation that you might find useful. Unless otherwise specified, these manuals support both Windows and Character platforms and are provided in electronic documentation format on CD-ROM.

Getting Started

Progress Installation and Configuration Guide Version 9 for UNIX

A manual that describes how to install and set up Progress Version 9.1 for the UNIX operating system.

Progress Installation and Configuration Guide Version 9 for Windows

A manual that describes how to install and set up Progress Version 9.1 for all supported Windows and Citrix MetaFrame operating systems.

Progress Version 9 Product Update Bulletin

A guide that provides a brief description of each new feature of the release. The booklet also explains where to find more detailed information in the documentation set about each new feature.

Progress Master Index and Glossary for Windows and Progress Master Index and Glossary for Character (Hard copy only)

Platform-specific master indexes and glossaries for the Progress hard-copy documentation set.

Progress Startup Command and Parameter Reference

A reference manual that describes the Progress startup commands and parameters in alphabetical order.

Welcome to Progress (Hard copy only)

A booklet that explains how Progress software and media are packaged. An icon-based map groups the documentation by functionality, providing an overall view of the documentation set. Welcome to Progress also provides descriptions of the various services Progress Software Corporation offers.

4GL

Progress Internationalization Guide

A guide to developing Progress applications for markets worldwide. The guide covers both internationalization—writing an application so that it adapts readily to different locales (languages, cultures, or regions)—and localization—adapting an application to different locales.

Database

Progress Database Design Guide

A guide that uses a sample database and the Progress Data Dictionary to illustrate the fundamental principles of relational database design. Topics include relationships, normalization, indexing, and database triggers.

Progress Database Administration Guide and Reference

This guide describes Progress database administration concepts and procedures. The procedures allow you to create and maintain your Progress databases and manage their performance.

DataServers

Progress DataServer Guides

These guides describe how to use the DataServers to access non-Progress databases. They provide instructions for building the DataServer modules, a discussion of programming considerations, and a tutorial. Each DataServer has its own guide, such as: the Progress DataServer for Microsoft SQL Server Guide , the Progress DataServer for ODBC Guide , the Progress DataServer for ORACLE Guide , or the Progress/400 Product Guide .

SQL-92

Progress Embedded SQL-92 Guide and Reference

A guide to Progress Embedded SQL-92 for C, including step-by-step instructions for building ESQL-92 applications and reference information about all Embedded SQL-92 Preprocessor statements and supporting function calls. This guide also describes the relationship between ESQL-92 and the ANSI standards upon which it is based.

Progress ODBC Driver Guide

A guide to the ODBC interface and the Progress SQL-92 ODBC driver. It describes how to set up and use the driver and details the driver’s support for the ODBC interface.

Progress SQL-92 Guide and Reference

A user guide and reference for programmers who use Progress SQL-92. It includes information on all supported SQL-92 statements, SQL-92 Data Manipulation Language components, SQL-92 Data Definition Language components, and Progress functions. The guide describes how to use the Progress SQL-92 Java classes and how to create and use Java stored procedures and triggers.

Java and JDBC Reference

The JavaTutorial

Mary Campione and Kathy Walrath
http://java.sun.com/docs/books/tutorial/index.html

The JavaLanguage Environment: A White Paper

James Gosling & Henry McGilton
http://java.sun.com/docs/white/langenv/

The JDBCDatabase Access API

http://www.javasoft.com/products/jdbc/index.html

Hamilton, Graham, Rick Cattell, Maydene Fisher. 1997. JDBC Database Access with Java ‘. Reading, MA: Addison Wesley.

SQL-92 Reference

A Guide to the SQL Standard

Date, C.J., with Hugh Darwen. 1997. Reading, MA: Addison Wesley.

Understanding the New SQL: A Complete Guide

Melton, Jim (Digital Equipment Corporation) and Alan R. Simon. 1993. San Francisco: Morgan Kaufmann Publishers.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095