Re: Problem with executeBatch and "A result was returned when none was expected" - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Problem with executeBatch and "A result was returned when none was expected"
Date
Msg-id AANLkTinF5dMpYaeGz4EVJvMWdE4tCJo6FacbDBHaF6aK@mail.gmail.com
Whole thread Raw
In response to Re: Problem with executeBatch and "A result was returned when none was expected"  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Responses Re: Problem with executeBatch and "A result was returned when none was expected"
List pgsql-jdbc
On Wed, Mar 16, 2011 at 6:43 AM, Vitalii Tymchyshyn <tivv00@gmail.com> wrote:
> 16.03.11 12:40, Dave Cramer написав(ла):
>
> So looking at the code if you add RETURN_GENERATED_KEYS to the
> statement it returns all of the columns. That's rather ugly. Is there
> a way to determine just the generated keys ?
>
> AFAIR it was a long discussion on what is "generated". E.g. is calculated
> default value (CURRENT TIMESTAMP) generated? Constant default value? So, the
> driver now either returns all or you can pass columns you require by
> yourself with "boolean execute(String sql,  String[] columnNames)".
>
So ideally we need some backend support here. The backend can
certainly figure out what was the result of a default column.

Dave

pgsql-jdbc by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Problem with executeBatch and "A result was returned when none was expected"
Next
From: Vitalii Tymchyshyn
Date:
Subject: Re: Problem with executeBatch and "A result was returned when none was expected"