{"id":8705,"date":"2021-06-02T09:00:09","date_gmt":"2021-06-02T00:00:09","guid":{"rendered":"https:\/\/jennifersoft.com\/ko\/?p=8705"},"modified":"2023-12-22T16:19:35","modified_gmt":"2023-12-22T07:19:35","slug":"2021-06-02","status":"publish","type":"post","link":"https:\/\/jennifersoft.com\/ko\/blog\/tech\/2021-06-02\/","title":{"rendered":"SQL\ub85c \uc81c\ub2c8\ud37c \ub370\uc774\ud130 \uc870\ud68c\ud558\uae30"},"content":{"rendered":"\n<figure class=\"wp-block-image wide\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"715\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/sql_main-1-1024x715.jpg\" alt=\"\" class=\"wp-image-9160\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/sql_main-1-1024x715.jpg 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/sql_main-1-300x210.jpg 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\uc81c\ub2c8\ud37c API\uc11c\ubc84 \ud65c\uc6a9\ud558\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc81c\ub2c8\ud37c\ub294 1\ucd08 \ub2e8\uc704\uc758 \uc218\uc9d1 \ub370\uc774\ud130\ub97c \uc790\uccb4\ub85c \uc81c\uc791\ud55c \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<br>\uc774 \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc740 \ub300\uc6a9\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uace0\uc18d\uc73c\ub85c \ucc98\ub9ac\ud558\ub294\ub370 \ucd08\uc810\uc744 \ub9de\ucd94\uc5b4 \uac1c\ubc1c\ub418\uc5c8\uace0 \uc2e4\uc81c \uace0\uac1d\uc0ac\uc758 \ub300\uc6a9\ub7c9 \uc778\uc2a4\ud134\uc2a4\uc758 \ub370\uc774\ud130\ub97c \uc548\uc815\uc801\uc73c\ub85c \uc218\uc9d1\ud558\uc5ec \ucc98\ub9ac\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc \uc9c1\uc811 \uc81c\uc791\ud55c \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc774\uae30\uc5d0 \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uac00\uacf5 \ud615\ud0dc\uc758 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294\ub370 \uc5b4\ub824\uc6c0\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc5d0 \ub9ce\uc740 \uace0\uac1d\ubd84\ub4e4\uc774 SQL\ub85c \uc81c\ub2c8\ud37c\uc758 \ub370\uc774\ud130\ub97c \uc790\uc720\ub86d\uac8c \uc870\ud68c\ud574\uc11c \uc0ac\uc6a9\ud558\uace0 \uc2f6\ub2e4\ub294 \uc758\uacac\uc744  \uc8fc\uc168\uace0 \uc81c\ub2c8\ud37c R&amp;D\ud300\uc5d0\uc11c\ub294 \uac1c\uc120\ubc29\ud5a5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uc5f0\uad6c\ud574\uc11c \uc0c8\ub86d\uac8c \uae30\ub2a5\uc744 \ucd94\uac00\ud574 \uc654\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud604\uc7ac \uc81c\ub2c8\ud37c\ub294 2\uac00\uc9c0 \ubc29\uc2dd\uc758 SQL \uc870\ud68c\ubc29\ubc95\uc744  \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \uae00\uc5d0\uc11c\ub294  \uc81c\ub2c8\ud37c API \uc11c\ubc84\uc640 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130 \uc870\ud68c \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc81c\ub2c8\ud37c API \uc11c\ubc84\ub294 \uc81c\ub2c8\ud37c \uc11c\ubc84\uc640 \ubcc4\ub3c4\uc758 \ud504\ub85c\uc138\uc2a4\ub85c \ub3d9\uc791\ud569\ub2c8\ub2e4. &nbsp;<br>JDBC \ub4dc\ub77c\uc774\ubc84\uac00 \uc0ac\uc6a9\uc790\ub85c\ubd80\ud130 \ubc1b\uc740 \uc694\uccad\uc744 API \uc11c\ubc84\uc5d0 \uc804\ub2ec\ud558\uace0 API \uc11c\ubc84\ub294 \ud30c\uc77c DB\ub97c \uc77d\uc5b4\uc11c HTTP \uc751\ub2f5 \ud615\ud0dc\ub85c \uacb0\uacfc\uac12\uc744 \uc804\ub2ec\ud574\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"918\" height=\"175\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/blog_api_01-copy.png\" alt=\"\" class=\"wp-image-9047\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/blog_api_01-copy.png 918w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/blog_api_01-copy-300x57.png 300w\" sizes=\"auto, (max-width: 918px) 100vw, 918px\" \/><figcaption>JENNIFER API Server\uad6c\uc870<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc81c\ub2c8\ud37c API\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc6b4\ub85c\ub4dc \ud328\ud0a4\uc9c0\uc5d0 \uc544\ub798\uc758 \ud30c\uc77c\uc774 \uc788\ub294\uc9c0 \ud655\uc778\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">\uac01 \ud328\ud0a4\uc9c0\ub294 \ub2e4\uc74c \ub9c1\ud06c\uc5d0\uc11c \ub2e4\uc6b4\ubc1b\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>API \uc11c\ubc84&nbsp;<\/strong>     <a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/github.com\/jennifersoft\/jennifer5-api-server\">https:\/\/github.com\/jennifersoft\/jennifer5-api-server<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>JDBC \ub4dc\ub77c\uc774\ubc84&nbsp;<\/strong>     <a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/github.com\/jennifersoft\/jennifer5-jdbc-driver\">https:\/\/github.com\/jennifersoft\/jennifer5-jdbc-driver<\/a><\/p>\n\n\n\n<div class=\"article-contents-width\"><table style=\"border:1px solid #e8e8e8;width:100%;border-radius:5px;padding:20px;\"><tbody><tr><td style=\"border-bottom:1px solid #e8e8e8;padding:0 0 10px 0;\">jennifer-api-server-5.6.0.5.zip <\/td><td style=\"border-bottom:1px solid #e8e8e8;padding:0 0 20px 0;\">\uc81c\ub2c8\ud37c API \uc11c\ubc84 \ud328\ud0a4\uc9c0 \ud30c\uc77c <\/td><\/tr><tr><td style=\"border-bottom:1px solid #e8e8e8;padding:20px 0 20px 0;\">jennifer-jdbc-5.6.0.5.zip <\/td><td style=\"border-bottom:1px solid #e8e8e8;padding:20px 0 20px 0;\"> \uc81c\ub2c8\ud37c JDBC \ub4dc\ub77c\uc774\ubc84 \ud30c\uc77c <\/td><\/tr><tr><td style=\"padding:20px 0 0 0;\">api_server.conf   <\/td><td style=\"padding:20px 0 0 0;\"> \uc81c\ub2c8\ud37c API\uc11c\ubc84 \uc124\uc815\ud30c\uc77c <\/td><\/tr><\/tbody><\/table><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\uc81c\ub2c8\ud37c API \uc11c\ubc84\uc758 \uc124\uc815 \ud30c\uc77c\uc740 conf\/api_server.conf \uc774\uba70 yaml \ud3ec\ub9f7\uc73c\ub85c \uc791\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">apiServer:\n   host: \"0.0.0.0\"\n   port: 8080               \uc81c\ub2c8\ud37c API \uc11c\ubc84 \uc5f0\uacb0\ud3ec\ud2b8 \uc785\ub2c8\ub2e4.\n   authentication:\n     id: \"jennifer\"          \uc811\uc18d\uc544\uc774\ub514\n     password: \"jennifer\"      \uc811\uc18d\ud328\uc2a4\uc6cc\ub4dc<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">jennifer:\n   dataServer:               \ub370\uc774\ud130\uc11c\ubc84\uc6a9 \ub370\uc774\ud130 \n     db:\n       - {path: \"\/home\/jennifer\/server.data\/db_data\", name: \"default\"} dbName\n   viewServer:               \ubdf0\uc11c\ubc84\uc6a9 \ub370\uc774\ud130\n     db:\n\n{path: \"\/home\/jennifer\/jennifer5-server\/db_view\", name: \"default\"}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;\uc5ec\ub7ec \uac1c\uc758 \ub370\uc774\ud130\uc11c\ubc84 (\ud639\uc740) \ubdf0\uc11c\ubc84\uc758 \ud30c\uc77c DB \uc815\ubcf4\ub97c \uc870\ud68c\ud558\uace0\uc790 \ud560 \uacbd\uc6b0 \uc0ac\uc6a9\ud558\uc544\ub798\uc640 \uac19\uc774 \ub514\ub809\ud1a0\ub9ac \uacbd\ub85c\ub97c \ucd94\uac00\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">db:\n  - {path: \"\/home\/jennifer\/server.data\/db_data\", name: \"default\"}\n  - {path: \"\/home\/jennifer\/server.data\/db_data1\", name: \"data1\"}\n  - {path: \"\/home\/jennifer\/server.data\/db_data2\", name: \"data2\"}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \uc81c\ub2c8\ud37c API \uc11c\ubc84\ub97c \uc2e4\ud589\ud558\uc5ec \uac04\ub2e8\ud788 \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uba3c\uc800 jennifer-api-server-{version}.zip \ud30c\uc77c\uc758 \uc555\ucd95\uc744 \ud574\uc81c \ud6c4 conf\/api_server.conf \ud30c\uc77c\uc5d0 \ubdf0\uc11c\ubc84 \ud639\uc740 \ub370\uc774\ud130 \uc11c\ubc84\uc758 \uacbd\ub85c\ub97c \uc0ac\uc6a9\uc790\uc758 \uc81c\ub2c8\ud37c \ub514\ube44 \uacbd\ub85c\uc5d0 \ub9de\uac8c \uc218\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">bin\/api-server (or api-server.bat) \uc2e4\ud589\ud558\uba74 \uc544\ub798\uc640 \uac19\uc740 \ub85c\uadf8\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/api_start-1024x332.png\" alt=\"\" class=\"wp-image-8722\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/api_start-1024x332.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/api_start-300x97.png 300w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/api_start.png 1827w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uc2e4\ud589 \uc608) \uc81c\ub2c8\ud37c API\uc11c\ubc84 \uc2e4\ud589\ud654\uba74<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc81c\ub2c8\ud37c API \uc11c\ubc84\uac00 \uc2e4\ud589 \ub418\uc5c8\uc73c\ub2c8 \uc774\uc81c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud45c\uc900 JDBC \ub85c \uc81c\uc791 \ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 \uac70\uc758 \ubaa8\ub4e0 \ub514\ube44 \uad00\ub828 \ud234\uc5d0\uc11c \uc774\uc6a9\uac00\ub2a5\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 \ub4dc\ub77c\uc774\ubc84 \uc790\uccb4 \ub0b4\uc7a5\ub41c CLI \ub97c \uc774\uc6a9\ud55c \ubc29\ubc95, \ubcc4\ub3c4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud558\ub294 \ubc29\ubc95, \uc624\ud508\uc18c\uc2a4 \ub514\ube44 \uad00\ub9ac \ub3c4\uad6c\uc778 DBeaver \uc758 \uc0ac\uc6a9\ubc29\ubc95\uc744 \uc54c\uc544\ubd05\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> \uba3c\uc800 \uc81c\ub2c8\ud37c JDBC \ub4dc\ub77c\uc774\ubc84\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 CLI\uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\uc11c \uc811\uc18d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<br> \uc544\ub798\uc640 \uac19\uc774 \uc81c\ub2c8\ud37c JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \uc2e4\ud589\ud558\uba74 \uc81c\ub2c8\ud37c DB\uc5d0 \uac04\ub2e8\ud558\uac8c \uc5f0\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"305\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-1024x305.png\" alt=\"\" class=\"wp-image-8707\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-1024x305.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-300x89.png 300w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image.png 1484w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uc2e4\ud589 \uc608) \uc81c\ub2c8\ud37c JDBC\ub4dc\ub77c\uc774\ubc84\ub97c \ud1b5\ud574 CLI \ud658\uacbd\uc2e4\ud589\ud558\uae30<br><\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">CLI\uac00 \uc2e4\ud589\ub41c \uc0c1\ud0dc\uc5d0\uc11c SQL\ubb38\uc744 \uc0ac\uc6a9\ud574\uc11c \uc81c\ub2c8\ud37c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-3-1024x269.png\" alt=\"\" class=\"wp-image-8708\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-3-1024x269.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-3-300x79.png 300w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/image-3.png 1658w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uc2e4\ud589 \uc608) CLI\ud658\uacbd\uc5d0\uc11c \uc81c\ub2c8\ud37c \ud2b8\ub79c\uc7ad\uc158 \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8 \ubcf4\uae30<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0ac\uc6a9\uc790\uac00 \uc81c\ub2c8\ud37c \ub514\ube44\ub97c \uad00\ub9ac\ud558\uac70\ub098 \uc870\ud68c\ud558\uc5ec \ubcc4\ub3c4\uc758 \uae30\ub2a5\uc744 \uad6c\ud604\ud558\uace0\uc790 \ud558\ub294 \uacbd\uc6b0 \uc544\ub798\uc640 \uac19\uc774 DriverManager \ub97c \uc774\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<hr class=\"\" style=\"\n    width: 100%;\n    max-width: 765px;\n    border: 1px solid #e8e8e8 !important;\n\">\n\n\n\n<h4 class=\"wp-block-heading\">\/\/HTTP \uc0dd\ub7b5 \uac00\ub2a5<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>DriverManager.getConnection(&#8220;jdbc:jennifer:\/\/host:port&#8221;)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\/\/ port 80 \uc77c \uacbd\uc6b0 \ufeff<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>DriverManager.getConnection(&#8220;jdbc:jennifer:\/\/host&#8221;)<\/li><li>DriverManager.getConnection(&#8220;jdbc:jennifer:http:\/\/host:port&#8221;)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\/\/ dbName \uad6c\ubd84\uc2dc<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>DriverManager.getConnection(&#8220;jdbc:jennifer:http:\/\/host:port;dbName=jennifer&#8221;)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\/\/ View Server DB \uc870\ud68c\uc2dc<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>DriverManager.getConnection(&#8220;jdbc:jennifer:http:\/\/host:port;dbType=view;dbName=jennifer&#8221;)<\/li><\/ul>\n\n\n\n<hr class=\"\" style=\"\n    width: 100%;\n    max-width: 765px;\n    border: 1px solid #e8e8e8 !important;\n    margin-top:40px;\n\">\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\uc74c\uc73c\ub85c SQL \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<br>\uc5ec\ub7ec\uac00\uc9c0 \ub3c4\uad6c\ub4e4\uc774 \uc788\uc73c\ub098 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508\uc18c\uc2a4\uc778 DBeaver\ub97c \uc0ac\uc6a9\ud558\uba74\uc11c  \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1.\uc81c\ub2c8\ud37c JDBC \ub4dc\ub77c\uc774\ubc84\ub97c Driver Manager \uba54\ub274\ub85c \uc774\ub3d9\ud558\uc5ec \ub4f1\ub85d\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/1.5-add-library-1024x580.png\" alt=\"\" class=\"wp-image-8709\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/1.5-add-library-1024x580.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/1.5-add-library-300x170.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">2. \uc811\uc18d\uc744 \uc704\ud55c Class Name, Host, Port \uc815\ubcf4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/1.create-new-driver-1024x582.png\" alt=\"\" class=\"wp-image-8710\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/1.create-new-driver-1024x582.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/1.create-new-driver-300x170.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. \ud504\ub85c\ud37c\ud2f0 \ud0ed\uc5d0\uc11c\ub294 \uc811\uc18d\uc744 \uc704\ud55c dbType, dbName \ud56d\ubaa9\uc744 \ub4f1\ub85d\ud569\ub2c8\ub2e4. API \uc11c\ubc84 \uc124\uc815\uc5d0 \ucd94\uac00\ud55c \uac01 dbPath \uc815\uc758\uc640 \ub9e4\uce6d\ub418\uba70 \ub2e8\uc77c \ub514\ube44 \uacbd\ub85c\ub97c \uc9c0\uc815\ud55c \uacbd\uc6b0 \uc0dd\ub7b5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 &#8220;default&#8221; \ub77c\ub294 \uc774\ub984\uc744 \uac00\uc9c4 dbPath \uac00 \uc120\ud0dd\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"583\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/2.edit-properties-1024x583.png\" alt=\"\" class=\"wp-image-8711\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/2.edit-properties-1024x583.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/2.edit-properties-300x171.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. \uc0c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc5d0\uc11c Jennifer5 \ub4dc\ub77c\uc774\ubc84\ub97c \uac80\uc0c9\ud558\uc5ec \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"583\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/3.connect-to-database-1024x583.png\" alt=\"\" class=\"wp-image-8712\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/3.connect-to-database-1024x583.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/3.connect-to-database-300x171.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5. \uc811\uc18d\uc5d0 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. \uc544\uc774\ud53c \ud328\uc2a4\uc6cc\ub4dc\ub294 API \uc11c\ubc84 \uc124\uc815 \ud30c\uc77c\uc758 authenticate \uc601\uc5ed\uc5d0 \uae30\uc785\ud55c \ub0b4\uc6a9\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"583\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/4.connection-setting-1024x583.png\" alt=\"\" class=\"wp-image-8713\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/4.connection-setting-1024x583.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/4.connection-setting-300x171.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">6. \uc0c8 SQL \ud3b8\uc9d1\uae30\ub97c \uc120\ud0dd\ud558\uc138\uc694.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"584\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/5.new-sql-script-1024x584.png\" alt=\"\" class=\"wp-image-8714\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/5.new-sql-script-1024x584.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/5.new-sql-script-300x171.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">7. \uc0ac\uc804 \uc900\ube44\ub41c SQL(select * from all_tables)\ub85c \uc870\ud68c \uac00\ub2a5\ud55c \ud14c\uc774\ube14 \ubaa9\ub85d\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubb3c\ub860 \uc2a4\ud0a4\ub9c8 \uc774\ub984\uc744 \uc120\ud0dd\ud574\ub3c4 \uc815\ubcf4 \ud655\uc778\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/6.table-list-search-1024x582.png\" alt=\"\" class=\"wp-image-8715\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/6.table-list-search-1024x582.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/6.table-list-search-300x170.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">8. \ud655\uc778\ub41c \ud14c\uc774\ube14\uc744 \ub300\uc0c1\uc73c\ub85c \uc6d0\ud558\ub294 SQL \uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/7.query-table-1024x582.png\" alt=\"\" class=\"wp-image-8716\" srcset=\"https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/7.query-table-1024x582.png 1024w, https:\/\/jennifersoft.com\/ko\/wp-content\/uploads\/sites\/2\/2021\/05\/7.query-table-300x170.png 300w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uc2e4\ud589 \uc608) \uc6d0\ud558\ub294 \ud14c\uc774\ube14\uc744 \ub300\uc0c1\uc73c\ub85c SQL\uc791\uc131 \ud6c4 \uc2e4\ud589\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>\ud2b8\ub79c\uc7ad\uc158 \ub370\uc774\ud130 \uc870\ud68c \uc608) select * from transaction_1004_20210401;<br><br><\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ud604\uc7ac \uc870\ud68c\ud560 \uc218 \uc788\ub294 \ud14c\uc774\ube14 \uc885\ub958\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"article-contents-width\">\n<table style=\"width:100%;border-radius:5px;padding:24px;background-color:#F8F9FA;\"><tbody><tr>\n<td style=\"color:#9245db;\">\u2714<\/td>\n<td style=\"line-height:40px;font-weight:bold;\"> APPLICATION_STATISTIC_\ub3c4\uba54\uc778_\ub0a0\uc9dc<\/td>\n<\/tr>\n<tr>\n<td style=\"color:#9245db;\">\u2714<\/td>\n<td style=\"line-height:40px;font-weight:bold;\">TRANSACTION_\ub3c4\uba54\uc778_\ub0a0\uc9dc\n<\/td>\n<\/tr>\n<tr>\n<td style=\"color:#9245db;\">\u2714<\/td>\n<td style=\"line-height:40px;font-weight:bold;\">INSTANCE_METRIC_\ub3c4\uba54\uc778_\ub0a0\uc9dc<\/td>\n<\/tr>\n<tr>\n<td style=\"color:#9245db;\">\u2714<\/td>\n<td style=\"line-height:40px;font-weight:bold;\">DOMAIN_METRIC_\ub3c4\uba54\uc778_\ub0a0\uc9dc<\/td>\n<\/tr>\n<tr>\n<td style=\"color:#9245db;\">\u2714<\/td>\n<td style=\"line-height:40px;font-weight:bold;\">INSTANCE_\ub3c4\uba54\uc778dbType=view<\/td>\n<\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\uc81c\ub2c8\ud37c JDBC \ub4dc\ub77c\uc774\ubc84\ub294 \ud45c\uc900 SQL \uc5d0 \ub9de\uac8c \uc81c\uc791\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uac00\ub2a5\ud55c SQL \ud568\uc218, \ubb38\ubc95\uc5d0 \ub300\ud55c \uc2a4\ud399\uc740 \uc544\ub798 \ub9c1\ud06c\ub97c \ucc38\uace0\ud558\uc138\uc694.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/calcite.apache.org\/docs\/reference.html\">SQL language (apache.org)<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc0c1\uc73c\ub85c \uc81c\ub2c8\ud37c API \uc11c\ubc84\uc640 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \uc774\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc18c\uac1c\ub97c \ub9c8\uce69\ub2c8\ub2e4.<br>\ub2e4\uc74c \uae00\uc5d0\uc11c\ub294 &#8220;SQL\ub85c \uc81c\ub2c8\ud37c \ub370\uc774\ud130 \ud65c\uc6a9\ud558\uae30&#8221; 2\ubc88\uc9f8 \uae30\ub2a5\uc744 \uc18c\uac1c\ud574 \ub4dc\ub9ac\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"\uc81c\ub2c8\ud37c API\uc11c\ubc84 \ud65c\uc6a9\ud558\uae30 \uc81c\ub2c8\ud37c\ub294 1\ucd08 \ub2e8\uc704\uc758 \uc218\uc9d1 \ub370\uc774\ud130\ub97c \uc790\uccb4\ub85c \uc81c\uc791\ud55c \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.\uc774 \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc740 \ub300\uc6a9\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uace0\uc18d\uc73c\ub85c \ucc98\ub9ac\ud558\ub294\ub370 \ucd08\uc810\uc744&#8230;","protected":false},"author":18,"featured_media":9160,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[204],"tags":[49,51,64,286,342,173,313,229,53],"class_list":["post-8705","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-apm","tag-jennifer","tag-jennifer-apm","tag-sql","tag-sql---","tag-173","tag-313","tag--apm","tag-53"],"acf":[],"_links":{"self":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts\/8705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/comments?post=8705"}],"version-history":[{"count":124,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts\/8705\/revisions"}],"predecessor-version":[{"id":10312,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts\/8705\/revisions\/10312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/media\/9160"}],"wp:attachment":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/media?parent=8705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/categories?post=8705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/tags?post=8705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}