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 81001 - Entity Classes from DB does not read recaptured schema
Summary: Entity Classes from DB does not read recaptured schema
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-24 16:34 UTC by giorgio42
Modified: 2007-10-25 13:52 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description giorgio42 2006-07-24 16:34:28 UTC
NB55 beta 2, Oracle 8.1.7 with Oracle 10g JDBC driver, Glassfish v2 b09.

I added a primary key to one of my tables and recaptured the schema, but Entity
from Classes (using the Database Schema option) still uses the previous schema.

Closed IDE and restarted it. This time NB re-reads the schema and I could go
ahead with my work.

Regards,
Georg
Comment 1 Andrei Badea 2006-07-28 13:59:29 UTC
Sorry, I didn't reproduce this. Here is what I did:

1) Created a new Oracle connection to the SCOTT schema.
2) Created a new EJB project, invoked Entity Classes from DB, created a data
source for the connection from step 1. The BONUS table didn't contain a primary
key and it was displayed as such.
3) Selected the DEPT table, finished the wizard.
4) Executed "alter table bonus add bonus_id int not null primary key" against
the connection from step 1.
5) Expanded the Configuration Files node of the project from step 2,
right-clicked the dbschema file, clicked Recaptured Schema from Database.
6) Invoked Entity Classes from DB. The BONUS key is not marked as not having a
primary key.

I also tried by just setting a column in BONUS to be a primary key, but that
didn't change anything. I know however that there are some issues with the
dbschema caching, it would be good to find reproducible steps. Did my steps
differ from yours? Thanks.
Comment 2 Andrei Badea 2007-10-25 13:52:49 UTC
No reply from submitter for a long time, closing.