#405 DB2 on AS400 table list not shown

2.3final
closed-fixed
Colin Bell
Core (461)
5
2014-07-11
2006-08-02
Anonymous
No

I can connect to the database, but the list of tables
isn't shown. On v2.2 final it works fine.

Discussion

  • saispo
    saispo
    2006-10-11

    Logged In: YES
    user_id=1618685

    I have the same problem with the latest JTOpen, latest JRE
    and SQuirrel SQL.

    The bug will be fixed shortly ? I can't download the
    previous version in order to retablish the situation...

    Thanks

     
  • Colin Bell
    Colin Bell
    2006-10-30

    Logged In: YES
    user_id=233132

    Works for me using the following:

    SQuirreL 2.3final
    Sun Java 1.5.0_06-b05
    DB2 05.03.0000 V5R3m0
    AS/400 Toolbox for Java JDBC Driver 7.0

    What versions are you using?

     
  • Colin Bell
    Colin Bell
    2006-10-30

    • assigned_to: nobody --> colbell
     
  • saispo
    saispo
    2006-10-30

    Logged In: YES
    user_id=1618685

    Hi,

    I use latest JTopen, version 5.2. SquirrelSQL 2.3 and JRE
    1.5.0.09.

    I try with the JDBC driver with IBM Client Access 5.1.0
    SI11806 and no longuer work too...

    How can i submit you a debug for this ?

     
  • Rob Manning
    Rob Manning
    2006-10-30

    Logged In: YES
    user_id=1287991

    There was an issue discovered last week and subsequently
    fixed which prevented SQuirreL 2.3 final from showing the
    list of tables for Sun HADB. The latest snapshot has the
    fix, so it would be beneficial to us to rule
    that out if you could give it a try. Also, in
    log4j.properties you should change "info" to "debug":

    log4j.rootLogger=info, SquirrelAppender

    becomes

    log4j.rootLogger=debug, SquirrelAppender

    That will enable debug logging in
    <user.home>/squirrel-sql/squirrel-sql.log.
    You can attach that log file to this bug report, or send it
    to Colin, if you
    feel so inclined.

    Rob

    Rob

     
  • Rob Manning
    Rob Manning
    2006-10-30

    • labels: --> Core
    • milestone: 620231 --> 2.3final
     
  • Colin Bell
    Colin Bell
    2006-10-31

    Logged In: YES
    user_id=233132

    Rob,

    Unfortunately the latest snapshot doesn't fix it.

    The problem is IBM breaking the JDBC spec. From their
    JavaDoc for DatabaseMetadata.getTables:
    schemaPattern - The schema name pattern. If null is
    specified, no value is sent to the system and the system
    default of *USRLIBL is used. If empty string is specified,
    an empty result set is returned.

    What this means is only a subset of the schemas are seen.
    You either need to do a getTables for each schema
    individually or use the special value '*ALLUSR' for
    schemaPattern.

    I've attached a patch that works for me. Its a patch to
    SQLDatabaseMetaData.getTables. Unfortunately its against
    2.3final instead of HEAD, unfortunately I can't get through
    the firewall to get CVS HEAD at the moment to generate a
    correct patch.

     
  • Colin Bell
    Colin Bell
    2006-10-31

    patch

     
  • Rob Manning
    Rob Manning
    2006-10-31

    Logged In: YES
    user_id=1287991

    Colin,

    The content of the patch is now in CVS.

    Rob

     
  • Rob Manning
    Rob Manning
    2006-10-31

    • status: open --> closed-fixed
     
  • Logged In: NO

    I will try with the next snapshot and inform you =)

    Thks !

     
  • Logged In: NO

    there is another sourceforge project called jtopen. the file jt400.jar (part of the zip package) has to be imported as as400 driver to squirrel - afterwards tables, schemas, ... are viewable with squirrel. the connection url is: jdbc:as400:[databasename]

    regards,
    martin