Well, I have tried it with the mm 2.0.7 Driver and the tables show up, but
there are no links shown. The foreign key is definitely there, cause if I
try to insert a record that doesn't give a proper reference I get a
referential integrity error. I believe the driver does in fact support the
getCrossReference( ), so I'm not sure why it doesn't work. Does the foreign
key have to have a name (child_parentid_fk)? The InnoDB docs do not specify
how to name the foreign key.
Interestingly, when I explore the tables in Forte for Java, it doesn't show
anything under the Foreign keys node...leading me to believe that InnoDB
stores them in some strange way.
I will keep trying.
Steve
----- Original Message -----
From: <***@netcom.no>
To: "Steve Knight" <***@hotmail.com>;
<middlegen-***@lists.sourceforge.net>
Sent: Sunday, January 20, 2002 5:44 PM
Subject: MySQL and JBoss WAS: [Middlegen-user] log4j problems when starting
Post by a***@netcom.noHi again Steve!
Post by a***@netcom.no-----Original Message-----
Knight
Sent: 20. januar 2002 19:09
Subject: Re: [Middlegen-user] log4j problems when starting
Very nice!
A few questions...Is it possible to use middlegen with the new
MySQL InnoDB
table type, as they support foreign keys?
It's (theoretically) possible if you're using a JDBC driver for MySQL that
myConnection.getMetaData().getCrossReference( ... ) must be working
correctly for the database being used.
This is done on line 418 in SchemaFactory.
-I haven't tried Middlegen with anything else than MS SQL Server, but I know
people have got it to work with Oracle.
Perhaps you could investigate the MySQL JDBC driver/InnoDB issue further? It
would be fantastic to have Middlegen working with great open source products
such as MySQL and JBoss!
Post by a***@netcom.noAnd, has anyone created a plugin for JBoss yet?
Nobody has written anything for JBoss yet. I'm working on a new version of
Middlegen that will generate code using the same template engine as XDoclet
instead of today's pretty awkward out.println statements. This will make it
a lot easier to write plugins for other app servers, and even for other
stuff such as JDO, Struts and WebWork.