ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peng Wang <wpc...@gmail.com>
Subject Re: Need extra pair of eyes
Date Thu, 27 Jan 2005 22:49:34 GMT
remove ";"


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

Mime
View raw message