TAC - Mysql Driver missing

Highlighted
Six Stars

TAC - Mysql Driver missing

Hi,

 

Trying to set up TAC in centos 7.

unable to get success as the error been pop with Driver not found(see installation guide for more information)

 

Downloaded JDBC driver from below url and installed by still showing error.

https://dev.mysql.com/downloads/connector/j/

 

if someone can provide me the url to download

 

 

image.png

 

Regards,

Arun

 

 

 


Accepted Solutions
Employee

Re: TAC - Mysql Driver missing

You should copy the mysql-connector-java-5.1.38-bin.jar in the /Talend/6.3.1/tac/apache-tomcat/endorsed

 

And then restart the TAC.

 

Talend cannot package these drivers in its installer due to licensing restriction from the driver providers.  Hence, it is a manual install here for the driver.

Employee

Re: TAC - Mysql Driver missing

On Windows: C:\Talend\6.3.1\tac\apache-tomcat\endorsed


All Replies
Moderator

Re: TAC - Mysql Driver missing

Hello,

The error message indicates that Tac cannot find this mysql jdbc driver. Did you install the mysql JDBC driver with correct version?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: TAC - Mysql Driver missing

You should copy the mysql-connector-java-5.1.38-bin.jar in the /Talend/6.3.1/tac/apache-tomcat/endorsed

 

And then restart the TAC.

 

Talend cannot package these drivers in its installer due to licensing restriction from the driver providers.  Hence, it is a manual install here for the driver.

Six Stars

Re: TAC - Mysql Driver missing

Hi,

 

I installed two versions mysql-connector-java-5.1.42 and mysql-connector-java-5.1.30

 

still not working may i know what is the version ?

 

Regards,

Arun

Employee

Re: TAC - Mysql Driver missing

mysql-connector-java-5.1.30 or mysql-connector-java-5.1.38 should work.  You should install just 1 of them at a time.  Not both.  

 

You should have the file in just 1 location.

 

Which version of Talend are you using?

Six Stars

Re: TAC - Mysql Driver missing

Hi iburtally,

 

i asked sabrina which version to be installed. mean while i saw your reply and followed. yes it is working now. Smiley Happy thank you 

 

if windows which folder need to be copied? for future solution

 

thank you so much.

 

Regards,

Arun

Employee

Re: TAC - Mysql Driver missing

On Windows: C:\Talend\6.3.1\tac\apache-tomcat\endorsed

Six Stars

Re: TAC - Mysql Driver missing

Thank youu Smiley Happy

Employee

Re: TAC - Mysql Driver missing

I am also facing similar issue but i tried copied the mysql-connector-java-5.1.30 jar in the "C:\Talend\6.3.1\tac\apache-tomcat\endorsed" . I restarted the TAC but still i am facing the same issue. please assist if any thing needs to be done apart from that.

Employee

Re: TAC - Mysql Driver missing

Place the mysql-connector-java-5.1.30 jar in the "C:\Talend\6.3.1\tac\apache-tomcat\bin" folder too on windows. 

Employee

Re: TAC - Mysql Driver missing

apache-tomcat\lib and in later versions after Tomcat 8.5 or when using Java 9 the endorsed folder support is removed. And what Irshad is correct too do not include duplicate or two drivers with the same class name in your driver folders.

Four Stars

Re: TAC - Mysql Driver missing

Something I came across 5.6.1 to 7.2.1, it was actually after the mysql 8 connector and not the mysql5 one, despite mysql being on version 5. something to keep an eye on, worked fine after restart and migrated db just fine.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download