No, not at the moment. Foreign key fields should represent primary key
fields. Probably, we'll address secondary keys in JBoss-4.

alex

Tuesday, March 25, 2003, 7:55:31 PM, you wrote:

NS> Okay, I'm just trying to find a simple piece of information. Can a one 
NS> to many CMR be created that references a non-key field of another 
NS> EJB? For instance I'd like to do the following:

NS> +-----------------+                +-----------------------+
NS> |      Text       |                |      FunkyThing       |
NS> +-----------------+                +-----------------------+
NS> | pk: int         | *            1 | pk: int               |
NS> | text_id: int    +<---------------+ description: int (FK) |
NS> | locale: String  |                | ...                   |
NS> | message: String |                |                       |
NS> +-----------------+                +-----------------------+

NS> So, basically, it would be a one-to-many unidirectional relation to a 
NS> non-unique, non-key field. This is to support an internationalization 
NS> scheme where a single text_id would be used for multiple languages to 
NS> identify the replacement text for a particular description.

NS> I have always used relations with primary keys involved, and was just 
NS> wondering if this kind of thing is supported by JBoss.

NS> I'm just trying to simplify something my DBA says I should be able to 
NS> do. Thanks.

NS> -Neal



-------------------------------------------------------
This SF.net email is sponsored by:
The Definitive IT and Networking Event. Be There!
NetWorld+Interop Las Vegas 2003 -- Register today!
http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to