ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Henrique Ferreira e Silva <dhsi...@gmail.com>
Subject Re: ERROR: cache lookup failed for type 0
Date Thu, 14 Jul 2005 14:40:15 GMT
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