ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Barnett, Brian W." <bbarn...@scholarinc.com>
Subject RE: Need extra pair of eyes
Date Thu, 27 Jan 2005 22:51:18 GMT
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:wpcfan@gmail.com] 
Sent: Thursday, January 27, 2005 3:50 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Need extra pair of eyes

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