Thanks. My editbale JTable returns null if there is not a date value in the database; and I store null in the database for any missing data; but I get the error message as if I had stored "0000-00-00" or as if the table returned "0000-00-00"
I am going to try to understand this: The JDBC driver developers for MySQL created an option for how '0000-00-00' dates should be handled (since that technically isn't a valid date from Java's standpoint). Even though this is the default value for NOT NULL date fields in MySQL, they decided to default this option to throw an exception. You can in fact change this behavior to the more sensible option of just returning null. To do this, add "zeroDateTimeBehavior=convertToNull" to the end of the "url" parameter in the server.xml connection pool resource section. Here's what the end product should look like:
Joined: Jul 15, 2011
Yes. You are rigth guys. I made a change in my JTable and it accidentaly change the database value from null to "0000-00-00"; the prole is with the JTable then. Do you handle JTable questions as well or showld I pose the question to the SWING guys?