insert into SMS (SMS_NUM, SMS_WRITE_DATE, SMS_TITLE, SMS_CON, SMS_SENDER, SMS_SENDE_TEL, SMS_WRITER) values (seq_sms.nextVal, sysdate, ?, ?, ?, ?, ?)
Parameters: [asdajkshdjjkk, asdsdsdsaasdas, 세외수입정보화사업단, 02-2222-2222, 정명춘] Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String]错误提示:
javax.servlet.ServletException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in wnis/sms/dao/sqlmap/Sms.xml.
--- The error occurred while applying a parameter map.
--- Check the addSms-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02289: ?????
高手详细说说~~~
Parameters: [asdajkshdjjkk, asdsdsdsaasdas, 세외수입정보화사업단, 02-2222-2222, 정명춘] Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String]错误提示:
javax.servlet.ServletException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in wnis/sms/dao/sqlmap/Sms.xml.
--- The error occurred while applying a parameter map.
--- Check the addSms-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-02289: ?????
高手详细说说~~~
seq_sms.nextVal取的是序列下一个值.
你建立一下序列吧.
要不就按这个在ORACLE里面创建个序列,序列从1取到99999,每seq_sms.nextVal一次自动加1