Hibernate version: 3.0alpha
Name and version of the database you are using: MySql 4.1 (InnoDB tables)
JDBC Driver is 3.0.15ga
I have a Project table, and Owner column within it. Mistakenly I had unique constarint specified on Owner column which prevented me from assigning same owner for two projects!! "desc project" showed unique constraint on Project table.
I removed unique tag from XDoclet and ran schemaupdate. It didn't print anything to stdout. But when I did "desc project" again, unique constraint on Project table was gone.
Apparently using the application, I still can't assign the same owner to two projects. Has anyone ran into same issues? I know "Hibernate In Action" advises that schemaupdate is not very usable in practice, but it's always good to know the real limitations.
|