ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Meindert" <meind...@pastelebusiness.com>
Subject RE: Retrieving wrong result out of the Cache.
Date Fri, 16 Mar 2007 09:30:16 GMT
Anyone who knows what I'm doing wrong or is encountering the same issue?


>Hi there,


My cache is returning the wrong ID, for instance the statement

Select ID from X where ID=3 is returning not 3!


Here are the code sniplets I have that are producing the wrong data (after
the cache has been populated)


Requesting the employee with diary.getDiaryEmpId()=3

EmpName empName = (EmpName) queryForObject("selectEmpName",



<cacheModel id="selectEmpNameCache" type="LRU">

    <flushInterval hours="12"/>

    <flushOnExecute statement="updateEmployee"/>

    <property name="cache-size" value="25"/>


  <select id="selectEmpName" parameterClass="int" resultClass="EmpName"

    SELECT EmplMain.EmpId, CompanyId, EmplName, Surname, NickName, Code,
Email, Telephone1, Telephone2

       FROM EmplMain

       JOIN EmplProfile ON EmplProfile.EmpId = EmplMain.EmpId

       WHERE  EmplMain.EmpId=#value# AND EmplMain.IsActiveEmployee=1



Results in fetching Employee out of cache

DEBUG [http-8084-Processor22] - Cache 'Employee.selectEmpNameCache':
retrieved object 'com.pastel.ess.domain.EmpName@1'


The resulting object has as Empid 1 and not 3!

All other field values are correct.





View raw message