Re: getTables problem -- JAVA400-L


Pass null instead of an empty string for the catalog parameter.  The
specification states that "" retrieves tables without a catalog; null
indicates that that the catalog should not be used to narrow the search.
All tables on the system are considered a part of the system catalog.

My testing suggest that this should work for you.  I can assure you that
you can't get values back with an empty string.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




"Franco Biaggi" <fbiaggi@ticino.com>@midrange.com on 10/10/2000 07:07:41 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   "JAVA400-L@midrange.com" <JAVA400-L@midrange.com>
cc:
Subject:  getTables problem



Hello,
I'm tring to get a table list using following statements, but no entries
are returned (this works fine on DB2 7.1 and Oracle 8i),
OS/400 at V4R3M0.

     DatabaseMetaData dmd = User.getSQLConnection().getMetaData();
     ResultSet rs = dmd.getTables( "", qual, null, new String[] { "TABLE" }
);

where "qual" is the library name.

Thanks for help.

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Franco Biaggi">
<meta name="GENERATOR" content="Franco Biaggi">
</head>

<body>

<p>&nbsp; </p>

<table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
  <tr>
    <td width="446"><font face="Comic Sans MS"><small><small><br>
    <font color="#3333FF"><a href="http://www.ticino.com/usr/fbiaggi/
">Franco Biaggi</a></font><small><br>
    <font color="#3333FF"><a href="http://www.sisa.ch">SISA Studio
Informatica SA</a></font><small><small><small> <br>
    </small></small></small><font color="#3333FF">R&amp;D
Services</font><small><small><small>
    <br>
    </small></small></small><font color="#3333FF">Via Carvina
1</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">CH-6807
Taverne</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">Tel. +41 91 935 75
35&nbsp; Fax. +41 91 935
    75 30</font></small></small></small><br>
    </small></small></small><font color="
#3333FF">ICQ:59714125(disabled)</font><small><small><small> <br>
</font></td>
  </tr>
</table>
</body>
</html>



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---