two foreign keys to the same table

hi,

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