DB2 on AS400 table list not shown
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
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
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?
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 ?
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
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.
patch
Logged In: YES
user_id=1287991
Colin,
The content of the patch is now in CVS.
Rob
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