Two solutions to this one: 1) Turn lazy loading off
2) Use a join mapping (which will be faster anyway) << preferred. This is a known limitation of the lazy loader, but something we could probably fix too. Clinton On Mon, Apr 21, 2008 at 2:44 AM, market sniffer <[EMAIL PROTECTED]> wrote: > hi: > > i try to select from a table with no rows of data and uses the following > resultMap as return > > <!-- definitions of another statement which has the following selection--> > .... > <result property="mktTotalIncome" column="HDBH" > select="marketing.mktTotalIncome"/> > ... > > <select id="mktTotalIncome" parameterClass="java.lang.String" > resultMap="get-mktTotalIncome-result"> > select > MARKETING_ID, > INCOME_TOTAL_AIM, > INCOME_TOTAL_ACTUAL, > BEFORE_ARPU_THREE, > BEFORE_ARPU_TWO, > BEFORE_ARPU_ONE, > AFTER_ARPU_ONE, > AFTER_ARPU_TWO, > AFTER_ARPU_THREE > from da.TABA_MARKET_TOTAL_INCOME > where MARKETING_ID = #marketingId# > </select> > > <resultMap id="get-mktTotalIncome-result" class="MktTotalIncomeVO"> > <result property="marketing_id" column="MARKETING_ID"/> > <result property="income_total_aim" column="INCOME_TOTAL_AIM" > nullValue="0"/> > <result property="income_total_actual" column="INCOME_TOTAL_ACTUAL" > nullValue="0"/> > <result property="before_arpu_three" column="BEFORE_ARPU_THREE" > nullValue="0"/> > <result property="before_arpu_two" column="BEFORE_ARPU_TWO" > nullValue="0"/> > <result property="before_arpu_one" column="BEFORE_ARPU_ONE" > nullValue="0"/> > <result property="after_arpu_one" column="AFTER_ARPU_ONE" > nullValue="0"/> > <result property="after_arpu_two" column="AFTER_ARPU_TWO" > nullValue="0"/> > <result property="after_arpu_three" column="AFTER_ARPU_THREE" > nullValue="0"/> > </resultMap> > > since there is no data, i am expecting the the field "mktTotalIncome" to > return null, however i got the return of a MktTotalIncomeVO with its fields > set to null, and which in turn is causing some of the arithmatic problems. > > i am wondering why it does not return NULL but a new object with fields > set to null? > > thanks. >
