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

Reply via email to