Обсуждение: BUG #14269: Postgres JDBC driver should be able to connect using protocol version 2 to server versions 9.5+

Поиск
Список
Период
Сортировка

BUG #14269: Postgres JDBC driver should be able to connect using protocol version 2 to server versions 9.5+

От
kh2@araxis.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI2OQpMb2dnZWQgYnk6ICAg
ICAgICAgIGtoCkVtYWlsIGFkZHJlc3M6ICAgICAga2gyQGFyYXhpcy5jb20K
UG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMwpPcGVyYXRpbmcgc3lzdGVtOiAg
IEZyZWVCU0QgMTAuMy1SRUxFQVNFLXA2CkRlc2NyaXB0aW9uOiAgICAgICAg
CgpXaXRoIHRoZSByZWxlYXNlIG9mIFBvc3RncmVTUUwgOS41LjAsIHN1cHBv
cnQgZm9yIHRoZSBzZXJ2ZXIgY29uZmlndXJhdGlvbgpwYXJhbWV0ZXIgImF1
dG9jb21taXQiIGhhcyBiZWVuIHJlbW92ZWQgKGFzIGRldGFpbGVkIGluIHRo
ZSByZWxlYXNlIG5vdGVzCmZvciA5LjUuMCkuIFJlbW92YWwgb2YgdGhpcyBz
dXBwb3J0IHByZXZlbnRzIGNvbm5lY3Rpb25zIHdpdGggdGhlIGFsbCByZWNl
bnQKdmVyc2lvbnMgb2YgdGhlIFBvc3RncmVzcWwgSkRCQyBkcml2ZXIgdXNp
bmcgSkRCQyBwcm90b2NvbCB2ZXJzaW9uIDIuDQoNCkF0dGVtcHRpbmcgdG8g
dXNlIHByb3RvY29sIHZlcnNpb24gMiB0byBjb25uZWN0IHRvIFBvc3RncmVz
IHNlcnZlcnMgdjkuNSBhbmQKbGF0ZXIsIHJlc3VsdHMgaW4gYW4gcG9zdGdy
ZXNxbCBzZXJ2ZXIgbG9nIGVudHJ5Og0KDQpFUlJPUjogIHVucmVjb2duaXpl
ZCBjb25maWd1cmF0aW9uIHBhcmFtZXRlciAiYXV0b2NvbW1pdCINClNUQVRF
TUVOVDogIGJlZ2luOyBzZXQgYXV0b2NvbW1pdCA9IG9uOyBzZXQgY2xpZW50
X2VuY29kaW5nID0gJ1VURjgnOyBTRVQKZXh0cmFfZmxvYXRfZGlnaXRzPTM7
IGNvbW1pdA0KDQpUaGUgc291cmNlIG9mIHRoZSBlcnJvciBpcyB0aGUgcnVu
SW5pdGlhbFF1ZXJpZXMoKSBtZXRob2Qgb2YKb3JnLnBvc3RncmVzcWwuY29y
ZS52Mi5Db25uZWN0aW9uRmFjdG9yeUltcGwuamF2YSB3aGVyZSwgb24gbGlu
ZSA0MzEgKHRha2VuCmZyb20gdmVyc2lvbiAxMjA5IG9mIHRoZSBwb3N0Z3Jl
YXFsIEpEQkMgZHJpdmVyIHNvdXJjZSksIGFueSBjb25uZWN0aW9uIHRvIGEK
c2VydmVyIHZlcnNpb24gNy4zIG9yIGhpZ2hlciBydW5zIHRoZSBTUUwgZ2l2
ZW4gaW4gdGhlIHN0YXRlbWVudCBhYm92ZS4NCg0KQ2xlYXJseSwgaWYgdGhl
IEpEQkMgZHJpdmVyIGlzIHRvIGNvbnRpbnVlIHRvIHN1cHBvcnQgcHJvdG9j
b2wgdmVyc2lvbiAyLCBpdApzaG91bGQgbm90IGJlIHRyeWluZyB0byBzZXQg
c2VydmVyIGNvbmZpZ3VyYXRpb24gcGFyYW1ldGVycyB0aGF0IGRvIG5vdApl
eGlzdCBvbiB0aGUgc2VydmVyIDkuNSBhbmQgbGF0ZXIsIGNhdXNpbmcgYSBj
b25uZWN0aW9uIHRvIGZhaWwuCgo=

Re: BUG #14269: Postgres JDBC driver should be able to connect using protocol version 2 to server versions 9.5+

От
"David G. Johnston"
Дата:
On Fri, Jul 29, 2016 at 9:34 AM, <kh2@araxis.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14269
> Logged by:          kh
> Email address:      kh2@araxis.com
> PostgreSQL version: 9.5.3
> Operating system:   FreeBSD 10.3-RELEASE-p6
> Description:
>

=E2=80=8B[...]
=E2=80=8B


>
> Clearly, if the JDBC driver is to continue to support protocol version 2,
> it
> should not be trying to set server configuration parameters that do not
> exist on the server 9.5 and later, causing a connection to fail.
>

=E2=80=8BNot our (PostgreSQL's) bug...its JDBC's.

=E2=80=8Bhttps://github.com/pgjdbc/pgjdbc/issues

We are well within our rights to remove configuration parameters in new
versions.

If you do post an issue against the JDBC driver it would be nice to know
why you are trying to connect to a version 9.5 server using an outdated
protocol version.

This has already come up and a PR was opened:

https://github.com/pgjdbc/pgjdbc/pull/581

See additional discussion therein.

In addition to GitHub JDBC-related discussions also happen on:

pgsql-jdbc@postgresql.org

David J.