Dates in AS400 using jtopen datasource driver

If you are using Toolbox jdbc driver for your as400 db2 datasource connection, it is possible you can only give dates between 1940 and 2039. Dates later then 2039 will give 01-01-2001.

Solution:

Set the property "dateFormat" to "iso".

Source:

http://www-03.ibm.com/systems/i/software/toolbox/faqjdbc.html#faqB5