I have an administrative console in my web application that allows an admin to perform a custom SQL SELECT query on our database.
Underneath, the application is using Hibernate, but these queries are not HQL, they’re pure SQL, so I’m using a Native Query like this:
protected EntityManager em; public List<Object[]> execute(String query) { Query q = em.createNativeQuery(query); List<Object[]> result = q.getResultList(); return result; }
This works correctly, but it only returns the rows of data, with no extra information. What I would like is to also get the column names, so when I print the results back to the user I can also print a header to show what the various columns are.
Is there any way to do this?
Advertisement
Answer
After a long time without any answer, And based on my own further research, It seems that it can not be possible, Unfortunately.