Hi!

I tried to use the INSERT INTO ... SELECT statement. The fellowing SQL is sent to the database (Oracle):

insert
into
dummy2.RiskAssignment
( Version, RiskAssignmentID, RiskGroupID, RiskVirtualAssetID ) select
?,
dummy2.hibernate_sequence.nextval,
riskgroup1_.RiskGroupID as RiskGrou1_146_0_,
virtualass0_.RiskVirtualAssetID as RiskVirt1_148_1_,
riskgroup1_.Version as Version146_0_,
riskgroup1_.Name as Name146_0_,
riskgroup1_.Description as Descript4_146_0_,
riskgroup1_.Priority as Priority146_0_,
riskgroup1_.ConsiderAbsoluteLimit as Consider6_146_0_,
riskgroup1_.LimitAbsolute as LimitAbs7_146_0_,
riskgroup1_.ConsiderPercentageLimit as Consider8_146_0_,
riskgroup1_.LimitPercentage as LimitPer9_146_0_,
riskgroup1_.LimitAbsoluteMinimal as LimitAb10_146_0_,
riskgroup1_.CommCurrencyID as CommCur11_146_0_,
riskgroup1_.Ris_RiskGroupID as Ris12_146_0_,
riskgroup1_.Ris_RiskGroupID2 as Ris13_146_0_,
riskgroup1_.RiskCategoryID as RiskCat14_146_0_,
riskgroup1_.OrgPortfolioID as OrgPort15_146_0_,
riskgroup1_.OrgSubPortfolioID as OrgSubP16_146_0_,
virtualass0_.Version as Version148_1_,
virtualass0_.Nominal as Nominal148_1_,
virtualass0_.Type as Type148_1_,
virtualass0_.VagExtendedCashFlowID as VagExten5_148_1_,
virtualass0_.CommCurrencyID as CommCurr6_148_1_
from
dummy2.RiskVirtualAsset virtualass0_,
dummy2.RiskGroup riskgroup1_,
dummy2.VagExtendedCashFlow extendedca2_,
dummy2.VagContract contract3_,
dummy2.VAGCONTRACT2ORGSUBPORTFOLIO subportfol6_,
dummy2.OrgSubPortfolio subportfol7_
where
VagContractID=subportfol6_.VagContractID
and subportfol6_.OrgSubPortfolioID=subportfol7_.OrgSubPortfolioID
and VagContractID=contract3_.VagContractID
and VagExtendedCashFlowID=extendedca2_.VagExtendedCashFlowID
and RiskGroupID=?
and OrgPortfolioId=?
and OrgSubPortfolioID=?

I get the Error ORA-00918: column ambiguously defined.

I also tried to execute only the SELECT part of the statement. This works fine. Now all columns are full qualified. The fellowing statement is sent to the database:

select
riskgroup1_.RiskGroupID as RiskGrou1_146_0_,
virtualass0_.RiskVirtualAssetID as RiskVirt1_148_1_,
riskgroup1_.Version as Version146_0_,
riskgroup1_.Name as Name146_0_,
riskgroup1_.Description as Descript4_146_0_,
riskgroup1_.Priority as Priority146_0_,
riskgroup1_.ConsiderAbsoluteLimit as Consider6_146_0_,
riskgroup1_.LimitAbsolute as LimitAbs7_146_0_,
riskgroup1_.ConsiderPercentageLimit as Consider8_146_0_,
riskgroup1_.LimitPercentage as LimitPer9_146_0_,
riskgroup1_.LimitAbsoluteMinimal as LimitAb10_146_0_,
riskgroup1_.CommCurrencyID as CommCur11_146_0_,
riskgroup1_.Ris_RiskGroupID as Ris12_146_0_,
riskgroup1_.Ris_RiskGroupID2 as Ris13_146_0_,
riskgroup1_.RiskCategoryID as RiskCat14_146_0_,
riskgroup1_.OrgPortfolioID as OrgPort15_146_0_,
riskgroup1_.OrgSubPortfolioID as OrgSubP16_146_0_,
virtualass0_.Version as Version148_1_,
virtualass0_.Nominal as Nominal148_1_,
virtualass0_.Type as Type148_1_,
virtualass0_.VagExtendedCashFlowID as VagExten5_148_1_,
virtualass0_.CommCurrencyID as CommCurr6_148_1_
from
dummy2.RiskVirtualAsset virtualass0_,
dummy2.RiskGroup riskgroup1_,
dummy2.VagExtendedCashFlow extendedca2_,
dummy2.VagContract contract3_,
dummy2.VAGCONTRACT2ORGSUBPORTFOLIO subportfol6_,
dummy2.OrgSubPortfolio subportfol7_
where
contract3_.VagContractID=subportfol6_.VagContractID
and subportfol6_.OrgSubPortfolioID=subportfol7_.OrgSubPortfolioID
and extendedca2_.VagContractID=contract3_.VagContractID
and virtualass0_.VagExtendedCashFlowID=extendedca2_.VagExtendedCashFlowID
and riskgroup1_.RiskGroupID=?
and contract3_.OrgPortfolioId=?
and subportfol7_.OrgSubPortfolioID=?

Is this a bug?

Greetings
olli73

Hello!

To make my posting more clear:

The problem is in the last 3 lines of the first statement (all lines with a ?). The statement contains more then one table with a column called OrgPortfolioId.

Greetings
olli73