Return-Path: <wpcfan@gmail.com>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 72908 invoked by uid 99); 27 Jan 2005 22:49:47 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of wpcfan@gmail.com designates
 64.233.184.194 as permitted sender)
Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.194)
  by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 27 Jan 2005 14:49:47 -0800
Received: by wproxy.gmail.com with SMTP id 58so356294wri
        for <ibatis-user-java@incubator.apache.org>;
 Thu, 27 Jan 2005 14:49:34 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=JZ47HZMBe1vL2qmEGuB2cMcauWhlmKoSJHSPhA/w1Mo85J6aFMwjmiuNuRDc311WS2hptj70aILAcaKkzFYCsSFMR+F8AUzUHOABR1gwxqDBKuvZreHtv7+cDsaTRTcsvsi6UHBjRDl4FP1FntvWB1sVzkgseeuThjZJNb4yZNk=
Received: by 10.54.25.53 with SMTP id 53mr128926wry;
        Thu, 27 Jan 2005 14:49:34 -0800 (PST)
Received: by 10.54.3.20 with HTTP; Thu, 27 Jan 2005 14:49:34 -0800 (PST)
Message-ID: <299154da05012714493d059d36@mail.gmail.com>
Date: Fri, 28 Jan 2005 06:49:34 +0800
From: Peng Wang <wpcfan@gmail.com>
Reply-To: Peng Wang <wpcfan@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: Need extra pair of eyes
In-Reply-To: <42E7C401A4CBCD49829BB53DDD538BA4BFBE73@chmpgexgmail3.ic.ncs.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <42E7C401A4CBCD49829BB53DDD538BA4BFBE73@chmpgexgmail3.ic.ncs.com>
X-Virus-Checked: Checked

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 
> 
>   
> 
>