ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Zurke <mis...@zurke.info>
Subject Re: ERROR: cache lookup failed for type 0
Date Thu, 14 Jul 2005 15:18:19 GMT
yes, you're right. it was caused by a buggy trigger. thanx.

Larry Meadors wrote:
> Hmm, well it is certainly a pgsql issue - http://tinyurl.com/bbfnw
> 
> Larry
> 
> 
> On 7/14/05, Michael Zurke <mischa@zurke.info> wrote:
> 
>>hi Daniel,
>>
>>PostgreSQL 8.0.2.
>>tried to run the same query on the console and had no problems, though.
>>
>>Daniel Henrique Ferreira e Silva wrote:
>>
>>>Hi Mischa,
>>>
>>>Usually SQL exceptions are due to failures in your database engine.
>>>Which database engine are you using?
>>>
>>>Cheers,
>>>Daniel Silva.
>>>
>>>On 7/14/05, Michael Zurke <mischa@zurke.info> wrote:
>>>
>>>
>>>>hi,
>>>>
>>>>getting this error
>>>>
>>>>--- The error occurred in Test.xml.
>>>>--- The error occurred while applying a parameter map.
>>>>--- Check the deleteTest-InlineParameterMap.
>>>>--- Check the statement (update failed).
>>>>--- Cause: java.sql.SQLException: ERROR: cache lookup failed for type 0
>>>>Caused by: java.sql.SQLException: ERROR: cache lookup failed for type 0
>>>>
>>>>for map
>>>>
>>>>    <delete id="deleteTest"
>>>>               parameterClass="java.lang.Integer">
>>>>           DELETE FROM
>>>>            test.foo
>>>>            WHERE id = #id#
>>>>    </delete>
>>>>
>>>>executed with
>>>>
>>>>    try
>>>>    {
>>>>      sqlMap.startTransaction();
>>>>
>>>>      for (int bbID : badIDs_)
>>>>      {
>>>>        sqlMap.delete("deleteTest", bbID);
>>>>      }
>>>>
>>>>      sqlMap.commitTransaction();
>>>>    }
>>>>    catch (SQLException e)
>>>>    {
>>>>      log.error(e.toString());
>>>>    }
>>>>    finally
>>>>    {
>>>>      try {sqlMap.endTransaction();}catch(Exception ignore){}
>>>>    }
>>>>
>>>>looks all straight forward for me. can't figure out what's going on. and
>>>>caching is disabled. any ideas?
>>>>
>>>>mischa
>>>>
>>>
>>>
>>
> 


Mime
View raw message