{"id":315,"date":"2020-06-24T16:34:39","date_gmt":"2020-06-24T08:34:39","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=315"},"modified":"2021-03-01T17:01:41","modified_gmt":"2021-03-01T09:01:41","slug":"gbase-8a%e9%9b%86%e7%be%a4jdbc%e8%8e%b7%e5%8f%96%e5%8a%a0%e8%bd%bd%e8%a1%8c%e6%95%b0%ef%bc%8c%e5%bf%bd%e7%95%a5%e5%87%bd%e6%95%b0%ef%bc%8c%e4%bb%bb%e5%8a%a1id%e7%ad%89","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/315","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4JDBC\u83b7\u53d6\u52a0\u8f7d\u884c\u6570 Loaded Line\uff0c\u5ffd\u7565\u884c\u6570skipped Line\uff0c\u4efb\u52a1ID\u7b49"},"content":{"rendered":"<p>GBase 8a\u96c6\u7fa4JDBC\u83b7\u53d6\u52a0\u8f7d\u884c\u6570 Loaded Line\uff0c\u5ffd\u7565\u884c\u6570skipped Line\uff0c\u4efb\u52a1ID\u7b49<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package com.gbase.jdbc;\n\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.ResultSet;\nimport java.sql.ResultSetMetaData;\nimport java.sql.SQLException;\nimport java.sql.Statement;\n\nimport com.gbase.jdbc.StatementImpl;\n\n\/\/ NEED gbase-connector-java-8.3.81.53-build54.4-bin.jar \npublic class TestLoad {\n\n\tpublic static void main(String&#91;] args) throws Exception {\n\t\tString URL = \"jdbc:gbase:\/\/192.168.174.61:5258\/testdb?user=gbase&amp;password=gbase20110531&amp;useOldAliasMetadataBehavior=false&amp;failoverEnable=true&amp;hostList=192.168.174.61&amp;gclusterId=vmax\";\n\t\t\/\/ System.out.println(URL);\n\t\tClass.forName(\"com.gbase.jdbc.Driver\");\n\n\t\tConnection con = DriverManager.getConnection(URL);\n\n\t\tStatement stat = con.createStatement();\n\t\ttry {\n\t\t\tint rtn = stat.executeUpdate(\n\t\t\t\t\t\"LOAD DATA INFILE 'ftp:\/\/gbase:gbase@192.168.174.61\/zxq\/2.txt' into table testdb.t1 fields terminated by ',' max_bad_records 0\");\n\t\t\tSystem.out.println(\"loaded=\" + rtn);\/\/ \u6210\u529f\u52a0\u8f7d\u7684\u884c\u6570\n\t\t\tlong skippedLines = ((StatementImpl) (stat)).getSkippedLines();\n\t\t\tSystem.out.println(\"Skipped=\" + skippedLines);\/\/ \u6210\u529f\u5ffd\u7565\u7684\u884c\u6570\n\n\t\t\tlong taskid = ((com.gbase.jdbc.StatementImpl) (stat)).getLoadTaskID();\/\/ \u4efb\u52a1\u7f16\u53f7\n\t\t\tSystem.out.println(\"LoadTaskId=\" + taskid);\/\/ \u4efb\u52a1\u7f16\u53f7\n\n\t\t\tResultSet rs = stat.executeQuery(\"show gcluster load logs \" + taskid + \" limit 0,10\");\n\t\t\tResultSetMetaData rsmd = rs.getMetaData();\n\t\t\tint cols = rsmd.getColumnCount();\n\t\t\twhile (rs.next()) {\n\t\t\t\tfor (int i = 1; i &lt;= cols; i++) {\n\t\t\t\t\tSystem.out.println(rsmd.getColumnName(i) + \"==&gt;\" + rs.getString(i));\n\t\t\t\t}\n\t\t\t}\n\n\t\t} catch (SQLException ex) {\n\t\t\tex.printStackTrace();\n\t\t\tSystem.out.println(ex.getErrorCode());\n\t\t\tSystem.out.println(ex.getMessage());\n\t\t\t\/\/ throw ex;\n\t\t}\n\t}\n\n}\n<\/code><\/pre>\n\n\n\n<p>\u9519\u8bef\u6570\u636e\uff0c\u53ef\u4ee5\u6839\u636etaskId\u901a\u8fc7SQL\u83b7\u5f97\u3002\u8bf7\u53c2\u8003<\/p>\n\n\n\n<figure class=\"wp-block-embed-wordpress wp-block-embed is-type-wp-embed is-provider-\u8001\u7d2b\u7af9\u7684\u5bb6\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"mSoIddIlk4\"><a href=\"https:\/\/www.gbase8.cn\/en\/565\/\">GBase 8a\u96c6\u7fa4\u901a\u8fc7SQL\u83b7\u5f97\u52a0\u8f7d\u9519\u8bef\u6570\u636e\u4fe1\u606f\u65e5\u5fd7<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u300aGBase 8a\u96c6\u7fa4\u901a\u8fc7SQL\u83b7\u5f97\u52a0\u8f7d\u9519\u8bef\u6570\u636e\u4fe1\u606f\u65e5\u5fd7\u300b\u2014\u8001\u7d2b\u7af9\u7684\u5bb6\" src=\"https:\/\/www.gbase8.cn\/565\/embed#?secret=mSoIddIlk4\" data-secret=\"mSoIddIlk4\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4JDBC\u83b7\u53d6\u52a0\u8f7d\u884c\u6570 Loaded Line\uff0c\u5ffd\u7565\u884c\u6570skipped Line\uff0c\u4efb\u52a1ID\u7b49<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,7],"tags":[10,16],"class_list":{"0":"post-315","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-gbase8a","8":"tag-10","9":"tag-jdbc"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=315"}],"version-history":[{"count":7,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/315\/revisions"}],"predecessor-version":[{"id":4889,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/315\/revisions\/4889"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}