Postgres Pro
Downloads
Home   >   mailing lists

Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING? - Mailing list pgsql-jdbc

From Tom Smith
Subject Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Date
Msg-id CAKwSVFHm0m2JmR-ComSoA0RHoH8oU5sW665JfrwZgQvGNa6vTQ@mail.gmail.com
Whole thread Raw
In response to Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?  (Jorge Solórzano <jorsol@gmail.com>)
Responses Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?  (Dave Cramer <pg@fastcrypt.com>)
Re: JDBC drive 42 release breaks seriously for RETURNING?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view
Something like below

sqlInsert = "insert into aTable ((select nextval()), "stringdata")
pstmt connection.prepareStatement(sqlInsert, new String[]{"id"})
pstmt.executeUpdate()
resultSet = pstmt.getGeneratedKeys()     --->  resultset  is empty using 42 series, but one row returned using 94. series

On Sat, Jun 17, 2017 at 2:58 PM, Jorge Solórzano <jorsol@gmail.com> wrote:
Hello Tom:

Could you please provide an example code that reproduce the issue?

Jorge Solórzano


On Sat, Jun 17, 2017 at 10:38 AM, Tom Smith <tomsmith1989sk@gmail.com> wrote:
Hello:


I have a working  call using

connection.prepareStatement(sqlInsert, generatedIds)

and get the expected resultset after insertion  using 9.4 series driver.
I just upgraded to 42 series latest,  it is not getting the resultset anymore.

I downgraded to 9.4 drive and it worked again.  It is a bit shocking.
Is it a bug or change?

Thanks



pgsql-jdbc by date:

Previous
From: Jorge Solórzano
Date:
Subject: Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Next
From: Dave Cramer
Date:
Subject: Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?