Thread: [JDBC] Does the JDBC connection failover require Postgres 10?
The Postgres JDBC driver offers a way to specify multiple hosts in the connection URL: https://jdbc.postgresql.org/documentation/head/connect.html#connection-failover However, it is unclear to me if that feature relies on the libpq feature introduced in Postgres 10: https://www.postgresql.org/docs/current/static/libpq-connect.html#libpq-multiple-hosts or if this is handled by the driver internally? Thomas -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc
Hi Thomas,
The PgJDBC driver do not rely on the libpq library, the driver implements everything in pure Java.
Jorge Solórzano
On Fri, Nov 3, 2017 at 5:53 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
The Postgres JDBC driver offers a way to specify multiple hosts in the connection URL:
https://jdbc.postgresql.org/documentation/head/connect.html #connection-failover
However, it is unclear to me if that feature relies on the libpq feature introduced in Postgres 10:
https://www.postgresql.org/docs/current/static/libpq-connec t.html#libpq-multiple-hosts
or if this is handled by the driver internally?
Thomas
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
The Postgres JDBC driver offers a way to specify multiple hosts in the connection URL:
https://jdbc.postgresql.org/documentation/head/connect. html#connection-failover
However, it is unclear to me if that feature relies on the libpq feature introduced in Postgres 10:
https://www.postgresql.org/docs/current/static/libpq- connect.html#libpq-multiple- hosts
or if this is handled by the driver internally?
In short, it is handled by the driver internally.
There is no server support (which make sense given failure to connect would preclude the presence of a server) in the libpq implementation of this behavior - i.e., its not a protocol thing but a client implementation. The JDBC driver does not utilize libpq at all, it directly implements the PostgreSQL communication protocol.
David J.
David G. Johnston schrieb am 03.11.2017 um 15:19: > On Fri, Nov 3, 2017 at 4:53 AM, Thomas Kellerer <spam_eater@gmx.net <mailto:spam_eater@gmx.net>>wrote: > > The Postgres JDBC driver offers a way to specify multiple hosts in the connection URL: > > https://jdbc.postgresql.org/documentation/head/connect.html#connection-failover > > However, it is unclear to me if that feature relies on the libpq feature introduced in Postgres 10: > > https://www.postgresql.org/docs/current/static/libpq-connect.html#libpq-multiple-hosts > > or if this is handled by the driver internally? > > > In short, it is handled by the driver internally. > > There is no server support (which make sense given failure to connect > would preclude the presence of a server) in the libpq implementation > of this behavior - i.e., its not a protocol thing but a client > implementation. The JDBC driver does not utilize libpq at all, it > directly implements the PostgreSQL communication protocol. > > David J. Thanks, apparently I mis-read the release notes -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc