Un-Verbose Messages

Thread view:

Michael Livingston - 25 Jun 2004 18:25 GMT

I am getting back on my feet with Java and have a SQL project I am
playing with. Part of that is spinning through the metadata of a
resultset and getting WAY more information than I want! For example,
when issueing the getColumnLabel(1) method of a result set metatdata
object I get:

*ResultSetMetaData.getColumnLabel (1)
Column attributes (SQLColAttributes), hStmt=480125912, icol=1, type=18
value (String)=FILE_NBR
FILE_NBR

when all I really want is "FILE_NBR". Is there a "verbosity flag"
somewhere that I should be setting?

TIA, Mike

Reply to this Message

Thomas Kellerer - 28 Jun 2004 06:54 GMT

> I am getting back on my feet with Java and have a SQL project I am
> playing with. Part of that is spinning through the metadata of a
[quoted text clipped - 11 lines]
>
> TIA, Mike

Try using getColumnName() and check if that returns something better.

Which database/driver are you using? Maybe your driver supports some connection
attributes to change this behaviour.

Thomas

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...