Pentaho Common Errors : Driver class 'oracle.jdbc.driver.OracleDriver' could not be found

Error Message

Error connecting to database [ORA_TEST_JDBC] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.
oracle.jdbc.driver.OracleDriver


org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.
oracle.jdbc.driver.OracleDriver

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.net.URLClassLoader$1.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.net.URLClassLoader.findClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at java.lang.ClassLoader.loadClass(Unknown Source)
 at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:467)


Resolution

1) Download latest oracle jdbc driver.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
ojdbc6 used here for demo purpose.

2) Copy "ojdbc6.jar" to folder
    /pentaho/server/data-integration-server/tomcat/webapps/pentaho-di/WEB-INF/lib/

3) Copy "ojdbc6.jar" to folder
    /pentaho/design-tools/data-integration/lib

4) Restart Spoon.

20 comments :

Tech Guy said...

for data science training in bangalore, visit:
Data Science training in bangalore

rutmanaish said...
This comment has been removed by the author.
Tech News said...

Nice Blog
Visit for the BEST IOT Training in Bangalore

Tech News said...

Visit-Devops training in bangalore

subhashini said...


This post is so interactive and informative. Thanks for sharing this post. keep update more informations...
IELTS Coaching in Chennai
IELTS Coaching centre in Chennai
IELTS coaching centre in coimbatore
IELTS coaching in madurai
IELTS Training in madurai
IELTS Training centre in madurai
Best IELTS Coaching in madurai
Tally course in madurai

Tech News said...

For Hadoop Training in Bangalore Visit:
Big Data and Hadoop Training in Bangalore

Tech News said...

For devops training in Bangalore Visit :
Devops Training in Bangalore

pavithra dass said...

Thanks for sharing such a nice info.I hope you will share more information like this. please keep on sharing!
RPA Training in Chennai
RPA Training in Chennai
RPA Training in Bangalore
Robotics Classes in Coimbatore
Robotics Courses in Coimbatore
Robotics Courses in Bangalore
RPA Classes in Chennai

Adhuntt said...
This comment has been removed by the author.
Adhuntt said...

Great blog thanks for sharing The world around is changing at turbo speed. With digital marketing companies booming up at every corner, it can be hard to decide which is the best place for you to begin your online marketing journey. If you are based in Chennai, the answer is plain simple - Adhuntt Media has the best team that cover all your branding needs - SEO, Graphic Design, Logo Design, Social Media Marketing, Google Ads, Competitor Analysis and much more. Get started with Adhuntt Media
digital marketing company in chennai
seo service in chennai
web designing company in chennai
social media marketing company in chennai

Jayalakshmi said...

i wish more writers of this sort of substance would take the time you did to explore and compose so well. I am exceptionally awed with your vision and knowledge. eleganteduc.netlify.com


Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery

bill.wood said...

Thus, to get successfully self employed, one must update the applications of the discipline and anticipate emerging demands. machine learning institute in hyderabad

rocky said...

I'm impressed in your blog. such a nice content.
Python Training in Chennai

Python Training in Bangalore

Python Training in Hyderabad

Python Training in Coimbatore

Python Training

python online training

python flask training

python flask online training

Aishu said...

Very useful information about Data science.Thank you so much for sharing.
IELTS Coaching in chennai

German Classes in Chennai

GRE Coaching Classes in Chennai

TOEFL Coaching in Chennai

spoken english classes in chennai | Communication training


Jayalakshmi said...

I am impressed with your work which you have done in this article. Your article is very informative and useful.
sap training in chennai

sap training in tambaram

azure training in chennai

azure training in tambaram

cyber security course in chennai

cyber security course in tambaram

ethical hacking course in chennai

ethical hacking course in tambaram

shiny said...

It is so interactive and informative. Thanks for sharing this post. keep update more informations...


sap training in chennai

sap training in annanagar

azure training in chennai

azure training in annanagar

cyber security course in chennai

cyber security course in annanagar

ethical hacking course in chennai

ethical hacking course in annanagar

Mohd Sharique said...

Wow! Such an amazing and helpful post this is. I really really love it. I hope that you continue to do your work like this in the future also.

Big Data Training Institute in Pune
Big Data Analytics Training in Pune

Aishwariya said...

Thanks for posting the best information and the blog is very helpful.Amazon Web Services Training in Chennai

Technogeekscs said...

Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.

Best AWS Training in Pune

Hi Every One said...

Microsoft Office 2019 Crack (Mac) Product Key fully Activated brings out the latest templates and designs for all its apps. Crack Office 2019

Post a Comment

UA-46724997-1