mercredi 20 novembre 2019

Java Web SQL: No suitable driver found for jdbc, but driver is added in project and code works fine local

I'm trying to build dynamic web project i having problem with sql connection. I made connector with database but i can run it.

Here is my code:

package DAO;

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

public class Connect {

private static Connection conn;
private static final String url = "jdbc:mariadb://localhost:3306/web_db";
static final String JDBC_DRIVER = "org.mysql.jdbc.Driver";
private static final String username = "root";
private static final   String password = "1234";

public static void open() {
    try {
        //Class.forName("org.mariadb.jdbc.Driver");
        conn = DriverManager.getConnection(url,username,password);

    } catch (Exception ex) {
        // TODO Auto-generated catch block
        ex.printStackTrace();
    }
}

public static Connection getConnection() {
    return conn;
}
public static void close() {
    try {
        conn.close();
    } catch (SQLException ex) {
        // TODO Auto-generated catch block
        ex.printStackTrace();
    }
}

public static void main(String[] args) {  
    open();  
}  

} 

Now when i run it on server i get error:

No suitable driver found for jdbc:mariadb://localhost:3306/web_db

but i added jar to build path and it's located in WEB-INF folder and when i run this code as Java Application and not on server it works fine, i tried uncommenting

//Class.forName("org.mariadb.jdbc.Driver");

and then got:

java.lang.ClassNotFoundException: org.mariadb.jdbc.Driver

except that i tried replacing "jdbc:mariadb://localhost:3306/web_db"; with "jdbc:mysql://localhost:3306/web_db"; i same error happened also here what i added is my pom.xml:

  <dependencyManagement>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mariadb-java-client</artifactId>
            <version>2.4.4</version>
        </dependency>
    </dependencies>
</dependencyManagement>

Btw i using ubuntu 19.04 and Eclipse EE 4.9.0 and mariadb-java-client-2.4.4.jar




Aucun commentaire:

Enregistrer un commentaire