MyISAM tables don't hold any information about foreign keys so torque can not fetch them from the DB I guess. You need to use InnoDB when creating your database, that's the only table-type in mysql which can deal with Foreign Key constrainst.
Maybe the fk information is also maintained for MyISAM tables in 5.0's InformationSchema but I don't know for sure. Tom Trevor Miller wrote: > Hi All, > > When running my jdbc task from a mysql database the xml schema is generated > fine but with no foreign key elements in the XML. Is there a way to get this > task to give the foreign key elements? > > I am using torque 3.1, mysql 4.0.25 and MyISAM tables. > > Any help would be greatly appreciated! >
signature.asc
Description: OpenPGP digital signature
