Re: List of schemas and tables via JDBC?

JDBC API Tutorial and Reference, Third Edition, by Fisher, Ellis and Bruce has a chapter on Database Metadata. (If I ever get time I plan to read more of this book and do some experimentation with Java.)

I'm not an expert, but they have some Java sample code (con is a Connection object):

DatabaseMetaData dbmd = con.getMetaData(0;
ResultSet rs = dbmd.getSchemas();
while (rs.next());
String s = rs.getString(1);
System.out.println("Schema name = " + s);
}

It looks like there is a boatload of information in the metadata object.

I picked up a copy of the book a couple of years ago used (read cheap) on e-bay. You might find it useful.

Sam


On 8/29/2013 8:34 PM, James H. H. Lampert wrote:

I haven't even started looking, but would anybody happen to know where I
need to look, for how one gets a list of databases/schemas/tables
available at any given JDBC URL?

And are the relevant methods already exposed in JDBCR4?

(I'm beginning to think that by the time I'm done with extensions to
JDBCR4, it will be more like JDBCR4000.)

--
JHHL