The PostgreSQL JDBC Interface

Table of Contents

Introduction

Setting up the JDBC Driver

Getting the Driver
Setting up the Class Path
Preparing the Database Server for JDBC
Creating a Database

Initializing the Driver

Importing JDBC

Loading the Driver

Connecting to the Database

Connection Parameters

Configuring the Server

Configuring the Client

Using SSL without Certificate Validation

Custom SSLSocketFactory

Issuing a Query and Processing the Result

Getting results based on a cursor
Using the Statement or PreparedStatement Interface
Using the ResultSet Interface
Performing Updates
Creating and Modifying Database Objects

Calling Stored Functions

Obtaining a ResultSet from a stored function

From a Function Returing SETOF type
From a Function Returing a refcursor

Storing Binary Data

JDBC escapes

Escape for like escape character
Escape for outer joins
Date-time escapes
Escaped scalar functions

PostgreSQL Extensions to the JDBC API

Accessing the Extensions
Geometric Data Types
Large Objects
Listen / Notify
Server Prepared Statements

Using the Driver in a Multithreaded or a Servlet Environment

Connection Pools and Data Sources

Overview
Application Servers: ConnectionPoolDataSource
Applications: DataSource
Tomcat setup
Data Sources and JNDI

Further Reading

		Next >>>
		Introduction