• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

dynamically finding the tables in a database

 
carox kaur
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?




 
Balu Sadhasivam
Ranch Hand
Posts: 874
Android Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator



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


is it TABLES or TABLE ?
 
carox kaur
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
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,

gives no output.....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic