ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vinaya Tirikkovalluru" <vinaya.tirikkovall...@converge.com>
Subject object no longer exists
Date Wed, 07 Apr 2010 17:11:21 GMT
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.

Mime
View raw message