Download mariadb-java-client-3.5.3.jar from https://mariadb.com/downloads/connectors/connectors-data-access/java8-connector/
Open eclipse:
- create folder lib
- copy mariadb-java-client-3.5.3.jar into [workspace_root]/myca/lib/
- open project properties -> Build Path -> Configure Build Path
- go to tab Libraries and click Classpath -> Add External JARS, i.e. [Workspace_root]/myca/lib/mariadb-java-client-3.5.3.jar
- 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:
- create a new Java Project
- optional: create package
- add a Class with Name TesCon.java
- copy paste the code above. If you create a package, replace all after "package [your_package];"
- run project