Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does following codes work in your JDBC driver and/or database server?
On Wed, 09 Sep 1998 22:11:30 -0700, Ruiming Chen <rctwo_at_erols.com> wrote:
>The following code is print a list of tables in a database. It works
>fine with Connecting Software Type 4 FastForward JDBC driver, Sybase SQL
>Server 10/11.
>
>But it not work with Weblogic Type 4 jdbcKona/Informix4 JDBC driver,
>Informix Dynamic Server 7.3x.
>
>Also not works with jdbc-odbc bridge, MS-Access neither.
[snip]
> DatabaseMetaData db = con.getMetaData();
> ResultSet result = db.getTables("database_name", "database_owner",
> "%", null);
To access an MS Access database through jdbc:odbc bridge you problably should use :
ResultSet result = db.getTables(null, null, null, new String[]{"TABLE"});
Succes !
-- Kees Nuyt; Rotterdam; Netherlands Email: nuijt_at_ipr.nl; MIME accepted +--HI, I'm a signature virus :-) Copy me into your sign to join in. ---+Received on Mon Sep 14 1998 - 00:00:00 CDT