Thank you,
This solved the problem.
Giora
[EMAIL PROTECTED]
10/09/2003 03:12 AM
Please respond to "OJB Users List"
To: "OJB Users List" <[EMAIL PROTECTED]>
cc:
Subject:Antwort: [Fwd: SQLGenerator]
Giora,
the elements and
must specifiy the foreign key columns in
the indirection table, not the primary keys of the linked tables. These fk
columns necessarily have different names as the are in the same table.
HTH
Gerhard
Original Message
Subject: SQLGenerator
Date: Wed, 8 Oct 2003 15:26:40 -0400
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi Thomas.
My name is Giora.
I am using OJB (Love it).
In my repository I have the following mapping for a collection using m:n
without decomposition:
Since both table use the GRP_REF_ID column name OJB generates SQL
without fully qualifying the column names. The result is the following
exception:
The column "GRP_REF_ID" is specified more than once in the INSERT,
UPDATE or SET transition-variable statement. SQLSTATE=42701.
Is there any way to instruct OJB to pre append the table alias to the
column name?
Thank you,
Giora
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
The information in this e-mail, and any attachment therein, is confidential and for
use by the addressee only. If you are not the intended recipient, please return the
e-mail to the sender and delete it from your computer. Although The Bank of New York
attempts to sweep e-mail and attachments for viruses, it does not guarantee that
either are virus-free and accepts no liability for any damage sustained as a result of
viruses.