问题描述
我想写一个java独立应用程序来连接到Google云端的sql - Mysql数据库。我可以找到应用程序客户端的示例,但不能用于独立的Java应用程序。当我尝试这样做时,出现以下错误。
Class.forName(com.mysql.jdbc.Driver);
Connection con = DriverManager.getConnection(jdbc:google:mysql:// IP:Instance_name?user = user_name);
Statement st = con.createStatement();
ResultSet rs = con.createStatement()。executeQuery(SELECT 1 + 1);
失败,错误:
没有为jdbc:google:mysql找到合适的驱动程序:..
我看到一些答案,他们要求启用mysql连接器。但是应用程序引擎项目就是这种情况。我如何使用独立应用程序执行此操作?
您可以使用标准的mysql连接器连接到云端sql实例:例如:
DriverManager.getConnection(jdbc:mysql:// IP:Instance_name?user = user_name);
您可以检查获取更多信息
I want to write a java stand alone application to connect to Google cloud sql - Mysql database. I could find samples for app client but not for stand alone java application.
When I tried to do this, I get the following error.
Class.forName("com.mysql.jdbc.Driver");Connection con = DriverManager.getConnection("jdbc:google:mysql://IP:Instance_name?user=user_name");Statement st = con.createStatement();ResultSet rs = con.createStatement().executeQuery("SELECT 1 + 1");
It fails with error :
No suitable driver found for jdbc:google:mysql:..
I see some answers where they have asked to enabled mysql connector. But it is the case with app engine project. How do I do it with stand alone application?
You can just use the standard mysql connector to connect to cloud sql instance: e.g:
DriverManager.getConnection("jdbc:mysql://IP:Instance_name?user=user_name");
You can check https://cloud.google.com/sql/docs/external for more information
这篇关于从Java独立应用程序连接到Google云端SQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!