Hi, thanks for your input. I found that two attributes of @jboss.relation-table were missing : datasource and datasource-mapping. everything is ok, as relationship tables are now located in the DB. Fr�d�ric.
-----Message d'origine----- De: Rupp, Heiko [mailto:[EMAIL PROTECTED] Date: dimanche 1 f�vrier 2004 19:10 �: [EMAIL PROTECTED] Objet: Re: [JBoss-user] m:n relationship and relation tables Hi, I'm wondering where the relationship tables are stored. normally also in the Database. How do you setup the CMP beans? With Xdoclet? Then use @jboss.relation-mapping and @jboss.relation-table tags to specify them (Afaik, the @jboss.relation-mapping is not even needed, when the setup of the relation clearly shows that this is n:m). * One poster can have several roles * * @ejb.relation name = "Poster-Roles" * target-ejb = "Poster" * target-role-name = "Poster-has-Role" * role-name = "Role-of-Poster" * * @jboss.relation-mapping = "mapping-table" * * @jboss.relation-table table-name = "poster_role_map" * create-table = "true" * remove-table = "false" * * @jboss.relation related-pk-field = "uid" * fk-column = "po_uid" * * @ejb.interface-method * @return */ public abstract Collection getPosters(); ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
