Skip to content

Destination MySQL: custom JDBC parameters #9434

Closed
@erikbaan

Description

@erikbaan

Tell us about the problem you're trying to solve

While trying to add a MySQL destination using the web interface, the following error occurs:

airbyte-worker      | 2022-01-12 13:10:10 INFO i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$0):61 - java.sql.SQLException: Cannot create PoolableConnectionFactory (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 specific time zone value if you want to utilize time zone support.)

But adding those JDBC parameters is currently not supported.
Thus adding the destination is impossible.

Describe the solution you’d like

Adding a custom JDBC driver param to provide another value for serverTimezone in the web interface could resolve this.

Describe the alternative you’ve considered or used

Configuring other timezones on the MySQL destination instance, but I would prefer not to change anything in that server configuration.

Are you willing to submit a PR?

No.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions