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 76317 - dbschema: how can we filter tables, and have a smaller file?
Summary: dbschema: how can we filter tables, and have a smaller file?
Status: RESOLVED DUPLICATE of bug 75687
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-05-12 23:50 UTC by _ ludo
Modified: 2006-05-16 13:47 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 _ ludo 2006-05-12 23:50:40 UTC 
From the nb mailing list:


the approach used by NB here (db schema generation) is fatally flawed, IMHO.

Even if you want to generate the entity class for a single table NB traverses
the complete db schema, including system tables (at least with Oracle).
Therefore, in your case it has to work through 2000+ tables. I tried it on an
Oracle schema with about 70 user tables and the generated db schema file
contained more than 300 tables.

The second issue is that the generated XML is extremely verbose. In the 300+
tables case above the file contains more than 145,000 lines (about 10 MB).

Do the math for your 2000 db tables (we have two Oracle schemas with 800 or so
tables, and their design IS flawed...).
Comment 1 Andrei Badea 2006-05-16 13:47:17 UTC 

*** This issue has been marked as a duplicate of 75687 ***