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
Using
SSL
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