Four Stars

Not able to make a MySQL DBConnection

Hi,

 

I am new to Talend Open Studio. I am trying to make a DBConnection to my Local MySQL Database for loading the data from an excel to MySQL Table. When i am creating the connection in DB Connection i am getting the below mentioned Error. 

 

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:316)
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:4138)
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: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
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.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2588)
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 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.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:195)
... 9 more
Caused by: java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3307)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1985)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1911)
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)
... 21 more

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: Not able to make a MySQL DBConnection

@Akhil_2517,Can you check the compatibility with Mysql?

 

https://help.talend.com/reader/1V5U6CVzPxVZHFWPIIKB1g/b_qVBTTIBMSa9YR0uV91pg

Manohar B
8 REPLIES
Twelve Stars

Re: Not able to make a MySQL DBConnection

@Akhil_2517,which version of Talend and MySql are you using?

Manohar B
Four Stars

Re: Not able to make a MySQL DBConnection

Hi @manodwhb

Thanks for your time.

 

I am using MySQL version 8.0 and Talend Version 7.0 .

Five Stars

Re: Not able to make a MySQL DBConnection

Hi bro!

 

Can you try do the following steps? and tell me if your MySQLConnection check is okay?

Step 1:

howToGoToDBConnection.JPG

 

Step 2:

DBConnection.JPG

 

If your database connection check ends succesful, you should can use it at your job Smiley Wink

But if not, pls feel free to notice me!

 

Pls, give me some Kudos if my response help you Smiley Very Happy

Thanks for your time and attention <3

Four Stars

Re: Not able to make a MySQL DBConnection

Hi @PataToT,

 

The error which i have mentioned in the request is coming after following this process only.

Five Stars

Re: Not able to make a MySQL DBConnection

Hi bro,
but what about your check connection? I mean if your check connection ends in the bad way, not insist more in try to use that conection cause you're not inserting the good info at your connection
Four Stars

Re: Not able to make a MySQL DBConnection

Hi @PataToT,

 

Sorry if i misunderstood something but , i am able to use this information to create a ODBC connection on my system and that is working fine.

When i am using the same values in the DBConnection and clicking on Test Connection button it is throwing the error.

Twelve Stars

Re: Not able to make a MySQL DBConnection

@Akhil_2517,Can you check the compatibility with Mysql?

 

https://help.talend.com/reader/1V5U6CVzPxVZHFWPIIKB1g/b_qVBTTIBMSa9YR0uV91pg

Manohar B
Four Stars

Re: Not able to make a MySQL DBConnection

Hi @manodwhb,

 

I reinstalled the previous version of my sql and it worked.

 

Thank you.