Hibernate version:
3.2

Mapping documents:

Name and version of the database you are using:
MySQL 5.x

Hello

I have classes Foo and Bar.
Foo has a Set<Bar> usedBy;
So in my table bar there is a field "foo_id" which points to field "id" of table foo.

hbm2ddl tries to generate a foreign key for that relation, but I don't want to. Is it possible to force hbm2ddl to not generate an FK?

In the hbm2ddl documentation (Customizing the schema) it says: "Note that inverse="true" sides will not be considered by SchemaExport."
But, both SchemaUpdate and SchemaExport do generate this FK.

I don't want an FK because entries from table "foo" might be deleted later on. And that's why I also use not-found="ignore". Right now this is not possible with this FK.

Any solution for this problem?
thanks

OK just found it.
I need to specify foreign-key="none" to cancel FK generation for that field.
This is not mentioned in the hibernate documentation, nor in the Java Persistence with Hibernate book. I found it at a cached version of hibernate 2.1.9 changelog after hardcore googling:



Maybe it should be included in the documentation in section 20. Toolset Guide

Thanks

Hi,
I am new to the Hibernate as well as in the forum.
Can you please specify where should I set the foreign-key="none" to cancel the generation of foreign-key reference ?

thanks in advance

Judging from the mapping DTD, set it as an attribute of they key element.

This post of yours was very very useful to me, you saved my day ;-)! Thanks a lot for putting down your solution; it's a shame this isn't (yet) in the reference manual!

put it in jira for hibernate core/docs.

Do you know if this is supported via annotations? I haven't found it yet, if it is...

You can do it via annotations too like so:
@ManyToOne
@ForeignKey(name = "none")
@JoinColumn(name = "user_id", nullable = false)

Anyone knows how I can get the same result (i.e. turn off the fk) but I'm using only JPA 1.0 annotations (rather metadata tags in orml.xml) ?

Thanks,