Result cached, dB query giving in correct result.

[malini]

Hi All, I am getting a very weird error.my Report Query (Oracle 9i database as the datasource)is givng very different result when I run using iReport.Query :SELECT COUNT(*)AS FULL_ELIGSFROM ELIG_TMP_TABLE WHERE MONTHS = 12Running this query in Oracle sql developer gives FULL_ELIGS=3953and running the same query in iRport gives FULL_ELIGS=19765i.e 5xFULL_ELIGs correct value.the ireport run was giving 3 time the FULL_ELIGS correct value 1st, then 4 times and 5 now...looks like it is caching data some place and giving me a computed result.How and where can i check if the result is indeed being cached.[color=#FF0000]Note: I am setting isUsingCache=fasle, it's still not clearing the data.[/color]Any help greatly appriciated.Thanks,Malini

 

Post edited by: malini, at: 2007/03/17 14:58