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.

36 comments :

sasitamil said...

After reading this web site I am very satisfied simply because this site is providing comprehensive knowledge for you to audience.
Thank you to the perform as well as discuss anything incredibly important in my opinion. We loose time waiting for your next article writing in addition to I beg one to get back to pay a visit to our website in



Selenium training in bangalore
Selenium training in Chennai
Selenium training in Bangalore
Selenium training in Pune
Selenium Online training

Tech Guy said...

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

Madhu Balan said...

I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
Java Training in Chennai
Java Training in Coimbatore
Java Training in Bangalore

Anjudevan said...

Awesome Article...Thanks for sharing...waiting for next update...
Wordpress Training in Chennai
Best Wordpress Training in Chennai
WordPress course
Wordpress Training in Velachery
Wordpress Training in Tambaram
Struts Training in Chennai
clinical sas training in chennai
Spring Training in Chennai
Photoshop Classes in Chennai
LoadRunner Training in Chennai

sultana said...

Really wonderful blog! Thanks for taking your valuable time to share this with us. Keep us updated with more such blogs.
AWS Training in Chennai
AWS Training
AWS Training institute in Chennai
DevOps Training in Chennai
Azure Training in Chennai
VMware Training in Chennai
AWS Training in Velachery
AWS Training in Tambaram
AWS Training in Tnagar
AWS Training in Anna nagar

Riya Raj said...

Wonderful Blog!!! Waiting for your upcoming data... thanks for sharing with us.
Software Testing Training in Chennai
software testing course in chennai
software testing course
software testing training institute in chennai
Software testing training in Velachery
Software testing training in Adyar
Python Training in Chennai
Digital marketing course in chennai
JAVA Training in Chennai

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

Prakash said...

Awesome Post!!! Thanks for sharing this great post with us.
JAVA Training in Chennai
java class
Best JAVA Training in Chennai
JAVA Training in Tnagar
java training in Thiruvanmiyur
Big data training in chennai
Software testing training in chennai
Android Training in Chennai
Selenium Training in Chennai
Python Training in Chennai

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

saathvik kutta said...

This is good information and really helpful for the people who need information about this.
personalized mugs online india
print cup online india
rent laptop chennai
computer rental in chennai
company registration consultants in chennai
private limited company registration 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

Softgen Infotech said...

Such a great information for blogger i am a professional blogger thanks…

Softgen Infotech is a leading training institute for all kind of the Best Software Training in Bangalore with real-time experienced trainers with 100% Placement Assistance.

pavithra dass said...

You have provided a nice article, Thank you very much for this one. And I hope this will be useful for many people. And I am waiting for your next post keep on updating these kinds of knowledgeable things
Android Training in Chennai
Android Course in Chennai
Android Training in Bangalore
Android Course in Bangalore
Android Training in Coimbatore
Android Course in Coimbatore
Android Training in Madurai

Tuhin said...

keep up the good work. this is an Assam post. this to helpful, i have reading here all post. i am impressed. thank you. this is our digital marketing training center. This is an online certificate course
digital marketing training in bangalore / https://www.excelr.com/digital-marketing-training-in-bangalore

shreekavi said...

Admire this blog. Keep sharing more updates like this
Ethical Hacking Course in Chennai
Ethical hacking course in bangalore
Ethical hacking course in coimbatore
Hacking Course in Bangalore
Ethical hacking Training institute in bangalore
Ethical Hacking institute in Bangalore
Ethical Hacking Training in Bangalore
Ethical Hacking in Bangalore
Software Testing Training in Chennai
Ielts coaching in bangalore

technorok said...

This website was... how do I say it? Relevant!! Data Finally I've found something that helped me. Appreciate it!

saran said...

Thanks for sharing the information. It is very useful for my future. keep sharing
Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery

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

praveen said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging
web designing training in chennai

web designing training in porur

digital marketing training in chennai

digital marketing training in porur

rpa training in chennai

rpa training in porur

tally training in chennai

tally training in porur

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

Anonymous said...

python training in bangalore | python online Training
artificial intelligence training in bangalore | artificial intelligence online training
machine learning training in bangalore | machine learning online training
uipath-training-in-bangalore | uipath online training
blockchain training in bangalore | blockchain online training
aws training in Bangalore | aws online training
data science training in bangalore | data science online training

CloudLearn ERP said...

With so much overstated negative criticism of the corporate culture in the media, it is indeed bracing to have an upbeat, positive report on the good things that are happening. Wish to read some more from you!
Data Science training in Mumbai
Data Science course in Mumbai
SAP training in Mumbai

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