Hello,

I'm facing the following problem:
I have a class named 'Container' that represents an object at table ttree that is extended from a class named 'Course' and a class named 'User', and a class named 'Subscription' that represents an object at table tsubscriptions.
The relation is one-to-many (one 'Course' can have many 'subscriptions' while one subscription can have only one 'Course').
The mapping is as follows in the specific section.

I have add a unique constraint at tsubscriptions table for courseId and userId.
When i try to update a list of course subscriptions, hibernate seems to try first to insert the new list and then to delete the old one. As a result i have a sql error for trying to add a duplicate key in table tsubscriptions.

Does anybody has an idea about this problem?


Thanks ...



[b]Hibernate version: 3.1.rc1

[b]Mapping documents:[/b]@Entity(access = AccessType.FIELD )
@Inheritance(discriminatorValue="O")
public class Course extends Container {
@OneToMany( cascade = CascadeType.ALL)
@Cascade( { org.hibernate.annotations.CascadeType.ALL, org.hibernate.annotations.CascadeType.DELETE_ORPHAN })
@JoinColumn(name="courseid", nullable=false)
protected Set<Subscription> subscriptions;


[b]Mapping documents:[/b]@Entity(access = AccessType.FIELD)
@Table(name="tsubscriptions")
public class Subscription extends BaseEntity {
@ManyToOne( fetch = FetchType.LAZY )
@JoinColumn( name = "courseid", nullable = false, insertable = false, updatable = false)
private Course course;

@ManyToOne( fetch = FetchType.LAZY )
@JoinColumn( name = "userid", nullable=false)
private User user;


[b]Full stack trace of any exception that occurs:[/b]
18:18:25,836 WARN [JDBCExceptionReporter] SQL Error: 2627, SQLState: 23000
18:18:25,836 ERROR [JDBCExceptionReporter] Violation of UNIQUE KEY constraint 'IX_tsubscriptions_courseid_userid'. Cannot insert duplicate key in object 'tsubscriptions'.
18:18:25,867 ERROR [[CourseHandler]] Servlet.service() for servlet CourseHandler threw exception
javax.ejb.EJBException: Unexpected error.; CausedByException is:
Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=mimar/533, BranchQual=, localId=533] status=STATUS_NO_TRANSACTION; - nested throwable: (org.hibernate.exception.ConstraintViolationException: could not insert: [exodus.elearn.model.Subscription])
at exodus.util.ejb.UserTransaction.commit(UserTransaction.java:46)
at elearn.objecthandlers.CourseManagerHandler.subscribeAll(CourseManagerHandler.java:256)
at elearn.objecthandlers.CourseManagerHandler.access$0(CourseManagerHandler.java:223)
at elearn.objecthandlers.CourseManagerHandler$1.call(CourseManagerHandler.java:176)
at elearn.objecthandlers.CourseManagerHandler$1.call(CourseManagerHandler.java:1)
at exodus.util.ejb.Ejb3Util.runCallableAs(Ejb3Util.java:78)
at elearn.objecthandlers.CourseManagerHandler.subscribeAllRunAs(CourseManagerHandler.java:180)
at elearn.objecthandlers.CourseManagerHandler.processRequest(CourseManagerHandler.java:137)
at elearn.objecthandlers.CourseManagerHandler.doPost(CourseManagerHandler.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at ecentric.web.util.NoCacheFilter.doFilter(NoCacheFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at elearn.session.ElearnSessionLogin.doChain(ElearnSessionLogin.java:165)
at elearn.session.ElearnSessionLogin.doFilter(ElearnSessionLogin.java:136)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at exodus.web.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:177)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [exodus.elearn.model.Subscription]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:582)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:576)
at org.hibernate.engine.CascadingAction$9.cascade(CascadingAction.java:225)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:130)
at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:121)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:877)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
... 42 more
Caused by: java.sql.SQLException: Violation of UNIQUE KEY constraint 'IX_tsubscriptions_courseid_userid'. Cannot insert duplicate key in object 'tsubscriptions'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:445)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:402)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1967)
... 71 more


[b]Name and version of the database you are using: SqlServer 2000

[b]The generated SQL (show_sql=true):[/b]18:18:25,633 INFO [STDOUT] Hibernate: insert into tsubscriptions (userid, actiontype, actiondate, courseid) values (?, ?, ?, ?)

One side has to be mappedBy, have a look at the docs.
PS the mappedBy side should not use @JoinColumn

I put 'mappedBy' at the @OneToMany side(Course) as follows:



and i removed from the mappedBy side(Subscription) the @JoinColumn:



Unfortunately i have the following sql exception:



Am i doing something wrong?

Add
@JoinColumn( name = "courseid", nullable = false)