Cascade error

[alexandre nofre]

Hi all

Im having a strange issue, whatever map I try to use cascade=CascadeType.ALL and use ddl-generation gives me a Restrict type in the table

already happened to someone that?

im using netbeans, glassfish v2, mysql 5 and toplink.ddl-generation to do that map

thanks in advance

[Cameron Wallace McKenzie]

What is the issue that this is causing? Are the cascades not working? Do you get an error when you try to add, update or delete? Is there an exception? Or are you just wondering why this type gets generated?

-Cameron McKenzie

[alexandre nofre]

Im wondering why I map with cascade.all and when I open the table in mysql administrator it show cascade type as restrict

[Yiorgos Panayiotakis]

Hi,

I also have the same issue here. Though when I'm creating the object relation mapping I use cascade=CascadeType.ALL,
somehow when auto-generating the new database schema cascade types (e.g. update,delete) are set to restrict, although
no errors are presented during the process of generating the schema and the foreign keys relations are created correctly.
Here is a small snippet of how my code looks like.

Entity A (AnotherEntity)

    
@OneToMany(mappedBy="anotherEntity", cascade=CascadeType.ALL})
	private Set<EventType> eventTypeCollection;

Entity B(EventType)

    
@ManyToOne
	@JoinColumn(name="type_id",nullable=false,insertable=false,updatable=false)
	private AnotherEntity anotherEntity;

I'm wondering if anybody has any idea about the problem I'm facing. Btw I'm using JPA - hibernate ddl-generation on mysql 5 and
deploy on jboss 4.2

Thanks in advance for the help

--
y.p.