Query only returns data

cassiot · **Posted:** Thu Jun 08, 2006 9:42 am

Hibernate version: 1.02 (self compiled)

Hi. Is there any way to see the fields returned by a query? Using IQuery.List() I can't know what are the names of the fields returned.

Thanks

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

No, hibernate throws away the result set's metadata after it has constructed the objects. To access the metadata, you have to use the database connection the "old fashioned" way, without hibernate.

cassiot · **Posted:** Fri Jun 09, 2006 7:54 am

What if we could configure it? And we could access it like this:

Code:

IQuery query = session.CreateQuery(MyQuery);
query.List();
string[] s  = query.Metadata;

I think it's interesting.

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

The whole point of hibernate is to protect you from all of that. If you want the metadata, use JDBC or whatever the .net equivalent is.

cassiot · **Posted:** Mon Jun 12, 2006 9:09 am

Ok, I understand. I was asking because there are some times that I want to return a DataTable as the result of some HQL's. I want to name the DataTable columns with the metadata. What I'm doing is use reflection to get the names from the properties.

Based in your last post I don't know if I am doing the right thing now.

Thanks.