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.

23 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 updates said...

Nice Blog
Visit for the BEST IOT Training in Bangalore

tech updates 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

Post a Comment

UA-46724997-1