How to get field names from relation (MySQL DB)

Madan_Prabhu · **Posted:** Wed Oct 15, 2008 7:28 am

Hi Friends!
I am new to hibernate. now i am working in hibernate enhancement project.
where i am using HQL queries to retrieve data from mysql database.
In my project they get field names from the table using DatabaseMeta.,
Like the following...

Code:

DatabaseMetaData meta = connection.getMetaData();
ResultSet rsColumns = null;
rsColumns = meta.getColumns(null, null, name, null);
rsColumns.next();
while (rsColumns.next()) {
System.out.println(rsColumns.getString("TYPE_NAME"));
System.out.println(rsColumns.getString("COLUMN_NAME"));
}

How will i convert this JDBC code to Hibernate code...

I am using MyEclipse 5.5 for my project and MySQL 5.0..

patrick1984 · **Joined:** Mon Mar 17, 2008 11:25 am **Posts:** 42

Hi
try it:
code]try{
begin();
ClassMetadata namen=getSession().getSessionFactory().getClassMetadata(Adressen.class);
String[] s=namen.getPropertyNames();
return s;
}[/code]

computersport · **Joined:** Wed Feb 16, 2011 4:56 am **Posts:** 2

Hi Patrick,

i also tried to get the Metadata on this way but i always get an Nullpointerexception.
What can be the reason for this?
My Connection works fine! I use Annotations and the class with the metadata is also mapped.

greetings
compi

patrick1984 wrote:

Hi
try it:

Code:

try{
         begin();
         ClassMetadata namen=getSession().getSessionFactory().getClassMetadata(Adressen.class);
         String[] s=namen.getPropertyNames();
         return s;
      }

vijeeguna · **Joined:** Thu Feb 02, 2012 4:43 am **Posts:** 3

Hi Madan Prabhu,

I am working on the same issue. And MetaData didn't work for me as well. I was just wondering if you have found a solution to your problem. If you have can you please post it.

Thank you,
Have a nice day.