{"id":7779,"date":"2022-10-22T16:11:37","date_gmt":"2022-10-22T08:11:37","guid":{"rendered":"http:\/\/123.57.164.21\/?p=7779"},"modified":"2022-10-22T16:11:37","modified_gmt":"2022-10-22T08:11:37","slug":"dbeaver%e7%ae%a1%e7%90%86h2%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=7779","title":{"rendered":"Dbeaver\u7ba1\u7406H2\u6570\u636e\u5e93"},"content":{"rendered":"\n<p>H2\u6570\u636e\u5e93\u662fJava\u7684\u5185\u5d4c\u6570\u636e\u5e93\uff0c\u4f53\u79ef\u5c0f\u5de7\uff0c\u8fd0\u884c\u901f\u5ea6\u5feb\uff0c\u975e\u5e38\u9002\u5408\u7a0b\u5e8f\u5f00\u53d1\u671f\u548c\u5c0f\u6570\u636e\u5e94\u7528\u3002<\/p>\n\n\n\n<p>\u4f46\u662fH2\u6709\u4e2a\u7f3a\u70b9\uff0c\u5c31\u662f\u7cfb\u7edf\u81ea\u5e26\u7684\u6570\u636e\u5e93\u7ba1\u7406\u8f6f\u4ef6\u529f\u80fd\u6bd4\u8f83\u7b80\u5355\uff0c\u5e76\u4e14\u6211\u627e\u4e2a\u51e0\u4e2a\u6570\u636e\u5e93\u7ba1\u7406\u8f6f\u4ef6\u90fd\u65e0\u6cd5\u8fde\u63a5\u4e0aH2\u7684\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<p>\u8fd9\u91cc\u7ed9\u5927\u5bb6\u8bf4\u4e00\u4e2a\u53ef\u4ee5\u7ba1\u7406H2\u7684\u6570\u636e\u5e93\u8f6f\u4ef6\uff0c\u5173\u952e\u8fd8\u662f\u514d\u8d39\u7684\uff0c\u6709\u7eff\u8272\u7248\u672c\u7684\u3002\u540d\u5b57\u5c31\u662fdbeaver\uff0c\u5927\u5bb6\u9700\u8981\u7684\u53ef\u4ee5\u641c\u7d22\u53bb\u5b98\u7f51\u4e0b\u8f7d\uff0c\u6709\u591a\u7cfb\u7edf\u7248\u672c\uff0cWindows\uff0cmacos,linux\u7b49\u7b49\u3002\u652f\u6301\u7684\u6570\u636e\u5e93\u79cd\u7c7b\u4e5f\u5f88\u591a\uff0c\u4f53\u79ef\u4e5f\u4e0d\u5927\uff0c\u5c31\u51e0\u5341M\uff0c\u64cd\u4f5c\u4e5f\u6bd4\u8f83\u7b80\u5355\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-1024x635.png\" alt=\"\" class=\"wp-image-7780\" width=\"521\" height=\"322\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-1024x635.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-300x186.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-768x476.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-830x515.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-230x143.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-350x217.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3-480x298.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-3.png 1258w\" sizes=\"(max-width: 521px) 100vw, 521px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u4e0b\u9762\u76f4\u63a5\u8bf4\u600e\u4e48\u64cd\u4f5c<\/strong><\/p>\n\n\n\n<p><strong>\u7b2c\u4e00\u6b65\uff1a\u65b0\u5efa\u8fde\u63a5<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-1024x700.png\" alt=\"\" class=\"wp-image-7781\" width=\"539\" height=\"368\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-1024x700.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-300x205.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-768x525.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-830x567.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-230x157.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-350x239.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4-480x328.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-4.png 1162w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u7b2c\u4e8c\u6b65\uff1a\u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u8fd9\u91cc\u662f\u91cd\u70b9<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5.png\" alt=\"\" class=\"wp-image-7782\" width=\"538\" height=\"537\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5.png 996w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-300x300.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-150x150.png 150w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-768x766.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-830x828.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-230x230.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-350x349.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-5-480x479.png 480w\" sizes=\"(max-width: 538px) 100vw, 538px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u7b2c\u4e09\u6b65\uff0c\u5728\u6587\u672c\u6846\u8f93\u5165H2,\u7cfb\u7edf\u4f1a\u81ea\u52a8\u7b5b\u9009\uff0c\u9009\u62e9H2Server,\u7136\u540e\u70b9\u51fb\u4e0b\u4e00\u6b65<\/strong><\/p>\n\n\n\n<p>\u6ce8\u610f\u8fd9\u4e00\u6b65\uff0c\u8981\u770bH2\u6570\u636e\u5e93\u7684\u7c7b\u578b\uff0c\u6709\u53ef\u80fd\u662f\u8fdc\u7a0b\u7684\u670d\u52a1\u5668\uff0c\u8fd9\u65f6\u9009H2Server\u3002<\/p>\n\n\n\n<p>\u4f46\u662f\u4e5f\u6709\u53ef\u80fd\u662fSpringBoot\u7684\u672c\u5730\u6570\u636e\u5e93\uff0c\u8fd9\u65f6\u9009H2 Embedded<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6.png\" alt=\"\" class=\"wp-image-7783\" width=\"529\" height=\"519\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6.png 998w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6-300x295.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6-768x754.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6-830x815.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6-230x226.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6-350x344.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-6-480x471.png 480w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><figcaption>H2 Server<\/figcaption><\/figure><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">Springboot application.yaml\n###################################\n# DB connection info\n###################################\nspring.datasource:  \n  driver-class-name: org.h2.Driver  \n  url: jdbc:h2:~\/db\/testdb;MODE=db2;DATABASE_TO_LOWER=FALSE;\n  username: sa    \n  password:<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-1024x897.png\" alt=\"\" class=\"wp-image-7784\" width=\"544\" height=\"476\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-1024x897.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-300x263.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-768x672.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-830x727.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-230x201.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-350x306.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7-480x420.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-7.png 1334w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><figcaption>H2 Embedded<\/figcaption><\/figure><\/div>\n\n\n\n<p><strong>\u7b2c\u56db\u6b65\uff1a\u914d\u7f6e\u6570\u636e\u5730\u5740\u548c\u76f8\u5173\u4fe1\u606f\uff0c\u8fd9\u91cc\u4e5f\u8981\u6ce8\u610f\u7aef\u53e3\u53f7\u7b49\u6570\u636e\u4fe1\u606f\uff0c\u4e0d\u7136\u662f\u8fde\u63a5\u4e0d\u4e0a\u7684<\/strong>\u3002<\/p>\n\n\n\n<p>\u8fd9\u91cc\u8981\u6ce8\u610f\u672c\u5730\u548cServer\u7684\u914d\u7f6e\u662f\u4e0d\u4e00\u6837\u7684\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-1024x856.png\" alt=\"\" class=\"wp-image-7786\" width=\"543\" height=\"453\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-1024x856.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-300x251.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-768x642.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-830x694.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-230x192.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-350x292.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8-480x401.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-8.png 1192w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><figcaption>H2 Server<\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-1024x751.png\" alt=\"\" class=\"wp-image-7787\" width=\"531\" height=\"389\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-1024x751.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-300x220.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-768x563.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-830x608.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-230x169.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-350x257.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9-480x352.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-9.png 1416w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><figcaption>H2 Embedded\u7684\u8bdd\uff0c\u70b9\u6d4f\u89c8\u8981\u9009\u62e9\u5230\u672c\u5730h2db\u6587\u4ef6\uff0c\u8fd9\u91cc\u662ftestdb.mv.db<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u8fde\u63a5\u5b8c\u6210\u540e\u518d\u5de6\u4fa7\u5c31\u53ef\u4ee5\u770b\u5230\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u76f8\u5e94\u7684\u64cd\u4f5c\u4e86\uff0c\u662f\u4e0d\u662f\u5f88\u7b80\u5355\u65b9\u4fbf\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-1024x769.png\" alt=\"\" class=\"wp-image-7789\" width=\"550\" height=\"412\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-1024x769.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-300x225.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-768x577.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-830x623.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-230x173.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-350x263.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10-480x361.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/10\/\u56fe\u7247-10.png 1270w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>H2\u6570\u636e\u5e93\u662fJava\u7684\u5185\u5d4c\u6570\u636e\u5e93\uff0c\u4f53\u79ef\u5c0f\u5de7\uff0c\u8fd0\u884c\u901f\u5ea6\u5feb\uff0c\u975e\u5e38\u9002\u5408\u7a0b\u5e8f\u5f00\u53d1\u671f\u548c\u5c0f\u6570\u636e\u5e94\u7528\u3002 \u4f46\u662fH2\u6709\u4e2a\u7f3a\u70b9\uff0c\u5c31 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,23],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/7779"}],"collection":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7779"}],"version-history":[{"count":3,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/7779\/revisions"}],"predecessor-version":[{"id":7790,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/7779\/revisions\/7790"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}