{"id":1463,"date":"2019-11-13T00:17:53","date_gmt":"2019-11-12T15:17:53","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1463"},"modified":"2019-12-04T00:18:54","modified_gmt":"2019-12-03T15:18:54","slug":"jdbc-driverpropertyinfo%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%b4-%ed%98%84%ec%9e%ac-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84-%ec%97%b0%ea%b2%b0%ec%9d%98-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0-%ea%b0%92","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/java\/jdbc-driverpropertyinfo%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%b4-%ed%98%84%ec%9e%ac-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84-%ec%97%b0%ea%b2%b0%ec%9d%98-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0-%ea%b0%92\/","title":{"rendered":"[Jdbc] DriverPropertyInfo\ub97c \uc774\uc6a9\ud574 \ud604\uc7ac \ub4dc\ub77c\uc774\ubc84 \uc5f0\uacb0\uc758 \ud30c\ub77c\ubbf8\ud130 \uac12 \ud655\uc778\ud558\uae30"},"content":{"rendered":"

[Jdbc] DriverPropertyInfo\ub97c \uc774\uc6a9\ud574 \ud604\uc7ac \ub4dc\ub77c\uc774\ubc84 \uc5f0\uacb0\uc758 \ud30c\ub77c\ubbf8\ud130 \uac12 \ud655\uc778\ud558\uae30<\/h1>\n

jdbc\uc5d0\uc11c useAffectedRows<\/code> \ud30c\ub77c\ubbf8\ud130\ub97c \ud14c\uc2a4\ud2b8\ud574\ubcf4\ub358 \uc911\uc5d0 \ud604\uc7ac jdbc \ub4dc\ub77c\uc774\ubc84\uc5d0 \uc81c\ub300\ub85c \uc801\uc6a9\uc774 \ub418\uc5b4\uc788\ub294 \uac83\uc778\uc9c0 \ud655\uc778\uc774 \ud544\uc694\ud588\ub294\ub370, java.sql.DriverPropertyInfo<\/code> \ub97c \uc774\uc6a9\ud574\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc5c8\ub2e4.<\/p>\n

\uc544\ub798\uc640 \uac19\uc774 \ud14c\uc2a4\ud2b8 \uc18c\uc2a4\ub97c \uc791\uc131\ud558\uace0 \ud30c\ub77c\ubbf8\ud130 \uc124\uc815\uc744 \ubc14\uafd4\uac00\uba74\uc11c \ud655\uc778\ud574\ubcf4\ub2c8 \uc81c\ub300\ub85c \ub3d9\uc791\ud558\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc5c8\ub2e4. \ucd9c\ub825 \ubd80\ubd84\uc740 \ud544\uc694\uc5d0\ub530\ub77c \ubcc0\ud615\ud558\uba74\ub420 \uac83 \uac19\uace0 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c \ub2e8\uacc4\uc5d0\uc11c\ub294 DEBUG \ubaa8\ub4dc\ub85c \ud604\uc7ac \ucee4\ub125\uc158 \uc0c1\ud0dc\ub97c \ub85c\uae45\ud574\uc8fc\ub294 \uac83\ub3c4 \uc88b\uc744 \uac83 \uac19\ub2e4.<\/p>\n

import java.util.Arrays;\n\nimport java.sql.Connection;\nimport java.sql.Driver;\nimport java.sql.DriverManager;\nimport java.sql.DriverPropertyInfo;\nimport java.sql.SQLException;\n\npublic class DriverPropertyInfoTest {\n\n    static Connection conn = null;\n\n    public static void main(String[] argv) {\n\n        try{\n            Class.forName("com.mysql.jdbc.Driver");\n        } catch (ClassNotFoundException e){\n            e.printStackTrace();\n        }\n\n        try{\n\n            String url = "jdbc:mysql:\/\/localhost:3306\/employees?useAffectedRows=true";\n            conn = DriverManager.getConnection(url, "root", "password");\n            Driver driver = DriverManager.getDriver(url);\n            DriverPropertyInfo[] props = driver.getPropertyInfo(url, null);\n\n            for(int i=0; i<props.length; i++) {\n                System.out.println("Name: "         + props[i].name                                     );\n                System.out.println("Required: "     + props[i].required                                 );\n                System.out.println("Value : "       + props[i].value                                    );\n                System.out.println("Description: "  + props[i].description                              );\n\n                String[] choices = props[i].choices;\n                System.out.println("Choices: "      + (choices!=null ? Arrays.asList(choices) : null)   );\n\n                System.out.println();\n            }\n\n            conn.close();\n\n        } catch (SQLException e){\n            e.printStackTrace();\n        }\n    }\n}<\/code><\/pre>\n
connection string \uc744 \uc544\ub798\uc640 \uac19\uc774 \uc124\uc815\ud588\uc744 \ub54c\uc5d0\ub294 <\/p>\n
String url = "jdbc:mysql:\/\/localhost:3306\/employees?useAffectedRows=true";<\/code><\/pre>\n
\ub2e4\uc74c\uacfc \uac19\uc774 Value: true<\/code> \ub85c \ud655\uc778\uc774 \ub418\uace0<\/p>\n
Name: useAffectedRows\nRequired: false\nValue : true \nDescription: Don't set the CLIENT_FOUND_ROWS flag when connecting to the server (not JDBC-compliant, will break most applications that rely on "found" rows vs. "affected rows" for DML statements), but does cause "correct" update counts from "INSERT ... ON DUPLICATE KEY UPDATE" statements to be returned by the server. \nChoices: [true, false, yes, no]<\/code><\/pre>\n
\ub2e4\uc74c\uacfc \uac19\uc774 \uc5f0\uacb0\ud588\uc744 \ub54c\uc5d0\ub294<\/p>\n
String url = "jdbc:mysql:\/\/localhost:3306\/employees";<\/code><\/pre>\n
\uae30\ubcf8\uac12\uc73c\ub85c Value: false<\/code> \ub85c \ud655\uc778\uc774 \ub41c\ub2e4.<\/p>\n
Name: useAffectedRows\nRequired: false\nValue : false\nDescription: Don't set the CLIENT_FOUND_ROWS flag when connecting to the server (not JDBC-compliant, will break most applications that rely on "found" rows vs. "affected rows" for DML statements), but does cause "correct" update counts from "INSERT ... ON DUPLICATE KEY UPDATE" statements to be returned by the server. \nChoices: [true, false, yes, no]<\/code><\/pre>\n
DriverPropertyInfo \ub97c \ud1b5\ud574\uc11c jdbc \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4\ub294 \uc218\ud655\uacfc \ud568\uaed8 jdbc \ud30c\ub77c\ubbf8\ud130\uac00 \uc774\ub807\uac8c \ub9ce\ub2e4\ub294 \uac83\uc5d0 \ub180\ub790\uace0 \ud558\ub098\ud558\ub098 \uacf5\ubd80\ud574\ubd10\uc57c\uaca0\ub2e4\ub294 \uc219\uc81c\ub97c \uc5bb\uc740 \uac83 \uac19\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcc4\ub85c \uc9c0\uc6d0\ud558\ub294 \ud30c\ub77c\ubbf8\ud130 \uc885\ub958\ub3c4 \ub2e4\ub97c \uc218 \uc788\uaca0\ub2e4\ub294 \uc0dd\uac01\uc774 \ub4dc\ub294\ub370 \ud45c\uc900 \ud56d\ubaa9\ubd80\ud130 \ucc3e\uc544\ubd10\uc57c\uaca0\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
[Jdbc] DriverPropertyInfo\ub97c \uc774\uc6a9\ud574 \ud604\uc7ac \ub4dc\ub77c\uc774\ubc84 \uc5f0\uacb0\uc758 \ud30c\ub77c\ubbf8\ud130 \uac12 \ud655\uc778\ud558\uae30 jdbc\uc5d0\uc11c useAffectedRows \ud30c\ub77c\ubbf8\ud130\ub97c \ud14c\uc2a4\ud2b8\ud574\ubcf4\ub358 \uc911\uc5d0 \ud604\uc7ac jdbc \ub4dc\ub77c\uc774\ubc84\uc5d0 \uc81c\ub300\ub85c \uc801\uc6a9\uc774 \ub418\uc5b4\uc788\ub294 \uac83\uc778\uc9c0 \ud655\uc778\uc774 \ud544\uc694\ud588\ub294\ub370, java.sql.DriverPropertyInfo \ub97c \uc774\uc6a9\ud574\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc5c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 \ud14c\uc2a4\ud2b8 \uc18c\uc2a4\ub97c \uc791\uc131\ud558\uace0 \ud30c\ub77c\ubbf8\ud130 \uc124\uc815\uc744 \ubc14\uafd4\uac00\uba74\uc11c \ud655\uc778\ud574\ubcf4\ub2c8 \uc81c\ub300\ub85c \ub3d9\uc791\ud558\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc5c8\ub2e4. \ucd9c\ub825 \ubd80\ubd84\uc740 \ud544\uc694\uc5d0\ub530\ub77c \ubcc0\ud615\ud558\uba74\ub420 \uac83 \uac19\uace0 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c \ub2e8\uacc4\uc5d0\uc11c\ub294 DEBUG \ubaa8\ub4dc\ub85c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,62],"tags":[],"class_list":["post-1463","post","type-post","status-publish","format-standard","hentry","category-java","category-mysql"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1463"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1463\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}