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