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.
| Summary: | generated PK files extremely unfriendly | ||
|---|---|---|---|
| Product: | javaee | Reporter: | err <err> |
| Component: | Persistence | Assignee: | Sergey Petrov <sj-nb> |
| Status: | RESOLVED WONTFIX | ||
| Severity: | blocker | ||
| Priority: | P3 | ||
| Version: | 6.x | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | ENHANCEMENT | Exception Reporter: | |
| Attachments: | ER diagram of part of schema | ||
Created attachment 87532 [details]
ER diagram of part of schema
may be some analysis can be added to track such cases, but it looks more like enhancement for me. This old bug may not be relevant anymore. If you can still reproduce it in 8.2 development builds please reopen this issue. Thanks for your cooperation, NetBeans IDE 8.2 Release Boss |
Attached ER diagram. The table chart_has_event is an n:m mapping. Notice that most every table here has a foreign key to chart_has_event. "entity class from databse" generates a different PK for each of these classes. That is decidedly not useful. All the classes should use the same class to represent the primary key; then things like "equals" work and the same PK class works to query multiple tables. /db/ $ ls *PK* AspectIdPK.java ChartHasEventPK.java PlanetIdPK.java ProfilesPK.java AspectsPK.java EventOrderPK.java ProfilePK.java /db/ $ diff ChartHasEventPK.java EventOrderPK.java 30c30 < public class ChartHasEventPK implements Serializable { --- > public class EventOrderPK implements Serializable { 38c38 < public ChartHasEventPK() { --- > public EventOrderPK() { 41c41 < public ChartHasEventPK(int chartId, int eventId) { --- > public EventOrderPK(int chartId, int eventId) { 72c72 < if (!(object instanceof ChartHasEventPK)) { --- > if (!(object instanceof EventOrderPK)) { 75c75 < ChartHasEventPK other = (ChartHasEventPK)object; --- > EventOrderPK other = (EventOrderPK)object; 87c87 < return "org.metawb.astro.db.ChartHasEventPK[chartId=" + chartId + --- > return "org.metawb.astro.db.EventOrderPK[chartId=" + chartId +