This question is locked. New answers and comments are not allowed.
I am doing reverse mapping on some tables on our Oracle database using Domain Model with the latest internal version (2010.2.804.5). I have two classes, A and B. A is inherited from B. I follow the steps in the comment #2 here to create inhertiance relationship. The primary key of table mapped to B (the base class) is "ID" while the primary key of the table mapped to A (the subclass) is "B_ID".
The issue that the generated SQL has the primary key of the table mappped to A as an ID.
For example, the generated SQL is
But I want the generated SQL to be like the below (notice A."B_ID")
Is it possible to do this within Domain Model Designer?
Thanks,
Karlkim
The issue that the generated SQL has the primary key of the table mappped to A as an ID.
For example, the generated SQL is
select
*
FROM
(
SELECT
A.
"ID"
, A.
"COL1", B."ID", B."COL1"
FROM
A
JOIN
B
ON
(A.
"ID"
=
B.
"ID"
))
But I want the generated SQL to be like the below (notice A."B_ID")
select
*
FROM
(
SELECT
A.
"ID"
, A.
"COL1", B."ID", B."COL1"
FROM
A
JOIN
B
ON
(A.
"B_ID"
= B.
"ID"
))
Is it possible to do this within Domain Model Designer?
Thanks,
Karlkim