one to many relation error

[rodrigo bengoechea]

Hi everyone! I�m newbe using Hibernate and I�m trying to figure out where�s my mistake mapping a one-to-may relation. I�ve been the last hours trying to solve it but I couldn�t, so I decided to ask you. Please any suggestion will help me a lot!!

I explain you the bussines logic here:
every user has one or more passwords, and a password can be removed from a user.

I know that my post it�s a quite long but I tried to provide you everything you should need...

So here�s the User class:

package beans;
 
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
 
public class User {
 
private long id;
private String name;
private String sirName;
private String user;
private List passwords;
private String authentication;
private Date registrationDate;
private String email;
private Date lastPasswordUpdate;

public static final int MIN_NUM_UNIQUE_PASSWORDS = 1;
public static final int UNIQUE_PASSWORDS = 3;
public static final String UNIQUE_PASSWORD = "PU";

public User(String name, String sirName, String user, 
String authentication, String password, String email,
Date registrationDate, Date lastPasswordUpdate){

this.name = name;
this.sirName = sirName;
this.user = user;
this.authentication = authentication;
this.email = email;
this.registrationDate = registrationDate;
this.lastPasswordUpdate = lastPasswordUpdate;
this.passwords = new ArrayList();
this.email = email;

this.passwords.add(new Password(password));

}

public User(String name, String sirName, String user,
String email, Date registrationDate, Date lastPasswordUpdate){

this.name = name;
this.sirName = sirName;
this.user = user;
this.lastPasswordUpdate = lastPasswordUpdate;
this.registrationDate = registrationDate;
this.authentication = UNIQUE_PASSWORD;
this.passwords = new ArrayList();
this.email = email;

generatePasswords();
}

public Date getLastPasswordUpdate() {
return lastPasswordUpdate;
}
 
public void setLastPasswordUpdate(Date lastPasswordUpdate) {
this.lastPasswordUpdate = lastPasswordUpdate;
}
 
public User(){
passwords = new ArrayList();
}

public String getEmail() {
return email;
}
 
public void setEmail(String email) {
this.email = email;
}
 
public long getId() {
return id;
}

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

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getSirName() {
return sirName;
}

public void setSirName(String sirname) {
this.sirName = sirname;
}

public String getUser() {
return user;
}

public void setUser(String user) {
this.user = user;
}
 
public String getAuthentication() {
return authentication;
}

public void setAuthentication(String authentication) {
this.authentication = authentication;
}
 
public Date getRegistrationDate() {
return registrationDate;
}
 
public void setRegistrationDate(Date registrationDate) {
this.registrationDate = registrationDate;
}
 
public List getPasswords() {
return passwords;
}
 
public void setPasswords(List passwords) {
this.passwords = passwords;
}

public void setPassword(String password){
Password pass = new Password(password);

passwords.add(pass);
}

public boolean hasPassword(String password){

Iterator it = passwords.iterator();
while(it.hasNext()){
Password pass = (Password)it.next();
if (pass.equals(password))
return true;
}

return false;
}

public void removePassword(String password){

Iterator it = passwords.iterator();
boolean removed = false;
Password passwordToRemove = new Password();

while(it.hasNext() && !removed){
passwordToRemove = (Password)it.next();

if(passwordToRemove.equals(password)){
removed = true;
}
}

passwords.remove(passwordToRemove);
}

private void generatePasswords(){

for(int i = 0; i < UNIQUE_PASSWORDS; i++){
Password newPassword = new Password(generateRandomPassword());
passwords.add(newPassword);
}

}

private String generateRandomPassword(){

String ret = "";

for(int i = 0; i < Password.STANDARD_LENGTH; i++){
double randomNumber = Math.random();
double randomNumberSetup = (randomNumber * 26 + 'a');
ret += (char) randomNumberSetup;
}

return ret;
}
}

Here the Password class

 package beans;
 
public class Password {
 
private String value;
private long id;

public static final int STANDARD_LENGTH = 8;

public Password(String value){
this.value = value;
}

public Password(){
}
 
public long getId() {
return id;
}
 
public void setId(long id) {
this.id = id;
}
 
public String getValue() {
return value;
}
 
public void setValue(String value) {
this.value = value;
}

public boolean equals(String value){
return this.value.equals(value);
}

public boolean equals(Password password){
return this.value.equals(password.value);
}

}

