Netbeans: using maven to connect to mariadb

1. Create project "Java with Maven" -> "Java Application"
2. Under tab "Project" -> Project Files, edit pom.xml and add mariadb jconnect client
   <?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
...
  <dependencies>
...
  <dependency>
    <groupId>org.mariadb.jdbc</groupId>
    <artifactId>mariadb-java-client</artifactId>
    <version>3.5.3</version>
    </dependency>
  </dependencies>
...
</project>
3. Test connection using this code
     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");
  }

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

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.