Java SQL DriverManager unable to locate mariadb driver (IntelliJ IDEA)

Question

I have a maven project where I import the mariadb driver directly from a jar file. I'm making a .jar artifact from this project using IntelliJ IDEA. I'm repeatedly getting a java.sql.SQLException: No suitable driver found for jdbc:mariadb://ip:3306/db error. What changes should I make to my project/setup to make DriverManager recognize the mariadb driver?

pom.xml

<dependency>
  <groupId>org.mariadb.jdbc</groupId>
  <artifactId>mariadb-java-client</artifactId>
  <version>2.7.4</version>
</dependency>

code (note it's not the connection string - I replaced the info)

package com.bremea.packagename.utils;

import java.sql.*;

public class db {

    private static Connection connection = null;

    public static void init() {
        try {
            connection = DriverManager.getConnection("jdbc:mariadb://ip:3306/db", "uname", "pass");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

Do you include the driver classes in the jar? See https://stackoverflow.com/a/42200519/104891. — CrazyCoder, Sep 20 '21 at 20:00
@CrazyCoder I have, the jar file is included in the artifact. — BreMea, Sep 20 '21 at 21:06
Did you extract it inside the jar or did you just copy one jar inside the other one? The latter will not work. — CrazyCoder, Sep 20 '21 at 21:41
@CrazyCoder I extracted it inside the jar. Screenshot: https://bremea.has.rocks/ktt9ilp3o9a — BreMea, Sep 20 '21 at 23:11
Works fine here. Please share the [Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve). — CrazyCoder, Sep 21 '21 at 05:14

score 0 · Answer 1 · answered Sep 20 '21 at 20:34

0

Easily way to include a JDBC driver in your project.

Download connector here.
Copy the file into your project -> lib folder.
Try to compile a code.

answered Sep 20 '21 at 20:34

TheVitik

11
3

score 0 · Answer 2 · answered Sep 20 '21 at 20:42

0

Did you reload project? Right click over the file pom.xml and select reload project, maybe the dependency does not was downloaded

answered Sep 20 '21 at 20:42

Alvaro Gili

25
1
3

I have refreshed, no effect – BreMea Sep 20 '21 at 21:05

Java SQL DriverManager unable to locate mariadb driver (IntelliJ IDEA)

2 Answers2