java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver when using Maven Dependency

Question

        <dependency>
            <groupId>org.apache.tomcat</groupId>
            <artifactId>tomcat-jdbc</artifactId>
            <version>7.0.47</version>
        </dependency>

Above is the maven dependency I'm using.

    PoolProperties p = new PoolProperties();

    p.setUrl("jdbc:oracle:thin:@//ip:port:ora11g");
    p.setDriverClassName("oracle.jdbc.OracleDriver");
    p.setUsername("un");
    p.setPassword("pw");
    p.setJmxEnabled(true);
    p.setTestWhileIdle(false);
    p.setTestOnBorrow(true);
    p.setValidationQuery("SELECT 1");
    p.setTestOnReturn(false);
    p.setValidationInterval(30000);
    p.setTimeBetweenEvictionRunsMillis(30000);
    p.setMaxActive(100);
    p.setInitialSize(10);
    p.setMaxWait(10000);
    p.setRemoveAbandonedTimeout(60);
    p.setMinEvictableIdleTimeMillis(30000);
    p.setMinIdle(10);
    p.setLogAbandoned(true);
    p.setRemoveAbandoned(true);
    p.setJdbcInterceptors(
            "org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"+
                    "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");
    DataSource datasource = new DataSource();
    datasource.setPoolProperties(p);

    Connection con = null;
    try {
        con = datasource.getConnection();
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery("select * from user");
        int cnt = 1;
        while (rs.next()) {
            System.out.println((cnt++)+". Host:" +rs.getString("Host")+
                    " User:"+rs.getString("User")+" Password:"+rs.getString("Password"));
        }
        rs.close();
        st.close();
    } finally {
        if (con!=null) try {con.close();}catch (Exception ignore) {}
    }

And above is my database querying test code snippet.

When I'm executing the program I'm getting "java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver" exception.

I searched for the issue and read that I have to "make sure oracle jdbc jar is in the classpath". I'm not sure why do I have to set it manually or is it actually required.

Yes, it's required. You can't connect to a database without its driver. The driver is the piece of code which knows how to communicate with the database, because every database has its own network protocol, types, etc. — JB Nizet
– JB Nizet, Commented Jan 11, 2020 at 17:40
Why do you think the tomcat-jdbc dependency would give you the Oracle driver? You need to add the dependency for the Oracle JDBC driver as well. — Mark Rotteveel
– Mark Rotteveel, Commented Jan 11, 2020 at 17:42

Joy · Accepted Answer · 2020-01-11 18:10:21Z

2

Use below dependency

<dependency>
    <groupId>com.oracle.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>12.2.0.1</version>
</dependency>

and use below code to connect with your oracle database.

Class.forName("oracle.jdbc.OracleDriver");

String dbURL1 = "jdbc:oracle:thin:{USER}/{PASSWORD}@{URL}:{PORT}:{DBNAME}";
//e.g. String dbURL1 = "jdbc:oracle:thin:tiger/scott@localhost:1521:productDB";
Connection  conn1 = DriverManager.getConnection(dbURL1);
if (conn1 != null) {
    System.out.println("Connected with connection #1");
}

answered Jan 11, 2020 at 18:10

Joy

4243 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Rotteveel Over a year ago

Why should he connect with that code? Using DriverManager instead of a DataSource like the OP does in his code is a bad choice in a web application

Aki T · Accepted Answer · 2020-01-17 06:02:07Z

1

I resolved the issue by adding the corresponding ojdbc.jar to the project.

It can be resolved by adding the mentioned maven dependency too (mentioned by Joy).

answered Jan 17, 2020 at 6:02

Aki T

6662 gold badges8 silver badges21 bronze badges

Comments

Nirmala · Accepted Answer · 2020-01-23 00:07:53Z

0

Note that you can download the 19.3 JDBC drivers from central maven

answered Jan 23, 2020 at 0:07

Nirmala

1,3521 gold badge10 silver badges12 bronze badges

Collectives™ on Stack Overflow

java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver when using Maven Dependency

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related