You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Michael Zurke <mi...@zurke.info> on 2005/07/14 16:30:10 UTC
ERROR: cache lookup failed for type 0
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
Re: ERROR: cache lookup failed for type 0
Posted by Michael Zurke <mi...@zurke.info>.
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 <mi...@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 <mi...@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
>>>>
>>>
>>>
>>
>
Re: ERROR: cache lookup failed for type 0
Posted by Larry Meadors <la...@gmail.com>.
Hmm, well it is certainly a pgsql issue - http://tinyurl.com/bbfnw
Larry
On 7/14/05, Michael Zurke <mi...@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 <mi...@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
> >>
> >
> >
>
>
Re: ERROR: cache lookup failed for type 0
Posted by Michael Zurke <mi...@zurke.info>.
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 <mi...@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
>>
>
>
Re: ERROR: cache lookup failed for type 0
Posted by Daniel Henrique Ferreira e Silva <dh...@gmail.com>.
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 <mi...@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
>