"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.