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
