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

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with executeBatch and "A result was returned when none was expected"
Date: 2011-03-16 12:25:31
Message-ID: AANLkTimvmcNPW-EYb0F2HGxDAaXmfas2+caPvYrRf9yo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Wed, Mar 16, 2011 at 7:04 AM, Vitalii Tymchyshyn <tivv00(at)gmail(dot)com> wrote:
> 16.03.11 12:57, Dave Cramer написав(ла):
>>
>> On Wed, Mar 16, 2011 at 6:43 AM, Vitalii Tymchyshyn<tivv00(at)gmail(dot)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.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Micka 2011-03-16 12:30:27 [Postgis][javax.sql.DataSource] Failed
Previous Message Vitalii Tymchyshyn 2011-03-16 11:04:28 Re: Problem with executeBatch and "A result was returned when none was expected"