[Middlegen-user] Relationships question

[Adrian Hallam]

Hello,

I have been working on generating cmp beans and have
gotten some jars completed. However, I never seem to
be able to get relationships in my database to appear
in the GUI. I have looked through the source code and
the call in the function
MiddlegenPopulator.addRelationships(...)
getMetaData().getExportedKeys(_catalog, _schema,
pkTable.getSqlName());

returns me an empty result set for my database. My
understanding is that this causes no relationships to
be generated. I am also working on the understanding
that the relationships should have been generated from
the Foreign Keys defined in the database?

I also get no relationships for the Airline example
when I run it on my system. I am running MySql
(mysql-max-3.23.52-win), Java 1.4 and Ant 1.5. Again,
the airline ejb jar that is produced deploys OK (Jboss
3.0.2) but doesn't contain any relationships.

When the airline sample GUI appears, is there supposed
to be relationships visible by default? For example,
between persons.person_id and
reservations.personid_fk? If not, is there a way to
create these manually?

Also, where is the best place for me to go and read
more - either documentation or source code to work out
why my relationships aren't appearing?

btw, I am referring to 1:1 and 1:M relationships
only.- I have bene updating the M:M in the build.xml
script.

Thanks greatly for any help.

Regards,
Adrian

http://mobile.yahoo.com.au - Yahoo! Messenger for SMS
- Always be connected to your Messenger Friends

[Aslak Hellesøy]

-----Original Message-----
Hallam
Sent: 3. oktober 2002 19:45
Subject: [Middlegen-user] Relationships question
Hello,
I have been working on generating cmp beans and have
gotten some jars completed. However, I never seem to
be able to get relationships in my database to appear
in the GUI. I have looked through the source code and
the call in the function
MiddlegenPopulator.addRelationships(...)
getMetaData().getExportedKeys(_catalog, _schema,
pkTable.getSqlName());
returns me an empty result set for my database. My
understanding is that this causes no relationships to
be generated. I am also working on the understanding
that the relationships should have been generated from
the Foreign Keys defined in the database?
I also get no relationships for the Airline example
when I run it on my system. I am running MySql
(mysql-max-3.23.52-win), Java 1.4 and Ant 1.5. Again,
the airline ejb jar that is produced deploys OK (Jboss
3.0.2) but doesn't contain any relationships.

http://boss.bekk.no/boss/middlegen/platforms/database.html
have you enabled InnoDB on your MySQL?
http://www.innodb.com/ibman.html

When the airline sample GUI appears, is there supposed
to be relationships visible by default? For example,

yes.

between persons.person_id and
reservations.personid_fk? If not, is there a way to
create these manually?

http://boss.bekk.no/boss/middlegen/ant/table.html#crossref

Also, where is the best place for me to go and read
more - either documentation or source code to work out
why my relationships aren't appearing?

Hopefully this will get you a step further.

btw, I am referring to 1:1 and 1:M relationships
only.- I have bene updating the M:M in the build.xml
script.
Thanks greatly for any help.
Regards,
Adrian

Cheers,
Aslak

http://mobile.yahoo.com.au - Yahoo! Messenger for SMS
- Always be connected to your Messenger Friends
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user