hi,
I am not able to understand if the key are not
mapped , how is it working for you.
Can anyone give an example done in Oracle for this
kind of situation.
--- Christian Möller <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I myself are using this kind of iBATIS config with a
> Sybase DB:
>
> <insert id="insertContact"
> parameterClass="contact">
> insert into CONTACT (PROP1, ...) values
> (#property1#, ...)
> <selectKey resultClass="long" type="post">
> select @@IDENTITY
> </selectKey>
> </insert>
>
> "@@IDENTITY" is the Sybase way to retrieve the
> auto-incremented value of
> the primary key column.
>
> As you can see: There is no mapping of the resulting
> key to a property
> of the parameter class. I'm retrieving the
> auto-incremented key by
> executing
>
> Long generatedKey = (Long)
> sqlMapClient.insert("insertContact", contact)
>
> Hope this will guide you to a working solution.
>
> Greetings
>
> Christian
>
5, 50, 500, 5000. Store N number of mails in your inbox. Go to
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html