Please help me, I have no idea how to connect with cloud sql on eclipse !!
심건우
Here is code and error message
<code>
package com.google.cloud.sql.mysql.conv;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class HelloAppEngine {
public static void main(String[] args) throws IOException, SQLException {
String instanceConnectionName = "convenience-205510:asia-east1:convenience";
String databaseName = "conv";
String username = "root";
String password = "";
//[START doc-example]
String jdbcUrl = String.format(
"jdbc:mysql://google/%s?cloudSqlInstance=%s"
+ "&socketFactory=com.google.cloud.sql.mysql.SocketFactory&useSSL=false",
databaseName, instanceConnectionName);
Connection connection = DriverManager.getConnection(jdbcUrl, username, password);
//[END doc-example]
try (Statement statement = connection.createStatement()) {
ResultSet resultSet = statement.executeQuery("SHOW TABLES");
while (resultSet.next()) {
System.out.println(resultSet.getString(1));
}
}
}
}
<error message>
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:mysql://google/conv?cloudSqlInstance=convenience-205510:asia-east1:convenience&socketFactory=com.google.cloud.sql.mysql.SocketFactory&useSSL=false
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at com.google.cloud.sql.mysql.conv.HelloAppEngine.main(HelloAppEngine.java:21)
How can i solve this problem ??
