Java Mybatis multiple update statements

Question

Java Mybatis Oracle

I have following mybatis statement in xml file

<update id="updateOfferIndex" parameterType="java.util.List">
   <foreach collection="list" item="offer"  index="index"  separator=";" >
        UPDATE  offer set indx=#{offer.idx} WHERE id=#{offer.eId}
    </foreach>

I am getting following error, can any one help ?

### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

### The error may involve com.dao.linear.upsell.LinearUpsellDao.updateOfferIndex-Inline
### The error occurred while setting parameters
### SQL: UPDATE  offer set indx=? WHERE id=?   ;       UPDATE  offer set indx=? WHERE id=?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

how does this call looks like in java? I thought it is not possible to call multiple statements with one execute. — nano_nano
– nano_nano, Commented Oct 27, 2015 at 15:50

Maforast · Accepted Answer · 2017-11-30 09:45:43Z

4

I resolve by insert BEGIN-END statements in this way:

BEGIN
<foreach collection="list" item="offer"  index="index"  separator=";" >
        UPDATE  offer set indx=#{offer.idx} WHERE id=#{offer.eId}
</foreach>;
END;

I hope this resolves.

answered Nov 30, 2017 at 9:45

Maforast

3971 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Felix Gerber · Accepted Answer · 2015-12-17 08:45:52Z

2

Looks like the last semicolon has not been appended:

    ### SQL: UPDATE  offer set indx=? WHERE id=?;       
    UPDATE  offer set indx=? WHERE id=?;

And this is coherent with the mybatis documentation about the foreach's separator:

The element is smart in that it won’t accidentally append extra separators.

Try adding a semicolon to the XML mapping:

  <foreach collection="list" item="offer"  index="index"  separator=";" >
        UPDATE  offer set indx=#{offer.idx} WHERE id=#{offer.eId}
  </foreach>
  ;

edited Dec 17, 2015 at 8:45

Felix Gerber

1,6494 gold badges32 silver badges40 bronze badges

answered Dec 17, 2015 at 8:02

s17t.net

1572 silver badges10 bronze badges

Collectives™ on Stack Overflow

Java Mybatis multiple update statements

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related