{"id":770,"date":"2024-11-24T23:51:06","date_gmt":"2024-11-24T15:51:06","guid":{"rendered":"https:\/\/www.xudongvp.com\/?p=770"},"modified":"2024-11-24T23:51:07","modified_gmt":"2024-11-24T15:51:07","slug":"preparethreshold%e5%8f%82%e6%95%b0%e5%b9%b2%e4%bb%80%e4%b9%88%e7%94%a8%e7%9a%84","status":"publish","type":"post","link":"https:\/\/www.xudongvp.com\/?p=770","title":{"rendered":"prepareThreshold\u53c2\u6570\u5e72\u4ec0\u4e48\u7528\u7684"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u4f7f\u7528apache sharadingsphere proxy\uff08\u7248\u672c5.5.0\uff09\u65f6\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff0c\u67d0\u4e2a\u4e1a\u52a1\u529f\u80fd\uff0c\u7b2c\u4e00\u6b21\u6267\u884cOK\uff0c\u7b2c\u4e8c\u6b21\u64cd\u4f5c\u5c31\u4f1a\u51fa\u73b0\u9519\u8bef\uff0c\u62a5\u9519\u4fe1\u606f\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQLComDescribeExecutor.java:150 NullException<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u8fdb\u5165\u5230\u8fd9\u4e2a\u7c7b\u578b\uff0c\u6211\u5c31\u6bd4\u8f83\u5947\u602a\uff0c\u600e\u4e48\u4e0d\u662f\u8d70prepare\u90a3\u8fb9\u6267\u884c\u5462\uff1f\u53e6\u5916\uff0c\u540c\u6837\u7684SQL\uff0c\u540c\u6837\u7684\u529f\u80fd\u5462\uff0c\u7b2c\u4e00\u6b21\u6267\u884cOK\uff0c\u53ef\u4ee5\u521d\u6b65\u6392\u9664\u6389\u662f\u4e1a\u52a1\u7cfb\u7edf\u4ee5\u53caSQL\u8bed\u6cd5\u7684\u95ee\u9898\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u627e\u4e86\u76f8\u5173\u8d44\u6599\uff0c\u53d1\u73b0\u8fdb\u5165DescribeStatement\u76f8\u5173\u7684\u5904\u7406\u8fc7\u7a0b\uff0c\u8bf4\u660e\u670d\u52a1\u7aef\u5df2\u7ecf\u5f00\u59cb\u8fdb\u884cSQL\u8bed\u53e5\u7684\u9884\u7f16\u8bd1\u548c\u590d\u7528\u76f8\u5173\u5904\u7406\u4e86\u3002\u8fd9\u4e2a\u529f\u80fd\uff0c\u9700\u8981JDBC\u5ba2\u6237\u7aef\u548c\u670d\u52a1\u7aef\u914d\u5408\u8d77\u6765\u624d\u884c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5355\u6b65\u8ddf\u8e2a\u5230JDBC\u7684\u672c\u5730\u6267\u884c\u8fc7\u7a0b\u53d1\u73b0\uff0cJDBC\u7684URL\u4e0a\u914d\u7f6eprepareThreshold\u53c2\u6570\uff0c\u53ef\u4ee5\u5bf9\u6b64\u529f\u80fd\u8fdb\u884c\u63a7\u5236\u3002<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"#\u5173\u95edSQL\u9884\u7f16\u8bd1\u7f13\u5b58\u529f\u80fd\nprepareThreshold=0\n\n#\u9ed8\u8ba4\u503c\uff0c5\u6b21\u6267\u884c\u540e\uff0c\u5f00\u542f\u7f13\u5b58\u529f\u80fd\nprepareThreshold=5\n\n#\u5176\u4ed6\u503c\uff0c\u8d85\u8d8a\u914d\u7f6e\u503c\u540e\uff0c\u5f00\u542f\u7f13\u5b58\u529f\u80fd\u3002\nprepareThreshold=XXX\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">#\u5173\u95edSQL\u9884\u7f16\u8bd1\u7f13\u5b58\u529f\u80fd<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">prepareThreshold<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #B48EAD\">0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">#\u9ed8\u8ba4\u503c\uff0c5\u6b21\u6267\u884c\u540e\uff0c\u5f00\u542f\u7f13\u5b58\u529f\u80fd<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">prepareThreshold<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #B48EAD\">5<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">#\u5176\u4ed6\u503c\uff0c\u8d85\u8d8a\u914d\u7f6e\u503c\u540e\uff0c\u5f00\u542f\u7f13\u5b58\u529f\u80fd\u3002<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">prepareThreshold<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #A3BE8C\">XXX<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">JDBC\u7684URL\u4e0a\u914d\u7f6eprepareThreshold=0\uff0c\u91cd\u65b0\u9a8c\u8bc1\u4e1a\u52a1\u529f\u80fd\uff0c\u53d1\u73b0\u73b0\u8c61\u6d88\u5931\u3002\u4e3a\u4f55\u7b2c\u4e00\u6b21\u53ef\u4ee5\uff0c\u7b2c\u4e8c\u6b21\u4e0d\u53ef\u4ee5\u5462\uff1f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u56e0\u4e3a\u8fd9\u4e2a\u529f\u80fd\u7684\u4e00\u6b21\u89e6\u53d1\uff0c\u4f1a\u5bfc\u81f4\u4e00\u4e2aSQL\u88ab\u6267\u884c3\u6b21\uff0c\u5219\u7b2c\u4e8c\u6b21\u7684\u7b2c\u4e8c\u7b14\uff0c\u4f1a\u89e6\u53d1\u7f13\u5b58\u5f00\u542f\u3002\u6b63\u597d\u9047\u5230proxy\u7684\u7f3a\u9677\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5f53\u524d\u6211\u4eec\u9009\u62e9\u5173\u95ed\u9884\u7f16\u8bd1\u7f13\u5b58\u529f\u80fd\uff0c\u4fdd\u5e73\u5b89\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53e6\u5916\uff0c\u8fd9\u4e2a\u9884\u7f16\u8bd1\u7f13\u5b58\u5f00\u5173\u7684\u8ba1\u6570\u5668\uff0c\u662f\u4e0e\u5177\u4f53\u7684connection\u7ed1\u5b9a\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\u5f53\u67d0\u4e2a\u8fde\u63a5\u5b58\u6d3b\u671f\u95f4\u8fdb\u884c\u8fde\u7eed\u8ba1\u6570\uff0c\u8fde\u63a5\u4e4b\u95f4\u7684\u8ba1\u6570\u6ca1\u6709\u5173\u7cfb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u7528apache sharadingsphere proxy\uff08\u7248\u672c5.5.0\uff09\u65f6\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff0c\u67d0\u4e2a\u4e1a\u52a1\u529f\u80fd\uff0c\u7b2c\u4e00\u6b21\u6267\u884cOK\uff0c\u7b2c\u4e8c\u6b21\u64cd\u4f5c\u5c31\u4f1a\u51fa\u73b0\u9519\u8bef\uff0c\u62a5\u9519\u4fe1\u606f\uff1a PostgreSQLComDescribeExecutor.java:150 NullException \u770b\u5230\u8fdb\u5165\u5230\u8fd9\u4e2a\u7c7b\u578b\uff0c\u6211\u5c31\u6bd4\u8f83\u5947\u602a\uff0c\u600e\u4e48\u4e0d\u662f\u8d70prepare\u90a3\u8fb9\u6267\u884c\u5462\uff1f\u53e6\u5916\uff0c\u540c\u6837\u7684SQL\uff0c\u540c\u6837\u7684\u529f\u80fd\u5462\uff0c\u7b2c\u4e00\u6b21\u6267\u884cOK\uff0c\u53ef\u4ee5\u521d\u6b65\u6392\u9664\u6389\u662f\u4e1a\u52a1\u7cfb\u7edf\u4ee5\u53caSQL\u8bed\u6cd5\u7684\u95ee\u9898\u3002 \u627e\u4e86\u76f8\u5173\u8d44\u6599\uff0c\u53d1\u73b0\u8fdb\u5165DescribeStatement\u76f8\u5173\u7684\u5904\u7406\u8fc7\u7a0b\uff0c\u8bf4\u660e\u670d\u52a1\u7aef\u5df2\u7ecf\u5f00\u59cb\u8fdb\u884cSQL\u8bed\u53e5\u7684\u9884\u7f16\u8bd1\u548c\u590d\u7528\u76f8\u5173\u5904\u7406\u4e86\u3002\u8fd9\u4e2a\u529f\u80fd\uff0c\u9700\u8981JDBC\u5ba2\u6237\u7aef\u548c\u670d\u52a1\u7aef &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[89],"class_list":["post-770","post","type-post","status-publish","format-standard","hentry","category-23","tag-shardingsphere-proxy"],"_links":{"self":[{"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=\/wp\/v2\/posts\/770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=770"}],"version-history":[{"count":1,"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=\/wp\/v2\/posts\/770\/revisions"}],"predecessor-version":[{"id":771,"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=\/wp\/v2\/posts\/770\/revisions\/771"}],"wp:attachment":[{"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xudongvp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}