The order of selectKey tag is important. Below is right, but if selectKey tag located just after insert tag, it can out get index id.
<insert id="insertUserDefinedURLData" parameterClass="UserDefinedURLData">
INSERT INTO userdefine_url
(projectname, url, expected, charset, sms, mail, name, companyID, precallURL)
VALUES
(#projectName#, #url#, #expected#, #charset#, #sms#, #mail#, #name#, #companyID#, #precallURL#)
<selectKey keyProperty="id" resultClass="int">
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
'Web service' 카테고리의 다른 글
[Java script] How to glue two forms (0) | 2009.06.23 |
---|---|
How to support UTF-8 URIEncoding with Tomcat (0) | 2009.06.15 |
Weakness of Java Web Start (0) | 2009.04.27 |
JDBC THIN DRIVER 사용시 CONNECT TIME FAIL-OVER를 고찰(TAF, 오라클 DB failover) (0) | 2009.04.10 |
<img src="http://blogimgs.naver.com/nblog/ico_scrap01.gif" class="i_scrap" width="50" height="15" alt="본문스크랩" /> 내 Custum Tags 에서 EL을 지원하게 하기~ (0) | 2007.06.08 |