Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1076 Squirrel does not list tables when connected to DB2

3.4.0
closed-fixed
nobody
DB2 listing (1)
5
2013-12-30
2013-02-26
Hans Ginzel
No

Hello,

Squirrel does not list tables when connected to DB2.

Using squirrel-sql-3.4.0-optional on Windows XP 32 bit, Java: http://java.sun.com/, VM version 16.3-b01, runtime version 1.6.0_20-b02, DB2 driver:
http://ashraffouad.blogspot.cz/2012/02/configure-squirrel-sql-to-connect-to.html,
http://www.java2s.com/Code/Jar/d/Downloaddb2jccjar.htm,
http://www.java2s.com/Code/Jar/d/Downloaddb2jcclicensecujar.htm, ClassName com.ibm.db2.jcc.DB2Driver, driver name IBM DB2 JDBC Universal Driver Architecture, driver version 3.57.82, Database Product Name DB2/AIX64, Database Product Version SQL09054.

See attached stack trace please.

What am I doing wrong?

Best regards
HG

PS: See analogou

1 Attachments

Discussion

  • Hans Ginzel
    Hans Ginzel
    2013-02-26

    Oracle SQL Developer (3.2.20.09) with same driver lists tables.

     
  • Probably you hit the same problem as in [#1061]
    Please try the patch attached to it.

     

    Related

    Bugs: #1061

  • Gerd Wagner
    Gerd Wagner
    2013-04-22

    • status: open --> closed-fixed
     
  • Gerd Wagner
    Gerd Wagner
    2013-04-22

    The patch from bug #1076 has been applied.
    A snapshot younger than that of 2013-03-25 should show up soon at:
    http://sourceforge.net/projects/squirrel-sql/files/3-snapshots/

    Since I cannot reproduce the problem please let me know if the fix works. This should be the last change that goes into 3.5. We are willing to release 3.5 as soon as possible.

    Thanks

    Gerd

     
  • Sergiu
    Sergiu
    2013-12-30

    SQuirreL SQL Client Version 3.5.0

    Connection do DB2 (AS/400).
    No table list is displayed in MY_BASE.

    however, the
    select * from MY_BASE.MY_TABLE
    works very well.

     
    Last edit: Sergiu 2013-12-30