Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Дата
Msg-id CADK3HHJRA6Z0Mo5xQtqVmZRjz41xeV5BhYVJnA8rb5n_uim5+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?  (Tom Smith <tomsmith1989sk@gmail.com>)
Ответы Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Re: JDBC drive 42 release breaks seriously for RETURNING?
Список pgsql-jdbc
Certainly not intended. Thanks for the report!


On 17 June 2017 at 16:40, Tom Smith <tomsmith1989sk@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Tom Smith
Дата:
Сообщение: Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?