"insert into .. select .. " causes exception
--------------------------------------------

                 Key: IBATIS-423
                 URL: https://issues.apache.org/jira/browse/IBATIS-423
             Project: iBatis for Java
          Issue Type: Bug
          Components: SQL Maps
    Affects Versions: 2.3.0
         Environment: java 1.4, eclipse 3.1, windows
            Reporter: Jamie
            Priority: Minor
             Fix For: 2.3.0


The following:

  <insert id="insert" parameterClass="java.util.Map">
    insert into view (name, version_id, template_id, model, strings, 
strings_name, secure, admin)
    select #view.name:VARCHAR#, version_id, id as template_id, 
#view.model:VARCHAR#, #view.strings#VARCHAR#, #view.strings_name:VARCHAR#, 
#view.secure:INTEGER#, #view.admin:INTEGER#
    from view_template where version_id = #versionId:INTEGER# and name = 
#view.templateName#
  </insert>

and:

                        Map params = new HashMap();
                        params.put("versionId", version.getId());
                        params.put("view", view);
                        sqlMap.insert("View.insert", params);

causes:

com.ibatis.sqlmap.client.SqlMapException: Incorrect inline parameter map format 
(missmatched name=value pairs): 
    from view_template where version_id = 
        at 
com.ibatis.sqlmap.engine.mapping.parameter.InlineParameterMapParser.newParseMapping(InlineParameterMapParser.java:129)
        at 
com.ibatis.sqlmap.engine.mapping.parameter.InlineParameterMapParser.parseInlineParameterMap(InlineParameterMapParser.java:50)
        at 
com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.parseDynamicTags(SqlStatementParser.java:240)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to