The PostgreSQL JDBC Interface
Next
The PostgreSQL
JDBC
Interface
Table of Contents
1. Introduction
2. Setting up the JDBC Driver
Getting the Driver
Setting up the Class Path
Preparing the Database Server for JDBC
3. Initializing the Driver
Importing JDBC
Loading the Driver
Connecting to the Database
Closing the Connection
4. Issuing a Query and Processing the Result
Getting results based on a cursor
Using the Statement or PreparedStatement Interface
Using the ResultSet Interface
5. Performing Updates
6. Calling Stored Functions
Using the CallableStatement Interface
Obtaining ResultSet from a stored function
7. Creating and Modifying Database Objects
8. Storing Binary Data
9. PostgreSQL Extensions to the JDBC API
Accessing the Extensions
Class org.postgresql.PGConnection
Class org.postgresql.Fastpath
Class org.postgresql.fastpath.FastpathArg
Geometric Data Types
Large Objects
Class org.postgresql.largeobject.LargeObject
Class org.postgresql.largeobject.LargeObjectManager
10. Using the Driver in a Multithreaded or a Servlet Environment
11. Connection Pools and Data Sources
Overview
Application Servers: ConnectionPoolDataSource
Applications: DataSource
Tomcat setup
Data Sources and JNDI
12. Further Reading
List of Tables
11.1.
ConnectionPoolDataSource Implementations
11.2.
ConnectionPoolDataSource Configuration Properties
11.3.
DataSource Implementations
11.4.
DataSource Configuration Properties
11.5.
Additional Pooling DataSource Configuration Properties
List of Examples
4.1.
Processing a Simple Query in JDBC
4.2.
Setting fetch size to turn cursors on and off.
5.1.
Deleting Rows in JDBC
6.1.
Calling a built in stored function
6.2.
Getting refcursor values from a function
6.3.
Treating refcursor as a distinct type
7.1.
Dropping a Table in JDBC
8.1.
Processing Binary Data in JDBC
11.1.
DataSource Code Example
11.2.
DataSource JNDI Code Example