Why ConstraintViolationException is generated?

[prakash. rajeev]

Hi all,


I am getting the following exception in my project while inserting the data to the database.I am using Struts1 with Hibernate (but no spring ) with Oracle and my connection is established but following error is coming in my Tomcat Console.

The error is like this:

 
before getting session factory
Inserting record
abc
abc
[e-mail]
user
null
DEV
Hibernate:insert into USER(USER_NAME,PASSWORD,EMAIL_ID,AUTHORITY_ROLE,STREAM,STATUS,USER_ID) values (?,?,?,?,?,?,?)

org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

   

My Bean class is like this:

  

package e.task;

public class AddUserBean {

	private long userid;
	private String uname;
	private String usrpwd;
	private String usremail;
	private String role;
	private String stream;
	private String status;
	
	
	
	
	
	public long getUserid() {
		return userid;
	}
	public void setUserid(long userid) {
		this.userid = userid;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUsrpwd() {
		return usrpwd;
	}
	public void setUsrpwd(String usrpwd) {
		this.usrpwd = usrpwd;
	}
	public String getUsremail() {
		return usremail;
	}
	public void setUsremail(String usremail) {
		this.usremail = usremail;
	}
	public String getRole() {
		return role;
	}
	public void setRole(String role) {
		this.role = role;
	}
	public String getStream() {
		return stream;
	}
	public void setStream(String stream) {
		this.stream = stream;
	}
	public String getStatus() {
		return status;
	}
	public void setStatus(String status) {
		this.status = status;
	}
	
	
}


  

My hbm.xml file is:

   

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="e.task.AddUserBean" table="ET_USER">

<id name="userid" type="long" >
<column name="USER_ID" unique="true"/>
<generator class="increment"/>

</id>

<property name="uname">
<column name="USER_NAME" />
</property>

<property name="usrpwd"> 
<column name="PASSWORD" />
</property>

<property name="usremail">
<column name="EMAIL_ID"  />
</property>

<property name="role">
<column name="AUTHORITY_ROLE" />
</property>

<property name="stream"> 
<column name="STREAM" />
</property>

<property name="status">
<column name="STATUS"/>
</property>



</class> 
</hibernate-mapping>



 

And My Action class in Struts is:

   

package e.task;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.Transaction;
import org.hibernate.exception.*;


public class AddUserAction extends Action {
	

	public ActionForward execute(ActionMapping mapping,ActionForm form,
             HttpServletRequest request,HttpServletResponse response) throws Exception
  {
	  
		 
		 AddUserForm addUserForm =(AddUserForm) form; 
		 
		 Session session=null;
			
				System.out.println("before getting session factory");
				SessionFactory sessionFactory = new  Configuration().configure().buildSessionFactory();
				session = sessionFactory.openSession();
				
				   System.out.println("Inserting record");
				AddUserBean addUser = new AddUserBean();
				
			    addUser.setUname(addUserForm.getUname());
			    addUser.setUsrpwd(addUserForm.getUsrpwd());
			    addUser.setUsremail(addUserForm.getUsremail());
			    addUser.setStream(addUserForm.getStream());
			    addUser.setStatus(addUserForm.getStatus());
			    addUser.setRole(addUserForm.getRole());
			     
			    System.out.println(addUser.getUname());
			    System.out.println(addUser.getUsrpwd());
			    System.out.println(addUser.getUsremail());
			    System.out.println(addUser.getRole());
			    System.out.println(addUser.getStatus());
			    System.out.println(addUser.getStream());
			    
			   
			    Transaction tr = session.beginTransaction();
			    
			    try
				{
			    
			    session.save(addUser);
			    session.flush();
			    tr.commit();
			    System.out.println("Done");
			    
			    System.out.println("Retrieving data from database: \n");
			    addUser = (AddUserBean) session.createQuery("from ET_USER").list();
			    
			   
			}catch(ConstraintViolationException cve)
			{
				if(tr!=null)
				{
					tr.rollback();
				}
				cve.printStackTrace();
			}
		   finally
		   {
			   session.close();
		   }

			
			
			
	      return mapping.findForward("success");

}
	
	

}




 

Any help in solving this is highly appreciable.

[Christian Dillinger]

"increment" does not work with Oracle.

[prakash. rajeev]

Which <generater-class> (in hbm.xml) file is suitable for Oracle.

[Christian Dillinger]

http://www.roseindia.net/hibernate/hibernateidgeneratorelement.shtml

We always take a sequence because we also have triggers that create IDs when needed.