How to catch an out of range date error

pertile · **Joined:** Sat Jul 23, 2005 7:19 pm **Posts:** 11

Hi, I'm trying to save dates on a table, and I want to know which is the best way to check that the date is not outside the range accepted by the database. In SQL Server (that accepts dates from 1753 to 9999) that type of error gives me error code 0.
Thanks.

Hibernate version:
3.1

Full stack trace of any exception that occurs:
16469 [AWT-EventQueue-0] ERROR util.JDBCExceptionReporter - Only dates between January 1, 1753 and December 31, 9999 are accepted.

Name and version of the database you are using:
SQL Server 2000 with jTDS

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Validate that sort of thing before it gets to the database. Probably immediately below the UI layer of your app.

jt_1000 · **Posted:** Mon Mar 13, 2006 6:52 pm

Perhaps this may help:

<column...
check=" dt > 1753 and dt < 9999"/>

(you may need to put the to_date(...) function (or sqlserver equivalent) around the years).

Or is it too late, in otherwords, the JDBC driver will pickup the "out of range" SQL error before it hits the db?

I would think it will make it to the database, and if the DT is out of range you'll get a CHECK violation.