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

Hi Ruiming. Congratulations. You've found a bug in Informix's new driver and shown that WebLogic's is better!

First, to solve your problem: Did you try this?

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

If you do not put the current catalog in the first argument, the WebLogic driver for Informix will not be able to satisfy the call, and will tell you so. This is because the driver works in the context of a single database, and we don't want to mislead you into thinking you've gotten all the information you wanted about any other databases/catalogs.

    I tried Informix's own JDBC driver with your call, and found that it actually demonstrates a bug in their driver, because their driver also only acts in the context of a single database, but it is simply ignoring the first argument to your call, and the answer you get is only about tables in your current database.

Please try this with Informix's driver:

    db.getTables("garbage", "database_owner", "%", null); or

    db.getTables("some_other_database", "database_owner", "%", null);

In either case you will get only information about tables in the current database. Therefore, if your Informix instance has more than one database owned by a user, or if you ask about another database the Informix driver will silently tell you only about tables in the current database.

Joe Weinstein at WebLogic, Inc.

Ruiming Chen wrote:

> Joseph Weinstein wrote:
>
> > 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.
 

> > --
> >
> > 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
>
> I have downloaded your company's Weblogic jdbcKona/Informix4 Type 4
> JDBC driver 3.1.1 beta 7. I do:
>
> driverName = "weblogic.jdbc.informix4.Driver";
> url = "jdbc:weblogic:informix4:mydb_at_myhost:1530";
>
> I caught Exception "Driver Not Capable" error message!
>
> I downloaded other Type 4 Informix JDBC driver from
> http://www.intraware.com/ . I changed to:
>
> driverName = "com.informix.jdbc.IfxDriver";
> url = \
> "jdbc:informix-sqli://myhost:1530/mydb:INFORMIXSERVER=MyServer_soc";
>
> It works wonderful! No caught Exception error message, just like the one I used
> in Sybase Type 4 JDBC driver.
>
> --
> RC Square Team.
>
> ------------------------------------------------------------------------
>
> Raymond/Ruiming Chui /Chen <rctwo_at_erols.com>
> CS
> RC Square
>
> Raymond/Ruiming Chui /Chen
> CS <rctwo_at_erols.com>
> RC Square HTML Mail
> U.S.A. Work: 301-498-8959
> Fax: 301-498-8959
> Home: URL http://www.erols.com/rctwo/
> Netscape Conference Address
> Netscape Conference DLS Server
> Raymond Chui & Ruiming Chen Company
> Additional Information:
> Last Name Chui /Chen
> First NameRaymond/Ruiming
> Version 2.1

--

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