ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: SQL statment => insert select
Date Tue, 19 Apr 2005 22:18:39 GMT
It should execute just fine. I don't see any reason why it wouldn't.
Did you enable logging or debug your app and make sure it is actually
getting called?

Brandon

On 4/19/05, Miquel Angel Bada Zuazo <mabada@gmail.com> wrote:
> I'm creating an Insert SQL statment woth the result of a selectsentence,
> 
> it works fine as a SQL statment, but when I tray to execute with
> IBatis, i don't know why, but it isn' executed, and there are no error
> ...
> 
> does anybody knows if I can execute the following statment?
> 
> <typeAlias alias="copiarPlantilla" type="stacks.domain.agenda.CopiarPlantilla"/>
> 
>         <insert id="insertItemCopiarPlantilla" parameterClass="copiarPlantilla">
>                 INSERT INTO stk_plantillas_horarios
>                 (PLA_ID, ACT_ID, IND_ID, DIASEMANA, HORA)
>                 SELECT #agendaAlId#, ph.ACT_ID, ph.IND_ID, #diaSemana#, ph.HORA
>                 FROM stk_plantillas_horarios ph
>                 WHERE ph.PLA_ID = #agendaDeId#
>                 AND ph.DIASEMANA = #diaSemana#
>         </insert>
> 
> Sincerely Yours,
> 
> Miquel Angel
>

Mime
View raw message