Hi Jean-Yves Beaujean
Try a class called DatabaseMetaData instead of ResultSetMetaData
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "JDJList" <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 3:00 PM
Subject: [jdjlist] JDBC and column length
> Hi All,
>
> I've a problem with JDBC and ResultSetMetaData interface.
> I'would know the length of a char or varchar column.
>
> Here's my code :
>
> ResultSet res = stmt.executeQuery("select * from x");
> ResultSetMetaData rmtd = res.getMetaData();
> for ( int i = 1 ; i <= rmtd.getColumnCount();i++)
> {
> System.out.println("col "+i+ " : type = " +
rmtd.getColumnTypeName(i)
> + ", length = " + rmtd.getScale() );
>
> }
>
> With numeric type, it's ok. But with char, getScale() return 0 and
> getPrecision() : return 0.
> Can anyone help me ?
> Thanks in advance.
>
> Jean-Yves Beaujean
> Service informatique
> CORMAN S.A.
>
>
> ____________________________________________________
> To change your JDJList options, please visit:
> http://www.sys-con.com/java/list.cfm
>
> Be respectful! Clean up your posts before replying
> ____________________________________________________
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Be respectful! Clean up your posts before replying
____________________________________________________
