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
