Mysql updating user password

Question

I am trying update password for database using mybatis:

update person 
   set name = #{name}, 
       address = #{address}, 
       phoneNumber = #{phoneNumber},
       balance = #{balance}, 
       password = #{password}, 
       id = #{new_id} 
 where id = #{id}

However, got following exception:

org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be null
### The error may involve com.lsp.mybatis.PersonMapper.update-Inline
### The error occurred while setting parameters
### SQL: update person set name = ?, address = ?, phoneNumber = ?             ,balance = ?, password = ?, id = ? where id = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be null

I have specified the user id I want to update. Why is it saying "id cannot be null"?

Can someone tell me what I did do wrong?

Do you want to update ID or password?

Smit
– Smit

2013-11-22 21:46:25 +00:00
Commented Nov 22, 2013 at 21:46 — Smit
– Smit, Commented Nov 22, 2013 at 21:46

Paul Vargas · Accepted Answer · 2013-11-25 13:32:38Z

2

Remove in the query: id = #{new_id}.

So, the query will be:

update person 
   set name = #{name}, 
       address = #{address}, 
       phoneNumber = #{phoneNumber},
       balance = #{balance}, 
       password = #{password}
 where id = #{id}

edited Nov 25, 2013 at 13:32

answered Nov 23, 2013 at 22:54

Paul Vargas

42.2k16 gold badges108 silver badges148 bronze badges

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

Collectives™ on Stack Overflow

Mysql updating user password

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related