Spoon Kettle Connection Database failure workaround

Source: Internet
Author: User

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

Just downloaded spoon, ready to write a simple sample test, log in to the database encountered this error, see the error description is unable to find the corresponding Oracle driver, if you install Oracle, then local can find the required driver. Search for "jdbc", usually tangible like ojdbc5.jar,ojdbc5_g.jar files

Ojdbc5.jar (1,996,228 bytes)-Class for JDK 1.5. It contains the JDBC driver class, but does not include the NLS-supported classes in Oracle Object and Collection types.
Ojdbc5_g.jar (3,081,328 bytes)-like Ojdbc5.jar, except that the class is compiled with "Javac-g" and contains trace code.

Specific instructions can refer to Oralce official website description: http://www.oracle.com/technetwork/cn/articles/oem/jdbc-112010-094555-zhs.html

My way is to put the local found Ojdbc.jar files under the Data-integration\libswt\win32, of course, can also be placed in Data-integration\lib and other programs can be found in the location, you can also modify the system environment variables, So that the driver can be found

Remember, to restart spoon, or no matter how you toss, will be an error

Spoon Kettle Connection Database failure workaround

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.