{"id":4697,"date":"2020-11-15T22:19:03","date_gmt":"2020-11-15T13:19:03","guid":{"rendered":"https:\/\/www.xenos.jp\/~zen\/blog2\/?p=4697"},"modified":"2020-11-15T22:19:05","modified_gmt":"2020-11-15T13:19:05","slug":"post-4697","status":"publish","type":"post","link":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/2020\/11\/15\/post-4697\/","title":{"rendered":"GAS\u304b\u3089JDBC\u3067Cloud SQL\u306b\u63a5\u7d9a\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u63a5\u7d9a\u304c\u78ba\u7acb\u3067\u304d\u306a\u3044"},"content":{"rendered":"\n<p>GAS\uff08Google Apps Script\uff09\u304b\u3089\u3001Cloud SQL\u306b\u63a5\u7d9a\u3092JDBC\u304b\u3089\u884c\u3063\u305f\u306e\u3060\u304c\u3001\u4e0b\u8a18\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u63a5\u7d9a\u3067\u304d\u306a\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Exception: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u3092\u78ba\u7acb\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u63a5\u7d9a\u6587\u5b57\u5217\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/code><\/pre>\n\n\n\n<p>\u63a5\u7d9a\u5148\u306e\u74b0\u5883\u306f\u3001Cloud SQL\uff08Google Cloud Platform SQL\uff09\u4e0a\u3067\u65b0\u3057\u304f\u4f5c\u3063\u305f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3067\u3001\u7b2c2\u4e16\u4ee3\u3067\u3001MySQL8.0\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3002<\/p>\n\n\n\n<p>GAS\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3068\u3057\u3066\u306f\u3001\u4e0b\u8a18\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function dbConn() {\n  var dbConnectName = \"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d:us-central1:\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\"; \/\/ GCP\u4e0a\u3067\u8868\u793a\u3055\u308c\u308b\u63a5\u7d9a\u540d\n  var user = \"\u30e6\u30fc\u30b6\u540d\";\n  var password = \"\u30d1\u30b9\u30ef\u30fc\u30c9\";\n  var dbName = \"DB\u540d\";\n  \n  var conURL = \"jdbc:google:mysql:\/\/\" + dbConnectName + \"\/\" + dbName;\n  Logger.log(conURL);\n  \n  var dbCon = Jdbc.getCloudSqlConnection(conURL, user, password);\n  Logger.log(dbCon.getCatalog());\n  \n  return dbCon;\n}<\/code><\/pre>\n\n\n\n<p>\u3044\u308d\u3044\u308d\u3068\u8abf\u3079\u3066\u3001JDBC\u306e`Jdbc.getConnection`\u3067\u3082\u8a66\u3057\u305f\u304c\u3001\u63a5\u7d9a\u3067\u304d\u305a\u3002<\/p>\n\n\n\n<p>\u539f\u56e0\u3068\u3057\u3066\u3001\u308f\u304b\u3063\u305f\u3053\u3068\u306f\u3001GAS\u304b\u3089\u547c\u3073\u51fa\u3055\u308c\u308bJDBC\u306f\u3001MySQL8.0\u3078\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3078\u306e\u63a5\u7d9a\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3002MySQL5.7\u3067\u65b0\u3057\u304f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u308a\u76f4\u3057\u3066\u3001`Jdbc.getCloudSqlConnection`\u3092\u884c\u3063\u305f\u3068\u3053\u308d\u3001\u3042\u3063\u3055\u308a\u3068\u63a5\u7d9a\u3067\u304d\u305f\u3002<\/p>\n\n\n\n<p>\u307e\u3055\u304b\u3001JDBC\u304c\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u3068\u306f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>GAS\uff08Google Apps Script\uff09\u304b\u3089\u3001Cloud SQL\u306b\u63a5\u7d9a\u3092JDBC\u304b\u3089\u884c\u3063\u305f\u306e\u3060\u304c\u3001\u4e0b\u8a18\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u63a5\u7d9a\u3067\u304d\u306a\u3044\u3002 \u63a5\u7d9a\u5148\u306e\u74b0\u5883\u306f\u3001Cloud SQL\uff08Google Cloud Platform S [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[98,85],"tags":[128,184],"class_list":["post-4697","post","type-post","status-publish","format-standard","hentry","category-googleappsscript","category-hangoutschat","tag-gas","tag-gcp"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/4697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/comments?post=4697"}],"version-history":[{"count":1,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/4697\/revisions"}],"predecessor-version":[{"id":4698,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/4697\/revisions\/4698"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=4697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=4697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=4697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}