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 AANLkTimvmcNPW-EYb0F2HGxDAaXmfas2+caPvYrRf9yo@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>)
List pgsql-jdbc
On Wed, Mar 16, 2011 at 7:04 AM, Vitalii Tymchyshyn <tivv00@gmail.com> wrote:
> 16.03.11 12:57, Dave Cramer написав(ла):
>>
>> On Wed, Mar 16, 2011 at 6:43 AM, Vitalii Tymchyshyn<tivv00@gmail.com>
>>  wrote:
>>>
>>> 16.03.11 12:40, Dave Cramer написав(ла):
>>>
>>> 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.
>
> The question AFAIK is not technical, there's simply no strict definition of
> "generated". And no public consensus on it.

Yes, this is a typical problem with JDBC.

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: Micka
Date:
Subject: [Postgis][javax.sql.DataSource] Failed