I have my sql map defined as follows...

 <cacheModel id="roleCache" type="LRU" readOnly="false" serialize="true">
   <flushInterval hours="24"/>
   <flushOnExecute statement="insertRole"/>
   <flushOnExecute statement="updateRole"/>
   <flushOnExecute statement="deleteRole"/>
   <flushOnExecute statement="deleteAllRoles"/>
   <property name="size" value="200"/>
 </cacheModel>

<insert id="insertRole">
INSERT INTO ROLES
(roleKey, roleName, roleDescription, roleComments, createUser, updateUser, createDate, updateDate)
VALUES
(#roleKey#, #roleName#, #roleDescription#, #roleComments#, #createUser#, #updateUser#, #createDate#, #updateDate#)
</insert>


there are other statements as well but this will explain my problem. When I execute "insertRole" with a SqlMapExecutor.executeBatch(), my cache doesn't get flush. Is not suppose to do that or am I missing something.

Thanks

Amad



Reply via email to