EDB Postgres Connectors → 10.0.3 → User Guides → JDBC Guide Other versions of this page: 11.0.3 · 11.0.2 · 11.0.1 · 10.0.3 · 10.0.2 · 10.0.1 · 10.0.0 · 9.6.0.3 · 9.6.0.2 · 9.5.1
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
Try it Now Free
Table of Contents 1 Introduction 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 2.5 Advanced Server JDBC Connector Compatibility 3 JDBC Installation 3.1 Installing the JDBC Connector 3.1.1 Installing the Connector with an RPM Package 3.1.2 Installing the Connector on an SLES 12 Host 3.1.3 Using the Graphical Installer to Install the Connector 3.2 Configuring the Advanced Server JDBC Connector 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.2.2 Preferring Synchronous Secondary Database Servers 4.2.2.1 Configuring Master and Secondary Database Servers Overview 4.2.2.2 Sample Master and Secondary Database Servers 4.3 Executing SQL Statements through Statement Objects 4.3.1 Using Named Notation with a CallableStatement Object 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.3.1.1 Executing a Simple Stored Procedure 7.3.1.2 Executing Stored Procedures with IN parameters 7.3.1.3 Executing Stored Procedures with OUT parameters 7.3.1.4 Executing Stored Procedures with IN OUT parameters 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 Using Object Types and Collections with Java 7.6.1 Using an Object Type 7.6.2 Using a Collection 7.7 Asynchronous Notification Handling with NoticeListener 8 Advanced Server JDBC Connector Logging 8.1 Enable Logging with Connection Properties (static) 8.2 Enable Logging with logging.properties (dynamic) 9 Reference - JDBC Data Types