I'm currently using hibernate 3.1 and have a one-to-one relationship that uses a many-to-one mapping with a unique key. This is a unidirectional relationship with a mapping which looks like



The column 'labelId' gets created in the package table but there is no FK constraint on this labelId. I would like to add this constraint to make sure that the label exists in the label table in order for the package to be valid. How can I tell hibernate to do this in my mapping?

-nefi

Add 'foreign-key="nameOfYourForeignKey"'.

Hi Tenwit,

I just tried what you suggested, dropped and recreated the tables, but to no avail. Still no foreign key constraint for the package table. BTW, I'm hitting SQLServer 2000, if this makes any difference.

-nefi

It's all described in the ref docs in section 20.1. According to that, it should work. Perhaps the foreign key is being generated on the table on the other side?

Examine the generated SQL. Use the --text or --output="filename" parameters to view the SQL, and that should help you deduce what's going wrong.

I've looked at the docs and seems like it should work. However, the only thing I see on the PACKAGE table is that there is an index for labelId:

name = UQ_PACKAGE_2F112023
id = 2
Uniq? = Y
Column1 = labelId

Again, there is no dependent PACKAGE table for LABEL and there is no foreign key constraint for LABEL in the PACKAGE table.

As for the SQL output, I use hibernate.cfg.xml, define the properties:

<property name="show_sql">true</property>
<property name="hibernate.hbm2ddl.auto">create-drop</property>

and when I launch my app server, the tables get generated. I do not know out to use --output="filename" in the config file. Any suggestions?

-nefi

Don't use it in the config file, run hbm2ddl manually. It's all described in the ref docs, section 20.1.2.