Hi,

I have to insert a new record using 2 sequences values (oracle).
So my code is :

        <insert id="INSERT_SESSION_HTTP_COOKIE"  parameterClass="mypackage.commun.dataobject.DoSessionHttp">
                <selectKey resultClass="int" keyProperty="codesession">
                        select SQ_CODE_SESSION.nextval AS CODESESSION from dual
                </selectKey>
                <selectKey resultClass="string" keyProperty="codecookie">
                        select SQ_CODE_COOKIE.nextval AS CODECOOKIE from dual
                </selectKey>
                insert into SESSION_HTTP (codeSession, codeCookie, numClient)
                values (#codesession#, #codecookie#, #numclient#)
        </insert>

But the problem is that the second selectkey isn't executing. Why ? Is it a limitation of ibatis ?

How can i solve my problem ?

Thanks for your help.

G.D.

Reply via email to