mysql conection to Talend

[Padilla404]

Hello, i am trying to stablich a conection between my databse in Mysql worckbench and Talend.

I get this specific error:

Connection failure. You must change the Database Settings.

 java.lang.RuntimeException: java.sql.SQLException: The server time zone value 'Hora est�ndar central (M�xico' 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.

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1170)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:317)

   at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.runWithCancel(DatabaseForm.java:4556)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.runWithCancel(DatabaseForm.java:1)

   at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)

   at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)

   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

   at java.base/java.lang.Thread.run(Thread.java:834)

 Caused by: java.sql.SQLException: The server time zone value 'Hora est�ndar central (M�xico' 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.

   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)

   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)

   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)

   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)

   at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)

   at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)

   at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)

   at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:199)

   ... 9 more

 Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Hora est�ndar central (M�xico' 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.

   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)

   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)

   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)

   at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)

   at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2121)

   at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2145)

   at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310)

   at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967)

   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)

   ... 14 more

Iv'e tried everything, from stablishing the timezone in talend to the one of the system with a tjava component. I've also already verificated that both timezones in Talend and SQL are the zame by calling the timezone. They are.

I don't know what else to do, please help.

[Padilla404]

stablish*

[Anonymous · Accepted solution]

Hello @Not defined Not defined​ ,

To resolve the issue, you can add the below Additional parameter in the mysql db connection like the below

serverTimezone=UTC

Best regards

Aiming