Re: Possible bug / regression from generated keys

From: Peter Cooner <petriborg(at)gmail(dot)com>
To: dmp <danap(at)ttc-cmc(dot)net>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>, Dave Cramer <pg(at)fastcrypt(dot)com>
Subject: Re: Possible bug / regression from generated keys
Date: 2012-11-08 13:08:13
Message-ID: CAHVZnpERodJFbT1AWJBFXcOsBCDtDp1DxsHg1pwd02eHkSiobw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ttc-cmc(dot)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"'

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Cooner 2012-11-08 13:39:55 Re: Possible bug / regression from generated keys
Previous Message Dave Cramer 2012-11-08 13:02:54 Re: Possible bug / regression from generated keys