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