ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhastakid <rc...@rivereo.com>
Subject Re: java.sql.SQLException : Column 'xxxxx' not found
Date Wed, 30 May 2007 03:39:16 GMT

hi nmaves, your guess was right.  It fixed my problem. :)


nmaves wrote:
> 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.

View this message in context: http://www.nabble.com/java.sql.SQLException-%3A-Column-%27xxxxx%27-not-found-tf3832783.html#a10866905
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message