Check record if it exist before persisting to database

Question

I made the username as PRIMARY KEY in the database. Creating new account with the same username that is already in the database cause this error:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'someuser' for key 'PRIMARY'

What is the best way to work around this problem?

I tried this approach:

        Query query = session.createQuery("from Account where name= :name");
        query.setParameter("name", user.getUsername());
        List<Account> result = query.list();

        if (!result.isEmpty()) {
            log.debug("User already exist"); 
        }

However log is not triggered even if record exist in database.

score 1 · Accepted Answer · answered Dec 20 '11 at 10:36

1

Try this one

 String hql = "from Account where name=?";

 List <Account> recordList= session.createQuery(hql).setString(0,"xybrek").list(); 

 if(recordList!=null && recordList.size>0)

  { 

      log.debug("User already exist");

  }

answered Dec 20 '11 at 10:36

subodh

6,136
12
51
73

score 0 · Answer 2 · edited May 23 '17 at 10:34

0

Well, wont using INSERT IGNORE aid in solving this kind of problem..? "INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

edited May 23 '17 at 10:34

Community

1
1

answered Dec 20 '11 at 07:15

Sudhir Bastakoti

99,167
15
158
162

Check record if it exist before persisting to database

2 Answers2