ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <nathan.ma...@gmail.com>
Subject Re: FW: object no longer exists
Date Wed, 07 Apr 2010 18:48:57 GMT
This is a sql exception from oracle.  This does not look like it has
anything to do with ibatis.

On Wed, Apr 7, 2010 at 11:52 AM, Vinaya Tirikkovalluru
<vinaya.tirikkovalluru@converge.com> wrote:
> 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.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message