Connector/J configuration file
Posted by: Jan Andersen
Date: October 27, 2020 11:13AM

I'm having some trouble which may be related to zero dates (see https://help.metricinsights.com/m/Connecting_to_Data_Sources/l/599791-validation-errors-value-0000-00-00-can-not-be-represented-as-java-sql-date), and it would be very inconvenient (read: impossible) to make changes to the Java code that uses the JDBC driver.

So, I have been looking in the .properties files in the .jar file (mysql-connector-java-8.0.22.jar), and a file called 3-0-Compat.properties contains the parameter I'm interested in:

zeroDateTimeBehavior=CONVERT_TO_NULL

- but there is rather a lot of .properties files, and I am not sure this one is being used, Is there a way to see which configuration is active? Or is there one specific file that is always used?

Options: ReplyQuote


Subject
Written By
Posted
Connector/J configuration file
October 27, 2020 11:13AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.