Postgresql JDBC Driver
Clone or download
Latest commit ef14cea Jan 20, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github Update pull_request_template.md (#1367) Dec 8, 2018
.travis fix: as of v12 recovery.conf is no longer used for standby recovery. … ( Nov 26, 2018
certdir Fix formatting Dec 14, 2018
docs Update waffle-jna to new artifact coordinates (#1383) Jan 7, 2019
packaging packaging: sync RPM spec with Fedora Rawhide Jul 13, 2018
pgjdbc test: avoid locale-dependent output in SetObject310Test Jan 20, 2019
test-anorm-sbt fix: json should be returned as PGObject, not as String for backward … Sep 17, 2016
.gitattributes chore: fetch contributors' URL via GitHub API Jul 11, 2018
.gitignore chore: update gettext plugin, sort po files Jun 5, 2018
.travis.yml chore: use openjdk7 to boostrap Travis CI images for JDK 6 (#1366) Dec 8, 2018
CHANGELOG.md docs: fix link to pull request 1052 in 42.2.3 changelog (#1345) Nov 22, 2018
CONTRIBUTING.md Fix link to Test Suite Howto (#1369) Dec 10, 2018
LICENSE docs: change license to BSD-2-Clause (#660) Oct 19, 2016
README.md Support custom 'options' connection property (#1356) Dec 6, 2018
TESTING.md Update testing documents, and point to jackdb/pgjdbc-test-vm (#1363) Dec 8, 2018
appveyor.yml chore: skip CI builds for tags; skip Fedora and extendedCacheEverythi… Jan 15, 2018
backend_protocol_v4_wanted_features.md doc: backend protocol, wanted features Feb 7, 2016
build.properties test: fix misspelled secondaryPort2 build property (#1284) Nov 28, 2018
codecov.yml chore: update gettext plugin, sort po files Jun 5, 2018
contributors.json docs: update site for 42.2.5 Aug 27, 2018
pom.xml [maven-release-plugin] prepare for next development iteration Aug 27, 2018
release_notes.sh chore: fetch contributors' URL via GitHub API Jul 11, 2018
release_notes_filter.pl chore: fetch contributors' URL via GitHub API Jul 11, 2018
release_stage.sh chore: implement a script to stage pgjdbc, pgdjbc-jre7, pgjdbc-jre6 a… May 6, 2017
settings.xml chore: introduce release via Travis Jan 15, 2018
ssltest.properties security: implement SSL hostname verification for non-default (LibPQF… Aug 27, 2018
toolchains.xml test: add jdk9 Travis job Jun 14, 2016

README.md

Slonik Duke

PostgreSQL JDBC Driver

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 PostgreSQL native network protocol.

Status

Build Status codecov.io Maven Central Javadocs License Join the chat at https://gitter.im/pgjdbc/pgjdbc

Supported PostgreSQL and Java versions

The current version of the driver should be compatible with PostgreSQL 8.2 and higher using the version 3.0 of the protocol, and Java 6 (JDBC 4.0), Java 7 (JDBC 4.1) and Java 8 (JDBC 4.2). Unless you have unusual requirements (running old applications or JVMs), this is the driver you should be using.

PgJDBC regression tests are run against all PostgreSQL versions since 8.2, including "build PostgreSQL from git master" version. There are other derived forks of PostgreSQL but have not been certified to run with PgJDBC. If you find a bug or regression on supported versions, please fill an Issue.

Get the Driver

Most people do not need to compile PgJDBC. You can download the precompiled driver (jar) from the PostgreSQL JDBC site or using your chosen dependency management tool:

Maven Central

You can search on The Central Repository with GroupId and ArtifactId Maven Search for:

Java 8

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.5</version>
</dependency>

Java 7

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.5.jre7</version>
</dependency>

Java 6

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.5.jre6</version>
</dependency>

Development snapshots

Snapshot builds (builds from master branch) are also deployed to Maven Central, so you can test current development version (test some bugfix) using:

<dependency>
  <groupId>org.postgresql</groupId>
  <artifactId>postgresql</artifactId>
  <version>42.2.6-SNAPSHOT</version> <!-- Java 8 -->
  <version>42.2.6.jre7-SNAPSHOT</version> <!-- Java 7 -->
  <version>42.2.6.jre6-SNAPSHOT</version> <!-- Java 6 -->
</dependency>

There are also available (snapshot) binary RPMs in Fedora's Copr repository.


Documentation

For more information you can read the PgJDBC driver documentation or for general JDBC documentation please refer to The Java™ Tutorials.

Driver and DataSource class

Implements Class
java.sql.Driver org.postgresql.Driver
javax.sql.DataSource org.postgresql.ds.PGSimpleDataSource
javax.sql.ConnectionPoolDataSource org.postgresql.ds.PGConnectionPoolDataSource
javax.sql.XADataSource org.postgresql.xa.PGXADataSource

Building the Connection URL

The driver recognises JDBC URLs of the form:

jdbc:postgresql:database
jdbc:postgresql:
jdbc:postgresql://host/database
jdbc:postgresql://host/
jdbc:postgresql://host:port/database
jdbc:postgresql://host:port/

The general format for a JDBC URL for connecting to a PostgreSQL server is as follows, with items in square brackets ([ ]) being optional:

jdbc:postgresql:[//host[:port]/][database][?property1=value1[&property2=value2]...]

where:

  • jdbc:postgresql: (Required) is known as the sub-protocol and is constant.
  • host (Optional) is the server address to connect. This could be a DNS or IP address, or it could be localhost or 127.0.0.1 for the local computer. To specify an IPv6 address your must enclose the host parameter with square brackets (jdbc:postgresql://[::1]:5740/accounting). Defaults to localhost.
  • port (Optional) is the port number listening on the host. Defaults to 5432.
  • database (Optional) is the database name. Defaults to the same name as the user name used in the connection.
  • propertyX (Optional) is one or more option connection properties. For more information see Connection properties.

Connection Properties

In addition to the standard connection parameters the driver supports a number of additional properties which can be used to specify additional driver behaviour specific to PostgreSQL™. These properties may be specified in either the connection URL or an additional Properties object parameter to DriverManager.getConnection.

Property Type Default Description
user String null The database user on whose behalf the connection is being made.
password String null The database user's password.
options String null Specify 'options' connection initialization parameter.
ssl Boolean false Control use of SSL (true value causes SSL to be required)
sslfactory String null Provide a SSLSocketFactory class when using SSL.
sslfactoryarg (deprecated) String null Argument forwarded to constructor of SSLSocketFactory class.
sslmode String null Parameter governing the use of SSL.
sslcert String null The location of the client's SSL certificate
sslkey String null The location of the client's PKCS#8 SSL key
sslrootcert String null The location of the root certificate for authenticating the server.
sslhostnameverifier String null The name of a class (for use in Class.forName(String)) that implements javax.net.ssl.HostnameVerifier and can verify the server hostname.
sslpasswordcallback String null The name of a class (for use in Class.forName(String)) that implements javax.security.auth.callback.CallbackHandler and can handle PasswordCallback for the ssl password.
sslpassword String null The password for the client's ssl key (ignored if sslpasswordcallback is set)
sendBufferSize Integer -1 Socket write buffer size
recvBufferSize Integer -1 Socket read buffer size
loggerLevel String null Logger level of the driver using java.util.logging. Allowed values: OFF, DEBUG or TRACE.
loggerFile String null File name output of the Logger, if set, the Logger will use a FileHandler to write to a specified file. If the parameter is not set or the file can't be created the ConsoleHandler will be used instead.
allowEncodingChanges Boolean false Allow for changes in client_encoding
logUnclosedConnections Boolean false When connections that are not explicitly closed are garbage collected, log the stacktrace from the opening of the connection to trace the leak source
binaryTransferEnable String "" Comma separated list of types to enable binary transfer. Either OID numbers or names
binaryTransferDisable String "" Comma separated list of types to disable binary transfer. Either OID numbers or names. Overrides values in the driver default set and values set with binaryTransferEnable.
prepareThreshold Integer 5 Statement prepare threshold. A value of -1 stands for forceBinary
preparedStatementCacheQueries Integer 256 Specifies the maximum number of entries in per-connection cache of prepared statements. A value of 0 disables the cache.
preparedStatementCacheSizeMiB Integer 5 Specifies the maximum size (in megabytes) of a per-connection prepared statement cache. A value of 0 disables the cache.
defaultRowFetchSize Integer 0 Positive number of rows that should be fetched from the database when more rows are needed for ResultSet by each fetch iteration
loginTimeout Integer 0 Specify how long to wait for establishment of a database connection.
connectTimeout Integer 10 The timeout value used for socket connect operations.
socketTimeout Integer 0 The timeout value used for socket read operations.
tcpKeepAlive Boolean false Enable or disable TCP keep-alive.
ApplicationName String null The application name (require server version >= 9.0)
readOnly Boolean true Puts this connection in read-only mode
disableColumnSanitiser Boolean false Enable optimization that disables column name sanitiser
assumeMinServerVersion String null Assume the server is at least that version
currentSchema String null Specify the schema to be set in the search-path
targetServerType String any Specifies what kind of server to connect, possible values: any, master, slave (deprecated), secondary, preferSlave (deprecated), preferSecondary
hostRecheckSeconds Integer 10 Specifies period (seconds) after which the host status is checked again in case it has changed
loadBalanceHosts Boolean false If disabled hosts are connected in the given order. If enabled hosts are chosen randomly from the set of suitable candidates
socketFactory String null Specify a socket factory for socket creation
socketFactoryArg (deprecated) String null Argument forwarded to constructor of SocketFactory class.
autosave String never Specifies what the driver should do if a query fails, possible values: always, never, conservative
preferQueryMode String extended Specifies which mode is used to execute queries to database, possible values: extended, extendedForPrepared, extendedCacheEverything, simple
reWriteBatchedInserts Boolean false Enable optimization to rewrite and collapse compatible INSERT statements that are batched.

Contributing

For information on how to contribute to the project see the Contributing Guidelines


Sponsors