Trouble connecting to MySQL database using my java code

Question

I'm trying to connect to MySQL using the following JAVA code. However, I'm getting an SQLException (connection cannot be established)

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

class Jdbctest {
    public static void main(final String args[]) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            // for establishing connection, cnn is object of connection
            final Connection cnn = DriverManager.getConnection("jdbc:oracle:thin:@//192.68.11.128:1521/orcl");
            System.out.println("connection to db");

        } catch (final ClassNotFoundException e) {
            System.out.println(e);

        } catch (final SQLException e) {
            System.out.println(e);
        }

    }
}

Look at the caught SQLException more closely and tell us e.g. about the exception message, i.e. call sxl.getMessage() and log / print it. — Hille
– Hille, Commented Aug 23, 2015 at 21:09

Amit Bhati · Accepted Answer · 2015-08-23 20:45:12Z

3

You are providing the driver class and connection string of oracle database.
How can you connect with MySQL db.

Use the below tutorial for connecting with MySQL:- http://www.mkyong.com/jdbc/how-to-connect-to-mysql-with-jdbc-driver-java/

answered Aug 23, 2015 at 20:45

Amit Bhati

5,6571 gold badge31 silver badges46 bronze badges

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

Comments

fraser jordan · Accepted Answer · 2015-08-23 21:12:02Z

0

Change

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

To this

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

And this

Connection cnn =DriverManager.getConnection("jdbc:oracle:thin:@//192.68.11.128:1521/orcl");

To this

Connection cnn =
       DriverManager.getConnection("jdbc:mysql:thin:@//192.68.11.128:1521/orcl", "Enter your database username", "Enter your database password");

This is all assumming of course your database is MySQL like you said above

answered Aug 23, 2015 at 21:12

fraser jordan

1142 silver badges10 bronze badges

Comments

Humphrey · Accepted Answer · 2016-11-13 19:00:55Z

This class will help you connect to mysql database. You have to change the database name and if your user is root and password is null then you good to go, else you have to change them also .

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;

public class jdbcConnect {
    public static void main  (String args[]) throws SQLException{
        Connection connection = null ;
    try{
    Class.forName("com.mysql.jdbc.Driver");
    connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabasename","root","");
    JOptionPane.showMessageDialog(null, "We are Connected");
}catch(ClassNotFoundException e){
    e.printStackTrace();

}
    } 

}

Collectives™ on Stack Overflow

Trouble connecting to MySQL database using my java code

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related