PostgreSQL DataSource

Owned by Philip Smart
Last updated: Nov 12, 2024
1 min read

If you would like to use PostgreSQL, please keep in mind the class org.postgresql.Driver is a JDBC Driver, and not a JDBC DataSource.

PostgreSQL provides three JDBC DataSource implementations, namely; PGConnectionPoolDataSource, PGPoolingDataSource, and PGSimpleDataSource. Their pooling data source implementations are deprecated, and you should use a more modern connection pooling implementation, such as those described in the Examples section.

To wire those up:

  • use org.postgresql.Driver as the driverClassName.

  • use a JDBC URL based on the following format: jdbc:postgresql://[hostname]:[port]/[database][?properties]

 

Â