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

Reply via email to