JBoss does not support non-nullable foreign key fields.
Do you know if there are any plans to address this in the future?
I know that in EJB 2.0 Specs, 1..0-n relations are not supported, but many programmers (myself at least) feel much more confortable if we can have a strict database structure that doesn't allow inconsistent data (for example, newsletter subscribers subscribed to no newsletters).
Is there any workarround on this? (A part of beeing very careful with app code)
Thanks and greetings from Madrid
This must be a popular problem, because I have talked to experienced database pros and they consider the idea of adding a child or "Many" table with a null foreign key as bad from a database standpoint. It breaks good database design they say. This is such a serious problem that we are looking to move to Weblogic.