object no longer exists

[Vinaya Tirikkovalluru <vi...@converge.com>]

Hi,

 

I am caching a query with ibatis. The query is as below

 

 

<resultMap

            class="com.persistent.model.cacheobjects.CacheObject"

            id="createSoUsers">

            <result column="user_id" jdbcType="NUMBER" property="longId"
/>

            <result column="user_name" jdbcType="VARCHAR"
property="name" />

      </resultMap>

 

      <select id="getCreateSoUsers"

            resultClass="com.persistent.model.cacheobjects.CacheObject"

            resultMap="createSoUsers" cacheModel="generalCache">

            SELECT ulog.user_id user_id,

            user_name( ulog.user_id) user_name

            FROM user_login ulog

            WHERE user_type_code = 'E'

            AND active_ind = 'Y'

            AND ( EXISTS( SELECT 1

            FROM user_roles_vw urv

            WHERE urv.user_id = ulog.user_id

            AND urv.security_role = 'SOENTRY'

            )

 

            OR EXISTS( SELECT 1

            FROM user_roles_vw urv2,

            necxadm.security_role_members srm

            WHERE urv2.user_id = ulog.user_id

            AND urv2.security_role = srm.security_role

            AND srm.member_role = 'SOENTRY'

            )

            )order by user_name

 

 

  </select>

 

I am getting the below error, but not always. If the query the same in
toad, I did not get the same error.

 

--- The error occurred while applying a parameter map.  

--- Check the NECXADM_CACHE_OBJECT.getCreateSoUsers-InlineParameterMap.


--- Check the statement (query failed).  

--- Cause: java.sql.SQLException: ORA-08103: object no longer exists

 

Any ideas?

 

Thanks

Vinaya



This electronic message is intended only for the use of the individual(s) or entity(ies) named above and may contain information which is privileged and/or confidential.  If you are not the intended recipient, be aware that any disclosure, copying, distribution, dissemination or use of the contents of this message is prohibited.  If you received this message in error, please notify the sender immediately.