Wednesday, December 25, 2013

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.

21 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. 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

    ReplyDelete
  4. 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

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

    ReplyDelete
  6. 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

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

    ReplyDelete
  8. 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

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

    ReplyDelete