|
Getting this error:
- The error occurred in com/scholar/model/map/OracleSpecificSQL.xml. --- The error occurred while applying a parameter map. --- Check the insertGradeLevel-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: ORA-00911: invalid character
Here is some debug logging:
[15:27] DEBUG PreparedStatement () - {pstm-100035} PreparedStatement: INSERT INTO grade_level ( grade_level,description,sif_code,external_key,district_id ) VALUES ( ?,?, ?,?, ? );
[15:27] DEBUG PreparedStatement () - {pstm-100035} Parameters: [16, 16, 16, , 1]
[15:27] DEBUG PreparedStatement () - {pstm-100035} Types: [java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, java.lang.Integer]
Here is the SQL Map code:
<insert id="insertGradeLevel" parameterClass="grade">
INSERT INTO grade_level ( grade_level,description,sif_code,external_key,district_id ) VALUES ( #gradeLevel:NUMERIC:-999#,#description:VARCHAR:null_string#, #sifCode:VARCHAR:null_string#,#externalKey:VARCHAR:null_string#, #districtId:NUMERIC:-999# );
<selectKey resultClass="int" keyProperty="gradeLevelId"> SELECT GRADE_LEVEL_SEQ.CURRVAL AS gradeLevelId FROM DUAL; </selectKey>
</insert>
If you see anything wrong, please advise.
Thanks, Brian Barnett
|
- Re: Need extra pair of eyes Barnett, Brian W.
- Re: Need extra pair of eyes Peng Wang
- RE: Need extra pair of eyes Barnett, Brian W.

