{"id":6498,"date":"2022-09-22T17:19:23","date_gmt":"2022-09-22T08:19:23","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=6498"},"modified":"2022-09-22T17:19:23","modified_gmt":"2022-09-22T08:19:23","slug":"sqlpagingqueryproviderfactorybean-join-%eb%b2%84%ea%b7%b8","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=6498","title":{"rendered":"SqlPagingQueryProviderFactoryBean join \ubc84\uadf8"},"content":{"rendered":"<h1>SqlPagingQueryProviderFactoryBean join \ubc84\uadf8<\/h1>\n<p>Spring Batch \ubc84\uc804\uc5d0 \ub530\ub77c,<br \/>\njoin \ub610\ub294 left join \uc0ac\uc6a9\uc2dc \uceec\ub7fc\uc744 \uc778\uc2dd\ud558\uc9c0 \ubabb\ud558\ub294 \ubc84\uadf8\uac00 \uc788\ub2e4.<\/p>\n<blockquote>\n<p>\uc5f4 \uc774\ub984 e.itemid\uc774(\uac00) \uc798\ubabb\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n<pre><code class=\"language-java\">    public PagingQueryProvider  createQueryProviderForInsert() throws Exception {\n        SqlPagingQueryProviderFactoryBean queryProviderFactoryBean = new SqlPagingQueryProviderFactoryBean();\n\n        queryProviderFactoryBean.setDataSource(dataSource);\n        queryProviderFactoryBean.setSelectClause(&quot;select e.*&quot;);\n        queryProviderFactoryBean.setFromClause(&quot;from db_test.dbo.tbl_test e left outer join db_test.dbo.tbl_test_transfer t on e.itemid = t.itemid&quot;);\n        queryProviderFactoryBean.setWhereClause(&quot;where t.itemid is NULL&quot;);\n        \/\/ \uc5f4 \uc774\ub984 e.itemid\uc774(\uac00) \uc798\ubabb\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\n        queryProviderFactoryBean.setSortKey(&quot;e.itemid&quot;);\n\n        return queryProviderFactoryBean.getObject();\n    }<\/code><\/pre>\n<p>\uc774\ub7f0 \uacbd\uc6b0 \uc544\ub798\ucc98\ub7fc \ud544\uc694\ud55c \uceec\ub7fc\uc758 alias \ub97c \ucd94\uac00\ub85c \uc0dd\uc131\ud574 \uc8fc\uba74 \ubc84\uadf8\ub97c \ud574\uacb0\ud560 \uc218 \uc788\ub2e4.<\/p>\n<pre><code class=\"language-java\">    public PagingQueryProvider  createQueryProviderForInsert() throws Exception {\n        SqlPagingQueryProviderFactoryBean queryProviderFactoryBean = new SqlPagingQueryProviderFactoryBean();\n\n        queryProviderFactoryBean.setDataSource(dataSource);\n        queryProviderFactoryBean.setSelectClause(&quot;select e.*, e.itemid as itemid1&quot;);\n        queryProviderFactoryBean.setFromClause(&quot;from db_test.dbo.tbl_test e left outer join db_test.dbo.tbl_test_transfer t on e.itemid = t.itemid&quot;);\n        queryProviderFactoryBean.setWhereClause(&quot;where t.itemid is NULL&quot;);\n        queryProviderFactoryBean.setSortKey(&quot;itemid1&quot;);\n\n        return queryProviderFactoryBean.getObject();\n    }<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SqlPagingQueryProviderFactoryBean join \ubc84\uadf8 Spring Batch \ubc84\uc804\uc5d0 \ub530\ub77c, join \ub610\ub294 left join \uc0ac\uc6a9\uc2dc \uceec\ub7fc\uc744 \uc778\uc2dd\ud558\uc9c0 \ubabb\ud558\ub294 \ubc84\uadf8\uac00 \uc788\ub2e4. \uc5f4 \uc774\ub984 e.itemid\uc774(\uac00) \uc798\ubabb\ub418\uc5c8\uc2b5\ub2c8\ub2e4. public PagingQueryProvider createQueryProviderForInsert() throws Exception { SqlPagingQueryProviderFactoryBean queryProviderFactoryBean = new SqlPagingQueryProviderFactoryBean(); queryProviderFactoryBean.setDataSource(dataSource); queryProviderFactoryBean.setSelectClause(&quot;select e.*&quot;); queryProviderFactoryBean.setFromClause(&quot;from db_test.dbo.tbl_test e left outer join db_test.dbo.tbl_test_transfer t on e.itemid = t.itemid&quot;); queryProviderFactoryBean.setWhereClause(&quot;where t.itemid is NULL&quot;); \/\/ \uc5f4 \uc774\ub984 e.itemid\uc774(\uac00)\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=6498\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-6498","post","type-post","status-publish","format-standard","hentry","category-spring-boot-2-5"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6498"}],"version-history":[{"count":1,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6498\/revisions"}],"predecessor-version":[{"id":6499,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6498\/revisions\/6499"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}