Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 3797 invoked by uid 99); 17 Feb 2005 15:55:50 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from web21523.mail.yahoo.com (HELO web21523.mail.yahoo.com) (66.163.170.142) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 17 Feb 2005 07:55:48 -0800 Received: (qmail 63751 invoked by uid 60001); 17 Feb 2005 15:55:47 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=OSrFSVVMVbV5x7QGCbAeIQkAKB4YoQ2Op3HCY3qq3bLi5QJ5LocYz1nQg1xZEtcx/VPxWraZjXPpxYOJiMVYXsIg6Ku5jrHZiKKpDau/PY2ycfPOCGS/LgzUsmxP/jUaXEEyqdSGAJAN5CepzPyT7h3nsUR+jxhMkutkCzTfYeo= ; Message-ID: <20050217155547.63749.qmail@web21523.mail.yahoo.com> Received: from [200.67.158.239] by web21523.mail.yahoo.com via HTTP; Thu, 17 Feb 2005 07:55:47 PST Date: Thu, 17 Feb 2005 07:55:47 -0800 (PST) From: Roger Baeza Subject: Re: R: How many field can insert To: ibatis-user-java@incubator.apache.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked My problem is when daoManager load configuration...not sql executing else... --- Fabrizio Gianneschi wrote: > The limit is imposed by the database or the JDBC > driver, on the length of > the entire query string. > > I remember an old query on SQLServer that didn't > work due a big dynamic SQL > IN clause. > > F > -----Messaggio originale----- > Da: Larry Meadors [mailto:larry.meadors@gmail.com] > Inviato: giovedi 17 febbraio 2005 16.40 > A: ibatis-user-java@incubator.apache.org; Brandon > Goodin > Oggetto: Re: How many field can insert > > > I have used iBATIS to insert dozens of fields. > AFAIK, there is no limit. > > Larry > > > On Thu, 17 Feb 2005 05:04:17 -0800 (PST), Roger > Baeza > > wrote: > > > Hello all > > > > > > Any one can help me... > > > > > > I'm usign sqlMap, when I put more than 9 field > to > > > insert statement like this > > > > > > 9 exactly > > > Insert Into spIngresoSecundaria > > > (IdPreinscripcion, IdAlumno, IdPrimaria, > > > IdSecundaria, TieneHermanos, > > > PrimariaInf, EsMenorA12, FechaPreIns, > FechaIns) > > > values > > > (0, #alumnoId#, #primariaId#, > #secundariaId#, > > > #tieneHermanos#, > > > #primariaInf#, #esMenora12#, current, > current) > > > > > > more than 9, > > > Insert Into spIngresoSecundaria > > > (IdPreinscripcion, IdAlumno, IdPrimaria, > > > IdSecundaria, TieneHermanos, > > > PrimariaInf, EsMenorA12, FechaPreIns, > FechaIns, > > > other) > > > values > > > (0, #alumnoId#, #primariaId#, > #secundariaId#, > > > #tieneHermanos#, > > > #primariaInf#, #esMenora12#, current, > current, > > > #other#) > > > > > > can let me inicialize the daoManager > > > > > > what's up? > > > > > > regards > > __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo