ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: ERROR: cache lookup failed for type 0
Date Thu, 14 Jul 2005 14:49:43 GMT
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