It is a copy and past error
-----Messaggio originale-----
Da: Giovanni Cuccu - CUP2000 [mailto:[EMAIL PROTECTED]
Inviato: lunedì 19 febbraio 2007 15.15
A: [email protected]
Oggetto: Re: handling null values
ciao Giuseppe,
is it a copy and paste error or did you forget the insert keyword in
the oracle sql?
Giovanni
> Hi all,
>
>
>
> I am developing an application which has to work with oracle and with mysql.
>
>
>
> I am using two different queries because in case the value x3=null and I
> am using oracle I get an exception.
>
> In case I use mysql I don't have any exception.
>
> I would like to know if I made some mistake or it is normal.
>
>
>
> <insert id="insertXXXMySQL">
>
> insert into XXX (x1, x2, x3, x4, x5, x6, x7)
>
> values (#x1#, #x2#, #x3#, #x4#, #x5#, #x6#, #x7#)
>
> </insert>
>
>
>
> <insert id="insertPraticaOracle">
>
> into XXX (x1, x2
>
> <dynamic>
>
> <isNotNull prepend="," property="x3">
>
> X3
>
> </isNotNull>
>
> </dynamic>
>
> ,x4, x5, x6, x7)
>
> values (#x1#, #x2#
>
> <dynamic>
>
> <isNotNull prepend="," property="x3">
>
> #x3#
>
> </isNotNull>
>
> </dynamic>
>
> ,#x4#, #x5#, #x6#, #x7#)
>
> </insert>
>
>
>
>
>
>
>
>
>
--
Giovanni Cuccu
CUP 2000 Spa
Via del Borgo di S. Pietro, 90/c - 40126 Bologna
e-mail: giovanni.cuccu _at_ cup2000.it
