/
PostgreSQL DataSource

PostgreSQL DataSource

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]

 

 

Related content

JDBCStorageService
JDBCStorageService
More like this
BeanManagedConnection
BeanManagedConnection
More like this
BeanManagedConnection
BeanManagedConnection
More like this
BeanManagedConnection
BeanManagedConnection
More like this
SimpleManagedConnection
SimpleManagedConnection
More like this
SimpleManagedConnection
SimpleManagedConnection
More like this