[jira] Closed: (IBATIS-410) reporting error using a valid JDBC expression in Oracle

["Larry Meadors (JIRA)" <ib...@incubator.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.