Eivind Waaler wrote:
Hi, this is unfortunately a known bug which hasen't been fixed yet.
Maybe someone on the list has a solution?
This is of course a major problem, I'll try to get it fixed asap.
Regards .eivind
On Sat, 24 Jan 2004, Alex Greif wrote:
hi,
The list does not seem to respont that's why I contact you
this way.
I have an urgent and tricky problem if a table contains two
foreign keys pointing to the same pk in another table:
Your Help is highly appreciated.
Thanks
ALex.
--- here is the message I posted to the list ----
In the following simple sample middlegen generates strange code.
Im a DB novice so maybe the sql code is not right, but
jboss/hsqldb had
no problems with it:
CREATE TABLE "addresses" (
"address_id" INT NOT NULL,
"city" VARCHAR NOT NULL,
"street" VARCHAR NOT NULL,
PRIMARY KEY("address_id")
);
CREATE TABLE "customers" (
"customer_id" INT NOT NULL,
"first_name" VARCHAR NOT NULL,
"last_name" VARCHAR NOT NULL,
"login" VARCHAR NOT NULL,
"password" VARCHAR NOT NULL,
"billing_address_id_fk" INT NOT NULL,
"shipping_address_id_fk" INT NOT NULL,
PRIMARY KEY("customer_id"),
FOREIGN KEY ("billing_address_id_fk") REFERENCES
"addresses"("address_id"),
FOREIGN KEY ("shipping_address_id_fk") REFERENCES
"addresses"("address_id")
);
In the CustomerValue.class it generates the following code
where the
same field name is declared more than once:
private java.lang.Integer billingAddressIdFk;
private boolean billingAddressIdFkHasBeenSet = false;
private java.lang.Integer shippingAddressIdFk;
private boolean shippingAddressIdFkHasBeenSet = false;
private flowshop.interfaces.AddressLightValue Address;
// duplicate
private boolean AddressHasBeenSet = false; // duplicate
private flowshop.interfaces.AddressLightValue Address;
// duplicate
private boolean AddressHasBeenSet = false; // duplicate
has anybody has a hint whats wrong with the sql code?
I use the cvs version of middlegen with jboss 3.2.3 with
hsqldb 1.7.1
chers
Alex.
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
-- Jos� Manuel Molina Pascual [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> /* Stratesys Consulting */ C/ Juan de Mena, 6 Madrid 28014 Tel (+34) 91 360 49 60
smime.p7s
Description: S/MIME Cryptographic Signature
