This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | On DB2 JDBC - Connection tree is not populated in TreeView | ||
---|---|---|---|
Product: | db | Reporter: | dbooher |
Component: | DB schema | Assignee: | Libor Fischmeistr <lfischmeistr> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | ||
Priority: | P3 | ||
Version: | 7.3.1 | ||
Hardware: | PC | ||
OS: | Windows 7 | ||
Issue Type: | DEFECT | Exception Reporter: | |
Attachments: |
A screenshot of unpopulated TreeView
Database Screenshot populated TreeView |
I had the exact same problem where the database tables would not display. I run an IBM AS/400(v6r1). I followed the IBM instructions for "Deleting SQL Package of the Database Host Server" reference number 377117296. From IBM... "Occasionally it is necessary to delete the SQL package, QZDAPKG, which is used by the database host server. It can become unusable because of corruption, size limitations, or an incompatibility between releases." "When you are ready to shut down the database server, you should run the following commands to correct the problem and restart everything:" ENDHOSTSVR *DATABASE ENDPJ QUSRWRK QZDASOINIT *IMMED ENDPJ QUSRWRK QZDASSINIT *IMMED ENDPJ QSERVER QZDAINIT *IMMED DLTSQLPKG QGPL/QZDAPKG STRHOSTSVR *DATABASE STRPJ QSERVER QZDAINIT The following fixed my problem of displaying database tables. Created attachment 133449 [details]
Database Screenshot populated TreeView
(In reply to comment #0) > After defining a jdbc connection to DB2 using the Services tab: Once the > connection is established the treeview is populated with SCHEMA names, however > when you attempt to expand TABLES, VIEWS or PROCEDUREs, nothing displays. Did you try the solution that mbilliot suggested? If so, did it help? Thanks. I'm having the same problem. What prompt does one enter these commands? Or is there another fix? I'm running the DB2 Personal Edition. TIA Correction - I'm using DB2 Express C, ver. 10.1. I am having the same issue in Netbeans 7.4 But it works fine in Netbeans 7.3.1 It's the production DB2 database and I can't delete anything on it. Driver I used is www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm/Information+Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=10.1.*&platform=All&function=fixId&fixids=DSClients--jdbc_sqlj-10.1.0.3-FP003&includeRequisites=1&includeSupersedes=0&downloadMethod=http&source=fc (In reply to rjdkolb from comment #6) > I am having the same issue in Netbeans 7.4 > But it works fine in Netbeans 7.3.1 > > It's the production DB2 database and I can't delete anything on it. > > Driver I used is > www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm/ > Information+Management&product=ibm/Information+Management/ > IBM+Data+Server+Client+Packages&release=10.1. > *&platform=All&function=fixId&fixids=DSClients--jdbc_sqlj-10.1.0.3- > FP003&includeRequisites=1&includeSupersedes=0&downloadMethod=http&source=fc Can you please try to reproduce with daily build? Thanks *** This bug has been marked as a duplicate of bug 237648 *** |
Created attachment 130549 [details] A screenshot of unpopulated TreeView After defining a jdbc connection to DB2 using the Services tab: Once the connection is established the treeview is populated with SCHEMA names, however when you attempt to expand TABLES, VIEWS or PROCEDUREs, nothing displays. See screenshot.