ibatis配置selectKey报错！！

cbaba 2012-07-05 11:19:57

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap      

    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      

    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap>

<!-- 取别名 -->

	<typeAlias alias="user" type="com.broada.coss.usermamt.entity.User"/>



	<select id="findAllUser" resultClass="user">

		<![CDATA[ select * from t_user ]]>

	</select>

	<select id="findUserById" parameterClass="int" resultClass="user">

		select * from t_user where id=#id#

	</select>

	<insert id="insertUser" parameterClass="user">

		<selectKey keyProperty="id" resultClass="int" type="pre">

			 <![CDATA[

			 SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL

			 ]]>

		</selectKey>

		<![CDATA[

			insert into t_user(id,name,birthday,address,salary) values(#id#,#name#,#birthday#,#address#,#salary#)

		]]>

	</insert>

	<update id="updateUser" parameterClass="user">

		update t_user set name=#name#,birthday=#birthday#,address=#address#,salary=#salary# where id=#id#

	</update>

	<delete id="deleteUser" parameterClass="int">

		delete from t_user where id=#id#

	</delete>

</sqlMap>

报的错误是
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowNo' defined in class path resource [test-appContext-common.xml]: Cannot create inner bean 'com.broada.itil.common.flowno.dao.ibatis.IbatisFlowNoDao#1fcf0ce' of type [com.broada.itil.common.flowno.dao.ibatis.IbatisFlowNoDao] while setting bean property 'flowNoDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.broada.itil.common.flowno.dao.ibatis.IbatisFlowNoDao#1fcf0ce' defined in class path resource [test-appContext-common.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in class path resource [test-daoContext-common.xml]: Invocation of init method failed; nested exception is com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "select" must be declared.
Caused by: org.xml.sax.SAXParseException: Element type "select" must be declared.
Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'versionDao' defined in class path resource [test-daoContext-common.xml]: Unsatisfied dependency expressed through constructor argument with index 1 of type [boolean]: Ambiguous constructor argument types - did you specify the correct bean references as constructor arguments?
Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'versionManager' defined in class path resource [test-daoContext-common.xml]: Unsatisfied dependency expressed through constructor argument with index 5 of type [java.lang.String]: Could not convert constructor argument value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: Failed to convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]; nested exception is java.lang.IllegalArgumentException: Cannot convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: no matching editors or conversion strategy found
Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'versionManager' defined in class path resource [test-daoContext-common.xml]: Unsatisfied dependency expressed through constructor argument with index 5 of type [java.lang.String]: Could not convert constructor argument value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: Failed to convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]; nested exception is java.lang.IllegalArgumentException: Cannot convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: no matching editors or conversion strategy found
Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'versionDao' defined in class path resource [test-daoContext-common.xml]: Unsatisfied dependency expressed through constructor argument with index 1 of type [boolean]: Ambiguous constructor argument types - did you specify the correct bean references as constructor arguments?
Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'versionManager' defined in class path resource [test-daoContext-common.xml]: Unsatisfied dependency expressed through constructor argument with index 5 of type [java.lang.String]: Could not convert constructor argument value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: Failed to convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]; nested exception is java.lang.IllegalArgumentException: Cannot convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: no matching editors or conversion strategy found
Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'versionManager' defined in class path resource [test-daoContext-common.xml]: Unsatisfied dependency expressed through constructor argument with index 5 of type [java.lang.String]: Could not convert constructor argument value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: Failed to convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]; nested exception is java.lang.IllegalArgumentException: Cannot convert value of type [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy] to required type [java.lang.String]: no matching editors or conversion strategy found

...全文

496 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

自古多情空余恨 2012-07-06

打赏
举报



<insert id="insertUser" parameterClass="user"

        <![CDATA[

            insert into t_user(id,name,birthday,address,salary) values( STOCKIDSEQUENCE.NEXTVAL ,#name#,#birthday#,#address#,#salary#)

        ]]>

    </insert>

昨天研究了一下，改成这个样子就OK 了
但是还是不知道为什么。

.... 这个问题还得自己结..

cbaba 2012-07-05

打赏
举报

如果把
<selectKey keyProperty="id" resultClass="int" type="pre">
<![CDATA[
SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
]]>
</selectKey>
这一句删除掉就不会报错为什么啊 ~~！！！！！！！菜鸟求真相

Spring Spring是一个开源框架，Spring是...MyBatis 使用简单的 XML或注解用于配置和原始映射，将接口和 Java 的POJOs（Plain Old Java Objects，普通的 Java对象）映射成数据库中的记录。

1）如果要使用selectKey提前自动生成字段ID，就在mapper interface方法定义中，如果使用@param。就需要在使用insert语句中，通过@param指定的名称来方位bean的属性；如果不使用@param就可以省去名称。2）使用selectKey获取多列数据时，千万不要在keyProperty中的列之间加空格（一般处于编码习惯，都会自然而然的加一个空格）。就这个例子来说，不使用@param会更简洁。然后代码就能够正常运行了。

ibatis insert语句的用法及selectKey的使用 2013-08-24 12:41:07| 分类： ibatis | 标签：insert ibatis |举报|字号订阅下载LOFTER客户端在Ibatis中，insert(

1.Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.mtsbw.ma.wms.newErp.dao.productWeight.IAddProdWeightDaogetIdByNum解决方法...

其实就是相为SHIPMENT_HISTORY表加入一个主键sequence idshipmentHistoryId,加入一条记录，然后返回这个sequence id xml 代码 <insertid="abatorgenerated_insert"parameterClass="cn.hot.delivery.domain.ShipHistory"> ...