How to get metadata column from native query

Support
#1

Hi,
Is there any way to get metadata columns of a query result from Native Query ?


Query query = entityManager.createNativeQuery(queryString);
List resultList = query.getResultList();

I need it when I want to export a ResultSet of a table into csv …

#2

I managed to do it by getting the connection first then creating a function which converts ResultSet into Set. To prevent the order, you must use LinkedHashMap.

Meanwhile, this is a solution, waiting for your answers.

#3

Hi Gent,

Please, find an example here. Particularly you will be interested in this part.

Regards,

Aleksey

1 Like
#4

Hi Aleksey,

Thanks, that will help me avoiding extra code with Object mapping.

Best Regards,
Gent