Should Middlegen support denormalised many-to-many relations? What do
you others think? Pros and cons please.

Those of you who have the latest CVS version of Middlegen may have
noticed that Ludovic Claude has submitted a new plugin for JDO.
Middlegen has a plugin API based on Velocity, so Middlegen is not only
about CMP EJBs anymore. Writing Plugins is quite easy. There will be
better documentation about how to do that when the next release is
shipped. That will probably be in the end of May.

Cheers,
Aslak




--=_alternative 0058841580256BB4_=
Content-Type: text/html; charset="us-ascii"


<br><font size=2 face="sans-serif">Aslak,</font>
<br><font size=2 face="sans-serif">I too hate the web based forums. Now if only I could figure out how to mail directly?</font>
<br>
<br><font size=2 face="sans-serif">It looks as if you've been doing some great work with MiddleGen in the last month. I look forward to playing with it when 1.1 comes out.</font>
<br><font size=2 face="sans-serif"><br>
Ciao,<br>
Jonathan O'Connor<br>
Ph: +353 1 872 3305<br>
Mob: +353 86 824 9736<br>
Fax: +353 1 873 3612</font> <br> <br> <br> <table width=100%> <tr valign=top> <td> <td><font size=1 face="sans-serif"><b>&lt;***@netcom.no&gt;</b></font>
<p><font size=1 face="sans-serif">08.05.2002 16:23</font>
<br>
<td><font size=1 face="Arial">&nbsp; &nbsp; &nbsp; &nbsp; </font>
<br><font size=1 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; To: &nbsp; &nbsp; &nbsp; &nbsp;***@users.sourceforge.net, middlegen-***@lists.sourceforge.net</font>
<br><font size=1 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; cc: &nbsp; &nbsp; &nbsp; &nbsp;middlegen-***@lists.sourceforge.net</font>
<br><font size=1 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; Subject: &nbsp; &nbsp; &nbsp; &nbsp;many-to-many (and some status about Middlegen's plugins)</font></table>
<br>
<br>
<br><font size=2 face="Courier New">(crossposting to middlegen-devel. please reply to middlegen-user. <br>
middlegen-devel is only for people interested in middlegen's source <br>
code)<br>
<br>
Hi! I was about to remove the web-based forums (because I hate them, <br>
and activity there is very low), and I saw Jonathan O'Connor's post <br>
about m-n relations. Here it is again:<br>
<br>
---------------------%&lt;-----------------------------<br>
I have some code which detects when there are one to one relations. <br>
Basically, if the foreign key field is also the primary key field for <br>
the foreign table, then we have a 1-1 relationship. <br>
<br>
Let me know if you are interested in this code and I'll post it. <br>
<br>
Also, I have looked at the many-to-many code, and I don't understand <br>
it :-( But, I think the only time you should generate many-to-many <br>
relations are when T1 to MapTable is many-to-1 and T2 to MapTable is <br>
many-to-1, and (this is the important bit) the two foreign key fields <br>
in MapTable are the only primary key fields in MapTable. I did notice <br>
that middlegen will create a many-to-many from 1-many, many-1 (rather <br>
than many-1, 1-many). <br>
<br>
Hope this helps, <br>
Jonathan &nbsp;<br>
---------------------%&lt;-----------------------------<br>
<br>
I think the most common way to create a many-to-many relationship is by <br>
using 1-many, many-1.