Seam / Hibernate adds extra foriegn keys?

[dustismo]

Hello,

I notice that seam adds extra foreign keys to my database models. I have carefully set up the proper cascade options to my foreign key associates, but then when I start my seam app it adds overlapping foreign keys with no cascade options. I'd like seam to skip this, I'm sure there is a configuration option somewhere but I haven't found it.

My app was created with the latest seam-gen with jboss AS and mysql db.

Thanks much,
Dustin

[gavin.king]

Yes, this is a problem affecting Hibernate SchemaUpdate with MySQL. I suggest that you disable automatic SchemaUpdate.

[dustismo]

For anyone else having this problem, commenting out this section in /seam-gen/build.xml fixed the problem.

<!--
 <condition property="hibernate.hbm2ddl.auto" value="update">
 <and>
 <equals arg1="${database.exists}" arg2="n"/>
 <equals arg1="${database.drop}" arg2="n"/>
 </and>
 </condition>
-->

-Dustin