- Create project "Java with Gradle" -> "Java Application"
- 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> - 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");
}
Dedetok: My Experiences Notes This page contains my experiences using technology. All of information are were working properly on the time when they wrote. You may use them for any purposes.