following myself up:
On Sat, 22 Feb 2003 15:00:21 -0500 (EST) Richard Welty <rwelty@averillpark.net> wrote:
> i have a bunch of code that was working with integer arrays which i just
> converted to work with decimals.
>
> the array is in the database correctly. from psql, target_percentages is:
>
> {0.08,0.08,0.09,0.08,0.08,0.09,0.08,0.08,0.09,0.08,0.08,0.09}
i the following alternate code to read the array:
java.sql.Array tp = result.getArray( "target_percentages");
target_percentages = getBigDecimalArray( tp, 12);
where getBigDecimalArray is as follows:
public static BigDecimal [] getBigDecimalArray( java.sql.Array array, int len){
BigDecimal [] bdarray = new BigDecimal [len];
try {
ResultSet rs = array.getResultSet();
int index;
BigDecimal num;
while( rs.next()){
index = rs.getInt( 1);
bdarray[index - 1] = rs.getBigDecimal( 2);
}
} catch ( SQLException ex){
Debug.println( "SQLException: " + ex.getMessage());
}
return bdarray;
}
> this is postgresql 7.2.1-5 from an rpm on redhat 7.3, using the
> pgjdbc2.jar
> driver from october of last year. the jdk is 1.4.1_01
i also updated to the pg72jdbc2.jar file from the pgjdbc website.
it is continuing to fail with the same error message,
SQLException: Bad BigDecimal 0.08
is there any known way to read an array of decimal values into a BigDecimal
array?
thanks,
richard
--
Richard Welty rwelty@averillpark.net
Averill Park Networking 518-573-7592
Unix, Linux, IP Network Engineering, Security
