Okay, thanks Alex, that's a good enough answer for me at the moment. I've already figured out a workaround, but it's much like using a relation-table. Just making sure I wasn't missing something.
-Neal On Tuesday 25 March 2003 05:12 pm, Alex Loubyansky wrote: > 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 ------------------------------------------------------- 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
