How to retrieve column names and their values ?

Nitzer_Ebb · **Posted:** Fri Jan 30, 2004 6:51 am

Suppose one row in a "ResultSet" ( i.e ScrollableResult in Hibernate ) looks like this :

<column1><column2><column3>
<string1><string2><string3>

How can I get the columnnames out, and their corresponding value (strings in this case )?
I.e, I want something like :

column1 , string1
column2 , string2
column3 , string3

Maybe this can't be done with ScrollableResults ? Is there any other way to do this with Hibernate ?

Cheers

emmanuel · **Posted:** Fri Jan 30, 2004 1:43 pm

reformulate.
Hibernate is an ORM tool, so there is no relational concept form the cleint perspective (column name is pointless).

micho2001 · **Posted:** Fri Jan 30, 2004 5:23 pm

how about getting a JDBC connection from hibernate and then using the pain old DatabaseMetadata object?

Mind you, not all JDBC drivers have a good implementation of this...

l.masini · **Posted:** Fri Jan 30, 2004 6:09 pm

Why not

Code:

sessionfactory.getClassMetadata(YourClass.class);

from metadata API ?