Re: Problem with executeBatch and "A result was returned when none was expected"

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