During testing we found that text input fields for date values set up with a converter:

<s:convertDateTime pattern="MM/dd/yyyy"/>

allow for the year input as 20007, which blows up on the DB side of things.

The unexpected thing here is that I expected the converter to limit year inputs to 4 characters (yyyy). I'm pretty sure this is right; but obviously not.

What are we doing wrong?

The actual db error is that in DB2 the year exceeds '9999'