Return-Path: 
 <dev-return-3871-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 94654 invoked from network); 25 Mar 2007 03:12:55 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 25 Mar 2007 03:12:55 -0000
Received: (qmail 13304 invoked by uid 500); 25 Mar 2007 03:13:02 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 13282 invoked by uid 500); 25 Mar 2007 03:13:02 -0000
Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@ibatis.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@ibatis.apache.org>
List-Post: <mailto:dev@ibatis.apache.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: dev@ibatis.apache.org
Delivered-To: mailing list dev@ibatis.apache.org
Received: (qmail 13271 invoked by uid 99); 25 Mar 2007 03:13:02 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Mar 2007 20:13:02 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Mar 2007 20:12:54 -0700
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id ECF76714040
	for <dev@ibatis.apache.org>; Sat, 24 Mar 2007 20:12:33 -0700 (PDT)
Message-ID: <28661438.1174792353968.JavaMail.jira@brutus>
Date: Sat, 24 Mar 2007 20:12:33 -0700 (PDT)
From: "Larry Meadors (JIRA)" <ibatis-dev@incubator.apache.org>
To: dev@ibatis.apache.org
Subject: [jira] Closed: (IBATIS-410) <selectKey> reporting error using a
 valid JDBC expression in Oracle
In-Reply-To: <23682191.1174601432304.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/IBATIS-410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Larry Meadors closed IBATIS-410.
--------------------------------


> <selectKey> reporting error using a valid JDBC expression in Oracle
> -------------------------------------------------------------------
>
>                 Key: IBATIS-410
>                 URL: https://issues.apache.org/jira/browse/IBATIS-410
>             Project: iBatis for Java
>          Issue Type: Bug
>    Affects Versions: 2.3.0
>         Environment: Oracle 10g, OC4J 10.1.3.0, eclipse 3.2.2
>            Reporter: Anaximandro de Godinho
>
> Hi guys, I got one exception using a valid JDBC expression, see below:
> 	<insert id="incluir_Projeto" parameterClass="ProjetoTO">
> 		<selectKey type="pre" resultClass="Integer" keyProperty="idProjeto">
> 			SELECT ${DBALIAS}.FVGPROJT_SEQ.NextVal() AS ID FROM DUAL
> 		</selectKey>
> 		INSERT 
> 		INTO	${DBALIAS}.FVGPROJT(
> 				FVGIDPRO,
> 				FVGIDMOD,
> 				FVGIDPRF,
> 				FVGNMPRO
> 		) VALUES (
> 				#idProjeto#,
> 				#idModelo#,
> 				#idProjetoPai#,
> 				#nomeProjeto#
> 		)
> 	</insert>
> If you try to use "SELECT MySCHEMA.FVGPROJT_SEQ.NextVal() FROM DUAL" with jdbc it works fine (FVGPROJT_SEQ is a oracle sequence).
> I just removed the () at the end of the NEXTVAL function and it worked, but, IMO, since this is a valid JDBC and NextVal is a function (not a keywork) this is a bug.
> Woody

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.