[Middlegen-user] Jboss3.0 - Many2Many

[Leslie Bertels (Synergetic)]

Hi all,

I created a very simple many to many relationship in my table-structure.
Now when I try to generate code with ant trough middlegen, It fails on the many2many table.

This is my configuration:
JBoss 3.0
EJB 2.0
MySQL db
Struts, Servlets.....

Table A :
Project
- projectId (int) PK
- name (varchar)
- description (varchar)
- status (varchar)

Phase
- phaseId (int) PK
- name (varchar)
- description (varchar)
- parent (int)


ProjectPhase
- projectId PK
- phaseId PK


Now Middlegen fails on creation of the EJB for ProjectPhase.
This is my build script :

<target name="generate.jdbc">
<taskdef
name="middlegen"
classname="middlegen.MiddlegenTask"
classpathref="middlegen.classpath" />
<middlegen
appname="timesheet"
prefsdir="${src}"
gui="no"
databaseurl="${database.url}"
initialContextFactory="${java.naming.factory.initial}"
providerURL=""
datasourceJNDIName="DataSource"
driver="${database.driver}"
username="${database.user}"
password="${database.passwd}"
schema="${database.schema}">


<table name="Phase"/>
<table name="Project"/>
<table name="ProjectPhase"/>

<many2many>
<tablea name="Project"/>
<jointable name="ProjectPhase" generate="false"/>
<tableb name="Phase"/>
</many2many>

<cmp20
destination="${src}"
package="${entity.package}"
jndiprefix="be.synsol"
dataobject="false"
viewtype="local"
mergedir="${src}"
readonly="false"
fkcmp="false">
<jboss/>
</cmp20>
</middlegen>
</target>


Now,
is this correct?
And if so, this error is popping up!

Nothing known about plugin <many2many>. Make sure the jar file containing the corresponding plugin class is on the classpath specified in the <taskdef> that defined middlegen.

All jars are in my classpath:

<path id="middlegen.classpath">
<fileset dir="${middlegen}/samples/lib">
<include name="*.jar"/>
</fileset>
</path>

So I don't see the problem.

Can anyone help me PLZ, Because I read in the forums that many people are able to generate many2many relationships!!!

Thx.
Les.