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
> >>
> >
> >
>
>
