{"id":666,"date":"2019-02-07T22:30:06","date_gmt":"2019-02-07T13:30:06","guid":{"rendered":"https:\/\/ito-u-oti.com\/?p=666"},"modified":"2019-02-07T22:30:06","modified_gmt":"2019-02-07T13:30:06","slug":"post-666","status":"publish","type":"post","link":"https:\/\/ito-u-oti.com\/?p=666","title":{"rendered":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09"},"content":{"rendered":"<h2 id=\"outline__1\">\u4e8b\u8c61<\/h2>\n<p>Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002<br \/>\nDB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v11.1.2 fixpack2\u304b\u3089v11.1.3.3 fixpack3\u306b\u5909\u66f4\u5f8c\u3001DB\u30a2\u30af\u30bb\u30b9\u5468\u308a\u306e\u30c6\u30b9\u30c8\u3092\u5b9f\u884c\u3057\u305f\u3068\u3053\u308d\u3001<br \/>\nSqlDataException\u304c\u767a\u751f\u3057\u3001SQLCODE=-180, SQLSTATE=22007\u3068\u51fa\u529b\u3055\u308c\u305f\u3002<\/p>\n<p>SQL\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSELECT\r\n    *\r\nFROM\r\n    HOGESCHEMA.POGETABLE\r\nWHERE\r\n    HOGESCHEMA.POGETABLE.hoge1 = RIGHT('0000000000' || TO_CHAR(?),10)\r\nAND\r\n(\r\n    (\r\n        HOGESCHEMA.POGETABLE.puge1 LIKE CONCAT(?,'%')\r\n        OR\r\n        HOGESCHEMA.POGETABLE.puge2 LIKE CONCAT(?,'%')\r\n    )\r\n    OR\r\n    (\r\n        HOGESCHEMA.POGETABLE.hogehoge1 LIKE CONCAT(?,'%')\r\n        AND\r\n        HOGESCHEMA.POGETABLE.pageStatus &gt;= 32\r\n    )\r\n)\r\n<\/pre>\n<h2 id=\"outline__2\">\u30a8\u30e9\u30fc\u5185\u5bb9<\/h2>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n### Error querying database.  Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.23.42\r\n### The error may exist in jp\/repository\/Hoge\/HogeRepository.xml\r\n### The error may involve jp.repository.Hoge.HogeRepository.select_MainTable_001-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT * FROM HOGESCHEMA.POGETABLE WHERE HOGESCHEMA.POGETABLE.hoge1 = RIGHT('0000000000' || TO_CHAR(?),10) AND ( ( HOGESCHEMA.POGETABLE.puge1 LIKE CONCAT(?,'%') OR HOGESCHEMA.POGETABLE.puge2 LIKE CONCAT(?,'%') ) OR ( HOGESCHEMA.POGETABLE.hogehoge1 LIKE CONCAT(?,'%') AND HOGESCHEMA.POGETABLE.pageStatus &gt;= 32 ) )\r\n### Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.23.42\r\n; SQL &#x5B;]; DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.23.42; nested exception is com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.23.42\r\n\tat org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:82)\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n\tat org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n\tat com.sun.proxy.$Proxy36.selectList(Unknown Source)\r\n\tat org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)\r\n\tat org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)\r\n\tat org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)\r\n\tat org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n\tat com.sun.proxy.$Proxy38.select_MainTable_001(Unknown Source)\r\n\tat jp.repository.Hoge.HogeRepositoryTest.repositoryTest(HogeRepositoryTest.java:180)\r\n\t... 44 more\r\nCaused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-180, SQLSTATE=22007, SQLERRMC=null, DRIVER=4.23.42\r\n\tat com.ibm.db2.jcc.am.ld.a(ld.java:802)\r\n\tat com.ibm.db2.jcc.am.ld.a(ld.java:66)\r\n\tat com.ibm.db2.jcc.am.ld.a(ld.java:140)\r\n\tat com.ibm.db2.jcc.am.aq.c(aq.java:2807)\r\n\tat com.ibm.db2.jcc.am.aq.a(aq.java:2244)\r\n\tat com.ibm.db2.jcc.t4.bb.r(bb.java:1463)\r\n\tat com.ibm.db2.jcc.t4.bb.l(bb.java:588)\r\n\tat com.ibm.db2.jcc.t4.bb.d(bb.java:98)\r\n\tat com.ibm.db2.jcc.t4.p.c(p.java:44)\r\n\tat com.ibm.db2.jcc.t4.vb.j(vb.java:162)\r\n\tat com.ibm.db2.jcc.am.aq.nb(aq.java:2239)\r\n\tat com.ibm.db2.jcc.am.bq.a(bq.java:4637)\r\n\tat com.ibm.db2.jcc.am.bq.b(bq.java:4154)\r\n\tat com.ibm.db2.jcc.am.bq.qc(bq.java:2874)\r\n\tat com.ibm.db2.jcc.am.bq.execute(bq.java:2849)\r\n\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)\r\n\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)\r\n\tat net.sf.log4jdbc.PreparedStatementSpy.execute(PreparedStatementSpy.java:418)\r\n\tat org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)\r\n\tat org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)\r\n\tat org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)\r\n\tat org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)\r\n\tat org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)\r\n\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)\r\n\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)\r\n\tat sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:498)\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n\t... 51 more\r\n&#x5B;2018\/12\/04 12:26:47] &#x5B;main] &#x5B;j.c.n.s.r.p.d.B.HogeRepositoryTest] &#x5B;ERROR] 9\u4ef6\u306eAssertionError\u304c\u767a\u751f\u3057\u3066\u3044\u307e\u3059\r\nTests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 226.489 sec &lt;&lt;&lt; FAILURE! - in jp.repository.Hoge.HogeRepositoryTest\r\njp.repository.Hoge.HogeRepositoryTest  Time elapsed: 225.49 sec  &lt;&lt;&lt; FAILURE!\r\njava.lang.AssertionError: 9\u4ef6\u306eAssertionError\u304c\u767a\u751f\u3057\u3066\u3044\u307e\u3059\r\n\tat jp.repository.HogeRepositoryTest.creanUpAfterTest(HogeRepositoryTest.java:144)\r\n\r\n&#x5B;2018\/12\/04 12:26:47] &#x5B;Thread-1] &#x5B;o.s.c.s.GenericApplicationContext] &#x5B;INFO ] Closing org.springframework.context.support.GenericApplicationContext@2f8dad04: startup date &#x5B;Tue Dec 04 12:23:03 JST 2018]; root of context hierarchy\r\n\r\nResults :\r\n\r\nFailed tests: \r\n  HogeRepositoryTest.creanUpAfterTest:144 9\u4ef6\u306eAssertionError\u304c\u767a\u751f\u3057\u3066\u3044\u307e\u3059\r\n\r\nTests run: 2, Failures: 1, Errors: 0, Skipped: 0\r\n\r\n&#x5B;INFO] ------------------------------------------------------------------------\r\n&#x5B;INFO] Reactor Summary:\r\n&#x5B;INFO] \r\n&#x5B;INFO] testProject-parent 1.0-SNAPSHOT .................. SUCCESS &#x5B;  0.704 s]\r\n&#x5B;INFO] testProject-env .................................. SUCCESS &#x5B;  2.849 s]\r\n&#x5B;INFO] testProject 1.0.0-SNAPSHOT ....................... FAILURE &#x5B;06:14 min]\r\n&#x5B;INFO] ------------------------------------------------------------------------\r\n&#x5B;INFO] BUILD FAILURE\r\n&#x5B;INFO] ------------------------------------------------------------------------\r\n&#x5B;INFO] Total time: 06:18 min\r\n&#x5B;INFO] Finished at: 2018-12-04T12:26:48+09:00\r\n&#x5B;INFO] ------------------------------------------------------------------------\r\n&#x5B;ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.19.1:test (default-test) on project testProject: There are test failures.\r\n&#x5B;ERROR] \r\n&#x5B;ERROR] Please refer to C:\\Users\\Jiki-Admin\\.jenkins\\workspace&#92;&#48;00_testProject-parent single_Test\\testProject\\target\\surefire-reports for the individual test results.\r\n&#x5B;ERROR] -&gt; &#x5B;Help 1]\r\n&#x5B;ERROR] \r\n&#x5B;ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.\r\n&#x5B;ERROR] Re-run Maven using the -X switch to enable full debug logging.\r\n&#x5B;ERROR] \r\n&#x5B;ERROR] For more information about the errors and possible solutions, please read the following articles:\r\n&#x5B;ERROR] &#x5B;Help 1] http:\/\/cwiki.apache.org\/confluence\/display\/MAVEN\/MojoFailureException\r\n&#x5B;ERROR] \r\n&#x5B;ERROR] After correcting the problems, you can resume the build with the command\r\n&#x5B;ERROR]   mvn &lt;goals&gt; -rf :testProject\r\nBuild step 'Maven\u306e\u547c\u3073\u51fa\u3057' marked build as failure\r\nFinished: FAILURE\r\n<\/pre>\n<h2 id=\"outline__3\">\u539f\u56e0<\/h2>\n<p>SQLCODE=-180, SQLSTATE=22007\u306f<br \/>\n<span class=\"asterisk\">DATE\u3001TIME\u3001\u307e\u305f\u306f TIMESTAMP value \u306e\u3001\u9577\u3055\u307e\u305f\u306f\u30b9\u30c8\u30ea\u30f3\u30b0\u8868\u8a18\u304c\u3001 \u6709\u52b9\u306a\u5f62\u5f0f\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/span><br \/>\n\u3068\u3044\u3046\u3053\u3068\u3089\u3057\u3044\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001SELECT\u5bfe\u8c61\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u65e5\u4ed8\u578b\u306e\u30ab\u30e9\u30e0\u306f\u5b58\u5728\u3057\u306a\u3044\u3002<br \/>\n\u3069\u3046\u3084\u3089\u3001table\u306b\u306fDate\u578b\u3084TIMESTAMP\u578b\u306a\u3069\u306e\u8a2d\u5b9a\u306f\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u304c\u3001<br \/>\nTO_CHAR\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3001\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u6307\u5b9a\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u3053\u3068\u304c\u539f\u56e0\u3089\u3057\u3044\u3002<\/p>\n<h2 id=\"outline__4\">\u89e3\u6c7a\u7b56<\/h2>\n<p>TO_CHAR\u95a2\u6570\u306b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nSELECT\r\n    *\r\nFROM\r\n    HOGESCHEMA.POGETABLE\r\nWHERE\r\n    HOGESCHEMA.POGETABLE.hoge1 = RIGHT('0000000000' || TO_CHAR(?,'YYYYMMDD'),10)\r\nAND\r\n(\r\n    (\r\n        HOGESCHEMA.POGETABLE.puge1 LIKE CONCAT(?,'%')\r\n        OR\r\n        HOGESCHEMA.POGETABLE.puge2 LIKE CONCAT(?,'%')\r\n    )\r\n    OR\r\n    (\r\n        HOGESCHEMA.POGETABLE.hogehoge1 LIKE CONCAT(?,'%')\r\n        AND\r\n        HOGESCHEMA.POGETABLE.pageStatus &gt;= 32\r\n    )\r\n)\r\n<\/pre>\n<h2 id=\"outline__5\">\u5099\u8003<\/h2>\n<p>\u306a\u3093\u3067\u5143\u3005\u306eSQL\u3067\u52d5\u3044\u3066\u3044\u305f\u304b\u306f\u4e0d\u660e\u3002<br \/>\nfixPack\u304c\u66f4\u65b0\u3055\u308c\u3066TO_CHAR\u306e\u4f7f\u3044\u65b9\u304c\u53b3\u5bc6\u306b\u306a\u3063\u305f\u30fb\u30fb\uff1f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":93,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[58,13,149,44,157,156,158],"class_list":["post-666","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-error-bugs","tag-db2","tag-mybatis","tag-spring-batch","tag-sql","tag-sqlcode-180","tag-sqldataexception","tag-sqlstate22007"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"\u3044\u3068\u3068\u3044\"\/>\n\t<meta name=\"google-site-verification\" content=\"dHfPMd0QGg17gHdKjRsKPMBchJp5FPXghry3uflwfwM\" \/>\n\t<meta name=\"keywords\" content=\"spring batch,sql,db2,mybatis,sqldataexception,sqlcode=-180,sqlstate=22007\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/ito-u-oti.com\/?p=666\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1\" \/>\n\t\t<meta property=\"og:description\" content=\"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/ito-u-oti.com\/?p=666\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-02-07T13:30:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-02-07T13:30:06+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@itouoti_IoT\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#article\",\"name\":\"Spring batch\\u3067mybatis\\u304c\\u30a8\\u30e9\\u30fc\\uff08SQLCODE=-180, SQLSTATE=22007\\uff09 | \\u30f0\\u5200\\u306e\\u304a\\u3082\\u3061\\u3083\\u7bb1\",\"headline\":\"Spring batch\\u3067mybatis\\u304c\\u30a8\\u30e9\\u30fc\\uff08SQLCODE=-180, SQLSTATE=22007\\uff09\",\"author\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/spring.png\",\"width\":900,\"height\":900},\"datePublished\":\"2019-02-07T22:30:06+09:00\",\"dateModified\":\"2019-02-07T22:30:06+09:00\",\"inLanguage\":\"ja\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#webpage\"},\"articleSection\":\"\\u30a8\\u30e9\\u30fc\\u30fb\\u30d0\\u30b0\\u5bfe\\u51e6, DB2, mybatis, Spring batch, sql, SQLCODE=-180, SqlDataException, SQLSTATE=22007\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com#listItem\",\"position\":1,\"name\":\"\\u30db\\u30fc\\u30e0\",\"item\":\"https:\\\/\\\/ito-u-oti.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=6#listItem\",\"name\":\"\\u30d7\\u30ed\\u30b0\\u30e9\\u30df\\u30f3\\u30b0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=6#listItem\",\"position\":2,\"name\":\"\\u30d7\\u30ed\\u30b0\\u30e9\\u30df\\u30f3\\u30b0\",\"item\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=6\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=7#listItem\",\"name\":\"\\u30a8\\u30e9\\u30fc\\u30fb\\u30d0\\u30b0\\u5bfe\\u51e6\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com#listItem\",\"name\":\"\\u30db\\u30fc\\u30e0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=7#listItem\",\"position\":3,\"name\":\"\\u30a8\\u30e9\\u30fc\\u30fb\\u30d0\\u30b0\\u5bfe\\u51e6\",\"item\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=7\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#listItem\",\"name\":\"Spring batch\\u3067mybatis\\u304c\\u30a8\\u30e9\\u30fc\\uff08SQLCODE=-180, SQLSTATE=22007\\uff09\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=6#listItem\",\"name\":\"\\u30d7\\u30ed\\u30b0\\u30e9\\u30df\\u30f3\\u30b0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#listItem\",\"position\":4,\"name\":\"Spring batch\\u3067mybatis\\u304c\\u30a8\\u30e9\\u30fc\\uff08SQLCODE=-180, SQLSTATE=22007\\uff09\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?cat=7#listItem\",\"name\":\"\\u30a8\\u30e9\\u30fc\\u30fb\\u30d0\\u30b0\\u5bfe\\u51e6\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/#person\",\"name\":\"\\u3044\\u3068\\u3068\\u3044\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#personImage\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/IMG_20191231_122527_095-150x150.jpg\",\"width\":96,\"height\":96,\"caption\":\"\\u3044\\u3068\\u3068\\u3044\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/itouoti_IoT\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/?author=1\",\"name\":\"\\u3044\\u3068\\u3068\\u3044\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#authorImage\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/IMG_20191231_122527_095-150x150.jpg\",\"width\":96,\"height\":96,\"caption\":\"\\u3044\\u3068\\u3068\\u3044\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/itouoti_IoT\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#webpage\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666\",\"name\":\"Spring batch\\u3067mybatis\\u304c\\u30a8\\u30e9\\u30fc\\uff08SQLCODE=-180, SQLSTATE=22007\\uff09 | \\u30f0\\u5200\\u306e\\u304a\\u3082\\u3061\\u3083\\u7bb1\",\"description\":\"\\u4e8b\\u8c61 Spring batch\\u3067DB2\\u3092\\u4f7f\\u7528\\u3057\\u3066\\u304a\\u308a\\u3001\\u305d\\u308c\\u307e\\u3067\\u306f\\u6b63\\u5e38\\u306b\\u52d5\\u4f5c\\u3057\\u3066\\u3044\\u305f\\u3002 DB2\\u306e\\u30d0\\u30fc\\u30b8\\u30e7\\u30f3\\u3092v1\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/spring.png\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666\\\/#mainImage\",\"width\":900,\"height\":900},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/?p=666#mainImage\"},\"datePublished\":\"2019-02-07T22:30:06+09:00\",\"dateModified\":\"2019-02-07T22:30:06+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/#website\",\"url\":\"https:\\\/\\\/ito-u-oti.com\\\/\",\"name\":\"\\u30f0\\u5200\\u306e\\u304a\\u3082\\u3061\\u3083\\u7bb1\",\"description\":\"music\\u00d7IT\\u00d7guiter\\u00d7programing\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/ito-u-oti.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","description":"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1","canonical_url":"https:\/\/ito-u-oti.com\/?p=666","robots":"max-image-preview:large","keywords":"spring batch,sql,db2,mybatis,sqldataexception,sqlcode=-180,sqlstate=22007","webmasterTools":{"google-site-verification":"dHfPMd0QGg17gHdKjRsKPMBchJp5FPXghry3uflwfwM","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ito-u-oti.com\/?p=666#article","name":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","headline":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09","author":{"@id":"https:\/\/ito-u-oti.com\/?author=1#author"},"publisher":{"@id":"https:\/\/ito-u-oti.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png","width":900,"height":900},"datePublished":"2019-02-07T22:30:06+09:00","dateModified":"2019-02-07T22:30:06+09:00","inLanguage":"ja","mainEntityOfPage":{"@id":"https:\/\/ito-u-oti.com\/?p=666#webpage"},"isPartOf":{"@id":"https:\/\/ito-u-oti.com\/?p=666#webpage"},"articleSection":"\u30a8\u30e9\u30fc\u30fb\u30d0\u30b0\u5bfe\u51e6, DB2, mybatis, Spring batch, sql, SQLCODE=-180, SqlDataException, SQLSTATE=22007"},{"@type":"BreadcrumbList","@id":"https:\/\/ito-u-oti.com\/?p=666#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com#listItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/ito-u-oti.com","nextItem":{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?cat=6#listItem","name":"\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0"}},{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?cat=6#listItem","position":2,"name":"\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0","item":"https:\/\/ito-u-oti.com\/?cat=6","nextItem":{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?cat=7#listItem","name":"\u30a8\u30e9\u30fc\u30fb\u30d0\u30b0\u5bfe\u51e6"},"previousItem":{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com#listItem","name":"\u30db\u30fc\u30e0"}},{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?cat=7#listItem","position":3,"name":"\u30a8\u30e9\u30fc\u30fb\u30d0\u30b0\u5bfe\u51e6","item":"https:\/\/ito-u-oti.com\/?cat=7","nextItem":{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?p=666#listItem","name":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09"},"previousItem":{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?cat=6#listItem","name":"\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0"}},{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?p=666#listItem","position":4,"name":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09","previousItem":{"@type":"ListItem","@id":"https:\/\/ito-u-oti.com\/?cat=7#listItem","name":"\u30a8\u30e9\u30fc\u30fb\u30d0\u30b0\u5bfe\u51e6"}}]},{"@type":"Person","@id":"https:\/\/ito-u-oti.com\/#person","name":"\u3044\u3068\u3068\u3044","image":{"@type":"ImageObject","@id":"https:\/\/ito-u-oti.com\/?p=666#personImage","url":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2021\/06\/IMG_20191231_122527_095-150x150.jpg","width":96,"height":96,"caption":"\u3044\u3068\u3068\u3044"},"sameAs":["https:\/\/twitter.com\/itouoti_IoT"]},{"@type":"Person","@id":"https:\/\/ito-u-oti.com\/?author=1#author","url":"https:\/\/ito-u-oti.com\/?author=1","name":"\u3044\u3068\u3068\u3044","image":{"@type":"ImageObject","@id":"https:\/\/ito-u-oti.com\/?p=666#authorImage","url":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2021\/06\/IMG_20191231_122527_095-150x150.jpg","width":96,"height":96,"caption":"\u3044\u3068\u3068\u3044"},"sameAs":["https:\/\/twitter.com\/itouoti_IoT"]},{"@type":"WebPage","@id":"https:\/\/ito-u-oti.com\/?p=666#webpage","url":"https:\/\/ito-u-oti.com\/?p=666","name":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","description":"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1","inLanguage":"ja","isPartOf":{"@id":"https:\/\/ito-u-oti.com\/#website"},"breadcrumb":{"@id":"https:\/\/ito-u-oti.com\/?p=666#breadcrumblist"},"author":{"@id":"https:\/\/ito-u-oti.com\/?author=1#author"},"creator":{"@id":"https:\/\/ito-u-oti.com\/?author=1#author"},"image":{"@type":"ImageObject","url":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png","@id":"https:\/\/ito-u-oti.com\/?p=666\/#mainImage","width":900,"height":900},"primaryImageOfPage":{"@id":"https:\/\/ito-u-oti.com\/?p=666#mainImage"},"datePublished":"2019-02-07T22:30:06+09:00","dateModified":"2019-02-07T22:30:06+09:00"},{"@type":"WebSite","@id":"https:\/\/ito-u-oti.com\/#website","url":"https:\/\/ito-u-oti.com\/","name":"\u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","description":"music\u00d7IT\u00d7guiter\u00d7programing","inLanguage":"ja","publisher":{"@id":"https:\/\/ito-u-oti.com\/#person"}}]},"og:locale":"ja_JP","og:site_name":"\u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","og:type":"article","og:title":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","og:description":"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1","og:url":"https:\/\/ito-u-oti.com\/?p=666","og:image":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png","og:image:secure_url":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png","og:image:width":900,"og:image:height":900,"article:published_time":"2019-02-07T13:30:06+00:00","article:modified_time":"2019-02-07T13:30:06+00:00","twitter:card":"summary","twitter:title":"Spring batch\u3067mybatis\u304c\u30a8\u30e9\u30fc\uff08SQLCODE=-180, SQLSTATE=22007\uff09 | \u30f0\u5200\u306e\u304a\u3082\u3061\u3083\u7bb1","twitter:description":"\u4e8b\u8c61 Spring batch\u3067DB2\u3092\u4f7f\u7528\u3057\u3066\u304a\u308a\u3001\u305d\u308c\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u305f\u3002 DB2\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092v1","twitter:creator":"@itouoti_IoT","twitter:image":"https:\/\/ito-u-oti.com\/wp-content\/uploads\/2017\/10\/spring.png"},"aioseo_meta_data":{"post_id":"666","title":null,"description":null,"keywords":[{"label":"Spring batch","value":"Spring batch"},{"label":"SQL","value":"SQL"},{"label":"DB2","value":"DB2"},{"label":"mybatis","value":"mybatis"},{"label":"SqlDataException","value":"SqlDataException"},{"label":"SQLCODE=-180","value":"SQLCODE=-180"},{"label":"SQLSTATE=22007","value":"SQLSTATE=22007"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":"","og_description":"","og_object_type":"article","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":"","og_article_tags":"","twitter_use_og":false,"twitter_card":"summary","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-04-11 14:11:17","updated":"2025-06-04 05:57:08","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts\/666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=666"}],"version-history":[{"count":1,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts\/666\/revisions"}],"predecessor-version":[{"id":667,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts\/666\/revisions\/667"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/media\/93"}],"wp:attachment":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}