Problems with @Past validator

mahbe · **Posted:** Thu Jan 10, 2008 5:30 am

Please see here: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=127321

Best Regards, Matthias

mahbe · **Posted:** Fri Jan 11, 2008 4:59 am

Here the posting from jboss.org:

I use Hibernate as JPA implementation with JBoss Seam. The underlying database is MS SQLSERVER 2000. Recently I added Hibernate Validation and used the builtin @Past validator. But since then, a few tables where no longer generated with hbm2ddl. Then I detected that all tables those tables used an @Past annotation on a field:

Code:

04:57,375 INFO  [SchemaExport] Running hbm2ddl schema export
04:57,375 INFO  [SchemaExport] exporting generated schema to database
04:57,437 ERROR [SchemaExport] Unsuccessful: create table Lizenz ([...], erwerbsDatum datetime not null check (erwerbsDatum < current_date), [...])
04:57,437 ERROR [SchemaExport] Falsche Syntax in der Naehe des current_date-Schluesselwortes. [<- means in English: 'wrong syntax near current_date keyword']
[...]
04:57,828 INFO  [SchemaExport] schema export complete

Is this a bug in Hibernate Validator or hbm2ddl? Probably in association with MS SQLSERVER?

emmanuel · **Posted:** Fri Jan 11, 2008 7:00 am

It's a fairly fundamental limitation in Hibernate Core and how it is integrated with Hibernate Validator, basically we cannot use the dialects to use the appropriate db function for current date.
We think of fixing this for Hibernate 4.
In the mean time you canrewrite the PastValidator class and remove the DDL changes.