Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 1152 invoked from network); 19 Feb 2007 15:18:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Feb 2007 15:18:19 -0000 Received: (qmail 74197 invoked by uid 500); 19 Feb 2007 15:18:24 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 74174 invoked by uid 500); 19 Feb 2007 15:18:24 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 74158 invoked by uid 99); 19 Feb 2007 15:18:24 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Feb 2007 07:18:24 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [212.131.171.241] (HELO mail.progetto-sole.it) (212.131.171.241) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 19 Feb 2007 07:18:13 -0800 Received: (qmail 21095 invoked from network); 19 Feb 2007 15:17:50 -0000 Received: from unknown (HELO ?127.0.0.1?) (172.16.20.105) by mail.progetto-sole.it with SMTP; 19 Feb 2007 15:17:50 -0000 Message-ID: <45D9BF9D.50002@cup2000.it> Date: Mon, 19 Feb 2007 16:17:49 +0100 From: Giovanni Cuccu - CUP2000 User-Agent: Mozilla Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: user-java@ibatis.apache.org Subject: Re: R: handling null values References: <45D9B0CF.1080704@cup2000.it> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org 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 into XXX (x1, x2, x3, x4, x5, x6, x7) >> >> values (#x1#, #x2#, #x3#, #x4#, #x5#, #x6#, #x7#) >> >> >> >> >> >> >> >> into XXX (x1, x2 >> >> >> >> >> >> X3 >> >> >> >> >> >> ,x4, x5, x6, x7) >> >> values (#x1#, #x2# >> >> >> >> >> >> #x3# >> >> >> >> >> >> ,#x4#, #x5#, #x6#, #x7#) >> >> >> >> >> >> >> >> >> >> >> > > -- Giovanni Cuccu CUP 2000 Spa Via del Borgo di S. Pietro, 90/c - 40126 Bologna e-mail: giovanni.cuccu _at_ cup2000.it