Can I retrieve column names in a JPA native sql query?

java jpa openjpa
stuff22 picture stuff22 · Apr 14, 2011 · Viewed 8.4k times · Source

Possible Duplicate:
How to get ResultSetMetaData from enity manager?

Given a simple table (example_table) with the following columns: id, first_name, last_name is it possible, by executing a JPA native sql query em.createNativeQuery("select * from example_table") retrieve the column names as well as the data? Running the getResultList() on the query only returns the data. How else can I retrieve the column names?

Answer

Kevin D. picture Kevin D. · Dec 18, 2012

try this

em.unwrap(Session.class).getDescriptor(Currency.class).getFields()

Related questions

JPA Criteria builder IN clause query

How to write criteria builder api query for below given JPQL query? I am using JPA 2.2. SELECT * FROM Employee e WHERE e.Parent IN ('John','Raj') ORDER BY e.Parent

Read More
JPA/Hibernate bulk(batch) insert

Here is simple example I've created after reading several topics about jpa bulk inserts, I have 2 persistent objects User, and Site. One user could have many site, so we have one to many relations here. Suppose I want to create …

Read More
JPA Implementations - Which one is the best to use?

I have made use of the following JPA implementations: Hibernate, Toplink, OpenJPA Each of them has their own strengths and weaknesses. I found Hibernate the most advanced of the three except that it mixed some of its own enhancements with …

Read More