import java.sql.*;

public class MariaDBTest {

	static Connection con;

	public static void main(String[] args) throws Exception {

		Class.forName("org.mariadb.jdbc.Driver");

		//Class.forName("com.mysql.jdbc.Driver");

		String dbUrl = "jdbc:mysql://localhost:3306/";

		con = DriverManager.getConnection(dbUrl, "root", "root");

		System.out.println("Connected to " + dbUrl);

		exec("CREATE DATABASE IF NOT EXISTS test");

		exec("USE test");

		exec("DROP TABLE IF EXISTS `test1`");

		exec("CREATE TABLE `test1` (`col1` varchar(50))");

		exec("INSERT INTO `test1` VALUES ('\\'a')"); //works

		exec("INSERT INTO `test1` VALUES ('\\'')");  //does not works

		con.close();

		System.out.println("Exiting with no errors");

	}

	static void exec(String sql) throws SQLException {

		System.out.println("sql: "+sql);

		// error occurs only with prepared statement 

		//con.createStatement().executeUpdate(sql);

		con.prepareStatement(sql).executeUpdate();

	}

}