EDB Postgres™ Advanced Server JDBC Connector Guide

The JDBC connector provides connectivity between a Java application and an Advanced Server database. This guide provides installation instructions, usage instructions, and examples that demonstrate the Advanced Server specific functionality of the JDBC Connector.

The JDBC connector is written in Java and conforms to Sun’s JDK architecture. For more information, see JDBC Driver Types

The JDBC connector is built on and supports all of the functionality of the PostgreSQL community driver. For more information about the features and functionality of the driver, please refer to the community documentation.

• What’s New
• Requirements Overview
  • Supported Versions
  • Supported Platforms
• Advanced Server JDBC Connector Overview
  • JDBC Driver Types
  • The JDBC Interface
  • JDBC Classes and Interfaces
  • The JDBC DriverManager
  • Advanced Server JDBC Connector Compatibility
• Installing and Configuring the JDBC Connector
  • Installing the Connector with an RPM Package
    • Updating an RPM Installation
  • Installing the Connector on an SLES 12 Host
  • Installing a DEB Package on a Debian or Ubuntu Host
  • Using the Graphical Installer to Install the Connector
  • Configuring the Advanced Server JDBC Connector
• Using the Advanced Server JDBC Connector with Java applications
  • Loading the Advanced Server JDBC Connector
  • Connecting to the Database
    • Additional Connection Properties
    • Preferring Synchronous Secondary Database Servers
  • Executing SQL Statements through Statement Objects
    • Using Named Notation with a CallableStatement Object
  • Retrieving Results from a ResultSet Object
  • Freeing Resources
  • Handling Errors
• Executing SQL Commands with executeUpdate()
  • Using executeUpdate() to INSERT Data
    • executeUpdate() Syntax Examples
• Adding a Graphical Interface to a Java Program
• Advanced JDBC Connector Functionality
  • Reducing Client-side Resource Requirements
    • Modifying the Batch Size of a Statement Object
  • Using PreparedStatements to Send SQL Commands
  • Executing Stored Procedures
    • Invoking Stored Procedures
  • Using REF CURSORS with Java
    • Using a REF CURSOR to retrieve a ResultSet
  • Using BYTEA Data with Java
    • Inserting BYTEA Data into an Advanced Server database
    • Retrieving BYTEA Data from an Advanced Server database
  • Using Object Types and Collections with Java
    • Using an Object Type
    • Using a Collection
  • Asynchronous Notification Handling with NoticeListener
• Using SSL
  • Configuring the Server
  • Configuring the Client
    • sslmode Connection Parameters
  • Testing the SSL JDBC Connection
    • Using SSL without Certificate Validation
  • Using Certificate Authentication (Without a Password)
• Advanced Server JDBC Connector Logging
  • Enabling Logging with Connection Properties (static)
  • Enabling Logging with logging.properties (dynamic)
• Reference - JDBC Data Types
• Conclusion