ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: java.sql.SQLException : Column 'xxxxx' not found
Date Tue, 29 May 2007 21:12:00 GMT
at first guess I would suggest that you might have to enable the
remapResults attribute.  Please post your sqlmap and any resultmaps that you
use for this query.

On 5/29/07, rhastakid <rchiu@rivereo.com> wrote:
>
>
> Hi people.  I'm new to Ibatis.  we're using Ibatis without the use of
> Spring.
> so we have a query with inner joins, and we have a parametermap to fill in
> all the variables there.  in the logs we're getting the error of a certain
> column is not found.  The way the query is created, we use a name like
> result_<variablename> as one of the fields in the select statement.  where
> variablename is variable that is passed with the parameter map.  The weird
> thing is, the name that it is saying that is not found is not really part
> of
> the parameters passed to it.  It is an "old" data that was used before and
> is not removed from the database(and not passed as a parameter).  Any
> thoughts on this?  we left the application for some time, and then tried
> accessing it again, the error was suddenly gone.  Though we know we have
> to
> fix this problem as it still lingers somewhere.
>
> We just can't find where the problem is.
>
> Thanks.
>
> --
> View this message in context:
> http://www.nabble.com/java.sql.SQLException-%3A-Column-%27xxxxx%27-not-found-tf3832783.html#a10850924
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message