How do I properly add a mySQL connector in JAVA for JDBC?

Question

error: package com.mysql.cj.jdbc does not exist
import com.mysql.cj.jdbc.MysqlDataSource;

java version: jdk 16 mysql version: 8.0 mysql driver version: 8.0.26

I already put the java connector along with the program files but I still have this error. Here's my code:

import com.mysql.cj.jdbc.MysqlDataSource;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

public class conn {

    private static String servername = "localhost";
    private static String username = "root";
    private static String dbname  = "station_db";
    private static Integer portnumber  = 3306;
    private static String password = "";
    
    public static Connection getConnection()
    {
        Connection con = null;
        
        MysqlDataSource datasource = new MysqlDataSource();
        
        datasource.setServerName(servername);
        datasource.setUser(username);
        datasource.setPassword(password);
        datasource.setDatabaseName(dbname);
        datasource.setPortNumber(portnumber);
        
        try {
            con = datasource.getConnection();
        } catch (SQLException ex) {
            Logger.getLogger(" Get Connection -> " + con.class.getName()).log(Level.SEVERE, null, ex);
        }
        
        return con;
    }
    
}

I haven't done that one I'm sorry I ain't sure about what I'm doing — LokuDesu, Oct 11 '21 at 13:01
Does this answer your question? [What is a classpath and how do I set it?](https://stackoverflow.com/questions/2396493/what-is-a-classpath-and-how-do-i-set-it) — sidgate, Oct 11 '21 at 16:09
I already added the classpath but it still doesn't work what I did is that I added it to my program libraries and it worked. — LokuDesu, Oct 12 '21 at 15:12

score 0 · Accepted Answer · answered Oct 11 '21 at 13:05

You need to list the version of JAVA, mySql, and the mySql driver.

This could be a classpath issue or incompatible versions between the 3 elements listed above or a typo in variable names. Any one of these three should throw this error.

Here is a basic tutorial for JDBC so you can review if you set things up properly.

How do I properly add a mySQL connector in JAVA for JDBC?

1 Answers1