Bug 205256 - Different mapping for sample database
Different mapping for sample database
Status: RESOLVED WORKSFORME
Product: db
Classification: Unclassified
Component: DB schema
7.1
PC Mac OS X
: P2 (vote)
: 7.1
Assigned To: Jiri Rechtacek
issues@db
:
Depends on:
Blocks:
  Show dependency treegraph
 
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
:


Attachments

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.


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo