Copying specific tables of a MySQL database to a MariaDB database in JDBC
Copying specific tables of a MySQL database to a MariaDB database in JDBC I am trying to create a Java programm that copies specific tables from a MySQL database on one server to a MariaDB on another. I know there is mysqldump but the purpose of the program is to be running on different machines, even if they don't habe mysql installed. What I created seems to work well, as the resulting SQL does look correct and executes for example when I connect to the MariaDB with HeidiSQL. But when I execute the sql using .executeQuery , I get an error as response that there is a problem with my SQL. .executeQuery The code is basically: import java.sql.* public class JdbcTest { Connection conn = null; Connection conn_2 = null; Statement stmt = null; Statement stmt_2 = null; //MySQL Class.forName("com.mysql.cj.jdbc.Driver"); //MariaDB Class.forName("org.mariadb.jdbc.Driver"); System.o...