[jboss-user] [EJB 3.0] - a foreign key constraint fails a weird issue!!!!

[panky_p]

Hi
I am trying for persist entries in database first time it works fine,
also for second time it works fine but when i try to persist third time it gives me 2:04:04,781 ERROR [JDBCExceptionReporter] Cannot add or update a child row: a foreign key constraint fails
  | 12:04:04,796 ERROR [SeamPhaseListener] uncaught exception
  | javax.el.ELException: javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.ConstraintViolationException: could not insert: [doctor.test.Reports]
  | 	at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
  | 	at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:270)
  | 	at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)
  | 	at org.jboss.el.parser.AstMethodSuffix.invoke(AstMethodSuffix.java:65)
  | 	at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
  | 	at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
  | 	at org.jboss.seam.core.Expressions$2.invoke(Expressions.java:174)
  | 	at org.jboss.seam.navigation.Page.preRender(Page.java:275)
  | 	at org.jboss.seam.navigation.Pages.preRender(Pages.java:309)
  | 	at org.jboss.seam.jsf.SeamPhaseListener.preRenderPage(SeamPhaseListener.java:544)
  | 	at org.jboss.seam.jsf.SeamPhaseListener.beforeRenderResponse(SeamPhaseListener.java:455)
  | 	at org.jboss.seam.jsf.SeamPhaseListener.beforeServletPhase(SeamPhaseListener.java:146)
  | 	at org.jboss.seam.jsf.SeamPhaseListener.beforePhase(SeamPhaseListener.java:116)
  | 	at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:222)
  | 	at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
  | 	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
  | 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  | 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  | 	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
  | 	at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
  | 	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  | 	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
  | 	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  | 	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:44)
  | 	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  | 	at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:127)
  | 	at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:277)
  | 	at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
  | 	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  | 	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
  | 	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  | 	at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:150)
  | 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  | 	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:179)
  | 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
  | 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  | 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  | 	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
  | 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  | 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
  | 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  | 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
  | 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  | 	at java.lang.Thread.run(Thread.java:619)
My reports bean contains

@ManyToOne(fetch = FetchType.EAGER,cascade ={ CascadeType.MERGE,CascadeType.REFRESH})
  | 	@JoinColumn(name="patient_id ")
  | 	private Patient patient;
where patient bean contains patient information

and mysql table is CREATE TABLE `report_entry` (                                                             
  | 	                `id` int(10) NOT NULL auto_increment,                                                   
  | 	                `patient_id` int(10) NOT NULL,                                                           
  | 	 		`report_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,                                            
  | 	                PRIMARY KEY  (`id`),                                                                    
  | 	                KEY `id` (`id`),                                                                        
  | 	                CONSTRAINT `FK_report_entry_1` FOREIGN KEY (`id`) REFERENCES `patient` (`id`)            
  |               )

Where i am going wrong.
For first and second entry it works fine for third entry it give above exception any help????

Thanks 
Panky

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4126011#4126011

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4126011