Hi,
I have below hibernate issue. Here is my configration.





// trying to get some records for origRptDefn.
for (Iterator it = origRptDefn.getPrntClmns().iterator(); it.hasNext();) {
hibernate query generates here for origRptDefn.getPrntClmns() correctly with srt_only_sw='N'
}

// trying to insert some records into QwRptClmn for qwRptDefn

for (Iterator it = qwRptDefn.getPrntClmns().iterator(); it.hasNext();) {
// getPrntClms suppose to get only records srt_only_sw is 'N' as defined in hbm file.
// I wounder this loop is geeting the records srt_only_sw is 'Y' also, where this record got saved just above.
// Tough I specified hibernate lazy is true, hibernate query is not generated here, but it got generated at the begining on origRptDefn.getPrntClmns(). I am not worry about this, but I am getting wrong record with srt_only_sw='Y' on qwRptDefn.getPrntClmns().Appreciate your help here.Thanks in advance
}
[/code]
Appreciate your help here.
Thanks in advance

I have little more information to share.
When tried to use qwRptDefn.getPrntClmns() initially, the below query generated fine with srt_only_sw='N'




After this, i have some java code(in my previous post) that inserts into QW_RPT_CLMN. Now when i try to access the same qwRptDefn.getPrntClmns(), below query generates with out srt_only_sw='N' and order by sqnc_num.


This is the reason I have wrong size of data with out having filtered with srt_only_sw='N'.
This issue happens only when my java code inserts records into QW_RPT_CLMN(as stated above). I wounder what is going on. Appreciate if some one have help in this, and i can provide more info if required.

Thanks a bunch.

This is resolved. Thanks for looking in to this.
There are two addPrntClmns getting called based on situation. One is not correctly implemented and after fixing it works. Thanks again.

Dileep