{"id":1579,"date":"2009-10-30T14:09:14","date_gmt":"2009-10-30T06:09:14","guid":{"rendered":"\/?p=1579"},"modified":"2009-10-30T14:09:14","modified_gmt":"2009-10-30T06:09:14","slug":"1579","status":"publish","type":"post","link":"https:\/\/www.justzz.com\/spec\/1579.html","title":{"rendered":"[SqlServer]\u89e3\u51b3Cannot start a cloned connection while in manual transaction mode"},"content":{"rendered":"<p>Java JDBC\u8fde\u63a5<\/p>\n<p>\u51fa\u73b0Cannot start a cloned connection while in manual transaction mode\u9519\u8bef\uff0c\u4ece\u7f51\u4e0a\u627e\u5230\u539f\u56e0\u53ca\u89e3\u51b3\u529e\u6cd5\u5982\u4e0b\uff1a<\/p>\n<p><strong>\u539f\u56e0\uff1a<\/strong><\/p>\n<p>\u4e00\u822c\u662f\u5f53\u4f60\u5728\u4e00\u4e2aSQL SERVER\u7684JDBC\u8fde\u63a5\u4e0a\u6267\u884c\u591a\u4e2aSTATEMENTS\u7684\u64cd\u4f5c\uff0c\u6216\u8005\u662f\u624b\u52a8\u4e8b\u52a1\u72b6\u6001\uff08AutoCommit=false) \u5e76\u4e14\u4f7f\u7528\u9ed8\u8ba4\u7684\u6a21\u5f0f. direct (SelectMethod=direct) \u6a21\u5f0f.<\/p>\n<p><strong>\u89e3\u51b3\u529e\u6cd5<\/strong><\/p>\n<p>\u5f53\u4f60\u4f7f\u7528\u624b\u52a8\u4e8b\u52a1\u6a21\u5f0f\u65f6\uff0c\u5fc5\u987b\u628aSelectMethod \u5c5e\u6027\u7684\u503c\u8bbe\u7f6e\u4e3a Cursor, \u6216\u8005\u662f\u786e\u4fdd\u5728\u4f60\u7684\u8fde\u63a5\u53ea\u6709\u4e00\u4e2aSTATEMENT\u64cd\u4f5c\u3002<\/p>\n<p>\u4fee\u6539url<\/p>\n<p>\u52a0\u5165SelectMethod=cursor\u5373\u53ef\u3002<\/p>\n<p>\u5982:<\/p>\n<p><span style=\"font-family: Courier New\">jdbc:microsoft:sqlserver:\/\/localhost:1433;DatabaseName=ys;SelectMethod=Cursor;User=ys;Password=ys\");<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Java JDBC\u8fde\u63a5 \u51fa\u73b0Cannot start a cloned connection while in manual transaction mode\u9519\u8bef\uff0c\u4ece\u7f51\u4e0a\u627e\u5230\u539f\u56e0\u53ca\u89e3\u51b3\u529e\u6cd5\u5982\u4e0b\uff1a \u539f\u56e0\uff1a \u4e00\u822c\u662f\u5f53\u4f60\u5728\u4e00\u4e2aSQL SERVER\u7684JDBC&hellip;<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1579","post","type-post","status-publish","format-standard","hentry","category-t"],"_links":{"self":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts\/1579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/comments?post=1579"}],"version-history":[{"count":0,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/posts\/1579\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/media?parent=1579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/categories?post=1579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.justzz.com\/spec\/wp-json\/wp\/v2\/tags?post=1579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}