I thought I had tried with and without ";", but in all the iterations, I must have missed something. I removed both ";" and it worked. Thanks Peng!
-----Original Message----- From: Peng Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 3:50 PM To: [email protected] Subject: Re: Need extra pair of eyes 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 > > > >
