ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Folashade Adeyosoye" <sharda...@gmail.com>
Subject Multiple selectKey in Oracle
Date Tue, 21 Mar 2006 18:41:38 GMT
Has anyone got this to work for them. I find out that the second selectKey
does not not work too well


<insert id="taskName" parameterClass="objectName">
    <selectKey keyProperty="col1">
          select seq_one from dual
    </selectKey>
    <selectKey keyProperty="col2">
          select seq_two from dual
    </selectKey>

    insert into TABLE_NAME (column1, column2, column3) values (#col1#,
#col2#, #col3#)
</insert>

Mime
View raw message