Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Advice fetching Array data with JDBC 8.3 driver
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Woody Woodring <george(dot)woodring(at)iglass(dot)net>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Advice fetching Array data with JDBC 8.3 driver
- Date: Wed, 26 Mar 2008 21:23:07 -0600
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.
Kris Jurka
- References:
- Advice fetching Array data with JDBC 8.3 driver
- From: Woody Woodring
- Advice fetching Array data with JDBC 8.3 driver
- Prev by Date: Re: Non-ORM layers over JDBC
- Next by Date: performance issue
- Previous by thread: Advice fetching Array data with JDBC 8.3 driver
- Next by thread: performance issue
- Indexes: