TestingDocs.com
    Software Testing website
    • Automation
      • Selenium
      • JBehave Framework
    • Tutorials
      • MySQL Tutorials
      • Testlink
      • Maven
      • Git
    • IDEs
      • IntelliJ IDEA
      • Eclipse
    • Flowcharts
      • Flowgorithm
      • Raptor
    • About

    JDBC

    Configure JDBC Driver in Java Project

    Overview

    Let’s learn the steps involved to configure JDBC Driver in a standalone Java Project using Eclipse IDE. In this article, we will configure the Oracle database JDBC Thin driver.

    Download JDBC Driver

    We can download the official and suitable JDBC thin driver from the database vendor’s website. There are different types of drivers to choose from to connect to the database.

    Types of JDBC Drivers:

    https://www.testingdocs.com/types-of-jdbc-drivers/

     

    For example, ojdbc<version>.jar is a JDBC driver for the Oracle database. Oracle database JDBC driver URL:

    https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

    Alternatively, we can find the JDBC driver under the following directory on the database machine.

    Windows:

    %ORACLE_HOME%\jdbc\lib

    Configure JDBC Driver

    JDBC driver should be set up and added to the project build path. The steps to configure in Eclipse IDE are as follows:

    Right-click on the project in the Eclipse IDEĀ  and choose the menu option ->> Build path ->> Configure Build Path..

     

    Configure Build Path Eclipse

    Choose the Java Build Path ->> Click on the Classpath

     

    JDBC Java Build Path Add Jar

    Click Add External JARs… ->> Browse to the JDBC driver location and Select the JDBC driver ->> Open

     

    Add JDBC Driver Classpath Eclipse

    Click the Apply and Close button to close the window.

    This should resolve the JDBC-related errors in the IDE editor. That’s it. We have successfully configured the JDBC driver in the project.

    —

    Java Tutorials

    Java Tutorial on this website:

    https://www.testingdocs.com/java-tutorial/

    For more information on Java, visit the official website :

    https://www.oracle.com/java/

    More information about Oracle Database:

    https://www.oracle.com/database/

    Related Posts

    tnsnames File Oracle TestingDocs

    JDBC /

    Connect to Oracle Database using JDBC Thin Driver

    Display Oracle Database Table JDBC

    JDBC /

    Display data from Oracle Database table using JDBC

    JDBC API TestingDocs

    JDBC /

    JDBC API Components

    JDBC /

    JDBC ResultSet Interface

    JDBC DriverManager Class

    JDBC /

    JDBC DriverManager Class

    ‹ JDBC DriverManager Class› JDBC ResultSet Interface

    Recent Posts

    • Running Tests in Parallel with Selenium Grid
    • Advanced Selenium Features
    • Locating Web Elements
    • Running the Test Script
    • Writing Your First Selenium Test Script
    • Getting Started with Selenium Automation Testing
    • Setting Up the Environment
    • How can you monitor the Quality Assurance Audit?
    • Leveraging LambdaTest with Appium 2.0
    • Appium 2.0 Plugins ListAppium 2.0 Plugins
    • Touch Actions and Multi-Touch Actions
    • Changes in Drivers and Classes
    • Appium Inspector
    • Capabilities in Appium 2.0
    • Appium 2.0 Driver ListAppium 2.0 Driver Installation & Management
    CyberLink Multimedia Software

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com