[resolved] TAC AMC: JDBC Driver class not found

Highlighted
Four Stars

[resolved] TAC AMC: JDBC Driver class not found

Hi all,
I created this post because i have an error on our TAC (TALEND Administrator Center) . Indeed, we installed TALEND 5.5.1 and we have an error on the Activity Monitoring Console: "An error occured (org.hibernate.HibernateException: JDBC Driver class not found: oracle.jdbc.driver.OracleDiver)" . I checked if the ojdbcXX.jar file was here on the server and I found ojdbc14.jar.
Do you know a solution to this issue?
Thank you
Anthony

Accepted Solutions
Highlighted
One Star

Re: [resolved] TAC AMC: JDBC Driver class not found

Hello Guys, 
Pasting the Jar in  tomcat\webapps\org.talend.administrator\WEB-INF\lib  Worked Well for me. 
On a customer site installing right now. good that you were around and posting things. 
I can confirm that it worked after that. 

View solution in original post


All Replies
Highlighted
Moderator

Re: [resolved] TAC AMC: JDBC Driver class not found

Hi,
Could you please put ojdbc14.jar into tomcat\webapps\org.talend.administrator\WEB-INF\lib and restart Talend Administration Center to see if it is OK?
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.
Highlighted
Four Stars

Re: [resolved] TAC AMC: JDBC Driver class not found

Hi,
Thank your answer but I always have same error Smiley Sad
Best Regards
Anthony
Highlighted
Moderator

Re: [resolved] TAC AMC: JDBC Driver class not found

Hi,
Did you download the corresponding jar for your current oracle JDK(keep consistency)?
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.
Highlighted
Four Stars

Re: [resolved] TAC AMC: JDBC Driver class not found

Hi,
Our TALEND server was installed with JDK 1.7 x64. We should used ojdbc7.jar.
This morning, I changed our ojdbc14.jar by ojdbc7.jar and I restarted all services TALEND.
However, there is no change. We already have same error!!!
In addition, we have no data in Activity Monitoring Console (The database connection is OK and we have data in three tables TA_LOG/TA_FLOW/TA_STAT).
Best Regards
Anthony
Highlighted
Moderator

Re: [resolved] TAC AMC: JDBC Driver class not found

Hi atalent,
We would suggest you report a ticket on Talend Support Portal , so that we can give you a remote assistance through support cycle.
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.
Highlighted
One Star

Re: [resolved] TAC AMC: JDBC Driver class not found

Hello Guys, 
Pasting the Jar in  tomcat\webapps\org.talend.administrator\WEB-INF\lib  Worked Well for me. 
On a customer site installing right now. good that you were around and posting things. 
I can confirm that it worked after that. 

View solution in original post

Highlighted
Employee

Re: [resolved] TAC AMC: JDBC Driver class not found

tomcat\webapps\org.talend.administrator\WEB-INF\lib makes the driver availlble for the org.talend.administrator webapp instead of the tomcat/lib folder which will make the jdbc driver available for all webapps with older versions of AMC after 6.5.1 then you will need to place the driver under the AMC webapp itself under a similar path:

 

/amc/eclipse/plugins/org.talend.amc.libraries_X.X.X.XXXXXXXX_XXXX/lib

 

Talend Big Data Installation Guide for Linux 7.0.1 Example of this documentation for newer versions of AMC

https://help.talend.com/reader/f7Em9WV_cPm2RRywucSN0Q/bhg4GkOyeXwayVJvv4kuEw

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog