Auto generated id not working for annotation param

[Rahul Mondal]

Hello friends,

can we use ?

     public static final String CREATE_USER_SESSION = "INSERT INTO int_session(user_id,ip_addr,start_tm) values(#{username},#{ip},now())";
   
    @Insert(CREATE_USER_SESSION)
    @Options(keyColumn="id",keyProperty="sessionNo",useGeneratedKeys=true)
    public int createUserSession(@Param("sessionNo") String sessionNo,@Param("username") String userCode,@Param("ip") String ip);

because it does not put generated value in param "sessionNo".
Please Help!!

--
Thank You
Rahul Mondal

[Frank Martínez]

Are you kidding right? Do you know that java method arguments are
passed by value?

You must pass an object with a sessionNo property if you want it to be assigned.

On Tue, Apr 17, 2012 at 11:21 PM, Rahul Mondal <[hidden email]> wrote:

> Hello friends,
>
> can we use ?
>
>      public static final String CREATE_USER_SESSION = "INSERT INTO
> int_session(user_id,ip_addr,start_tm) values(#{username},#{ip},now())";
>
>     @Insert(CREATE_USER_SESSION)
>     @Options(keyColumn="id",keyProperty="sessionNo",useGeneratedKeys=true)
>     public int createUserSession(@Param("sessionNo") String
> sessionNo,@Param("username") String userCode,@Param("ip") String ip);
>
> because it does not put generated value in param "sessionNo".
> Please Help!!
>
> --
> Thank You
> Rahul Mondal
>

--
Frank D. Martínez M.