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