Fred, Is getColumnDisplaySize supported?
Please check out the fragment below, that call always returns a zero.
Thoughts?
-Jason
-------------------
Yup, I am trying that, but I always get a zero.
Code:
ArrayList metadata_info = new ArrayList();
ResultSetMetaData meta = rs.getMetaData();
int N = meta.getColumnCount();
for(int i=0; i<N; ++i)
{
metadata_info.add(meta.getColumnLabel(i+1));//,
meta.getColumnTypeName(i+1));
System.out.println(i + " * " + meta.getColumnLabel(i+1) + " - " +
meta.getColumnTypeName(i+1) + " - " +
meta.getColumnDisplaySize(i+1));
}
Output:
E:\Projects>java -cp . LocalDB
0 * ISCI - VARCHAR - 0
1 * IMAGEID - VARCHAR - 0
2 * ANUM - INTEGER - 0
3 * MASTER_REC_NUM - VARCHAR - 0
4 * RECST_REF_NUM - VARCHAR - 0
I am kind of lost as to how to do this.
-Jason
-----Original Message-----
From: Karl Meissner [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:55 AM
To: [EMAIL PROTECTED]
Subject: RE: [Hsqldb-developers] MetaData example?
did you try
getColumnDisplaySize(int column)
--- "J. Todd Slack" <[EMAIL PROTECTED]> wrote:
>
> OK, after reading more about metadata, I am still not finding the answer I
> need.
>
> I am currently using getColumnLabel() and getColumnTypeName() to get the
> following information:
>
> LNS_Catalog varchar
>
> I need to get the size also, like:
>
> LNS_Catalog varchar 10
>
> Does anyone know how I get get the size?
>
> -Jason
>
>
>
>
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
