On Fri, 2 Jul 2004, Dario V. Fassi wrote:
> Hi, I whish to report a erroneous information returned by
> DatabaseMetaData.getColumns() method.
>
> Suppose
>
> CREATE TABLE A ( f1 DEC(6,3), f2 dec(6,3) );
> CREATE VIEW B as ( select ( f1 + f2 ) as f from a;
>
> Then DatabaseMetaData.getColumns() returns:
>
> VIEW B
> F NUMERIC( 65535 , -65531 )
>
I've modified the cvs version of the driver to return numeric(1000,1000)
which is the maximum precision and scale you are allowed to define. A
more complete solution is outside the realm of the JDBC driver.
Kris Jurka