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 FW: object no longer exists
Date Wed, 07 Apr 2010 17:52:33 GMT
Just resending it, as I got a failure notice

 

Thanks
Vinaya

 

________________________________

From: Vinaya Tirikkovalluru [mailto:vinaya.tirikkovalluru@converge.com] 
Sent: Wednesday, April 07, 2010 1:11 PM
To: user-java@ibatis.apache.org
Subject: object no longer exists

 

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. 



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