Java: Problem with Code for Database Connection

Question

I want to compile this Java Code. so I can connect myself to a local Oracle database. But my code doesn't work correcty. It fails at:

Driver myDriver = new oracle.jdbc.driver.OracleDriver();

Could you please tell me how i replace this line ?

package DB_Oracle_Connection;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;

public class dbconf {

private String connstr;
private Connection connect;
public Connection getConnection() throws SQLException {
        connstr = "jdbc:oracle:thin:@localhost:1521:orcl";

        try {
                String uname = "scott";
                String pass = "tiger";

                Driver myDriver = new oracle.jdbc.driver.OracleDriver();
                DriverManager.registerDriver( myDriver );                  


                connect = DriverManager.getConnection(connstr, uname, pass);

        } catch (Exception e) {
            System.out.println(e.toString());
        }

            return connect;
    }
}

As suggested by @ShivamPuri, add the stacktrace of the error from the application log. — A. Wolf
– A. Wolf, Commented Jan 16, 2020 at 11:54

Datta Diware · Accepted Answer · 2020-01-16 11:55:17Z

1

Driver's class path should be oracle.jdbc.OracleDriver() whereas you have written it as oracle.jdbc.driver.OracleDriver()

answered Jan 16, 2020 at 11:55

Datta Diware

6121 gold badge6 silver badges16 bronze badges

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

1 Comment

user12467638 Over a year ago

I have change thje value to Driver myDriver = oracle.jdbc.OracleDriver(); But the problem is the same.

Lakshman · Accepted Answer · 2020-01-16 11:42:38Z

0

Use Class.forName to load the driver. See the below code.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Dbconf {

    private String connstr;
    private Connection connect;

    public Connection getConnection() throws SQLException {
        connstr = "jdbc:oracle:thin:@localhost:1521:orcl";

        try {
            String uname = "scott";
            String pass = "tiger";

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

            connect = DriverManager.getConnection(connstr, uname, pass);

        } catch (Exception e) {
            System.out.println(e.toString());
        }

        return connect;
    }

answered Jan 16, 2020 at 11:42

Lakshman

4797 silver badges14 bronze badges

3 Comments

user12467638 Over a year ago

I have changed my code Class.forName("oracle.jdbc.driver.OracleDriver"); This solves my complilation problem. But when i execute my program i get the error java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Lakshman Over a year ago

Add below JAR to your classpath. java2s.com/Code/Jar/o/Downloadojdbc6jar.htm

user12467638 Over a year ago

Hello I had to add ojdbc8.jar in eclipse for my project. Now I can connect to my database. Thank you !

Collectives™ on Stack Overflow

Java: Problem with Code for Database Connection

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related