remove ";"
On Thu, 27 Jan 2005 15:24:10 -0700, Barnett, Brian W.
<[EMAIL PROTECTED]> wrote:
>
>
>
> 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
>
>
>
>
