Deleting data from multiple tables?

[mallikarjun dontamsetti]

Hi i am practicing hibernate with some examples i come across this problem please help me
i want to delete data from two tables but in jsp i am getting first table primary key based on that i have to delete data from two tables (second one contain 1st table pk as fk) my error is


1640047 [[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO org.hibernate.event.def.DefaultDeleteEventListener - handling transient entity in delete processing
xxxxxxxxxxxxxxx
xxxxxxx--------------------------xxxxxxxx
Hibernate:
delete
from
jp.company_info
where
COMPANY_SN=?
1640063 [[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1451, SQLState: 23000
1640063 [[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot delete or update a parent row: a foreign key constraint fails (`jp`.`comp_contact_info`, CONSTRAINT `FK_COMP_COMPANY_SN` FOREIGN KEY (`COMPANY_SN`) REFERENCES `company_info` (`COMPANY_SN`))
1640063 [[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR org.hibernate.event.def.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:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at com.garnet.services.DAO.commit(DAO.java:40)
at com.garnet.services.CompanyMaintanceDAOImpl.deleteCompanyMaintance(CompanyMaintanceDAOImpl.java:101)
at com.garnet.admin.CompanyMaintanceServlet.doGet(CompanyMaintanceServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`jp`.`comp_contact_info`, CONSTRAINT `FK_COMP_COMPANY_SN` FOREIGN KEY (`COMPANY_SN`) REFERENCES `company_info` (`COMPANY_SN`))
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:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 24 more
Cannot delete or update a parent row: a foreign key constraint fails (`jp`.`comp_contact_info`, CONSTRAINT `FK_COMP_COMPANY_SN` FOREIGN KEY (`COMPANY_SN`) REFERENCES `company_info` (`COMPANY_SN`))


my code is:

    try {
      session = getSession();
      begin(session);
      session.clear();
      compContactInfo.setCompanyInfo(companyInfo);
      System.out.println("-----------------"+compContactInfo.getContactPersonEmail());
      session.clear();
      session.delete(compContactInfo); 
      System.out.println("xxxxxxxxxxxxxxx");
      commit(session);
      session.clear();
      System.out.println("xxxxxxx--------------------------xxxxxxxx");
      begin(session);
      session.clear();
      session.delete(companyInfo); 
      commit(session);
     
      session.clear();
      return 1;
    } catch (HibernateException e) {
      rollback(session);
      System.out.println(e.getCause().getMessage());
    }finally {
      close(session);
    }
      return 0;

I am using entities like this

@Entity
@Table(name = "company_info", catalog = "jp")
public class CompanyInfo implements java.io.Serializable {
------
----------
	private Set<CompContactInfo> compContactInfos = new HashSet<CompContactInfo>(
			0);
---
	@OneToMany(fetch = FetchType.EAGER, mappedBy = "companyInfo")
	public Set<CompContactInfo> getCompContactInfos() {
		return this.compContactInfos;
	}

	public void setCompContactInfos(Set<CompContactInfo> compContactInfos) {
		this.compContactInfos = compContactInfos;
	}
-------

}

please help me

[mallikarjun dontamsetti]

Hy I got it i just added @Cascade(CascadeType.ALL) in the parent entity above child column. I work's fine for me.

[mallikarjun dontamsetti]

Is there any problems will occur in future by using this annotation @Cascade please let me know if there any alternative thanks

[Wouter Oet]

Why are you clearing your session after almost each statement?

[mallikarjun dontamsetti]

Wouter Oet wrote:Why are you clearing your session after almost each statement?

I am just beginner i have seen that in some web site Is It wrong..?

[Wouter Oet]

It isn't really wrong but it is certainly not right. As a beginner you'll probably never need session.clear().

[mallikarjun dontamsetti]

ok thanks but when i apply same concept for update also it is saying that session is closed what may be the reason..