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.

42 comments :

mary Brown said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java Online Training in India . Nowadays Java has tons of job opportunities on various vertical industry.

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

rutmanaish said...

Really informative blog for all people. Thanks for sharing it.
Spoken English Classes in Chennai
Spoken English in Chennai
Data Analytics Courses in Chennai
IELTS Coaching centre in Chennai
Japanese Language Classes in Chennai
TOEFL Classes in Chennai
Spoken English Classes in Tambaram
Spoken English Classes 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

chintu said...

I read this blog, Nice article...Thanks for sharing waiting for the next...
C C++ Training in Chennai
c++ class
c c++ course fee
c++ course fees
C Language Training
javascript training in chennai
core java training in chennai
Html5 Training in Chennai
DOT NET Training in Chennai
QTP 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

sanjandevan said...

Informative content,thanks for sharing...waiting for next update...
javascript training in chennai
javascript course in chennai
javascript training institute in chennai
javascript training in Thiruvanmiyur
javascript training in Tambaram
javascript training in chennai
core java training in chennai
Photoshop Classes in Chennai
Manual Testing Training in Chennai
Drupal Training in Chennai

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

Karuna said...

Nice blog thanks for sharing It’s time you got the number 1 gardening service in Chennai. Find exotic plants and aromatic flowers at the best price at Karuna Nursery Gardens - the home for high quality organic greenery.
plant nursery in chennai
rental plants in chennai
corporate gardening service in chennai

Pixies said...

Excellent blog thanks for sharing Setting up a successful salon means that you need the best wholesale cosmetics suppliers in Chennai to back up your brand. With hundreds of exclusive international brands and down to earth service, Pixies Beauty Shop is your destination to success.
Cosmetics Shop in Chennai

Nannie Co Pam said...

Great Article. Thank you for sharing! Really an awesome post for every one.

IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training 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

Indpac said...

Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.

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


deiva 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.
web designing training in chennai

web designing training in omr

digital marketing training in chennai

digital marketing training in omr

rpa training in chennai

rpa training in omr

tally training in chennai

tally training in omr

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

jeni said...

Thank you so much for sharing these amazing tips. I must say you are an incredible writer, I love the way that you describe the things. Please keep sharing.
angular js training in chennai

angular js training in velachery

full stack training in chennai

full stack training in velachery

php training in chennai

php training in velachery

photoshop training in chennai

photoshop training in velachery


sathishkumar 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

Post a Comment

UA-46724997-1