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

[Anaximandro de Godinho (JIRA)]

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