Re: Inconsistent: Getting array from result set

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.


--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc