Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » @CascadeOnDelete
@CascadeOnDelete [message #911373] Tue, 11 September 2012 09:18 Go to previous message
Oleg Danilov is currently offline Oleg Danilov
Messages: 21
Registered: July 2012
Junior Member
I have a strange problem with @CascadeOnDelete annotation. For instance

@Entity
public class Employee {
	@Id
	private long id;
	private String firstName;
	private String lastName;
	@OneToMany(mappedBy = "parent", orphanRemoval = true, cascade = { CascadeType.ALL })
	@CascadeOnDelete
	private List<Employee> children;
	@ManyToOne
	private Employee parent;
}


eclipselink generates the following DDL:

CREATE TABLE EMPLOYEE (ID BIGINT NOT NULL, FIRSTNAME VARCHAR(255), LASTNAME VARCHAR(255), PARENT_ID BIGINT, PRIMARY KEY (ID))
ALTER TABLE EMPLOYEE ADD CONSTRAINT FK_EMPLOYEE_PARENT_ID FOREIGN KEY (PARENT_ID) REFERENCES EMPLOYEE (ID)

Note, that ON DELETE CASCADE is not generated, therefore it works not as expected.

Any ideas?

[Updated on: Tue, 11 September 2012 09:19]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:ManyToOne and JoinTable
Next Topic:Loging SQL to a file
Goto Forum:
  


Current Time: Wed May 22 09:02:04 EDT 2013

Powered by FUDForum. Page generated in 0.02306 seconds