데이터베이스 질문과 답변

oracle insert 질문합니다.(부적절한 열 인덱스) 0 4 2,415

by 너구링 [2016.05.20 14:35:15]

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
int check=-1;
        String sql="";
        try {
            try {
                conn = ConnectionManager.getConnection();
            } catch (NamingException e) {
                e.printStackTrace();
            }
 
            sql += "  INSERT INTO TABLE1";
            sql += "  (INCIDENT_ID,  ";
            sql += "  STRT_STD_LINK_ID,  ";
            sql += " STOP_STD_LINK_ID,  ";
            sql += "  STRT_INFO_OFFR_ID,  ";
            sql += "  STOP_INFO_OFFR_ID,  ";
            sql += "   STRT_NODE_ID,  ";
            sql += "   STOP_NODE_ID,  ";
            sql += "   STRTDATE,  ";
            sql += "   STOPDATE,  ";
            sql += " REGDATE,  ";
            sql += " INCIDENT_DVSN,  ";
            sql += " OTBR_CAUS,  ";
            sql += " OTBR_CONTENTS,  ";
            sql += " OTBR_DIR,  ";
            sql += " INCIDENTCODE,  ";
            sql += " INVOLVEDCODE,  ";
            sql += " STATUSCODE,  ";
            sql += " HUMANFATAL,  ";
            sql += " HUMANINJURY,  ";
            sql += " DAMAGECODE,  ";
            sql += " STRTDISTANCE,  ";
            sql += " STOPDISTANCE,  ";
            sql += " PLANCODE,  ";
            sql += " PLANDTLCODE,  ";
            sql += " ROADWAYCODE,  ";
            sql += " LANEBLOCK,  ";
            sql += " SHOULDBLOCK,  ";
            sql += " STRT_ITS_LINK_ID,  ";
            sql += " STOP_ITS_LINK_ID,  ";
            sql += " VMS_DSPL,  ";
            sql += " VMS_DSPL_TEXT)  ";
            sql += " VALUES  ";
            sql += "  ( ?,  ";
            sql += "    ?,  ";
            sql += "    ?,  ";
            sql += "        NULL,  ";
            sql += "        NULL,  ";
            sql += "        ?,  ";
            sql += "        ?,  ";
            sql += "        TO_CHAR('?', 'YYYY-MM-DD HH24:MI'),  ";
            sql += "    TO_CHAR('?,' 'YYYY-MM-DD HH24:MI'),  ";
            sql += "    TO_CHAR('20160201', 'YYYY-MM-DD HH24:MI'), ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    NULL,  ";
            sql += "    'N',  ";
            sql += "        NULL)   ";
 
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, incident_id);
            pstmt.setString(2, strt_node_id);
            pstmt.setString(3, stop_node_id);
            pstmt.setString(4, strt_std_link_id);
            pstmt.setString(5,  stop_std_link_id);
            pstmt.setString(6, strtdate);
            pstmt.setString(7, stopdate);
             
            check = pstmt.executeUpdate();

 

 

(부적절한 열 인덱스) >>날짜부분인것 같은데...조언 부탁드립니다. 

by 푸르른 [2016.05.20 14:50:18]

'?' 따옴표 필요없지 않나요 ?..

by 마농 [2016.05.20 15:42:57]

오~~~

"매의 눈" 을 가지셨군요. ^^

by 우리집아찌 [2016.05.20 15:41:56]
?
1
2
3
SELECT TO_DATE('2016-02-01 12:24', 'YYYY-MM-DD HH24:MI') FROM DUAL
 
-- 해달 컬럼이 DATE  TYPE 이시면

 

by 너구링 [2016.05.20 15:51:42]

답변 감사합니다. 위에분들 말씀다 맞고.. 날짜 파라미터가 0으로 넘어오고 있었네요..... 

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입