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

Поиск
Список
Период
Сортировка
От Tom Smith
Тема Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Дата
Msg-id CAKwSVFHm0m2JmR-ComSoA0RHoH8oU5sW665JfrwZgQvGNa6vTQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?  (Jorge Solórzano <jorsol@gmail.com>)
Ответы Re: [JDBC] JDBC drive 42 release breaks seriously for RETURNING?
Re: JDBC drive 42 release breaks seriously for RETURNING?
Список pgsql-jdbc
Дерево обсуждения
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 по дате отправления:

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