[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - ERROR: duplicate key violates unique constraint

[vivekmk2006]

Hi all,

     I am trying to execute the bellow code,
  
   private boolean isUserNameExist(){
	Users users = getInstance();
	String qry = "from Users where userName=:userName AND tenantId =:tenantId";
	Query query = entityManager.createQuery(qry);
	query.setParameter("userName",users.getUserName()).
	      setParameter("tenantId", users.getTenantId());
	List lst =query.getResultList();
	
	return lst.size() > 0 ? true : false;
  }


  but i am getting an entirely different exception like bellow.The exception is throwing at  "List lst =query.getResultList(); " . 

 11:22:54,328 ERROR [JDBCExceptionReporter] ERROR: duplicate key violates unique constraint "ad_users_u2"
11:22:54,328 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  
 
Can anybody can help me to fix it.

Thanks in advance 
vivek


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4166302#4166302

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4166302