Hi List,
I have the following issue, I'm using an intermediate table for a many
to many relationship (supplier<--->>supplier_product<<--->product), the
primary key of the intermediate table is composed by the foreign keys
to supplier and product, If I delete an object fetched from the
intermediate table and then I insert another object with the same
supplier, product and save I get the next exception:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.PostgresqlExpression: "INSERT INTO
public.supplier_product(supplierid, productid) VALUES (?, ?)"
withBindings: 1:2(supplierid), 2:1865(productid)>:
Next exception:SQL State:23505 -- error code: 0 -- msg: ERROR:
duplicate key violates unique constraint "supplier_product_pkey"
I think that the adaptor is sending a delete and an insert but the
order is not the correct one.
Please help!
Thanks in advance.
Cheers
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
