Using Java to connect to an Oracle database

Question

This Java code compiles fine, but when I try to run it I get:

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Here is my code:

import java.sql.*;

public class TestConnection {

    public static void main(String[] args) throws Exception {
        //connect to database
        Class.forName("oracle.jdbc.driver.OracleDriver");
        String serverName = "000.000.000.000";
        String portNumber = "1521";
        String sid = "abcd";
        String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
        String username = "user";
        String password = "pass";
        Connection conn = DriverManager.getConnection(url, username, password);
    }
}

How do I get this to work? I am using Ubuntu 11.04 and JDK 6.

Thanks!

You need to download the Oracle JDBC driver and put it on your classpath. — Alex
– Alex, Commented Jun 18, 2012 at 18:50

dcp · Accepted Answer · 2012-06-18 18:53:32Z

9

You need the Oracle jars.

You can get them from here.

edited Jun 18, 2012 at 18:53

answered Jun 18, 2012 at 18:50

dcp

55.7k24 gold badges149 silver badges169 bronze badges

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

3 Comments

Windle Over a year ago

You'll probably want to grab ojdbc6.jar from that link.

bumbleshoot Over a year ago

It says: ojdbc6.jar (2,714,189 bytes) - Classes for use with JDK 1.6. But I have JDK 6??

bumbleshoot Over a year ago

Ah I see, they are the same: oracle.com/technetwork/java/javase/version-6-141920.html

David Caissy · Accepted Answer · 2013-06-06 18:27:33Z

5

If you're using Maven:

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0</version>
</dependency>

answered Jun 6, 2013 at 18:27

David Caissy

2,2596 gold badges25 silver badges28 bronze badges

2 Comments

Rodislav Moldovan Over a year ago

is it still present in mvn repo ?

Pablo Insua Over a year ago

It's not public right now. I had to register previously in the Oracle Maven Repository. More info here: link

David Kroukamp · Accepted Answer · 2012-06-18 19:14:42Z

3

Add ojdbcXX.jar-where XX is version number-to Java build path of your project. Aside from the classpath issue, requesting "oracle.jdbc.driver.OracleDriver" is deprecated. For a long time it has been recommended to use: "oracle.jdbc.OracleDriver". For some more recent driver versions, the former will not even work.

edited Jun 18, 2012 at 19:14

answered Jun 18, 2012 at 18:54

David Kroukamp

36.4k13 gold badges85 silver badges138 bronze badges

2 Comments

bumbleshoot Over a year ago

Why that jar? And where can I get it?

David Kroukamp Over a year ago

Oh no sorry you would use ojdbc6.jar as this is for java 6. (1.6 is the same as 6 naming conventions for java changed). The one i referenced was for java 1.4!

Wottensprels · Accepted Answer · 2012-06-18 18:54:06Z

1

Also, you have to add those jars to your project. @Netbeans, you can easily do that at the project-properties

answered Jun 18, 2012 at 18:54

Wottensprels

3,3273 gold badges31 silver badges39 bronze badges

Collectives™ on Stack Overflow

Using Java to connect to an Oracle database

4 Answers 4

3 Comments

2 Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

2 Comments

Comments

Linked

Related