[ https://issues.apache.org/jira/browse/IBATIS-423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jamie closed IBATIS-423. ------------------------ Resolution: Fixed Ignore me - I had an extra # char earlier in the statement (#view.strings#VARCHAR#) and that was messing up the parsing of the rest of the statement. There is no iBATIS bug here (unless you count misleading parsing errors), so closing. > "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.