프로그램/database

java.sql.SQLException: ORA-00911: 문자가 부적합합니다

mulderu 2009. 1. 15. 16:48
jdbc execute 시SQL 안의 ';' 를 빼주세요
-----------------------------------------------------------------------------------------------
     [java] DEBUG (ApprTxDAO.java[insert_ctrn01t_log]:908) [2009-01-15 16:40:17,752] - INSERT INTO GW_USER.CTRN01T VALUES (
     [java]  SYS_GUID(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 3, 'L'  );

     [java] ERROR (ApprTxDAO.java[insert_ctrn01t_log]:929) [2009-01-15 16:40:17,820] - ORA-00911: 문자가 부적합합니다

     [java] ERROR (ClpXMLWork.java[process]:200) [2009-01-15 16:40:17,821] - [Runtime Exception] Invalid Xml file=/app/acube/handy2acube/data/2007/7001852/6666555/7001980/7001981/7002134/7001982/CLIP/queue/7001982AA0000102007000001001.xml
     [java] ERROR (ClpXMLWork.java[process]:201) [2009-01-15 16:40:17,823] - [Runtime Exception] :ORA-00911: 문자가 부적합합니다

     [java]  WARN (ImportService.java[main]:97) [2009-01-15 16:40:17,826] - processXML Fail:CLP:/app/acube/handy2acube/data/2007/7001852/6666555/7001980/7001981/7002134/7001982/CLIP/queue/7001982AA0000102007000001001.xml
     [java] java.sql.SQLException: ORA-00911: 문자가 부적합합니다

     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
     [java]     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
     [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
     [java]     at handyexport.util.ApprTxDAO.insert_ctrn01t_log(ApprTxDAO.java:926)
     [java]     at com.sds.acube.dm.gov.migration.ClpXMLWork.process(ClpXMLWork.java:161)
     [java]     at com.sds.acube.dm.gov.migration.ImportService.processXML(ImportService.java:29)
     [java]     at com.sds.acube.dm.gov.migration.ImportService.main(ImportService.java:92)