Bug 1382228

Summary:	Postgres-jdbc driver 9.4.1200 is not compatible with Postgres-Server 9.5.4-1
Product:	[Fedora] Fedora	Reporter:	GroovieMan <christian.groove>
Component:	postgresql-jdbc	Assignee:	Pavel Raiskup <praiskup>
Status:	CLOSED NOTABUG	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	24	CC:	christian.groove, hhorak, jmlich83, pkajaba, praiskup
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-10-11 21:23:16 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description GroovieMan 2016-10-06 04:05:33 UTC

Description of problem:
The jdbc driver is still using deprecated flag autocommit
that has been marked as deprecated on the server side 
for a long time. Since 9.5.x this flag is not supported
on the serverside anymore, so any connection request 
is beeing rejectet!!


Version-Release number of selected component (if applicable):
client side: 9.4.1200-3.fc24
server side: 9.5.4-1

How reproducible:
does permanentls fail 

Steps to Reproduce:
1.get a SQL Ide i.e. IntelliJ and try to connect to a local DB
2.server denied connection request with Connection to budger@localhost failed. FEHLER: unbekannter Konfigurationsparameter ��autocommit��
3.

Actual results:
it fails

Expected results:
it works

Additional info:
postgres-jdbc Version 9.4.1211 (2016-16-16)
https://jdbc.postgresql.org/documentation/changelog.html

Comment 1 Pavel Raiskup 2016-10-11 10:47:01 UTC

Can you be more specific?  What commits need to be back-ported to make it work
for you?  TBH, I don't know the IntelliJ IDE, so can you help?

I just tried to connect my testing script to (local) postgresql server through
local port (on fedora 24) and I was able to connect successfully.

Comment 2 Pavel Raiskup 2016-10-11 10:52:54 UTC

Christian, thanks for the report btw!

Comment 3 GroovieMan 2016-10-11 21:23:16 UTC

i'll gonna redraw my incident. I found a similar
Dev environement, where the jdbc driver was able to
work.

Comment 4 Pavel Raiskup 2016-10-12 00:37:29 UTC

By Dev environment you mean something different from IntelliJ?   Anyway,
in case you have more details, feel free to reopen.  Thanks.