Anton Koval created NIFI-9519:
---------------------------------
Summary: CaptureChangeMySQL processor don't accept additional
parameters to JDBC connection
Key: NIFI-9519
URL: https://issues.apache.org/jira/browse/NIFI-9519
Project: Apache NiFi
Issue Type: Bug
Affects Versions: 1.15.1
Reporter: Anton Koval
We have MySQL server with timezone setting to CEST. A CaptureChangeMySQL
processor returns error message:
Caused by: java.sql.SQLException: The server time zone value 'CEST' 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.
I have tried to pass this parameter to *Database/Schema Name Pattern* property
like this: {*}schema_name?serverTimezone=UTC{*}, however it seems to be
ignored.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
