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 14:42:22 GMT
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