Why I obtain this SQLException (No suitable driver) when I try to create a Connection object for an Oracle database?

Question

I have to create a very simple batch Java application (an application that run into shell) and that perform some query on an Oracle database using JDBC and I never done it.

I am following this tutorial: http://www.ntu.edu.sg/home/ehchua/programming/java/JDBC_Basic.html

So I have done in this way to allocate a new Connection object for my application:

import java.sql.*;

public class Main {

    public static void main(String[] args) {
        System.out.println("Hello World !!!");

        String partitaIVA = args[0];
        String nomePDF = args[1];

        Connection conn = null;
        Statement  stmt = null;

        try {
            // Step 1: Allocate a database "Connection" object
            conn = DriverManager.getConnection("jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:eme1", "myUserName", "myPswd"); // Oracle DB

        } catch(SQLException ex) {
            ex.printStackTrace();
        }
    }
}

The problem is that when I run the application it seems that the SQLException is thrown because enter into the catch block and print the following error message in the console:

java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:eme1
    at java.sql.DriverManager.getConnection(DriverManager.java:602)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at Main.main(Main.java:16)

Why? What cause this problem and how can I fix this issue? What am I missing?

Tnx

the supplied link looks like it has some discrepancy, look at the last section of the tutorial, it says, first step is to register driver(which is the prefered step), while the example provided doesn't register any Driver, it directly asking for connection !! — ppuskar, Feb 11 '15 at 10:27

score 1 · Answer 1 · edited May 23 '17 at 12:06

1

You need to have an appropriate ojdbc.jar in you classpath. E.g. see Oracle JDBC ojdbc6 Jar as a Maven Dependency

The problem should be that the linked tutorial describes how to connect to a Mysql, but you're trying to connect to an oracle - therefore you need the oracle driver in your classpath.

edited May 23 '17 at 12:06

Community

1
1

answered Feb 11 '15 at 09:46

Alexander

2,925
3
33
36

Ok but I am not using Maven at this time, where can I download this jar? – AndreaNobili Feb 11 '15 at 09:48
Google "site:oracle.com ojdbc download" and choose the appropriate version (depends on which oracle version you want to connect to: 10 or 11G,...) – Alexander Feb 11 '15 at 09:50

score 1 · Answer 2 · answered Feb 11 '15 at 09:46

1

How about following oracle's documentation for its Driver. http://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html

In the above code, you didn't registered the driver class.

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

answered Feb 11 '15 at 09:46

ppuskar

773
6
9

score 0 · Answer 3 · answered Feb 11 '15 at 09:58

If you are following instructions from the given link. In chapter 2.2 you have instructions how to instal MySql drivers. If you are using an Oracle database, then you'll need to instal Oracle JDBC drivers.

If you don't want affect your JDK installation like in tutorial, you can load driver dynamicaly

Why I obtain this SQLException (No suitable driver) when I try to create a Connection object for an Oracle database?

3 Answers3