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

Reply via email to