How to select column names using JP QL or however possible

[Bonno Mosimanyana]

Hi all,

I have a problem am still learning Spring MVC and JPA. I can't figure out how to select column names using either EntityManager or JP QL.
What I want is to get the column names of a table and pass them to my success view so that I can display them in a table format as headings. I want for this functionality to
be generic if possible.I'm using Spring MVC and JPA with TopLink Essentials as the persistence provider. Here's some of my code in the onSubmit() method:

 
public ModelAndView onSubmit(Object command)
        //..more code
        EntityManagerFactory emf = javax.persistence.Persistence.createEntityManagerFactory("LovTest5PU");
        EntityManager em = emf.createEntityManager();
        String select= "select u from UsersLov u";
        Query q1 = em.createQuery(select);
        List lovList = q1.getResultList();
        UserLovWindowModel userModel = new UserLovWindowModel();
        userModel.setLovEntity(lovList);
        mv.addObject("model", userModel);
        em.close();
        emf.close();
         
        return mv;
}

[Mark Spritzler]

This is a JPA question, so moving this to the ORM forum.

Mark

[Paul Sturrock]

Column names? Are the property names of your object not more appropriate? Why do you want to map a relational model to and object model if you are displaying the relational model?