I got error named no suitable driver?

Question

I couldn't find out why it shows error. I have created table named books in Oracle priorly.

create table books(num number);

Then I wrote code in Java:

Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(
    "jdbc:oracle:thin:@CF:1521:orcl",
    "scott",
    "tiger");
Statement s=con.createStatement();
s.execute("INSERT INTO BOOKS VALUES(123)");
s.close();
con.close();

It shows error as "No suitable driver"

can you please ident your code by 4 spaces or mark it and press CTRL+K. It'll be easier to read. — user85421, Jan 12 '10 at 12:06

score 3 · Answer 1 · answered Jan 12 '10 at 07:01

3

It seems that the oracle driver (v 1.6) is actually "called":

oracle.jdbc.OracleDriver

answered Jan 12 '10 at 07:01

Bozho

554,002
136
1,025
1,121

score 0 · Answer 2 · answered Jan 12 '10 at 06:57

0

You need to set your classpath to point to the jar file. The one I used years ago was "ojdbc14.jar". Find the one suitable for you here.

answered Jan 12 '10 at 06:57

shinkou

4,973
1
18
28

score 0 · Answer 3 · answered Jan 12 '10 at 07:22

If you are executing code from command line - make sure that the classpath is set using either $CLASSPATH environment variable or command line argument -cp [pathTo:]ojdbc14.jar or setting the ClassPath: attribute in Manifest.mf of the current executing jar

With Eclipse IDE : Check in the build path the presence of jar / or if build issues exist - check for them in the problems tab.

The version of the jar file (which can be determined from Manifest.mf file) will confirm if you are using the right package for the driver Check if your jar is not corrupt by doing a simple jar -tvf.

score 0 · Answer 4 · answered Jan 12 '10 at 14:10

It shows error as "No suitable driver"

You apparently did System.out.println(e.getMessage()) instead of a e.printStackTrace(). Then you will indeed get that little information. But this message is recognizeable as being a SQLException which can basically have two causes:

The driver is not loaded.
The (wrong) JDBC URL didn't return true for Driver#acceptsURL() for any of the loaded drivers.

To fix 1, you need to ensure that you have a

Class.forName("com.example.jdbc.Driver");

in your code prior to DriverManager#getConnection() call and that you do not swallow/ignore any ClassNotFoundException which can be thrown by it by putting for example an empty catch block or just doing a System.out.println() instead of throwing it.

To fix 2, you need to ensure that the JDBC URL syntax conforms the one as specified in the JDBC driver documentation. In case of Oracle it is located here. Here's a quote:

In JDBC all url's begin with jdbc:protocol: This is the standard. After this is driver specific, and no two drivers are the same.

What is the form of a URL?

The general form of a URL is
jdbc:oracle:<drivertype>:<username/password>@<database>
The <drivertype> is one of

thin

oci

kprb

The <username/password> is either empty or of the form <username>/<password>

In your specific case, the URL looks okay, so you might have not loaded the right driver or plain ignored the ClassNotFoundException thrown by it.

Thank you for your detailed answer Note: ojdbc drivers for Oracle are now to be found @"**oracle.jdbc.OracleDriver**" (rather than "oracle.jdbc.driver.OracleDriver") in ojdbc5 or ojdbc6 libraries according to your JVM. — David SCHERRER, Mar 16 '12 at 14:03

I got error named no suitable driver?

4 Answers4