Bug 3159 - DB2 Reverse Engineering Error: Could not find any objects to add to the PlayPen.
: DB2 Reverse Engineering Error: Could not find any objects to add to the PlayPen.
Status: NEW
Product: Bug Database
Everything
: 3.6.2
: PC All
: P5 enhancement
: ---
Assigned To: kirti
:
:
:
:
  Show dependency treegraph
 
Reported: 2015-03-19 16:55 EDT by kirti
Modified: 2015-05-22 16:40 EDT (History)
0 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description kirti 2015-03-19 16:55:15 EDT
This bug originally reported by AdamiTJ :
(http://www.sqlpower.ca/forum/posts/list/0/2947.page#38499)

Hello folks, 

When using IBM DB2 Express-C 10.5 FixPack 1 LUW SQL Power Architect cannot read
tables of any database schema. I tried both in Linux and Windows (client and
server). 

All the schemas are listed, but no table can be found. 

I'm using class "com.ibm.db2.jcc.DB2Driver" in "db2jcc.jar" and
"db2jcc_license_cu.jar" into classpath, both are distributed with the main
installer - inside "C:\Program Files\IBM\SQLLIB\java" folder in Windows. 

Even with database admin users (included into SYSADM_GROUP) the error persists
- I double checked to be sure there is not a permission issue. 

Steps to reproduce error: 

1) Open a new project into SQL Power Architect; 
2) Create a new Connection to an existing DB2 database (filled with user tables
in any schema). Be sure to use an user with permissions over the desired
schemas -or- inform a database user included into SYSADM_GROUP; 
3) Add the new connection to the project; 
4) On the left side, double-click the connection name. All schemas should now
be listed; 
5) Left click on a schema name and drag'n'drop it to the workspace (where
tables must be placed). 
6) The message: "Could not find any objects to add to the PlayPen" 


I wonder if SQL Power Architect is trying to read IBM DB2 catalog tables
directly or if it is using Java's DatabaseMetaData. Maybe it is an JDBC driver
issue? 


Here's the environment used: 

SQL Power Architect 1.0.7 
Copyright 2003-2012 SQL Power Group Inc. 

Operating System: 
Windows 7 6.1 (x86) 

Runtime Environment: 
Java(TM) SE Runtime Environment 
1.7.0_51-b13 

VM info: 
Java HotSpot(TM) Client VM 
24.51-b03 
Oracle Corporation 

Memory: 
36MiB allocated (247MiB max); 13MiB free 

---- 
DB2: 

C:\>db2licm -l 
Product name: "DB2 Express-C" 
License type: "Unwarranted" 
Expiry date: "Permanent" 
Product identifier: "db2expc" 
Version information: "10.5" 
Max number of CPUs: "2" 
Max amount of memory (GB): "16" 
Enforcement policy: "Soft Stop" 




C:\>db2level 
DB21085I This instance or install (instance name, where applicable: "DB2") 
uses "64" bits and DB2 code release "SQL10051" with level identifier 
"0602010E". 
Informational tokens are "DB2 v10.5.100.64", "special_31160", "IP23521_31160", 
and Fix Pack "1". 
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".
Comment 1 kirti 2015-05-22 16:40:07 EDT
Tested this issue on a Mac  using following DB2 version

Product name:                     "DB2 Express-C"
Product identifier:               "db2expc"
Version information:              "10.1"
Max number of CPUs:               "2"
Max amount of memory (GB):        "4"
Enforcement policy:               "Soft Stop"

cannot recreate this issue.