This one time, at band camp, Ebersole, Steven said:
ES>Can someone please point out to me what is wrong with the following mapping
ES>snippet:
ES>
ES> <field name="forecastedAmount.number" type="double">
ES> <sql name="TOT_AMT" many-key="OPP_ID"
ES>many-table="V_OPP_FORECASTED_AMOUNTS"/>
ES> </field>
ES> <field name="forecastedAmount.currency"
ES>type="com.vignette.it.apps.jdo.CurrencyImpl">
ES> <sql name="TOT_CURR_ID" many-key="OPP_ID"
ES>many-table="V_OPP_FORECASTED_AMOUNTS"/>
ES> </field>
ES>
ES>Leads to the following query statement (from castor debug logs):
ES>SELECT "OPPORTUNITY"."NAME",
ES> "OPPORTUNITY"."COMP_ID",
ES> "OPPORTUNITY"."ORG_ID",
ES> "OPPORTUNITY"."PROJ_CLOSE_DT",
ES> "OPPORTUNITY"."SS_ID",
ES> "OPPORTUNITY"."FORECAST_DESIGNATION_ID",
ES> "OPPORTUNITY"."OPP_ASSESSMENT_ID",
ES> "V_OPP_FORECASTED_AMOUNTS"."TOT_CURR_ID",
ES> "OPPORTUNITY"."TOT_AMT",
ES> "OPP_TECH_ENV_JT"."TECH_ENV_ID",
ES> "OPPORTUNITY"."ACTIVE_FLG",
ES> "OPPORTUNITY"."CRTD_DT",
ES> "OPPORTUNITY"."CRTD_BY",
ES> "OPPORTUNITY"."CHGD_DT",
ES> "OPPORTUNITY"."CHGD_BY"
ES>FROM "V_OPP_FORECASTED_AMOUNTS","OPPORTUNITY","OPP_TECH_ENV_JT"
ES>WHERE "OPPORTUNITY"."OPP_ID"="V_OPP_FORECASTED_AMOUNTS"."OPP_ID"(+)
ES> AND "OPPORTUNITY"."OPP_ID"="OPP_TECH_ENV_JT"."OPP_ID"(+)
ES>
ES>
ES>
ES>The currency part actually gets mapped correctly in the SQL statement
ES>("V_OPP_FORECASTED_AMOUNTS"."TOT_CURR_ID"), but, for some reason I have
ES>failed to see, Castor thinks it should find the TOT_AMT column on the
ES>OPPORTUNITY table ("OPPORTUNITY"."TOT_AMT") even though I just told it to
ES>look on V_OPP_FORECASTED_AMOUNTS. ?????
Steve,
Whoa! That's odd. Let's see the mapping for the whole class. I
notice it's been two days since you posted this. Have you made any
additional progress (e.g. hints or even guesses as to why this is
occurring)?
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
