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
\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
\nSqlDataException\u304c\u767a\u751f\u3057\u3001SQLCODE=-180, SQLSTATE=22007\u3068\u51fa\u529b\u3055\u308c\u305f\u3002<\/p>\n
SQL\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n
\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 >= 32\r\n )\r\n)\r\n<\/pre>\n\u30a8\u30e9\u30fc\u5185\u5bb9<\/h2>\n\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 >= 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 []; 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[2018\/12\/04 12:26:47] [main] [j.c.n.s.r.p.d.B.HogeRepositoryTest] [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 <<< FAILURE! - in jp.repository.Hoge.HogeRepositoryTest\r\njp.repository.Hoge.HogeRepositoryTest Time elapsed: 225.49 sec <<< 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[2018\/12\/04 12:26:47] [Thread-1] [o.s.c.s.GenericApplicationContext] [INFO ] Closing org.springframework.context.support.GenericApplicationContext@2f8dad04: startup date [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[INFO] ------------------------------------------------------------------------\r\n[INFO] Reactor Summary:\r\n[INFO] \r\n[INFO] testProject-parent 1.0-SNAPSHOT .................. SUCCESS [ 0.704 s]\r\n[INFO] testProject-env .................................. SUCCESS [ 2.849 s]\r\n[INFO] testProject 1.0.0-SNAPSHOT ....................... FAILURE [06:14 min]\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] BUILD FAILURE\r\n[INFO] ------------------------------------------------------------------------\r\n[INFO] Total time: 06:18 min\r\n[INFO] Finished at: 2018-12-04T12:26:48+09:00\r\n[INFO] ------------------------------------------------------------------------\r\n[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[ERROR] \r\n[ERROR] Please refer to C:\\Users\\Jiki-Admin\\.jenkins\\workspace\000_testProject-parent single_Test\\testProject\\target\\surefire-reports for the individual test results.\r\n[ERROR] -> [Help 1]\r\n[ERROR] \r\n[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.\r\n[ERROR] Re-run Maven using the -X switch to enable full debug logging.\r\n[ERROR] \r\n[ERROR] For more information about the errors and possible solutions, please read the following articles:\r\n[ERROR] [Help 1] http:\/\/cwiki.apache.org\/confluence\/display\/MAVEN\/MojoFailureException\r\n[ERROR] \r\n[ERROR] After correcting the problems, you can resume the build with the command\r\n[ERROR] mvn <goals> -rf :testProject\r\nBuild step 'Maven\u306e\u547c\u3073\u51fa\u3057' marked build as failure\r\nFinished: FAILURE\r\n<\/pre>\n\u539f\u56e0<\/h2>\n
SQLCODE=-180, SQLSTATE=22007\u306f
\nDATE\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>
\n\u3068\u3044\u3046\u3053\u3068\u3089\u3057\u3044\u3002<\/p>\n\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
\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
\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
\u89e3\u6c7a\u7b56<\/h2>\n
TO_CHAR\u95a2\u6570\u306b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
\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 >= 32\r\n )\r\n)\r\n<\/pre>\n\u5099\u8003<\/h2>\n
\u306a\u3093\u3067\u5143\u3005\u306eSQL\u3067\u52d5\u3044\u3066\u3044\u305f\u304b\u306f\u4e0d\u660e\u3002
\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":"
\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 […]<\/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":[],"_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}]}}