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.

Bug 63718 - DB Explorer does not show tables from SYS schema
Summary: DB Explorer does not show tables from SYS schema
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: All All
: P2 blocker with 1 vote (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
: 63882 (view as bug list)
Depends on:
Blocks:
 
Reported: 2005-09-06 15:42 UTC by Martin Schovanek
Modified: 2009-10-16 15:39 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Schovanek 2005-09-06 15:42:38 UTC 
[#200509041800, jdk1.5.0, Derby 10.1.1.0]

to reproduce:
-------------
1) connect to a Derby database
2) in the Connect > Advanced tab select SYS schema
3) expand Tables node
ERROR: no table list appears
Comment 1 Andrei Badea 2005-09-08 17:50:31 UTC 
The cause of this is that the tables in the SYS schema are system tables. System
tables are not displayed in NetBeans and I learned from Radko that this is as
designed. The question is if we should start displaying them -- probably yes,
but it needs some thinking. Especially we need to make sure that we don't
display a mix of user tables and system tables under the Tables node. 

I and Martin tested a few databases (MSSQL, PostgreSQL, Pointbase,MySQL) and the
system tables (if any) seem to be in their own schema, so they are not mixed
with the user tables. We should test this for all databases we support. If any
supported database show the tables mixed, we could consider adding a "Show
system tables" option to the popup menu of the Tables node.
Comment 2 bakksjo 2005-09-09 13:59:03 UTC 
I think it should be possible to view them. Especially I think it should be
possible to view system procedures. In Derby, these are used for administration
such as backing up a database.
Comment 3 bakksjo 2005-09-09 14:17:27 UTC 
*** Issue 63882 has been marked as a duplicate of this issue. ***
Comment 4 Andrei Badea 2005-09-13 14:55:14 UTC 
Re. the system procedures, I think they are visible, since there isn't a filter
for user/system procedures as there is for tables.

Re. the system tables, I agree they should be visible. This is however more an
enhancement than a defect, so marking as such. Will be probably implemented in
the version after 5.0.
Comment 5 bakksjo 2005-09-21 13:33:16 UTC 
The system procedures are, for some reason, *not* visible.
Comment 6 Andrei Badea 2005-09-21 15:19:01 UTC 
As far as I can tell there are procedures in three schemas: SYSIBM, SYSCS_UTIL
and SQLJ. As leasts that's what DatabaseMetaData.getProcedures(null, "%", "%")
reports. When I connect to these schemas I can see the respective procedures. If
you don't, could you please post steps to reproduce?

You are probably aware of the fact that in NetBeans you connect to a schema, and
you can only see objects in that schema? That is, if you connect to the SYS
schema, you won't see any system procedures, as there aren't any in that schema.
Comment 7 bakksjo 2005-09-21 15:43:51 UTC 
Yes, you are right, there are no procedures in the SYS schema.
Comment 8 Jiri Rechtacek 2009-10-16 14:00:48 UTC 
Reassigned to new owner.
Comment 9 Jiri Rechtacek 2009-10-16 15:39:45 UTC 
It's currently implemented, since NB6.5.