Re: Possible bug / regression from generated keys - Mailing list pgsql-jdbc

From Peter Cooner
Subject Re: Possible bug / regression from generated keys
Date
Msg-id CAHVZnpERodJFbT1AWJBFXcOsBCDtDp1DxsHg1pwd02eHkSiobw@mail.gmail.com
Whole thread Raw
In response to Re: Possible bug / regression from generated keys  (dmp <danap@ttc-cmc.net>)
Responses Re: Possible bug / regression from generated keys  (Peter Cooner <petriborg@gmail.com>)
List pgsql-jdbc
OK, I've spent some time and removed the DBCP from the mix - I'm now
using SimpleDataSource object - the error persists. I'll work this
next at removing the use of DbUtil for the specific query.

Its rather odd.

position_id inserts that worked:
1075 through 1083

But 1084 fails - the id is in the database, but the result fails to return.

I looked at the ids, and they are continuous in the database, so the
inserts are working...

The next value to come back successfully from the batch is 1088.

I'm going to add a batch counter to my outputs... I'll get back to you
on this trail.



On Wed, Nov 7, 2012 at 8:04 PM, dmp <danap@ttc-cmc.net> wrote:
> I can try as indicated to rebuild the jar so that Peter could have an output
> of the exact value that is throwing the error when it occurs. To limit
> output
> I would then recommend a case that would throw the error soon with as little
> data processing as possible. Let me know if this maybe something I could do
> to help.
>
> danap.
>
>
> Dave Cramer wrote:
>>
>> Well there is a relatively easy fix that would get rid of the problem.
>> Currently we don't check the length of the array that we are trying to
>> convert. However I'd like to understand how the problem is manifest
>> before doing that.
>>
>> Dave
>>
>> Dave Cramer
>>
>> dave.cramer(at)credativ(dot)ca
>> http://www.credativ.ca



--
Pete
"Yates went on to say that using MS formats left a fresh, minty feeing
in user's mouths while every time an open [format] is used a kitten
dies." -- maggard (on slashdot)

perl -lne '(1x$_) !~ /^1?$|^(11+?)\1+$/ && print "$_ is prime"'


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Possible bug / regression from generated keys
Next
From: Peter Cooner
Date:
Subject: Re: Possible bug / regression from generated keys