Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of larry.meadors@gmail.com
 designates 66.249.92.174 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=qBFUnGksDUM4t2foRBDH6eyERQoP3xcZ0Yx4iP9FDf7PODXmYMF35Cc1SLhLLyKy2pKYJ+EWEZQFE91HNZPFpDXfxqwXvE3WxqHUH56pABJF761/hZsiYyVq31gj0lvmvEP62DuQha9hx8bectM+l5eiCVm55wkeZ9B2gvgegCA=
Message-ID: <a10a823c0711010937q1970fbe9i8ab07670031674fa@mail.gmail.com>
Date: Thu, 1 Nov 2007 10:37:28 -0600
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Problem with insertKey
In-Reply-To: <20071101154754.1DE0772494F@athena.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <002c01c81c95$238a4c30$0301a8c0@VAIOSZ330>
	 <20071101154754.1DE0772494F@athena.apache.org>

Try

SELECT obituary_seq.NEXTVAL AS id FROM dual

instead (id, not value).

Larry


On 11/1/07, Odelya Glick <odelya@jpost.com> wrote:
> Well,
>
> I changed it, but it always puts value 0.
>
> The sequence is declared like this:
>
> CREATE SEQUENCE obituary_seq
>     INCREMENT BY 3
>     START WITH 100
>     NOMAXVALUE
>     MINVALUE 100
>     NOCYCLE
>     CACHE 20
>     NOORDER
>
> What could be the problem?
>
> Many thanks,
>
> Odelya
>
>
> -----Original Message-----
> From: Jean-Francois Poilpret [mailto:jfpoilpret@yahoo.fr]
> Sent: Thursday, November 01, 2007 4:40 PM
> To: user-java@ibatis.apache.org
> Subject: RE: Problem with insertKey
>
> An Oracle sequence cannot map to a String, so your condolence class should
> have the following properties:
> int id; (or long)
> String status;
>
> Cheers
>
> Jean-Francois
>
> -----Original Message-----
> From: Odelya Glick [mailto:odelya@jpost.com]
> Sent: Friday, November 02, 2007 9:21 AM
> To: user-java@ibatis.apache.org
> Subject: Problem with insertKey
>
>
> Hi,
>
> I am trying to receive primary key with:
> <insert id="insertCondolence" parameterClass="condolence">
>                 <selectKey keyProperty="id" resultClass="int">
>                         SELECT obituary_seq.NEXTVAL AS value FROM dual
>                 </selectKey>
>                 INSERT INTO CONDOLENCE(ID, STATUS)
>                 VALUES(#id#,#status#)
>         </insert>
>
> The condolence class has 2 properties:
> String id;
> String status;
>
> But it always inserts a record with the right status value, but id value is
> always null!!
>
> Why?
>
> Thanks
> Odelya
> web-programmer
> 050-2052075
>
>
>
>
>
>
>
>
> ****************************************************************************
> ********
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
> ****************************************************************************
> ********
>
>
>
>
>