finally got tomcat to work with my old configuration. had some troubles due to using the new version of mysql with new connector. i hope the new setup runs ok on the old server. they have changed a few things in the new version of mysql - namely tinyint(1) has become a boolean which returns true or false. had to change to tinyint(2) to make it work. seems to be ok. also blank dates i.e. 0000-00-00 are not returned as null anymore so do not parse well. this is fixed in the jdbc connection string by using ?zeroDateTimeBehavior=convertToNull.
i have a bad feeling about the outcome next time i do a web system update...
No comments:
Post a Comment