Talend open studio connection failure

[MShahid1630769876]

Hi all,

I can make a successful connection with my localhost using the Talend open studio but cannot make a connection using the

a remote IP address can anyone help me out.

[Anonymous]

Hello,

Could you please click "Details" button to see if there is anymore information about connection failure? If so, we will appreciate it a lot if you could paste it or upload a screenshot here.

Best regards

Sabrina

[MShahid1630769876]

Hello,

Thanks for your time below are the details of the error.

Connection failure. You must change the Database Settings.

 java.lang.RuntimeException: java.sql.SQLException: The server time zone value 'GMT Summer Time' 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:1146)

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

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

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

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.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.util.concurrent.FutureTask.run(Unknown Source)

   at java.lang.Thread.run(Unknown Source)

 Caused by: java.sql.SQLException: The server time zone value 'GMT Summer Time' 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 'GMT Summer Time' 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 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

   at java.lang.reflect.Constructor.newInstance(Unknown Source)

   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

[Anonymous]

Hello,

There is a DB connection issue. From your error message, you might need a "real" time zone.

Please try to add ?useLegacyDatetimeCode=false&serverTimezone=GMT

in your DB connection string url to see if it works.

Here is a related article about: https://stackoverflow.com/questions/7605953/how-to-change-mysql-timezone-in-a-database-connection-us...

Best regards

Sabrina