Re: Does following codes work in your JDBC driver and/or database server?

Ruiming Chen 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.
> I don't have MS SQL Server (you can use Connecting Software Type 4
> FastForward JDBC driver or Weblogic Type 4 jdbcKona/MSSQLSERVER JDBC
> driver).
> And I don't have Oracle 7/8, Type 4 Oracle thin JDBC driver.
> Can you test following code for me?
> Thanks!
> ...
> ResultSet result = db.getTables("database_name", "database_owner",
> "%", null);

Hi Ruiming. If you will try the variant:

    db.getTables(con.getCatalog(), "database_owner", "%", null);

It will work with our type-4 Informix driver. It is currently not possible to get information on the tables in another database.

If you try this with Oracle, you will have to substitute a "" or null for the first argument because Oracle has no analog to the Sybase or Informix 'database' or catalog.

--

Joseph Weinstein       Staff Engineer            http://www.weblogic.com
See our newsgroups:     http://www.weblogic.com/services/newsgroups.html
try weblogic free *with support*: http://www4.weblogic.com/register.html