Here the User mapping xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
  <class name="beans.User" table="User"> 
    <id name="id" type="long" column="id" unsaved-value="0">
      <generator class="increment"/>
    </id>    
    <list name="passwords" cascade="all">
    <key column="user_id"/>
    <index column="id"/>
    <one-to-many class="beans.Password"/>
    </list>        
    <property name="name" type="string" column="name"/>    
    <property name="sirName" type="string" column="sir_name"/>
    <property name="user" type="string" column="user"/>
    <property name="authentication" type="string" column="authentication"/>
    <property name="email" type="string" column="email"/>
    <property name="registrationDate" type="date" column="registration_date"/>
    <property name="lastPasswordUpdate" type="date" column="last_pass_update"/>
  </class>
  
    <class name="beans.Password" table="Password">
    <id name="id" type="long" column="id" unsaved-value="0">
      <generator class="increment"/>
    </id>
    <property name="value" type="string" column="value"/>
    <!-- <many-to-one name="User" column="user_id" not-null="true"/>  -->  
  </class>
  
</hibernate-mapping>

Here�s the hibernate config:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration> 
  <session-factory>
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
    <!--  JDBC connection pool (use the built-in) -->
    <property name="connection.pool_size">10</property>
    <!--  Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property>
    <!--  Drop and re-create the database schema on startup -->
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">admin</property>
    <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
    <property name="hibernate.hbm2ddl.auto">create</property>
    <!--  <property name="hibernate.c3p0.max_size">3</property>-->
    <!--<property name="hibernate.c3p0.min_size">1</property>-->
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost/gruposweb</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    
    <property name="show_sql">true</property>
    <property name="format_sql">true</property>
    
    <mapping resource="beans/User.hbm.xml"/>
    <!-- <mapping resource="beans/Password.hbm.xml"/>  -->
  </session-factory>
</hibernate-configuration>

Here where I�m creating the user:

 
public int registerUser(String userName, String name, String sir, String password, Date date, String email, String authentication){
try{
Session session = HibernateFactory.getSessionFactory().openSession();
Transaction tx = (Transaction) session.beginTransaction();
User user;

if(authentication.equals(User.UNIQUE_PASSWORD)){
[B]user = new User(name, sir, userName, email, date, date);[/B]
}
else{
user = new User(name, sir, userName, authentication, password, email, date, date);
}

session.save(user);

tx.commit();
session.flush();
session.close();
}
catch (Exception e) {
e.printStackTrace();
return 1;
}

return 0;
}

And finally here�s the stack trace:

22:58:39,781 INFO  [STDOUT] 22:58:39,781 WARN  [JDBCExceptionReporter] SQL Error: 1062, SQLState: 23000
22:58:39,781 INFO  [STDOUT] 22:58:39,781 ERROR [JDBCExceptionReporter] Duplicate entry '2' for key 1
22:58:39,781 INFO  [STDOUT] 22:58:39,781 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)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:143)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at dao.UserDAOImpl.registerUser(UserDAOImpl.java:32)
at services.ServiceImpl.registerUser(ServiceImpl.java:15)
at action.register.RegisterAction.execute(RegisterAction.java:53)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Duplicate entry '2' for key 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 34 more
22:58:39,781 ERROR [STDERR] 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)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:143)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at dao.UserDAOImpl.registerUser(UserDAOImpl.java:32)
at services.ServiceImpl.registerUser(ServiceImpl.java:15)
at action.register.RegisterAction.execute(RegisterAction.java:53)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Duplicate entry '2' for key 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 34 more
22:58:39,796 ERROR [STDERR] Sat Nov 22 22:58:39 ART 2008 WARN: Invalid value {1} for server variable named {0}, falling back to sane default of {2}.

Thanks in advance for your help!!!
Regards!!!

[joe sinnott]

Hi

At first glance it would seem that you are violating some database contraint.

Caused by: java.sql.BatchUpdateException: Duplicate entry '2' for key 1

It would appear that you are inserting into a table that already has a key value i.e. '2'