spring mysql ssl_Spring Boot通过SSL远程连接Mysql

我有一个远程MySQL数据库服务器，需要与我在本地运行的Spring Boot应用程序连接 .

在Spring Boot Applications加载之前，它首先使用远程服务器进行ssh隧道 .

这是首先创建的主应用程序代码，然后启动ssh tunnel然后启动主应用程序 .

public class XXXCoreApplication {

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

Connection connection = null;

Session session = null;

String host = "XX.XXX.XX.XXX";

String servUser = "user";

String servPwd = "pass";

int port = 22;

String rhost = "localhost";

int rport = 3306;

int lport = 3307;

String driverName = "com.mysql.jdbc.Driver";

String db2Url = "jdbc:mysql://localhost:" + lport + "/xxx_core";

String dbUsr = "MT";

String dbPwd = "****";

try {

JSch jsch = new JSch();

// Get SSH session

session = jsch.getSession(servUser, host, port);

session.setPassword(servPwd);

java.util.Properties config = new java.util.Properties();

// Never automatically add new host keys to the host file

config.put("StrictHostKeyChecking", "no");

session.setConfig(config);

// Connect to remote server

session.connect();

// Apply the port forwarding

session.setPortForwardingL(lport, rhost, rport);

// Connect to remote database

Class.forName(driverName);

connection = DriverManager.getConnection(db2Url, dbUsr, dbPwd);

System.out.println("Connection to database established!");

} catch (Exception e) {

e.printStackTrace();

} finally {

if (connection != null && !connection.isClosed()) {

connection.close();

}

if (session != null && session.isConnected()) {

session.disconnect();

}

}

SpringApplication.run(XXXCoreApplication.class, args);

}

}

但是我的application.properties文件是空的，可能是故障点 .

它给了我一个空的application.properties的错误：

“无法确定数据库类型为NONE的嵌入式数据库驱动程序类”

我应该给application.properties中的spring.datasource.url值什么？还是其他任何建议？谢谢 .