Re: ERROR: cache lookup failed for type 0

[Michael Zurke]

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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