ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Giovanni Cuccu - CUP2000 <giovanni.cu...@cup2000.it>
Subject Re: R: handling null values
Date Mon, 19 Feb 2007 15:17:49 GMT
can you post the oracle error code plus java stack trace along the sql 
executed from the ibatis log file?
Giovanni

> 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