Re: List of schemas and tables via JDBC?

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

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