tuohai666 commented on issue #2389: sharding-proxy fail to handle '0000-00-00 00:00:00' Timestamp result URL: https://github.com/apache/incubator-shardingsphere/issues/2389#issuecomment-493014228 Get it. This exception is thrown by JDBC. Sharding-Proxy use JDBC as a backend to access databases, so if JDBC throws an exception, Sharding-Proxy will transfer the exception transparently to client. There's a workaround to resolve this problem, in your case, add parameter: url: jdbc:mysql://172.16.4.253:3306/test?serverTimezone=UTC&useSSL=false&**zeroDateTimeBehavior=convertToNull** The **zeroDateTimeBehavior** parameter convert the '0000-00-00 00:00:00' to NULL.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
