ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fabrizio Gianneschi" <fabrizio.giannes...@gruppoatlantis.com>
Subject R: How many field can insert
Date Thu, 17 Feb 2005 15:50:25 GMT
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
> <rogerimo@yahoo.com> 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


Mime
View raw message