java.sql.BatchUpdateException: Duplicate entry

[Kris Reid]

OK this exception should speak for itself but.....

I'm using struts2 and hibernate together.
I've got in my JSP an iterator that calls the get method that returns a Set.

Before the Set is being returned I've tested what is in the Set and there are what I expect a unique set.
I don't even understand what is forcing the update. All the action is meant to do is display a Set of data from the database.

Any ideas??

  

SEVERE: Servlet.service() for servlet default threw exception
java.sql.BatchUpdateException: Duplicate entry 'GC Boys' for key 2
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
	at filter.SessionFilter.doFilter(SessionFilter.java:42)
	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:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Unknown Source)
20/05/2009 16:33:59 org.apache.catalina.core.StandardHostValve custom
SEVERE: Exception Processing ErrorPage[exceptionType=java.lang.Exception, location=/error.jsp]
java.lang.IllegalStateException
	at org.apache.coyote.Response.reset(Response.java:297)
	at org.apache.catalina.connector.Response.reset(Response.java:658)
	at org.apache.catalina.connector.Response.reset(Response.java:925)
	at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:417)
	at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Unknown Source)

  

[Rahul Babbar]

Kris Reid wrote:
I don't even understand what is forcing the update. All the action is meant to do is display a Set of data from the database.

So, you are not even expecting an update to happen when it is updating..

Are you trying to load the entities from a session where you have other entities already added or updated?

Could you post your code?

It could be because of the following.
I think, in a session, if you try to do a load some entities from the database, if some of those entities are already changed in your same session, hibernate will first do a flush and then load the entities.

This is to make sure that it gets the latest entities..

[Kris Reid]

Because I'm using struts there are two methods

The first is the action which determines which set to get

  

public String displayAll() {
     alliances = new TreeSet<Alliance>(dao.findAll());

     for (Alliance alliance : alliances) {
         System.out.println("a " + alliance.getName());
     }

     return SUCCESS;
}

  

And then the one called from the JSP to display the results of that set.
The println is just there to show me that the right stuff is in the set

  
	public Set<Alliance> getAlliances() {
		for (Alliance alliance : alliances) {
			System.out.println("Name " + alliance.getId() + " " + alliance.getRank() + " " + alliance.getName());
		}
		return alliances;
	}
 

Both println print the same set. Which is what is in the database

[Kris Reid]

As this update is being called explicitly how can I find out what is making it fire?
I have several actions just like this. They all look the same but this is the only one doing a update

[Rahul Babbar]

You must be doing this inside some Hibernate session and inside a transaction.
Where are the transaction boundaries.

[Kris Reid]

4 hours later here is lesson to keep damn logic out of JSP

    
<s:if test="user.alliance.name = name">

    
<s:if test="user.alliance.name == name">

[Rahul Babbar]

glad you figured out...