You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Anton Koval (Jira)" <ji...@apache.org> on 2021/12/27 10:35:00 UTC

[jira] [Created] (NIFI-9519) CaptureChangeMySQL processor don't accept additional parameters to JDBC connection

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)