hi
here this is code for new user loggin, when we enter already exists user id , then system dispalyed the erorr page.( Primary key is user id)

but when we add a new user details the system does display following erorr, but data has been inserted to the database.


19:34:45,510 INFO SessionFactoryImpl:118 - building session factory
id is testtest
password is dqwd
19:34:45,525 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
id is testtest
email is wdqwdqwdqwd
users size is []
users list size are0
password is dqwd
email is wdqwdqwdqwd
users size is []
users list size are0
19:34:45,541 WARN JDBCExceptionReporter:38 - SQL Error: 1062, SQLState: S1009
19:34:45,541 ERROR JDBCExceptionReporter:46 - Invalid argument value: Duplicate
entry 'testtest' for key 1
19:34:45,541 WARN JDBCExceptionReporter:38 - SQL Error: 1062, SQLState: S1009
19:34:45,557 ERROR JDBCExceptionReporter:46 - Invalid argument value: Duplicate
entry 'testtest' for key 1
19:34:45,557 ERROR JDBCExceptionReporter:38 - Could not execute JDBC batch update


package test.hibernate.actions;

import java.util.List;
import java.util.Iterator;

import webwork.action.ActionSupport;
import webwork.action.CommandDriven;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.HibernateException;
import test.hibernate.util.SessionManager;
import test.hibernate.data.User;


public class NewUserlog extends ActionSupport implements CommandDriven {
private String id;
private String pword;
private String email;
private List users;
String checklogin;

public List getUsers() {
return users;
}

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getPword() {
return pword;
}

public void setPword(String pword) {
this.pword =pword;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}


public String doExecute() {
try {


Configuration cfg=new Configuration().addClass(test.hibernate.data.User.class);



SessionFactory sf=cfg.buildSessionFactory();
Session sess=sf.openSession();
users = sess.find("select u from u in class test.hibernate.data.User"
+" where u.id='"+ id +"'");


System.out.println( " id is " + id);
System.out.println( " password is " + pword);
System.out.println( " email is " + email);
System.out.println( " users size is " + users);
System.out.println(" users list size are"+ users.size());

if(users.size() == 0 || users.equals("")){

User event = new User();
event.setId(id);
event.setPassword(pword);
event.setEmail(email);

sess.save(event);
sess.flush();
sess.close();
checklogin="SUCCESS";
return SUCCESS;
}


else if(users!=null || !users.equals("")){
System.out.println(" error in logging");
checklogin="

;
return ERROR;

}

sess.flush();
sess.close();

System.out.println(" check login value is "+ checklogin);
return checklogin;


} catch (HibernateException e) {
e.printStackTrace();
System.out.println(" exception value is "+ e);
return ERROR;
}
}
public String doEnter() {
return INPUT;
}

}