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.tirikkovall...@converge.com> wrote: > Just resending it, as I got a failure notice > > > > Thanks > Vinaya > > > > ________________________________ > > From: Vinaya Tirikkovalluru [mailto:vinaya.tirikkovall...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
