Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#364 DB2 table information column headings are all numbers

2.2rc1
closed
Colin Bell
Core (461)
5
2006-04-02
2006-03-23
eagle79
No

When looking at various table meta data, I lose the
column headings. This happened after setting up and
testing a Type 4 JDBC 3.0-compliant driver. The old
driver (a JDBC 2.0 Type 2 driver) did not exhibit this
problem.

This could certainly be a driver issue -- I really
don't know to be honest.

Queries work fine, and the data in the metadata tables
is correct... it simply doesn't have a heading.

Screenshot will follow.

Discussion

  • eagle79
    eagle79
    2006-03-23

    example screenshot

     
    Attachments
  • eagle79
    eagle79
    2006-03-24

    Logged In: YES
    user_id=1300245

    Please see related bug 1451478... most of the discussion
    seems to be ending up there... or we can close this
    problem... I'm not sure this is a graph plugin problem...

     
  • eagle79
    eagle79
    2006-03-30

    Logged In: YES
    user_id=1300245

    UPDATE: tested Snapshot-20060325_1439

    under the JDBC 3.0 (Type 4) drivers, the table column names
    do not appear as before. I still don't know why this is
    happening, but I suspect either a driver issue of some sort,
    or some incompatibility/bug between the driver and a DB2/390
    database. If I can find time to play with this, I'll see if
    I can find out something driver-related. Any clues from
    anyone are much appreciated, though.

    I cannot test the JDBC 3.0 Type 2 drivers, because I don't
    have them installed, nor can I install them at the moment.

     
  • Gerd Wagner
    Gerd Wagner
    2006-04-02

    • status: open --> closed
     
  • Gerd Wagner
    Gerd Wagner
    2006-04-02

    Logged In: YES
    user_id=776065

    You may try out the following on Your JDBC connection:

    ResultSet rs1 =
    con.getMetaData().getColumns(null, null, "<aTableName>");

    ResultSetMetaData rsm = rs.getMetaData();

    for(int i=1; i<rsm.getColumnCount(); ++i)
    {
    System.out.println("Col name " + rsm.getColumnLabel(1));
    }

    This will surely produce the numbers you see instead of the
    names you normally see with SQuirreL. So it should be an
    issue of your driver. I'll close this bug.

    PS: I don't think there is a relation fo this problem to 1451478