无法将Java（Netbeans）连接到MariaDB

Question

/** To change this license header, choose License Headers in Project
 *   Properties.  * To change this template file, choose Tools | Templates 
 * and open the template in the editor.  
 */
package mariadbtest; 

import java.sql.*;


/**
 * 
 * @author AAAA  
 */ 
public class MariaDBTest {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args){  
        try {
            Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
            String url = "jdbc:MariaDB://localhost:3306/customer"; // url to access the DB
            String user = "root";
            String pwd="password";
     
            Connection connection = DriverManager.getConnection(url,user,pwd);
     
            System.out.println("Connected to MariaDB");
        } 
        catch (SQLException e) {
            System.out.println("SQL Exception: "+ e.toString()); 
        } 
        catch (ClassNotFoundException cE) {
            System.out.println("Class Not Found Exception: "+ cE.toString()); 
        }
        catch (Exception ex) {
            System.out.println("Exception: "+ ex.toString()); 
        }

        // TODO code application logic here
    }
}

null

错误：SQL异常：java.SQL.sqlexception：找不到适合JDBC的驱动程序：mariadb：//localhost:3306/customer构建成功（总时间：3秒）

Answer 1

我认为问题在于您使用的MySQL Connector/J JDBC驱动程序带有它无法识别的URL。此URL

    jdbc:MariaDB://localhost:3306/customer

说要从“MariaDB”提供商那里寻找驱动程序。但很明显，MySQL驱动程序并没有（通过SPI）宣传自己是MariaDB驱动程序。

首先你应该摆脱这个：

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

jdbc:mysql://localhost:3306/customer

根据MariaDB文档，MySQL Connector/J驱动程序与MariaDB兼容。但是MySQL Connector/J文档中没有提到在JDBC url中使用“mariadb”。

切换到MariaDB连接器/J驱动程序。根据文档，这应该支持

jdbc:mariadb://localhost:3306/customer

或

jdbc:mysql://localhost:3306/customer