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 205256 - Different mapping for sample database
Summary: Different mapping for sample database
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 7.1
Hardware: PC Mac OS X
: P2 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-17 22:21 UTC by arungupta
Modified: 2011-11-18 10:21 UTC (History)
3 users (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 arungupta 2011-11-17 22:21:23 UTC 
Generate JPA entities for the sample database bundled with NetBeans.

Customer table, Discount Code and Micro Market are picked as related tables on Mac but not on Windows. As a result the generated mapping is different.
Comment 1 Sergey Petrov 2011-11-18 04:00:55 UTC 
from email thread there is a difference in captured scheme
Comment 2 Sergey Petrov 2011-11-18 04:05:36 UTC 
see http://netbeans.org/kb/docs/ide/java-db.html and Recreate Table dialog, there is nothing about micromarket, not sure why it may happen to be in relation on mac
Comment 3 Sergey Petrov 2011-11-18 04:09:59 UTC 
http://netbeans.org/kb/docs/websvc/rest.html one more tutorial with Customer relation, may be this tutorials was created on win, but to be sure, can you reinstall your sample db?
Comment 4 Jiri Rechtacek 2011-11-18 10:18:31 UTC 
Depends on version on Sample database installed on your computer. Look on issue 197501 which caused different records in sample database, together with that issue was fixed a missing foreign key in Customer table to Micro Market. It means since NB701 all new installations of Java DB Sample database contains the new records and keys.
How to re-install the sample database to contains new records? Remove all content of Java DB Database location (e.g. /home/user/.netbeans-derby on unix manachines), the current location found in Java DB node under Database root node in Services tab. Then run IDE with fresh userdir. In that case new records will deployed into Sample database.