Hibernate version:
3.2.6 ga

Mapping documents:
<property name="resume" length="512" not-null="true" />

Name and version of the database you are using:
MySQL 5.0 with MySQL5InnoDBDialect

Hello

I validate my schema with org.hibernate.tool.hbm2ddl.SchemaValidator
It works OK, but it does not check for column length or null/not-null constraints.

For example, if I manually change the type of the field from varchar to text, I get this nice exception:


But if field is different in any other aspect (length, or allowing null) the validator does not inform me.



Couldn't the org.hibernate.mapping.Table be enhanced on line 257 by adding columnInfo.getColumnSize() and columnInfo.getNullable() checks?

Is there a reason why this hasn't been implemented?

thanks

Hello

I've enhanced it locally to support the nullability match. It helped me identify mismatches on the production database of my project.

Do you find this helpful? Should I submit a patch?

thanks

Sounds useful to me ;).

I've submitted a patch: http://opensource.atlassian.com/project ... e/HHH-3192

Hope it's helpful.