@past and ORA-02436 issue

shahbazi · **Posted:** Mon Apr 07, 2008 5:50 pm

Data base: Oracle XE 10g
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

Payment.java

Code:

@Past
@Column(name = "payment_date")
@Temporal(TemporalType.DATE)
public Date getPaymentDate() {

schemaexport ant task creates schema.sql as:

payment_date date check (payment_date < current_date),

Then Oracle doesn't like it and says:

Code:

ERROR  04/07 14:42 [main] SchemaExport.create(275) | ORA-02436: date or system variable wrongly specified in CHECK constraint