topic Re: TAC - Mysql Driver missing in Installing and Upgrading

TAC - Mysql Driver missing

Anonymous — Sat, 16 Nov 2024 09:39:24 GMT

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

Regards,

Arun

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 10:31:28 GMT

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

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 10:50:59 GMT

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.

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 10:51:36 GMT

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

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 11:04:11 GMT

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?

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 11:07:45 GMT

Hi iburtally,

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

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

thank you so much.

Regards,

Arun

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 11:22:48 GMT

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

Re: TAC - Mysql Driver missing

Anonymous — Fri, 09 Jun 2017 17:58:11 GMT

Thank youu

Re: TAC - Mysql Driver missing

Anonymous — Mon, 14 Aug 2017 19:38:41 GMT

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.

Re: TAC - Mysql Driver missing

Anonymous — Fri, 27 Oct 2017 00:18:47 GMT

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

Re: TAC - Mysql Driver missing

Anonymous — Thu, 13 Dec 2018 17:54:04 GMT

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.

Re: TAC - Mysql Driver missing

Anonymous — Fri, 26 Jul 2019 15:02:35 GMT

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.