Re: Curious behaviour with Execute Batch and Prepared Statements

Hi Dave,

Is it your feelling that PostgreSQL 8.3 can't support this functionality, even with a recent JDBC driver?

It's fine if it can't. Some sort of error Java side or warning in the db log would have been helpful. I was getting nothing only a curious side effect. It didn't make sense.

Brett
________________________________________
From: davecramer(at)gmail(dot)com [davecramer(at)gmail(dot)com] On Behalf Of Dave Cramer [pg(at)fastcrypt(dot)com]
Sent: Sunday, 24 June 2012 11:22 PM
To: Brett Walker
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Curious behaviour with Execute Batch and Prepared Statements

Brett,

Clearly we can't document every use case with every version of the
driver and server.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Sun, Jun 24, 2012 at 7:26 AM, Brett Walker
<brett(dot)walker(at)geometryit(dot)com> wrote:
> Hi Dave,
>
> I'm aware that 8.3 is old. I was trying to run a regression test.
>
> If it is not supported on 8.3 that is fine but I cannot find any documentation to say that.
>
> I am using a recent JDBC driver version. Hoping that would cover it.
>
> Brett
> ________________________________________
> From: davecramer(at)gmail(dot)com [davecramer(at)gmail(dot)com] On Behalf Of Dave Cramer [pg(at)fastcrypt(dot)com]
> Sent: Sunday, 24 June 2012 9:09 PM
> To: Brett Walker
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] Curious behaviour with Execute Batch and Prepared Statements
>
> Brett,
>
> Does it work with a recent version of postgresql ? 8.3 is quite old
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On Sun, Jun 24, 2012 at 1:58 AM, Brett Walker
> <brett(dot)walker(at)geometryit(dot)com> wrote:
>> I have a problem that I have described on stackoverflow. It is here:
>> http://stackoverflow.com/questions/11167471/curious-behaviour-with-executebatch-and-prepared-statements
>>
>>
>>
>> I don’t want to provide the detail here as I think it is too long.
>>
>>
>>
>> Comments or questions are appreciated.
>>
>>
>>
>> Brett
>>
>>
>>
>> Brett Walker <brett(dot)walker(at)geometryit(dot)com>
>>
>> Software Developer / Analyst
>>
>> Geometry Pty Ltd
>>
>>
>>
>> Telephone 03 6223 1999
>>
>> Mobile 0458 498 386
>>
>> Fax 03 6223 1988
>>
>> Web www.geometryit.com
>>
>> Address 31 Salamanca Square, Battery Point,
>> TAS 7004, Australia
>>
>>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc