ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: Insert Statement.
Date Mon, 14 Jul 2008 13:54:26 GMT
Are you calling insert() or update()?

Larry

On Mon, Jul 14, 2008 at 7:27 AM, kiran vuppla
<kirankumar_vuppla@yahoo.com> wrote:
> 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