Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# ResultSet MetaData

ResultSetMetadata can be used to discover information about the columns that comprise the rows of a query result. The ResultSetMetadata for a SELECT statement can be retrieved by invoking the getResultSetMetadata() method of the Statement object.

The ResultSetMetadata information includes the number of columns in a result row, each column's data type, the label given to the column, the name of the column from the table, and the name of the table for each column.

If a label was not specified for a column, the name of the column from the table is used as the label. If a label was not specified for a column and the column is not from a table, but is an expression that is calculated as part of the result, the entire expression string is used as the label. It is always safest to access a column of a ResultSet by its label as a ResultSet column always has a label but might not necessarily have a name from a table.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.