I have the following mapping in securities.hbm.xml file. The value of index comes fine.(value=10) However, sometimes the value of stockmembership s null. any ideas why? i didnt make any change to the code. it works fine now. however, earlier the same code was nt working.
Code:
<property name="index" column="INDEX_SPPW_ID"/>
<property name="stockMembership" formula="(case when INDEX_SPPW_ID = 10 then 'S&P 400' when INDEX_SPPW_ID = 11 then 'S&P 500' when INDEX_SPPW_ID = 12 then 'S&P 600' else '' end)" type="string" />
Thank you!
Jayashree.