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
