iBATIS doesn't remap sql fully
------------------------------

         Key: IBATIS-297
         URL: http://issues.apache.org/jira/browse/IBATIS-297
     Project: iBatis for Java
        Type: Bug

  Components: SQL Maps  
    Versions: 2.1.5    
    Reporter: adamb


iBATIS doesn't remap parameters.

If I have statement with remapResults="true":

select * from mytable where $dynamicWhereClause$

and pass in the following two parameters: 
dynamicWhereClause                              #key#='abc'
key                                                                 
java.lang.String="abc"

Then the remap puts the #key# in the sql directly, rather than rechecking the 
statement to determine what the parameters will be, so gives the error
message:
java.sql.SQLException: ORA-00911: invalid character 

because it hasn't recognised the new hash parameters.

Version tested on:
iBATIS 2.1.5

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to