Woody Woodring wrote:
> Upgrading to the latest 8.3 JDBC driver broke one of our queries (that we
> have found) that involves arrays in the database. Reverting to the latest
> 8.2 driver fixes it.
> int hdata = (int)(rs.getArray("data")).getArray();
The 8.3 driver is returning this as Integer instead of the primitive
int because the server allows null values in arrays. While null array
elements are possible in the server since 8.2, the driver didn't get
updated until 8.3. You can change your code or provide the
"compatible=8.2" URL parameter to your connection URL.
In response to
pgsql-jdbc by date
|Next:||From: Steven varga||Date: 2008-03-27 04:46:03|
|Subject: performance issue|
|Previous:||From: Petite Abeille||Date: 2008-03-26 19:48:10|
|Subject: Re: Non-ORM layers over JDBC|