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*