I am using Jt400 driver to read from a table (located on AS400 i series server ).
There is issue while reading values from a date type column.
If value inside Date column is greater than 2040-01-01, it returns null. Is there any property which can be set to increase the limit(if any)?
Are you getting "null" only from the Jt400 driver? What database are you using? Have you try in the DB tool?
K. Tsang OCPJP7 OCMJEA6
posted 3 years ago
Yes null is only from jt400 driver. Reading the values using ISeries navigator is not an issue. I also get null if i use squirrel SQL client, where i use jt400 driver to connect to the database. And i am using jt400 driver from my java code.
There's something which limits dates to be within the range 1940 to 2039 under certain circumstances, if I recall correctly. This applies only if you're formatting your dates using a two-digit year. So see if you can find something which lets you specify the "date format" in your JDBC driver and specify a 4-digit year there.