ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "De Gaetano Giuseppe" <degaet...@PITAGORA.IT>
Subject R: handling null values
Date Mon, 19 Feb 2007 14:53:43 GMT
It is a copy and past error

-----Messaggio originale-----
Da: Giovanni Cuccu - CUP2000 [mailto:giovanni.cuccu@cup2000.it] 
Inviato: lunedì 19 febbraio 2007 15.15
A: user-java@ibatis.apache.org
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


Mime
View raw message