iBATIS does not deal with ResultsetMetaData, but it does try to remember the structure of previous qureies. To turn it off, set
remapResults="true" Jeff Butler On 5/24/07, Tegan Clark <[EMAIL PROTECTED]> wrote:
Hi group, I've got an interesting one: I have iBATIS 2.3 mapping against a set of legacy Oracle stored procedures (via an out parameter). These stored procedures return different cursors based on the input parameters supplied, i.e. sometimes it might return three columns, other times six. The first call works fine, as do calls that return the same cursor structure as the first call. I get problems though if the cursor structure changes. I think iBATIS is caching the resultset structure to save it having to interrogate the resultset metadata again for multiple calls. Unfortunately that doesn't work for me. Is there any way to turn it off? If not does anyone have a pointer as to where to start in the code to adjust this behavior? All help greatly appreciated. Tegan Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlMap/storedProcedure/all_report_pkg/listJobSummary.xml. --- The error occurred while applying a result map. --- Check the listJobSummary-AutoResultMap. --- Check the result mapping for the 'PRODUCT_TYPE_NAME' property. --- Cause: java.sql.SQLException: Invalid column name Shape Yahoo! in your own image. Join our Network Research Panel today! http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7hot CTA = Join our Network Research Panel
