Friday, May 9, 2025

Netbeans 25 with JDK 17 add MariaDB Connector/J 3.5 into Project

Netbeans 25 can be download from https://www.apache.org/dyn/closer.lua/netbeans/netbeans/25/netbeans-25-bin.zip. Extract it, it will create folder netbeans. 

On debian, to run netbeans:

[home_user]\netbeans/bin/netbeans

On window, to run netbeans (windows 64):

[folder]\netbeans\bin\netbeans64.exe

Note: on windows, if you want to clean install remove/delete folder C:\Users\[username]\AppData\Roaming\NetBeans\[any_previous].

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

Add mariadb-java-client-3.5.3.jar into project

  1. create a New Project -> Java with maven -> Java application
  2. in tab Files under your project, create folder libjar
  3. copy mariadb-java-client-3.5.3.jar
  4. in Project -> your project, right click on Dependencies, Add Dependency:
    Group ID: org.mariadb.jdbc
    Artifact ID: mariadb-java-client
    Version: 3.5.3
  5. Scope: Runtime
  6. done. 

Run your database and test your project by editing your java files:

    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");
    }

Add mariadb to Services:

  1. to add mariadb connector j, go to Services -> Right Click Databases -> New Connection.
  2. Select MariaDB (MySQL-compatible).
  3. select jar file.
  4. next.
  5. fill/adjust username, password and database name.
  6. test connection.
  7. if successfull, next.
  8. leave default connection info and finish.

You can manage your mariadb database from Service.