Return column name

mrsmylle · **Joined:** Fri Jun 09, 2006 6:34 pm **Posts:** 5

Hello, to all?!?How can I return the column names?Does anybody know?!

pepelnm · **Posted:** Fri Jun 09, 2006 6:57 pm

Interface QueryTranslator

public String[][] getColumnNames()

mrsmylle · **Joined:** Fri Jun 09, 2006 6:34 pm **Posts:** 5

Hi!!Thanks for the answer!!I'm trying this:

Code:

   QueryTranslator qt = (QueryTranslator) HibernateUtility.getSession().createCriteria(Aluno.class);
      String[][] string = qt.getColumnNames();
      for(int i=0; i<=string.length; i++){
         for(int j=0; j<=string.length; j++){
            System.out.println(string[i][j]);
         }
      }

But nothing happens!!What's wrong?!

pepelnm · **Posted:** Sat Jun 10, 2006 7:05 pm

QueryTranslator is for HQL.

I think that you need:

Interface CriteriaQuery

mrsmylle · **Joined:** Fri Jun 09, 2006 6:34 pm **Posts:** 5

Nothing happened!!!Could you give an example?!

damnhandy · **Posted:** Sun Jun 11, 2006 1:32 pm

If you're looking to get at the column names that would be returned by a mapped class, you can do something like this:

Code:

Configuration cfg = HibernateUtil.getConfiguration();
PersistentClass pc = cfg.getPersistentClass(Aluno.class.getName());
Iterator properties = pc.getPropertyIterator();
while(properties.hasNext()) {
   Property property = (Property) properties.next();
   Iterator columns = property.getColumnIterator();
   while(columns.hasNext()) {
      Column column = (Column) columns.next();
      System.out.println(column):
   }
}

If you're looking for the column names that are returned by a query, that gets a bit more complicated. The CriteriaQuery interface wasn't designed to be used by application code and doesn't offer an easy means of getting the data that you might be looking for.

Ryan-