hi nmaves, your guess was right. It fixed my problem. :) thanks!!!
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 <[EMAIL PROTECTED]> 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.