Search code examples
ibatismybatis

mybatis update is not working


I'm using mybatis for the update and query doesn't update the table: can any one help me whats going wrong

configuration

    <update id="updateInfo" parameterType="int" timeout="20">
        UPDATE RULE_DETAILS
        SET state=0
        WHERE severity ='info'
        and cfg_id=#{cfg_id}   
    </update

calling

session.selectList("updateInfo",  cfg_id);  

and log also shows

DEBUG java.sql.PreparedStatement - ==>  Executing: UPDATE RULE_DETAILS SET state=0 WHERE severity ='warning' and cfg_id=? 

DEBUG java.sql.PreparedStatement - ==> Parameters: 2572(Integer)

but database is not updated with this data. can any one please help me..


Solution

  • Use session.update() but not session.selectList().