Oracle 8 JDBC DatabaseMetaData

From: <radmk2_at_cam.ac.uk>
Date: Sun, 21 Jun 1998 11:18:50 GMT
Message-ID: <6miq6q$smu$1@nnrp1.dejanews.com>

Hi,

I am using the thin jdbc driver of oracle and I try to access DatabaseMetaData.

Here are a few lines of the code :
 static final String driver_class = "oracle.jdbc.driver.OracleDriver";

 static final String connect_string =

                  "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";

 Class.forName (driver_class);
 Connection conn = DriverManager.getConnection (connect_string, "scott","tiger");
 DatabaseMetaData dmd = conn.getMetaData ();  String name = dmd.getCatalogTerm ();
.......

But it seems that oracle drivers doesn't support catalogs. The function getCatalogs (), getCatalogTerm()... return all null.

I would like to list the tables name that are in a database but I need for that to specify a catalog name.

If you have any suggestion, it would be great.

Thanks,

        Remi

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun Jun 21 1998 - 06:18:50 CDT