- Run your SQL on Toad / SQL Plus or anything similar and make sure it runs first. - Check if you get the "unexpected" column. Santhi
"Nathan Maves" <[EMAIL PROTECTED]> 05/29/2007 05:12 PM Please respond to [email protected] To [email protected] cc Subject Re: java.sql.SQLException : Column 'xxxxx' not found 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.
