I simply want stuff like the following. Say I have two Beans Person and Address mapped to the following DB tables:
Person Address ------ ------- id (PK) 1 * id (PK) name --------> person_id (FK) etc. street etc. I'd say this is quite the standard way of modeling table relationships in an RDBMS. I would like Address's person_id aka the FOREIGN KEY column to be a DB column with a NOT NULL constraint. AFAIK this is not possible with JBoss 3.0.x? Is exactly this possible with 3.2 now or will it be with 4.0 or what do you mean by "just map foreign key fields to primary key columns" ?? Anyway, thanks for all the info and explanations. Bernie -----Ursprüngliche Nachricht----- Von: Alex Loubyansky [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. März 2003 20:28 An: Dain Sundstrom Betreff: Re[2]: [JBoss-user] CMP Entity Bean Insert/Commit after ejbPostCreate() DS> 3.2 supports not null foreign keys, but you will have to ask Alexey how DS> to set it up. Just map foreign key fields to primary key columns. This case is not trivial and we had hot debates on this topic with Dain and Jeremy. If foreign key fields mapped to primary key fields is what you need then feel free to ask for details on how it works. Just FYI, you can also have a partial mapping, i.e. some of the foreign key fields are mapped to primary key columns and others to its own. But those that mapped to its own can't be NON NULL. alex DS> -dain DS> On Thursday, March 13, 2003, at 10:42 AM, Jonathan.O'[EMAIL PROTECTED] DS> wrote: >> >> Bernhard, >> No, JBoss 3.x does the insert after ejbCreate. 4.0 is reputed to have >> (will have) support for INSERT after ejbPostCreate. >> >> Ciao, >> Jonathan O'Connor >> Development Manager >> XCOM Dublin >> Phone: +353 1 872 3305 >> Mobile: +353 86 824 0736 >> >> DS> <image.tiff> >> >> >> >> >> Hi, >> >> does JBoss 3.2 issue INSERT/COMMIT after ejbPostCreate() or is it >> possible >> to configure it this way (you can do this e.g. in WebLogic) ? >> >> As far as I know, all JBoss 3.0.x versions already do an INSERT between >> ejbCreate() and ejbPostCreate(). Has this changed in any newer >> version()? >> This is a problem for me, since this means FK columns can't be >> declared as >> NOT NULL since as y'all know CMR fields can only be set in >> ejbPostCreate(). >> I don't want to use Deferred Constraints feature some databases offer. >> >> >> Cheers, >> Bernhard >> >> >> Bernhard Meyer-Willner, MSc >> Insurance - Financial Services >> _________________________________________ >> >> LogicaCMG >> Logica GmbH >> Osterbekstrasse 90b - Alster City >> 22083 Hamburg >> Germany >> T: +49 (0) 40 27071-405 (direct) >> M: +49 (0) 177 425-9036 >> E: mailto:[EMAIL PROTECTED] >> www.logicacmg.com >> >> This e-mail and any attachment is for authorised use by the intended >> recipient(s) only. It may contain proprietary material, confidential >> information and/or be subject to legal privilege. It should not be >> copied, disclosed to, retained or used by, any other party. If you >> are not an intended recipient then please promptly delete this e-mail >> and any attachment and all copies and inform the sender. Thank you. ------------------------------------------------------- This SF.net email is sponsored by:Crypto Challenge is now open! Get cracking and register here for some mind boggling fun and the chance of winning an Apple iPod: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ------------------------------------------------------- This SF.net email is sponsored by:Crypto Challenge is now open! Get cracking and register here for some mind boggling fun and the chance of winning an Apple iPod: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user