String values = (String) rs.getObject(column);
String values = (String) rs.getArray(column).getArray();
On Oct 11, 2006, at 3:43 PM, Markus Schaber wrote:
> Hi, Bendik,
> Bendik Rognlien Johansen wrote:
>> yes you are right, I don't really understand Generics that well.
>> But it
>> is a little clearer now :-)
>> Anyway, I was hoping there would be a clean way to get arrays from
>> result set, Generics or not, using a single method. I would like
>> to avoid:
>> getStringArray, getIntegerArray etc.
> Usually, ResultSet.getArray() should do it.
>> The reason I need to do this is that I use two different drivers for
>> PostgreSQL with the same code, and they handle arrays differently.
> So you say that the the other one (pljava, IIRC) maps a postgresql
> integer to an java.lang.Integer in java, and not an int like
> Looks strange.
> Does the jdbc spec promote one or the other behaviour?
> However, I don't know a clean solution.
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf. | Software Development GIS
> Fight against software patents in Europe! www.ffii.org
In response to
pgsql-jdbc by date
|Next:||From: Markus Schaber||Date: 2006-10-13 09:29:14|
|Subject: Re: Retrieving arrays|
|Previous:||From: Guillaume Cottenceau||Date: 2006-10-13 07:48:40|
|Subject: 'now' is sometimes not now - but current_timestamp is|