Hi,

I am trying to generate a check constraint to a column in adatabase table by using Hibernate. The version of Hibernate I am using is 3.0.

The Hibernate documentation says that to generate a check constraint for a column in a database table, we need to use the check attribute of property tag, that is within the class tag. So in my Hibernate mapping file (the file with [b].hbm.xml[/b] extension), I am specifying the check constraint on my database table column in this manner:
<class name="[b]myClass" table="myTable">
<property name="id" column="REF_CODE" type="java.lang.Integer" check="REF_CODE < 4000" not-null="true" />
</class>[/b]

When I run the org.hibernate.tool.hbm2ddl.SchemaExport utility to generate schema from the configuration file containing an entry to this mapping file, I get the following error on the console:
Error parsing XML: XML InputStream(42) Attribute "check" must be declared for element type "property".

Can you please tell me what I am doing wrong?

Thanks,

Kalpana

Per DTD http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd there is no check attribute on property, it should be used with nested column tag like this:
[/code]