Mysql Connection error

hbensaid — Sat, 16 Nov 2024 02:39:18 GMT

Hi Team,

i have this error when im trying to test mysql connection in my ESB Talen:

" Plugin '*84AAC12F54AB666ECFC2A83C676908C8BBC381B1' is not loaded "

Can you please help:

Echec de la connexion Vous devez modifier les paramètres de la base de données.
java.lang.RuntimeException: java.sql.SQLException: Plugin '*84AAC12F54AB666ECFC2A83C676908C8BBC381B1' is not loaded
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.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Plugin '*84AAC12F54AB666ECFC2A83C676908C8BBC381B1' is not loaded
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
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

Re: Mysql Connection error

Anonymous — Thu, 23 Apr 2020 10:20:29 GMT

Hi
Please provides the following information, it will help us to more easily evaluate your issue:
- Product and Version which you used (for example, Talend Data Fabric 7.3.1)
- Operating System, for example, Windows Server 2008 R2 SP1 (64bit)
- Version of Java Platform JDK / JRE in use (for example, ORACLE JDK 1.8.0_161)
- Version of Mysql database

Regards
Shong

Re: Mysql Connection error

hbensaid — Thu, 23 Apr 2020 11:23:06 GMT

Hi,

As requested please find bellow the details informations:

Product and Version:

TOS ESB Version: 7.3.1

Operating System:

Windows 10 64bit

Java Verison:

C:\Users\Lenovo>java -version
java version "10.0.1" 2018-04-17
Java(TM) SE Runtime Environment 18.3 (build 10.0.1+10)
Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10.0.1+10, mixed mode)

Version of Mysql database:

MySQL 5.7.17

Best regards,

Hassan

Re: Mysql Connection error

Anonymous — Fri, 24 Apr 2020 04:23:56 GMT

Hi Hassan
According to the installation production, only Java 8 or 11 are supported Java environment.
https://help.talend.com/reader/K6MGfX3FuK5RGGq5JMB3mA/GftTLST2kdZyupgpc8KkuQ
Please upgrade Java version to 11 and test again.

Regards
Shong

topic Mysql Connection error in Talend Studio

Mysql Connection error

Re: Mysql Connection error

Re: Mysql Connection error

Re: Mysql Connection error