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

 

 

Reply via email to