Inconsistent: Getting array from result set

From: robrez <resendez(dot)java(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Inconsistent: Getting array from result set
Date: 2013-10-24 23:27:16
Message-ID: 1382657236721-5775841.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am encountering inconsistent behavior when getting an array from a result
set that was produced via a prepared statement.

It seems that the first 5 times the result set is generated from a given
statement, everything is good.
Attempts 6-n do something strange. It's tough to explain so here is a test I
ran...

Here is the output...

Is the the result of some sort of lazy-loading mechanism in the sql.Array?
I'm aware of any number of ways to work-around this 'issue'... but the
inconsistency strikes me as odd.

I'm running postgres 9-2.
I could duplicate this issue using the following jars:
*9.2-1003-jdbc3
9.2-1003-jdbc4
9.2-1002-jdbc4*

I had an OLD jar hanging around that worked as I would have expected... I
could not duplicate the issue using* 8.3-604-jdbc3*

JRE is 7

Thanks for any input

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Inconsistent-Getting-array-from-result-set-tp5775841.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2013-10-25 10:20:39 Re: Inconsistent: Getting array from result set
Previous Message Vitalii Tymchyshyn 2013-10-24 12:49:39 Re: Remove usage of finalizers ?