ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roger Baeza <roger...@yahoo.com>
Subject Re: How many field can insert
Date Thu, 17 Feb 2005 15:48:43 GMT
my xml have this specification


<insert id="insertDireccion"
parameterClass="sep.fmat.sipre.domain.DireccionBean">
    <selectKey resultClass="int"
keyProperty="direccionId">
        Select (max(Id_direccion) + 1) as direccionId
from direcciones
    </selectKey>
        
    Insert Into Direcciones
     (id_direccion, calle, entrecalle, ycalle,
nombrecol, num_int,
      num_ext, codpost, cve_mpio)
    values
      (#direccionId#, #calle#, #calle1#, #calle2#,
#colonia#, '',
       #numExt#, #codPos#, #municipioId#)
              
  </insert>

when i coment it, my daoManager can load succefull,
when I uncomente raise a exception

java.lang.ExceptionInInitializerError

sep.fmat.sipre.service.PreinscripcionService.<init>(PreinscripcionService.java:53)

sep.fmat.sipre.service.PreinscripcionService.<clinit>(PreinscripcionService.java:37)

sep.fmat.sipre.action.BusqAlumnoAction.execute(BusqAlumnoAction.java:66)



--- Larry Meadors <larry.meadors@gmail.com> wrote:

> 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
> 



		
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com 

Mime
View raw message