Skip to content
A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres
Java
Branch: develop
Clone or download
Pull request Compare This branch is 263 commits behind impossibl:develop.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
.gitignore
LICENSE
README.md
pom.xml

README.md

pgjdbc-ng

A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres

http://impossibl.github.io/pgjdbc-ng

Connection format

The connection format for the pgjdbc-ng driver is

jdbc:pgsql://<server>[:<port>]/<database>

An example

jdbc:pgsql://localhost:5432/test

Driver

The java.sql.Driver class is

com.impossibl.postgres.jdbc.PGDriver

The driver will accept configuration parameters in the style of

jdbc:pgsql://localhost:5432/test?applicationName=MyApp&networkTimeout=10000

Data sources

The javax.sql.DataSource class is

com.impossibl.postgres.jdbc.PGDataSource

, the javax.sql.ConnectionPoolDataSource class is

com.impossibl.postgres.jdbc.PGConnectionPoolDataSource

and the XADataSource class is

com.impossibl.postgres.jdbc.xa.PGXADataSource

Configuration

The driver and data sources supports the following configuration properties (name, type and default value).

host      (String) localhost

The 'host' parameter specifies the host name of the database server. Data sources only.

port         (int)     5432

The 'port' parameter specifies the port number of the database server. Data sources only.

database     (String)

The 'database' parameter specifies the name of the database on the database server. Data sources only.

user   (String)

The 'user' parameter specifies the user name.

password     (String)

The 'password' parameter specifies the password.

housekeeper      (boolean) true

The 'housekeeper' parameter specifies if the JDBC driver should keep track connections, statements and result sets and automatically close them if they can't no longer be reached.

parsedSqlCacheSize   (int)   250

The 'parsedSqlCacheSize' parameter specifies how big the cache size for parsed SQL statements should be.

preparedStatementCacheSize (int)     50

The 'preparedStatementCacheSize' parameter specifies how big the cache size for PreparedStatement instaces should be.

applicationName          (String)  pgjdbc app

The 'applicationName' parameter specifies the application name associated with the connection on the database server.

clientEncoding          (String)  UTF8

The 'clientEncoding' parameter specifies the client encoding for the database server.

networkTimeout         (int)     0

The 'networkTimeout' parameter specifies the default timeout in milliseconds for the connections. A value of 0 indicates that there isnt a timeout for database operations.

strictMode          (boolean)  false

The 'strictMode' parameter specifies if the JDBC driver should follow behavior assumed by certain frameworks, and test suites. See http://github.com/impossibl/pgjdbc-ng/wiki/StrictMode for additional details.

License

pgjdbc-ng is released under the 3 clause BSD license.

Building

The driver is built with maven. Simply build with:

mvn clean package

This will produce, in the target directory, two JAR files. One with dependencies packaged inside and another without.

Testing

The unit tests need a PostgreSQL database to execute against. The tests assume theses defaults:

SERVER:     localhost
PORT:       5432
DATABASE:   test
USERNAME:   pgjdbc
PASSWORD:   test

The following system properties are supported in order to customize the setup

pgjdbc.test.server
pgjdbc.test.port
pgjdbc.test.db
pgjdbc.test.user
pgjdbc.test.password

If you'd like to build the driver without running the unit tests use the command:

mvn clean package -DskipTests
You can’t perform that action at this time.