[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2801) wrong insert/delete order when updating record-set

imran pariyani (JIRA) noreply at atlassian.com
Thu Sep 6 20:56:14 EDT 2007


    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28032 ] 

imran pariyani commented on HHH-2801:
-------------------------------------

Hi Christoph. you are right i don't understand this is quite common issue and still it has gone unnoticed.  Today there was a new release from Jboss jboss-4.2.1.GA and it uses hibernate 3.2.4.sp1 i guess you are also using the same one . I tried it with that and its still giving same problem.. 

2007-09-07 02:17:24,847 DEBUG [org.hibernate.SQL] insert into location_i18n (loc_id, language, date_created, date_updated, province, city, worldregion, region, subregion, quarter) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2007-09-07 02:17:24,848 TRACE [org.hibernate.type.IntegerType] binding '1' to parameter: 1
2007-09-07 02:17:24,848 DEBUG [org.hibernate.type.EnumType] Binding 'EN' to parameter: 2
2007-09-07 02:17:24,848 TRACE [org.hibernate.type.TimestampType] binding '2007-09-07 02:17:24' to parameter: 3
2007-09-07 02:17:24,848 TRACE [org.hibernate.type.TimestampType] binding '2007-09-07 02:17:24' to parameter: 4
2007-09-07 02:17:24,848 TRACE [org.hibernate.type.StringType] binding null to parameter: 5
2007-09-07 02:17:24,848 TRACE [org.hibernate.type.StringType] binding null to parameter: 6
2007-09-07 02:17:24,849 TRACE [org.hibernate.type.StringType] binding null to parameter: 7
2007-09-07 02:17:24,849 TRACE [org.hibernate.type.StringType] binding 'afsdfa' to parameter: 8
2007-09-07 02:17:24,849 TRACE [org.hibernate.type.StringType] binding null to parameter: 9
2007-09-07 02:17:24,849 TRACE [org.hibernate.type.StringType] binding null to parameter: 10
2007-09-07 02:17:24,873 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1062, SQLState: 23000
2007-09-07 02:17:24,874 ERROR [org.hibernate.util.JDBCExceptionReporter] Duplicate entry 'EN-1' for key 2
2007-09-07 02:17:24,874 ERROR [STDERR] javax.persistence.EntityExistsException: org.hibernate.exception.ConstraintViolationException: could not insert: [com.triple.LocationI18n]
2007-09-07 02:17:24,874 ERROR [STDERR]  at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:604)
2007-09-07 02:17:24,874 ERROR [STDERR]  at org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:236)
2007-09-07 02:17:24,874 ERROR [STDERR]  at org.jboss.ejb3.entity.TransactionScopedEntityManager.merge(TransactionScopedEntityManager.java:188)
2007-09-07 02:17:24,874 ERROR [STDERR]  at com.triple.LocationBean.updateLocation(LocationBean.java:83)
2007-09-07 02:17:24,874 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2007-09-07 02:17:24,874 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2007-09-07 02:17:24,875 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

If you come up with something do let me know. This is a very crucial issue for us. 


