쿼리를 찍어보면 다음과 같이 나옵니다.
INSERT INTO SECA_GOOD
(
USER_ID, GUEST_MAIN, JUMIN_NO, COMP_GB, SEQ, KOR_NAME,
POLICY_NO, COMP_CD, GOOD_GB, BOJONG_CD, GOOD_NAME,
JU_JUMIN_NO, JU_NAME, GE_JUMIN_NO, GE_NAME, CONTRACT_DATE,
BOGI, BOGI_MONTH, NAPGI, NAPGI_MONTH, NAPBANG,
LAST_PAID_COUNT, LAST_PAID_MONTH, BO_RYO, BO_KEUM,
DEATH_ILBAN, DEATH_JAEHAE, DEATH_GYOJAE,
CANCER_JINDAN, CANCER_SU, CANCER_IPWON,
CEREBRAL_JINDAN, MYOCA_JINDAN, IPWON_DISEASE, IPWON_JAEHAE,
SU_DISEASE, SU_JAEHAE, OBSTACLE_KEUM2, OBSTACLE_KEUM6,
VALID_GB, NEW_BOJANG_GB,
INSERT_DATE, INSERT_TIME, UPDATE_DATE, UPDATE_TIME
)
VALUES
(
?, ?, ?, ?, -- USER_ID, GUEST_MAIN, JUMIN_NO, COMP_GB
(SELECT CASE S.CNT
WHEN 0 THEN 1
ELSE (SELECT MAX(SEQ)+1 AS MAXSEQ
FROM SECA_GOOD
WHERE USER_ID = ?
AND JUMIN_NO = ?
AND COMP_GB = '1')
END AS MAXSEQ
FROM
(SELECT COUNT(SEQ) AS CNT
FROM SECA_GOOD
WHERE USER_ID = ?
AND JUMIN_NO = ?
AND COMP_GB = '1') AS S
), ?, -- SEQ, KOR_NAME,
?, ?, ?, ?, ?, -- POLICY_NO, COMP_CD, GOOD_GB, BOJONG_CD, GOOD_NAME,
?, ?, ?, ?, ?, -- JU_JUMIN_NO, JU_NAME, GE_JUMIN_NO, GE_NAME, CONTRACT_DATE,
?, ?, ?, ?, ?, -- BOGI, BOGI_MONTH, NAPGI, NAPGI_MONTH, NAPBANG,
?, ?, ?, ?, -- LAST_PAID_COUNT, LAST_PAID_MONTH, BO_RYO, BO_KEUM,
?, ?, ?, -- DEATH_ILBAN, DEATH_JAEHAE, DEATH_GYOJAE,
?, ?, ?, -- CANCER_JINDAN, CANCER_SU, CANCER_IPWON,
?, ?, ?, ?, -- CEREBRAL_JINDAN, MYOCA_JINDAN, IPWON_DISEASE, IPWON_JAEHAE,
?, ?, ?, ?, -- SU_DISEASE, SU_JAEHAE, OBSTACLE_KEUM2, OBSTACLE_KEUM6,
?, ?, -- VALID_GB, NEW_BOJANG_GB,
?, ?, ?, ? -- INSERT_DATE, INSERT_TIME, UPDATE_DATE, UPDATE_TIME
)
위에 대응되는 파라미터들은 다음과 같고요...
1 = [9114580]
2 = [7601031123456]
3 = [7601031123456]
4 = [1]
5 = [9114580]
6 = [7601031123456]
7 = [9114580]
8 = [7601031123456]
9 = [이재학]
10 = [null]
11 = [4]
12 = [null]
13 = [null]
14 = [신보장]
15 = [7601031123456]
16 = [이재학]
17 = [null]
18 = [이재학]
19 = [20030303]
20 = [null]
21 = [203303]
22 = [null]
23 = [201303]
24 = [1]
25 = [null]
26 = [null]
27 = [74500]
28 = [null0000]
29 = [1753000000]
30 = [1380230000]
31 = [2183310000]
32 = [1834330000]
33 = [134830000]
34 = [118830000]
35 = [843430000]
36 = [84340000]
37 = [34840000]
38 = [374830000]
39 = [4348740000]
40 = [483440000]
41 = [214870000]
42 = [null0000]
43 = [Y]
44 = [N]
45 = [20041014]
46 = [140834]
47 = [20041014]
48 = [140834]
위와같은 쿼리를 실행하면...
Exception COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N "?, ?, ?, ?" 다음에 예기치 않은 토큰 ","이(가) 있었습니다. 예상되는 토큰으로는 ")"이(가) 있습니다. SQLSTATE=42601
이런 메시지가 나면서 SQLException 이 나오는데...
뭐가 잘못된건가요??
내용으로 봐선 신텍스 에러라는것같은데... 아무리 봐도 문법상 오류는 못찾겠네요... ㅜ.ㅜ
환경은
OS : AIX
WAS : WebSphere 5.0
DB : DB2
입니다.
|