How to get column names from hibernate query?

prakash.thangarasu · **Joined:** Tue May 08, 2007 8:25 am **Posts:** 1

Hibernate version: 3.1.3

Name and version of the database you are using: Oracle 10

Hi All,

In my project we are using Native-SQL for querying data from Oracle database.

Like
List products = this.getSession()
.createSQLQuery("Select * from Products").list();

Here, before or after executing query I want to get column names.

How to do?

adamgibbons · **Joined:** Sat Apr 21, 2007 11:01 pm **Posts:** 144

wut?

... Hibernate doesn't work like that. Column names are mapped to fields to a domain/data/pojo object. Which you will have for each table...
Then you use HQL not SQL to query for actual objects as opposed to raw data from the DB.
Try reading up on some hibernate basics. From what you posted it doesn't sound like you are using Hibernate at all.

pramodkp · **Joined:** Mon Mar 26, 2007 12:38 am **Posts:** 119

Hi,
The requirement looks a bit strange to me.
However, since you are working on Oracle, you can use this query.

iterator = session.createSQLQuery("select column_name from user_tab_columns where table_name = 'PRODUCTS'").list().iterator();
while(iterator.hasNext())
System.out.println(iterator.next());

It prints out all columns of Products table.
--------------------------------------------------
Rate the reply if you find it helpful