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

Summary:	DB Explorer does not show tables from SYS schema
Product:	db	Reporter:	Martin Schovanek <mschovanek>
Component:	Code	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED FIXED
Severity:	blocker	CC:	pjiricka
Priority:	P2
Version:	5.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:

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.