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:[EMAIL PROTECTED] 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 > <[EMAIL PROTECTED]> 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
