You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by "Barnett, Brian W." <bb...@scholarinc.com> on 2005/01/27 23:24:10 UTC

Need extra pair of eyes

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

Posted by Peng Wang <wp...@gmail.com>.
remove ";"


On Thu, 27 Jan 2005 15:24:10 -0700, Barnett, Brian W.
<bb...@scholarinc.com> 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 
> 
>   
> 
>