Re: [Middlegen-user] Problem with relationship in MySQL

Fabio Oliveira wrote:

>>Your MySQL tables must be of type InnoDB.
>>    
>>
>
>Dear Aslak:
>In my script, i was used type InnoDB.
>Look the error:
>[Middlegen] (middlegen.MiddlegenPopulator        222 ) WARNING:
>Middlegen couldn
>'t find any relations between any tables. This may be intentional from
>the desig
>n of the database, but it may also be because you have incorrectly
>defined the r
>elationships. It could also be because the JDBC driver you're using
>doesn't corr
>ectly implement DatabaseMetaData. See the samples (for an example on how
>to defi
>ne relationships) and verify that your driver correctly implements
>DatabaseMetaD
>ata.
>
>Look my script:
>drop table if exists a;
>drop table if exists b;
>create table a (campo1 integer not null,
>campo2 integer not null,
>primary key (campo1,campo2)
>) type=InnoDB;
>
>create table b(campo3 integer not null,
>campo4 integer not null,campo5 integer not null,campo6 integer not null,
>primary key (campo3,campo4),
>index i2 (campo5,campo6),
>foreign key (campo5,campo6) references a (campo1,campo2)
>) type=InnoDB;
>
>Fabio.
>
>  
>
Looks correct. Can you get the samples to work? If they don't work for 
you either, you're most likely doing something wrong on the MySQL side. 
Maybe InnoDB hasn't been properly installed? It's not enough to just 
declare InnoDB in your SQL. See the InnoDB manual. Also make sure you're 
using the driver that ships with Middlegen when you run Middlegen.

http://boss.bekk.no/boss/middlegen/platforms/database.html
HTH,
Aslak

>
>-------------------------------------------------------
>This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>Data Reports, E-commerce, Portals, and Forums are available now.
>Download today and enter to win an XBOX or Visual Studio .NET.
>http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>_______________________________________________
>middlegen-user mailing list
>mid...@li...
>https://lists.sourceforge.net/lists/listinfo/middlegen-user
>
>
>  
>