dynamically finding the tables in a database

[carox kaur]

I am trying to find out the tables presesnt in the database through java program. I have correctly configured the DSN but table name "emp" and "employee" present in the database are not coming in the output. Tables are made in MS access. I have tried with oracle also but no output is coming!!! Can anyone detect the error?

 
import java.sql.*;
class dbMeta
{
public static void main(String args[])
{
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:empDS");

	System.out.println("Details of database and drivers");
	DatabaseMetaData dmd=con.getMetaData();
	
	System.out.println("Database product:"+dmd.getDatabaseProductName()); //Access
	System.out.println("Driver: "+dmd.getDriverName());		//JDBS_ODBC Bridge (odbcjt32.dll)
	System.out.println("Following Tables are defined.....");
	ResultSet rset=dmd.getTables(null,null,"e%", new String[]{"TABLES"});

	while(rset.next())
	{
		System.out.println(rset.getString(1));
		System.out.println(rset.getString(2));
		System.out.println(rset.getString(3));
	}

}catch(Exception e)
{
	System.out.println(e);
}

}
}
   

[Balu Sadhasivam]

ResultSet rset=dmd.getTables(null,null,"e%", new String[]{"TABLES"});

is it TABLES or TABLE ?

[carox kaur]

Thanks..I am now able to access data from MS Access but not from oracle...
In oracle there are two types of users:
1. Database Users
2. Internal Users

User "HR" is under "database user",I am able to access the tables made under this user. On doing,

ResultSet rset=dmd.getTables(null,"HR",null, new String[]{"TABLE"});   

prints all the table names in teh output.

But "SYSTEM" and many other user are under "internal user". I am not able to access any tables made under this user !!! Why is it so? and How can i access such tables. On doing,

ResultSet rset=dmd.getTables(null,"SYSTEM",null, new String[]{"TABLE"});   

gives no output.....