Thursday, May 8, 2025

Eclipse 2025-03 (4.35.0) with JDK 17 add MariaDB Connector/J 3.5 into Project

Download mariadb-java-client-3.5.3.jar from https://mariadb.com/downloads/connectors/connectors-data-access/java8-connector/ 

Open eclipse:

  1. create folder lib
  2. copy mariadb-java-client-3.5.3.jar into [workspace_root]/myca/lib/
  3. open project properties -> Build Path -> Configure Build Path
  4. go to tab Libraries and click Classpath -> Add External JARS, i.e. [Workspace_root]/myca/lib/mariadb-java-client-3.5.3.jar 
  5. apply and close

To test mariadb-client without without Eclipse, write TesCon.java using any editor:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class TesCon {

    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        // TODO Auto-generated method stub
        String muser = "
my_user";
        String mpass = "
my_password";
        String murl = "jdbc:mariadb://localhost:3306/
my_database_name";
        Class.forName("org.mariadb.jdbc.Driver");
        Connection connection = DriverManager.getConnection(murl, muser, mpass);
        System.out.println("ok");
    }

}

Run from command line/terminal

$> javac TesCon.java

$> java -cp ./:./mariadb-java-client-3.5.3.jar TesCon

window:

D:\>javac TesCon.java

D:\>java -cp .\;.\mariadb-java-client-3.5.3.jar TesCon

In Eclipse:

  1. create a new Java Project
  2. optional: create package
  3. add a Class with Name TesCon.java
  4. copy paste the code above. If you create a package, replace all after "package [your_package];"
  5. run project
Every major release eclipse, adding external jar, especially j connector, into eclipse is very painful. Loading mariadb connector j using eclipse is Fail.