ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jaybytez <jayby...@gmail.com>
Subject Re: selectKey and parameterMap issue
Date Thu, 17 Aug 2006 15:00:05 GMT

If I do the following...I get an exception from Oracle...

(java.sql.SQLException: ORA-00911: invalid character)

    <insert id="insertHBAContact"
        <selectKey resultClass="long" keyProperty="id">
                SELECT hba_contact_seq.NEXTVAL FROM DUAL
            INSERT INTO hba_contact_hbc
                ( hbc_contact_id, hbc_tsc_name, hbc_contact_name,
                  hbc_issue_resolved_ind, hbc_follow_up_required_ind,
                  hbc_follow_up_required_desc, hbc_contact_type_desc,
                  hbc_reason_desc, hbc_fk_contact_type_id,
                  hbc_fk_contact_reason_id )
            VALUES (#id#, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

I am trying to figure out what the keyProperty really stands for.  Is it a
property that is in your parameterMap...or do you map it directly to the
name of the column for which it is going to be used for?


View this message in context: http://www.nabble.com/selectKey-and-parameterMap-issue-tf2118776.html#a5852855
Sent from the iBATIS - User - Java forum at Nabble.com.

View raw message