Mar 13, 2024 · The PostgreSQL JDBC Driver allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. pgJDBC is an open source JDBC driver written in Pure Java (Type 4), and communicates in the …

PostgreSQL® JDBC Driver (pgJDBC for short) allows Java programs to connect to a PostgreSQL® database using standard, database independent Java code. Is an open source JDBC driver written in Pure Java (Type 4), and communicates in the …

Applications do not need to explicitly load the org.postgresql.Driver class because the pgJDBC driver jar supports the Java Service Provider mechanism. The driver will be loaded by the JVM when the application connects to PostgreSQL® (as …

Logging using java.util.logging Further Reading Setting up the JDBC Driver This section describes the steps you need to take before you can write or run programs that use the JDBC interface. Getting the Driver . Precompiled versions of the driver can be downloaded from the PostgreSQL® JDBC web site.

Using Java 8 Date and Time classes . The PostgreSQL® JDBC driver implements native support for the Java 8 Date and Time API(JSR-310) using JDBC 4.2. Table 5.1. Supported Java 8 Date and Time classes

Binary JAR file downloads of the JDBC driver are available here and the current version with Maven Repository. Because Java is platform neutral, it is a simple process of just downloading the appropriate JAR file and dropping it into your classpath. Source versions are also available here for recent driver versions. Latest SNAPSHOT versions.

PostgreSQL® is an extensible database system. You can add your own functions to the server, which can then be called from queries, or even add your own data types. As these are facilities unique to PostgreSQL®, we support them from Java, with a set of extension APIs.

PostgreSQL® provides a way for developers to customize how an SSL connection is established. This may be used to provide a custom certificate source or other extensions by allowing the developer to create their own SSLContext instance.

For an environment without an application server, PostgreSQL® provides two implementations of DataSource which an application can use directly. One implementation performs connection pooling, while the other simply provides access to database connections through the DataSource interface without any pooling.

The PostgreSQL® JDBC Driver supports the use of logging (or tracing) to help resolve issues with the pgJDBC Driver when is used in your application. The pgJDBC Driver uses the logging APIs of java.util.logging that is part of Java since JDK 1.4, which makes it a good choice for the driver since it doesn’t add any external dependency for a ...