CascadeType.ALL is not doing what I expected (int constraint violated)

[Logan Lee]

I am using JBoss5.1.0GA (hibernate) and Oracle XE.
A book can have one or multiple authors (as reflected below)
When I persist a book, it contains a collection of authors. I want the authors also to be persisted (cascade)

I have three tables.

BOOK_TBL
BOOK_ID (PK)
BOOK_AUTHOR_TBL
BOOK_ID (FK)
AUTHOR_ID (FK)
AUTHOR_TBL
AUTHOR_ID (PK)

I have two Entities:
Code snippets:
Book

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator = "BOOK_ID_SEQ") 
@SequenceGenerator(name = "BOOK_ID_SEQ", sequenceName = "BOOK_TBL_SEQ", allocationSize = 1) 
@Column(name="BOOK_ID")
public Long getBookId() {
	return bookId;
}

@OneToMany(cascade = CascadeType.ALL, fetch=FetchType.EAGER)
@JoinTable(name = "BOOK_AUTHOR_TBL", 
		joinColumns = @JoinColumn(name = "BOOK_ID"), 
		inverseJoinColumns = @JoinColumn(name = "AUTHOR_ID"))
public List<Author> getAuthors() {
	return authors;
}

Author
Nothing special here, except I use a sequence for the PK

@Id
@SequenceGenerator(name = "AUTHOR_ID_SEQ", sequenceName = "AUTHOR_TBL_SEQ", allocationSize = 1) 
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="AUTHOR_ID_SEQ")
@Column(name="AUTHOR_ID")
public Long getAuthorId() {
	return authorId;
}

When I persist my book, I get:

Exception in thread "main" javax.ejb.EJBTransactionRolledbackException: Transaction rolled back
...
Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (schema.B
OOK_AUTHOR_AUTHOR_ID) violated - parent key not found

So it seems it's trying to insert the FK's in the mapping table but can't find the parent key yet.. What am I doing wrong?

[Logan Lee]

any ideas? all help is very much appreciated