Michael,
Would it be possible for you to use the getObject() method instead. In
order to support the money type as a double we need to put some code in
to check for the $, and comma's; Given that money is a deprecated type
in postgres this is alot of cycles in the driver to support a case which
will be used sparsely.
Dave
On Fri, 2003-10-31 at 16:55, Michael Andreasen wrote:
> Going a getObject() on a money field with a value over 1,000 causes an
> error;
>
> Bad Double 3,273.65
> at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.toDouble(AbstractJdbc1ResultSet.java:775)
> at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.getDouble(AbstractJdbc1ResultSet.java:159)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:116)
>
> I guess it's the comma!
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>