Postgres Plus Advanced Server JDBC Guide : Table of Contents

Jump to content

1.1 Typographical Conventions Used in this Guide

2 Advanced Server JDBC Connector Overview

2.1 JDBC Driver Types

2.2 The JDBC Interface

2.3 JDBC Classes and Interfaces

2.4 The JDBC DriverManager

3 JDBC Installation

4 Using the Advanced Server JDBC Connector with Java applications

4.1 Loading the Advanced Server JDBC Connector

4.2 Connecting to the Database

4.2.1 Additional Connection Properties

4.3 Executing SQL Statements through Statement Objects

4.4 Retrieving Results from a ResultSet Object

4.5 Freeing Resources

4.6 Handling Errors

5 Executing SQL Commands with executeUpdate()

5.1 Using executeUpdate() to INSERT Data

5.1.1 executeUpdate() Syntax Examples

6 Adding a Graphical Interface to a Java Program

7 Advanced JDBC Connector Functionality

7.1 Reducing Client-side Resource Requirements

7.1.1 Modifying the Batch Size of a Statement Object

7.2 Using PreparedStatements to Send SQL Commands

7.3 Executing Stored Procedures

7.3.1 Invoking Stored Procedures

7.4 Using REF CURSORS with Java

7.4.1 Using a REF CURSOR to retrieve a ResultSet

7.5 Using BYTEA Data with Java

7.5.1 Inserting BYTEA Data into an Advanced Server database

7.5.2 Retrieving BYTEA Data from an Advanced Server database

7.6 Asynchronous Notification Handling with NoticeListener