MERGE 사용시 0901오류 발생
SQL0901: SQL system error. Cause . . . . . : An SQL system error has occurred. The current SQL statement cannot be completed successfully. The error will not prevent other SQL statements from being processed. Previous messages may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. The previous message identifier was CPF4204. Internal error type 3002 has occurred. If precompiling, processing will not continue beyond this statement. Recovery . . . : See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile. An application program receiving this return code may attempt further SQL statements. Correct any errors and try the request again.
Spring 3.1.1 + myBatis 3.2.3 + spring-mybatis 1.2.0 환경에서 jtopen, native driver로 테스트결과
시간,JDBC Driver버전에 따라 차이가 발생하였습니다.락경합이 발생한 건지, 저널링시스템의 특성인지 알 수 없고,
CTE 사용이 문제가 된 거라면 아마도 Temporary가 다 찬건지
도저히 안되는 경우가 있어 MERGE를 사용하지 않았습니다.
PATCH를 하라는데,당췌...의견은 묵살할 것이 뻔한 상황이..아마 2015년도 중반..