Getting MetaData for JDBC tables with getTables() does not work?

From: Thomas Hansen <thans2000_at_gmx.de>
Date: Wed, 26 Jan 2005 23:06:15 +0100
Message-ID: <ct948m$fb1$05$1@news.t-online.com>

When I access an Oracle database I can successfully select rows from a database table. So at least one table must exist. But when I try to access the MetaData with getTables() I get no data. Why?

I use the follwoing coding:

String dbname = "MYDB.TABLEA";
DatabaseMetaData md = cn.getMetaData(); ResultSet rsm = md.getTables(null, null, dbname, null); if (rsm.next()) {

     res = true;
     System.out.println("tables found"); }
  else 
     System.out.println("tables not found");

For what are the 4 parameters of getTables? I found some samples with percentage signs as values. Others filled the last paramter and left the third parameter to null. From my point of view putting null into parm 1 and 2 should return ALL tables for all users. Is this correct?

Thomas Received on Wed Jan 26 2005 - 16:06:15 CST