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
>
