Connector/J configuration file
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?
Subject
Written By
Posted
Connector/J configuration file
October 27, 2020 11:13AM
November 09, 2020 07:02AM
Sorry, you can't reply to this topic. It has been closed.
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.