IBatisnet的insert返回主键出错

[m_halfman]

网上查了很多代码，都是这么写的

<!- Microsoft SQL Server ->
<insert id="insertProduct-MS-SQL" parameterClass="com.domain.Product">
insert into PRODUCT (PRD_DESCRIPTION) values (#description#)
<selectKey resultClass="int" keyProperty="id" >
SELECT @@IDENTITY AS ID
</selectKey>
</insert>

我这么写却出错，错误是：
- The error occurred while loading SqlMap.
- loading insert tag
- The error occurred in <sqlMap resource="maps/HotelAuditLock.xml" xmlns="http://ibatis.apache.org/dataMapper" />. at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean isCallFromDao)

我想是不是因为这是java的写法？那么.net的写法呢？望赐教

[vrhero]

map文件就是这样的...跟java,.net没关系...

出错说明你map配置不对...原因就说不清楚了...比如

1.parameterClass指定的com.domain.Product找不到...
2.com.domain.Product没有description属性...
3.com.domain.Product没有id属性...

都会报这个错...

[m_halfman]

是<selectKey>段的问题，我去掉这部分就好了。

我的字段名是LockId，这么写有问题吗？在parameterClass里已定义。
<selectKey resultClass="int" keyProperty="LockId">
SELECT @@IDENTITY AS ID
</selectKey>

[vrhero]

keyProperty指定的id必须和你parameterClass中对应的id一致...整个map文件都是这样...所有的id都必须匹配...

[m_halfman]

parameterClass里已经定义了LockId
SELECT @@IDENTITY AS ID这句呢？要把ID或IDENTITY改成LockId吗？

[vrhero]

SELECT @@IDENTITY AS VALUE
---------------
Value和#Value#有特别的含义...去它的官方网站下载个文档多看看...

[m_halfman]

搞不定啊，郁闷了。
<selectKey resultClass="int" keyProperty="LockId">
SELECT @@IDENTITY AS VALUE
</selectKey>

- The error occurred while loading SqlMap.
- loading insert tag
- The error occurred in <sqlMap resource="maps/HotelAuditLock.xml" xmlns="http://ibatis.apache.org/dataMapper" />. at IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean isCallFromDao)

[CSDNCFO]

mark

[WIKESOFT]

 public int InsertAttachment(AttachmentEntity entity)
        {
            int ret=1;
            ret = Mapper.Instance.QueryForObject<int>("GetKeyAfterInsertAttachment", entity);
            return ret;
        }

 <select id="GetKeyAfterInsertAttachment" parameterClass="Attachment" resultClass="int">

      insert into [E_Attachment](TypeID,AttachmentName,Path,TrueName,Userid,Remark,CreateTime) values (#TypeID#,#AttachmentName#,#Path#,#TrueName#,#Userid#,#Remark#,#CreateTime#)
      SELECT SCOPE_IDENTITY() AS AttachmentID
    </select>