BTW this is because the FK elements are not added on the call to create but with postCreate.
On Mon, 2004-01-26 at 14:15, Timothy Peter Cockle wrote: > Also FK's can not be defined as NOT NULL. > > On Mon, 2004-01-26 at 12:33, Russell Simpkins wrote: > > The duplicate definition is due to the dual foreign keys. One set of > > interface values for each key. You may need to use the gui to tell > > middlegen to give each fk reference unique interface names, or just > > manually fix that. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Alex > > Greif > > Sent: Saturday, January 24, 2004 10:20 AM > > To: [EMAIL PROTECTED] > > Subject: [Middlegen-user] 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 > > _______________________________________________ > > middlegen-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/middlegen-user > > > > > > ------------------------------------------------------- > > 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 > > > > ------------------------------------------------------- > 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 ------------------------------------------------------- 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
