getting list of table names in Oracle and MySQL

[hadzrul hashim]

Dear everyone,

I would like to ask "noob" question here regarding to Hibernate. I want to get a list of table names and list of columns names in every table from my database. I am using 2 different db environment (MySQL and Oracle) and I would like to do this for both.

Here are my files. I guess I'm wrong. Please guide me to get the results

hibernate.cfg.xml

<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
        <property name="hibernate.connection.password"></property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost/icn</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    </session-factory>
</hibernate-configuration>

TestScheme.java

import java.io.File;
import java.io.FileInputStream;
import java.util.Iterator;
import java.util.Properties;
 
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.mapping.Table;
 

public class TestSchema {
public static void main(String[] args) throws Exception{
try{
Configuration cfg = new Configuration();
cfg.configure("hibernate.cfg.xml");
SessionFactory sessionFactory = cfg.buildSessionFactory();
System.out.println("*** hello");

Iterator itr = cfg.getTableMappings();
while(itr.hasNext()){
System.out.println("testing");
Table table = (Table)itr.next();
System.out.println(table.getName());;
}
}catch(Exception e){
e.printStackTrace();
}

}
}

[Mark Spritzler]

Well, this isn't really a Hibernate ORM thing. I mean you are trying to use Hibernate to get to that information, but the real issue is the databases and what "DBA" tables they have to get that information.

So, the only Hibernate thing would be that the connection/user has to have permission to access that stuff for each database.

But the big key is in the databases. In Oracle there is a table called dba_tables that you can query to get the table names, and with that id you can go into dba_fields table to get the field information.

I do not know what MySQL has. I recommend looking for MySQL and Oracle documentation.

Good Luck

Mark