{"id":6269,"date":"2022-02-19T15:08:49","date_gmt":"2022-02-19T06:08:49","guid":{"rendered":"https:\/\/www.xenos.jp\/~zen\/blog2\/?p=6269"},"modified":"2022-02-19T15:08:51","modified_gmt":"2022-02-19T06:08:51","slug":"post-6269","status":"publish","type":"post","link":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/2022\/02\/19\/post-6269\/","title":{"rendered":"GAS\u306eDB\u63a5\u7d9a\u3067\u3001\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u3092\u8abf\u3079\u308b"},"content":{"rendered":"\n<p>\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u306e\u300c.getAutoCommit()\u300d\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001DB\u3078\u306e\u66f8\u304d\u8fbc\u307f\u304c\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u8abf\u3079\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>\u300c.getAutoCommit()\u300d\u306e\u7d50\u679c\u304c\u3001True\u306a\u3089\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u3001False\u306a\u3089\u624b\u52d5\u30b3\u30df\u30c3\u30c8\u3002\u624b\u52d5\u30b3\u30df\u30c3\u30c8\u306e\u5834\u5408\u306b\u306f\u3001\u300c.commit()\u300d\u3092\u660e\u793a\u7684\u306b\u5b9f\u884c\u3057\u306a\u3044\u3068\uff24\uff22\u306b\u30b3\u30df\u30c3\u30c8\u3055\u308c\u306a\u3044\u3002<\/p>\n\n\n\n<p>\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  \/\/ DB\u306b\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u3092\u306f\u308b\n  var connection = Jdbc.getConnection(addr, connectionInfo);\n\n  \/\/ \u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u3092\u7121\u52b9\u306b\u3057\u3066\u3001\u624b\u52d5\u3067\u30b3\u30df\u30c3\u30c8\u3059\u308b\u3088\u3046\u306b\u3059\u308b\u3002\n  connection.setAutoCommit(false);\n\n  \/\/ True\u306a\u3089\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u3001False\u306a\u3089\u624b\u52d5\u30b3\u30df\u30c3\u30c8\u3002\u30ed\u30b0\u306b\u66f8\u304d\u51fa\u3059\u3002\n  Logger.log('\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u306e\u8a2d\u5b9a\uff1a\u3000' + connection.getAutoCommit());<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u306e\u300c.getAutoCommit()\u300d\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001DB\u3078\u306e\u66f8\u304d\u8fbc\u307f\u304c\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u8abf\u3079\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002 \u300c.getAutoCommit()\u300d\u306e\u7d50\u679c\u304c\u3001True\u306a\u3089\u30aa\u30fc\u30c8\u30b3\u30df\u30c3\u30c8\u3001F [&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],"tags":[128,49],"class_list":["post-6269","post","type-post","status-publish","format-standard","hentry","category-googleappsscript","tag-gas","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/6269","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=6269"}],"version-history":[{"count":2,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/6269\/revisions"}],"predecessor-version":[{"id":6450,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/6269\/revisions\/6450"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=6269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=6269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=6269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}