When hitting the running service, get sql error

[demongolem]

I get the error:

Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

when trying to hit the service when running in Tomcat.

From scanning the web, I see that a mere addition to the jdbc string can fix this. Is there a fix that can be applied for this?

I have running on Ubuntu 18.04 and I see the following:

Time zone: America/New_York (EDT, -0400)

[MatthewVita]

Hi @demongolem,

This issue was brought up here: https://github.com/GoTeamEpsilon/ctakes-rest-service/issues/43#issuecomment-423787274

Please see the comments there. I'm not on a computer with this solution running, but I think that conversation will help you.

[demongolem]

I was looking and looking for where the jdbc string was to adjust it. Took me way too long, but yes the comment in #43 is exactly the same problem.

My mistake was that I was just blindly going through the README step-by-step for the installation process. It was also weird because I did not run into this issue on the original install but at a point later in time.

The one thing I ask before this one is closed, can you adjust README.md with this information? Obviously the user has to set the timezone to their own preferences, but just show the new user how to do it when they are installing the Tomcat web app?