[ http://issues.apache.org/jira/browse/IBATIS-163?page=all ]
Clinton Begin closed IBATIS-163:
--------------------------------
Fix Version: 2.1.5
Resolution: Invalid
Assign To: Clinton Begin
No verification, cannot reproduce. So closing.
> cache not flushing if namespace is used in <sqlMap>
> ---------------------------------------------------
>
> Key: IBATIS-163
> URL: http://issues.apache.org/jira/browse/IBATIS-163
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Environment: OS - Windows XP
> Reporter: Satish Rao
> Assignee: Clinton Begin
> Fix For: 2.1.5
>
> I have the following xml
> <sqlMap namespace="User">
> <cacheModel id="user-cache" type="LRU" readOnly="false"
> serialize="true">
> <flushInterval hours="24"/>
> <flushOnExecute statement="User.addUser"/>
> <flushOnExecute statement="User.removeUser"/>
> <flushOnExecute statement="User.addEmail"/>
> <flushOnExecute statement="User.removeUserEmails"/>
> <property name="cache-size" value="1000"/>
> </cacheModel>
> <resultMap id="list-users-result"
> class="com.fmr.gift.strutsplus.domain.User">
> <result property="id" column="UID"/>
> <result property="age" column="AGE"/>
> <result property="firstname" column="FIRSTNAME"/>
> <result property="lastname" column="LASTNAME"/>
> <result property="eventsJoined" column="UID"
> select="getEventsJoinedByUserId"/>
> <result property="emails" column="UID"
> select="getEmailsbyUserId"/>
> </resultMap>
> <select id="listUsers" resultMap="list-users-result"
> cacheModel="user-cache">
> SELECT
> UID,
> AGE,
> FIRSTNAME,
> LASTNAME
> FROM
> USERS
> </select>
> <delete id="removeUser" parameterClass="java.lang.Long">
> DELETE FROM
> USERS
> WHERE
> UID = #value#
> </delete>
> </sqlMap>
> The caching works fine for select. But when I delete a user, I expected the
> cache to be be flushed because of the following entry in cache model -
> <flushOnExecute statement="removeUser"/>. This does not happen. When I
> perform removeUser operation, the user list is displayed again and shows the
> user id that was deleted.
> I removed namespace="User" from <sqlMap> and also the 'User' prefix on
> <flushOnExecute> and the flushing worked fine.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
