Return-Path: 
 <user-java-return-9779-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 95043 invoked from network); 14 Nov 2006 09:15:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 14 Nov 2006 09:15:18 -0000
Received: (qmail 41911 invoked by uid 500); 14 Nov 2006 09:15:16 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 41866 invoked by uid 500); 14 Nov 2006 09:15:16 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 41823 invoked by uid 99); 14 Nov 2006 09:15:14 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Nov 2006 01:15:14 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates
 72.21.53.35 as permitted sender)
Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Nov 2006 01:15:00 -0800
Received: from [72.21.53.38] (helo=jubjub.nabble.com)
	by talk.nabble.com with esmtp (Exim 4.50)
	id 1GjuNM-0007DK-4H
	for user-java@ibatis.apache.org; Tue, 14 Nov 2006 01:14:40 -0800
Message-ID: <7333890.post@talk.nabble.com>
Date: Tue, 14 Nov 2006 01:14:40 -0800 (PST)
From: Carfield Yim <carfield@carfield.com.hk>
To: user-java@ibatis.apache.org
Subject: Can I use resultMap for insert?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: carfield@carfield.com.hk
X-Virus-Checked: Checked by ClamAV on apache.org


We've already create a resultMap for select data from database. However we
need to retype everything for insert query, like 

<insert id="insertProduct-ORACLE-type-specified"
parameterClass="com.domain.Product">
       insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
       values  (#id#,#description#)
      <selectKey resultClass="int" type="pre" >
              SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
      </selectKey>
</insert>

Can I reuse resultMap so that I can have something like 

<insert id="insertProduct-ORACLE-type-specified" resultMap="productResult"
parameterClass="com.domain.Product">
       insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
       values  (?,?)
      <selectKey resultClass="int" type="pre" >
              SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
      </selectKey>
</insert>

And then ibatis will help me to field suitable attribute from object to SQL
parameters?
-- 
View this message in context: http://www.nabble.com/Can-I-use-resultMap-for-insert--tf2628161.html#a7333890
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.