You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Jamie (JIRA)" <ib...@incubator.apache.org> on 2007/05/01 22:56:15 UTC
[jira] Closed: (IBATIS-423) "insert into .. select .. " causes
exception
[ 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.