Re: Error in DatabaseMetaData TableColumn lenght.dec

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