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. However, their implementations for pooling data sources are deprecated, and you should use a more modern connection pooling implementation, such as those described in the Examples section.
To wire it those up:
use
org.postgresql.Driver
as thedriverClassName
.use a JDBC URL based on the following format:
jdbc:postgresql://[hostname]:[port]/[database][?properties]