> wrong insert/delete order when updating record-set
> --------------------------------------------------
>
>                 Key: HHH-2801
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2801
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.2.4.sp1
>         Environment: hibernate-3.2.4.sp1, hibernate-annotations-3.3.0.GA, hibernate-entitymanager-3.3.1.GA, Oracle 10g Express Edition
>            Reporter: Christoph Mayerhofer
>         Attachments: model.zip, test-pro.tar.gz
>
>
> Overview: I have a record with a OneToMany association. From this associated record-set a record is removed and added again, both records identified with the same key. When doing a merge, I get a Unique constraint violation, because Hibernate first tries to insert the new record. Hibernate should first delete the old record, and after this insert the new record, avoiding the unique constraint violation.
> Detailed description: I have the following entities: Patient, SocialInsurance, PatientSocialInsurance. A patient could have several social insurances assigned to it. A social insurance could be assigned several times to a patient, we have a m:n relation between Patient and SocialInsurance. The relation-table has the name PatientSocialInsurance, with a unique constraint over patient_id and social_insurance_id. Each POJO inherits from a Base-POJO, which holds the id and the insert- and update-timestamps and userstamps.
> Base ---> PatientEntity ---> Patient
> Base ---> SocialInsuranceEntity ---> SocialInsurance
> Base ---> PatientSocialInsuranceEntity ---> PatientSocialInsurance
> Note: All *Entity model objects are generated with Hibernate-Tools from the db-schema, assuming that there are no wrong annotations, no wrong fields or wrong getter-/setter-methods in these model-classes.
> (I have enclosed all model-classes within an zipped attachment.)
> Now I try to delete an existing social insurance from a patient and add the same social insurance to the patient again:
> 	public void deleteSocialInsurance(Patient p, PatientSocialInsurance s) {
> 		if (p == null || s == null) {
> 			throw new IllegalArgumentException();
> 		}
> 		s.setSocialInsurance(null);
> 		s.setPatient(null);
> 		p.getPatientSocialInsurances().remove(s);
> 	}
> 	public void addPatientSocialInsurance(Patient p, PatientSocialInsurance s)
> 		throws DuplicatePatientSocInsException {
> 		if (p == null || s == null) {
> 			throw new IllegalArgumentException();
> 		}
> 		s.setPatient(p);
> 		p.getPatientSocialInsurances().add(s);
> 	}
> After doing a merge on the patient object, I get the following error:
> DEBUG - persisting patient...
> DEBUG - transaction org.hibernate.ejb.TransactionImpl at 44ac6a started
> DEBUG - update timestamp and userstamp for base record set
> DEBUG - update timestamp and userstamp for base record set
> DEBUG - update timestamp and userstamp for base record set
> DEBUG - update timestamp and userstamp for base record set
> DEBUG - update timestamp and userstamp for base record set
> DEBUG - select rawtohex(sys_guid()) from dual
> DEBUG - insert timestamp and userstamp for base record set
> DEBUG - insert into dseas.PATIENT_SOCIAL_INSURANCE (TIME_CRE, TIME_UPD, USER_CRE, USER_UPD, CODE_MEMBERSHIP_NO, CODE_TYPE_DEFAULT, PATIENT_ID, SOC_INS_ID, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
> ERROR - ORA-00001: Unique Constraint (DSEAS.PATIENT_SOCIAL_INSURANCE_UK) verletzt
> ERROR - ORA-00001: Unique Constraint (DSEAS.PATIENT_SOCIAL_INSURANCE_UK) verletzt
> ERROR - 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:253)
>    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
>    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
>    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 org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
>    at org.dseas.base.hibernate.EntityManagerFacade.commit(EntityManagerFacade.java:78)
>    at org.dseas.business.service.maindata.PatientEditorService.save(PatientEditorService.java:112)
>    at org.dseas.ui.rcp.editor.patient.PatientEditorPart.doSave(PatientEditorPart.java:1298)
>    at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:143)
>    at org.eclipse.ui.internal.SaveableHelper$4.run(SaveableHelper.java:266)
>    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
>    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
>    at org.eclipse.jface.window.ApplicationWindow$1.run(ApplicationWindow.java:758)
>    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
>    at org.eclipse.jface.window.ApplicationWindow.run(ApplicationWindow.java:755)
>    at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:2451)
>    at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:274)
>    at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:253)
>    at org.eclipse.ui.internal.SaveableHelper.savePart(SaveableHelper.java:148)
>    at org.eclipse.ui.internal.EditorManager.savePart(EditorManager.java:1345)
>    at org.eclipse.ui.internal.WorkbenchPage.savePart(WorkbenchPage.java:3184)
>    at org.eclipse.ui.internal.WorkbenchPage.saveEditor(WorkbenchPage.java:3197)
>    at org.eclipse.ui.internal.SaveAction.run(SaveAction.java:73)
>    at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
>    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
>    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
>    at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443)
>    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
>    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
>    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
>    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
>    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
>    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
>    at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
>    at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
>    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
>    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
>    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
>    at org.dseas.ui.rcp.Application.start(Application.java:22)
>    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153)
>    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
>    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
>    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
>    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>    at java.lang.reflect.Method.invoke(Unknown Source)
>    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504)
>    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443)
>    at org.eclipse.equinox.launcher.Main.run(Main.java:1169)
>    at org.eclipse.equinox.launcher.Main.main(Main.java:1144)
> Caused by: java.sql.BatchUpdateException: ORA-00001: Unique Constraint (DSEAS.PATIENT_SOCIAL_INSURANCE_UK) verletzt
>    at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
>    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10657)
>    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
>    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
>    ... 55 more
> ERROR - Error while commiting the transaction 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        



More information about the hibernate-issues mailing list