Index

A

Adding a Graphical Interface to a Java Program Additional Connection Properties Advanced JDBC Connector Functionality

Advanced Server JDBC Connector Compatibility Advanced Server JDBC Connector Logging Advanced Server JDBC Connector Overview Asynchronous Notification Handling with NoticeListener

C

Conclusion Configuring the Advanced Server JDBC Connector

Configuring the Client Configuring the Server Connecting to the Database

E

enable logging with connection properties enable logging with logging.properties executeupdate() syntax examles executing a simple stored procedure Executing SQL Commands with executeUpdate()

Executing SQL Statements through Statement Objects Executing Stored Procedures executing stored procedures with in out parameters executing stored procedures with in parameters executing stored procedures with out parameters

F

Freeing Resources

H

Handling Errors

I

inserting bytea data into advanced server database Installing a DEB Package on a Debian or Ubuntu Host Installing and Configuring the JDBC Connector

Installing the Connector on an SLES 12 Host Installing the Connector with an RPM Package invoking stored procedures

J

jdbc classes jdbc driver types

jdbc drivermanager jdbc interface

L

Loading the Advanced Server JDBC Connector

M

modifying batch size of statement object

P

Preferring Synchronous Secondary Database Servers

R

Reducing Client-side Resource Requirements Reference - JDBC Data Types

Requirements Overview retrieving bytea data from advanced server database Retrieving Results from a ResultSet Object

S

sslmode connection parameters

supported platforms supported server versions

T

Testing the SSL JDBC Connection

U

Using BYTEA Data with Java Using Certificate Authentication (Without a Password) using collection using executeupdate() to insert data using named notation with a callablestatement object using object type Using Object Types and Collections with Java

Using PreparedStatements to Send SQL Commands using ref cursor to retrieve a resultset Using REF CURSORS with Java Using SSL using ssl without certificate validation Using the Advanced Server JDBC Connector with Java applications Using the Graphical Installer to Install the Connector

W

What’s New