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
