ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kiran vuppla <kirankumar_vup...@yahoo.com>
Subject Insert Statement.
Date Mon, 14 Jul 2008 13:27:29 GMT
Hi,
  I am having a insert statement and in which I am trying to insert values that I recieve
from <selectKey> result. But I see that it is not inserting the value. Please let me
know if it is correct way to do it?
 
In the below It is inserting null values for "#date#" which I get from <selectKey> statement.
 
<insert id="insertValues" parameterClass="Session">
<selectKey resultClass="java.sql.Date" type="pre"  keyProperty="date">
  select sysdate from dual
</selectKey>
 insert into SessionTbl (name, date, address, city, zip) values (#name#, #date#, #address#,
#city#, #zip#)
</insert>
 
Thanks
KV


      
Mime
View raw message