topic Re: Connection Error -- mysql in Talend Studio

Connection Error -- mysql

Anonymous — Thu, 24 Nov 2016 07:15:06 GMT

Hi,
I am quite new to Talend; I have installed Talend Open Studio v6.1.1 and I am trying to create a connection to mysql DB installed locally in my system. my mysql version is v57. I have insattaled all the additional packages asked by talend (help>install additional packages)
DB Details:
host: localhost
Port: 3306
However, It's throwing below error:
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.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.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:121)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:146)
... 9 more

Could someone please advise on this?

Thanks

Re: Connection Error -- mysql

Anonymous — Thu, 24 Nov 2016 07:21:45 GMT

Hi,
Talend Studio requires specific third-party Java libraries or database drivers (. jar files) to be installed to connect to sources and targets. Those libraries or drivers, known as external modules, can be required by some of Talend components or by some connection wizards or by both . Due to license restrictions, Talend may not be able to ship certain external modules within Talend Studio .
Please take a look at documents about:TalendHelpCenter:Identify required external modules and TalendHelpCenter:Install external modules.
Best regards
Sabrina

Re: Connection Error -- mysql

Anonymous — Thu, 24 Nov 2016 09:03:14 GMT

Hi,

Appreciating your quick response.
From your reply, I infer that, the Open source pack of Talend does not hold the license to download external (may be some of the) drivers/modules. I have gone through the links given and tried to download from Help>Instal Additional Packages, but it throws "Time out" issues for many downloads, a few got successful though; so I may need to buy a fledged version, correct?

Cheers,
Sreekumar

Re: Connection Error -- mysql

Anonymous — Thu, 24 Nov 2016 09:46:57 GMT

Hi,

Due to license restrictions, Talend may not be able to ship certain external modules within Talend Studio.

Actually, we are talking about Apache License.
Is your network Ok with you? Are you working behind proxy?
Some modules are not available on the Talend website but can be downloaded directly from external websites. Once downloaded, these modules must be placed in specific folders. For the studio, the downloaded modules must be placed in the following folder:<StudioPath>/configuration/.m2

Best regards
Sabrina

Re: Connection Error -- mysql

Anonymous — Wed, 21 Dec 2016 09:17:06 GMT

Hi,
How can i connect to a remote MySQL server in Talend over SSH? A "Connection Failure" was encountered when trying to connect to the remote server. I was able to connect it though via MySQL instance with the correct SSH key.

Re: Connection Error -- mysql

Anonymous — Wed, 21 Dec 2016 09:36:08 GMT

Hi AntonioOna,
Could you please take a look at the solution mentioned in this topic: https://community.talend.com/t5/Design-and-Development/How-to-create-DB-Connection-over-SSH/td-p/188148 to see if it works?
Best regards
Sabrina

Re: Connection Error -- mysql

Anonymous — Wed, 21 Dec 2016 10:08:41 GMT

Hi,
No it did not. i still got the same error. what i am trying to achieve here is to add a new mysql connection in talend.

Re: Connection Error -- mysql

Anonymous — Thu, 22 Dec 2016 03:15:28 GMT

Hi,
So far, MySql components just support for jdbc connection not SSH tunneling.

Best regards
Sabrina